sqlite encryption

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
goozgooz
Posts: 3
Joined: Sat 17 Apr 2010 00:12

sqlite encryption

Post by goozgooz » Tue 28 Dec 2010 08:51

3.50.0.14

* Added encryption support in the SQLite provider


encryption by wxsqlite?
please sample or demo!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Tue 28 Dec 2010 09:32

Hello,


We have added encryption support with using standard SQLite functions: sqlite3_key, sqlite3_rekey.
You can use these features like:

use the key
UniConnection1.SpecificOptions['EncryptionKey']:= 'key'

set the key
uses LiteClassesUni;
procedure EncryptDatabase(Connection: TCRConnection; NewKey: _string);

but if your sqlite.dll doesn't support encryption you can't use these features.

We will add this information into the UniDAC help in one of the next builds.

Post Reply