Android Question SQLite3 FTS5 for B4X

If you just need support for extra capabilities of SQLite, then look into using SQLCipher. It supports more SQLite extensions than the SQLite furnished by Android's bundled version of SQLite. You do not have to use the encryption features in order to use the additional capabilities.

Thank you very much for reply.

Unfortunately, I have several databases which are used in Windows, WEB and Android. I use same database for all of these platforms.

If I use SQLCipher for Android, I have to convert existing databases since SQLCipher database format is not compatible with the standard format which will result in extra work for every update.

This is why I and other developers need a standard implementation of SQLite for Android with FTS5 extension enabled.

texwillerx said:

If I use SQLCipher for Android, I have to convert existing databases since SQLCipher database format is not compatible with the standard format which will result in extra work for every update.

Click to expand...

Does it?

SQLCipher is also compatible with standard SQLite databases. When a key is not provided, SQLCipher will behave just like the standard SQLite library.

Click to expand...

Source: https://github.com/sqlcipher/sqlcipher

Thank you very much OliverA!

I have read Android database encryption with SQLCipher library where it says

Not compatible by default with databases created with older versions

Also, in SQLCipher 4.0.0 Release it says

"Thus, SQLCipher 4 will not open older databases by default. As always, we have updated our migration feature to streamline the upgrade process. To enable backwards-compatibility, it is possible to adjust settings at runtime or migrate older databases:"

Shame of me! I didn't realize that these statements are related for encrypted databases. If I have looked to github, I would find the answer to my problem.

Thank you very much for informing me about the compatibility.

You saved several hours of my time.

Regards.

I'm using FTS5 with SQLCipher (without password) and it works fine. You can easily convert your database to fts5. I think that your question is for SQLite and not for B4X. For example for the DBBrowser for workstation you have 2 different applications: one for SQLite "standard" and another one for SQLite with fts5. fts5 is really easy to use and set scanning of table very easy and efficient.