Devart Forums

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.

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

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?

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.

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