SQlite encrypte database
lazarus / 16-Databases

----------------------------------------------------------------------
Hansvb · 2017-07-09 18:02

I want to store some information in a SQlite database. I just
encrypted the SQLite database with a tool called "DB browser for
SQlite". When i want to connect i get a warning: "SQLite3Connection1:
file is encrypted or is not a database"
I set the password in the SQLite3Connection1.

Is it possible to open an encrypted SQlite database?

----------------------------------------------------------------------
shadow · 2017-07-12 06:50

AFAIK SQLite doesn't support encryption by itself. I think "DB browser
for SQlite" encrypts the database file and decrypts it by need. So
you've to decrypt the file by yourself first before using it with
SQLite3Connection.

Could anyone approve?

----------------------------------------------------------------------
JanRoza · 2017-07-12 07:02

You may take a look at the SQLite Encryption Extension
(https://www.hwaci.com/sw/sqlite/see.html) and the SQLite CEROD
extension (https://www.hwaci.com/sw/sqlite/cerod.html).
I've never used them, but maybe they can give you a clue.