Forum > Databases

Example of using encrypted sqlite databases for Lazarus needed.

<< < (2/2)

PierceNg:

--- Quote from: wekwejt.com on October 15, 2021, 08:48:24 pm ---Now I have made libraries an database. It works with command line but I still can't connect with Lazarus components (SQLdb or Zeos).
Some more clues?

--- End quote ---

By SQLdb I assume you mean fcl-db, and the unit usage in this chain: <your program> uses sqlite3conn, which uses sqlite3dyn, which includes sqlite3.inc. The source file sqlite3.inc defines the const Sqlite3Lib = 'sqlite3.dll'.

1. Expedient approach - Since sqlcipher.dll is just sqlite3.dll plus crypto, rename sqlcipher.dll to sqlite3.dll, placing it in the same directory as your executable. Then your program will link with it dynamically and get the crypto functionality.

2. More effort for long term payoff - Modify fcl-db source code to distinguish between loading sqlite3.dll and sqlcipher.dll.

Same way for Zeos.

Soner:
There is an example with explanations in the Lazarus folder :
lazarus-folder\examples\database\sqlite_encryption_pragma

wekwejt.com:
Thanks guys! This is what I was looking for. :D

Navigation

[0] Message Index

[*] Previous page

Go to full version