How to encrypt sqlite with Aurelius?

BIZ TMS Aurelius
1

Is there a way to encrypt/decrypt sqlite using Aurelius native sqlite driver?

2

Currently there is no builtin feature for that, unfortunately.

3

I found if using FireDAC SQLite connection, we can have encrypted SQLite db that works with Aurelius.

There is a good sample that comes with RAD Studio to show SQLite encryption with FireDAC:
C:\Users\Public\Documents\Embarcadero\Studio\21.0\Samples\Object Pascal\Database\FireDAC\Samples\DBMS Specific\SQLite\Encryption

Following this sample, I was able to have Aurelius to work encrypt SQLite db. Actually I found FireDAC SQLite driver is more advantageous than Aurelius native SQLite driver, considering it provides more configuration options. FireDAC SQLite driver also supports static linking to avoid dependency on sqlite.dll which is very nice.

Just to share here so people may find this information useful.

2 Likes