Best SQLite DLL For Encryption Support?

Best SQLite DLL For Encryption Support?

Postby 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.
DespatchSystems
 
Posts: 14
Joined: Tue 24 Jul 2012 10:45

Re: Best SQLite DLL For Encryption Support?

Postby 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
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Best SQLite DLL For Encryption Support?

Postby 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?
DespatchSystems
 
Posts: 14
Joined: Tue 24 Jul 2012 10:45

Re: Best SQLite DLL For Encryption Support?

Postby 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.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Best SQLite DLL For Encryption Support?

Postby DespatchSystems » Fri 14 Sep 2012 14:05

Good news that Encryption support has now been added to new v3.01!
DespatchSystems
 
Posts: 14
Joined: Tue 24 Jul 2012 10:45


Return to dbExpress driver for SQLite