꿈소년의 개발 이야기

안드로이드 DB 에 대해 FTS 설정 및 적용하기 how to implement FTS in android. https://developer.android.com/training/search/search.html#search how to use FTS3, FTS4. https://sqlite.org/fts3.html how to use SQLiteQueryBuilder in android. https://developer.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html#setTables(java.lang.String) how to use sqlite command in adb shell in android. https://dev..

refer: http://www.androiddesignpatterns.com/2012/05/correctly-managing-your-sqlite-database.html Issue log:SQLiteConnectionPool The connection pool for database '/data/data/com.android.providers.media/databases/external.db' has been unable to grant a connection to thread 554 (eject thread) with flags 0x2 for 750.025 seconds. Analysis:SQLiteOpenHelper instance 가 여러 개 생성되어 접근할 경우 발생함. new 를 이용한 생성..