Recent

Author Topic: SQlite encrypte database  (Read 3164 times)

Hansvb

  • Hero Member
  • *****
  • Posts: 602
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: 9
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

  • Hero Member
  • *****
  • Posts: 672
    • 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) / Linux Mint (64 bit)
       Lazarus 3.2 FPC 3.2.2
       CodeTyphon 8.40 FPC 3.3.1

 

TinyPortal © 2005-2018