SQLiteDatabase.Encrypt and SQLite Apps

Should I be able to open an SQLite database that I’ve created and encrypted with a 3rd party SQLite app like ‘SQLPro for SQLite’ or ‘Datum’?

When I open the 3rd party SQLite app, it asks for a password but when I supply it, it won’t open. Datum asks for the password and the page size which defaults to 1024…

No you shouldn’t. Nearly all of the 3rd party sqlite tools take a different approach to encrypting. SQLiteManager is the only xojo-compatible tool I’m aware of.

MBS SQL Plugin also supports encryption. So you can write a tool using our plugin if needed.

Thank you!