Best SQLite DLL For Encryption Support?

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQLite in Delphi and C++Builder
Post Reply
DespatchSystems
Posts: 14
Joined: Tue 24 Jul 2012 10:45

Best SQLite DLL For Encryption Support?

Post by DespatchSystems » Tue 24 Jul 2012 10:59

Which specific SQLite DLL do you recommend/have tested with to support the EncryptionKey functionality?

I need to know where to download a SQLite DLL that you have tested with encryption that you know works on Windows and OSX.

Do you recommend any particular SQLite Management tool that supports encryption?

Can you help?

Any help would be appreciated.

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

Re: Best SQLite DLL For Encryption Support?

Post by AlexP » Tue 24 Jul 2012 12:33

hello,

To test encryption capabilities, we used the library from http://sqlite.phxsoftware.com/. In different SQLite builds encryption is implemented in different ways, using different encryption algorithms, therefore you should choose a suitable library yourself. In the next SQLite version our driver will support static linking of the SQLite library with our encryption algorithms that are already built-in.
You can find and choose a more suitable tool to work with SQLite from the list at the official SQLite website: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

DespatchSystems
Posts: 14
Joined: Tue 24 Jul 2012 10:45

Re: Best SQLite DLL For Encryption Support?

Post by DespatchSystems » Tue 24 Jul 2012 15:42

Thanks Alex,

Have you tested encryption with Mac OSX, Delphi XE2 and SQLite?

Which OSX dylib did you need to use?

The http://sqlite.phxsoftware.com/ appears to be a windows only ADO.Net site?

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

Re: Best SQLite DLL For Encryption Support?

Post by AlexP » Wed 25 Jul 2012 11:23

hello,

We tested encryption on MacOS on our internal build of SQLite3.dylib library.
There may be other free libraries with encryption support, you can try finding them yourself.

DespatchSystems
Posts: 14
Joined: Tue 24 Jul 2012 10:45

Re: Best SQLite DLL For Encryption Support?

Post by DespatchSystems » Fri 14 Sep 2012 14:05

Good news that Encryption support has now been added to new v3.01!

Post Reply