* * *

Author Topic: SQlite encrypte database  (Read 345 times)

Hansvb

  • Sr. Member
  • ****
  • Posts: 328
SQlite encrypte database
« on: July 09, 2017, 08:02:27 pm »
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

  • New member
  • *
  • Posts: 6
Re: SQlite encrypte database
« Reply #1 on: July 12, 2017, 08:50:09 am »
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

  • Sr. Member
  • ****
  • Posts: 447
    • http://www.silentwings.nl
Re: SQlite encrypte database
« Reply #2 on: July 12, 2017, 09:02:42 am »
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.
OS: Windows 10 (64 bit)
Laz: Lazarus 1.9 FPC 3.1.1 i386-win32-win32/win64

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus