J jcmartini Member Licensed User Longtime User Oct 10, 2019 #1 is sqlite3 fts5 option supported by B4A ?
OliverA Expert Licensed User Longtime User Oct 10, 2019 #2 B4A relies on Android's build in SQLite version. None (that I'm aware of) of the Android versions of SQLite include FTS5 support. You would have to bundle your own version of SQLite with your application if you want FTS5 support. A possible solution to including a newer version of SQLite is to use SQLCipher. It bundles a more recent version of SQLite and technically has the ability to support FTS5. B4A's version/wrap of SQLCipher can be found here: https://www.b4x.com/android/forum/threads/android-database-encryption-with-sqlcipher-library.14965/. It will be up to you to test that version and see if FTS5 has been enabled. Someone else's thoughts on why/why not to include your own version of SQLite: https://ericsink.com/entries/multiple_sqlite_problem.html Upvote 0
B4A relies on Android's build in SQLite version. None (that I'm aware of) of the Android versions of SQLite include FTS5 support. You would have to bundle your own version of SQLite with your application if you want FTS5 support. A possible solution to including a newer version of SQLite is to use SQLCipher. It bundles a more recent version of SQLite and technically has the ability to support FTS5. B4A's version/wrap of SQLCipher can be found here: https://www.b4x.com/android/forum/threads/android-database-encryption-with-sqlcipher-library.14965/. It will be up to you to test that version and see if FTS5 has been enabled. Someone else's thoughts on why/why not to include your own version of SQLite: https://ericsink.com/entries/multiple_sqlite_problem.html
J jcmartini Member Licensed User Longtime User Oct 11, 2019 #3 Thanks for your help, Oliver. It works perfectly with your suggestions. Upvote 0
