Encryption

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
FerCastro
Posts: 47
Joined: Mon 26 Jun 2006 17:32
Location: México City
Contact:

Encryption

Post by FerCastro » Mon 15 Jul 2013 02:07

Hello

I am evaluating LiteDAC because I have the impression that this library manages in a better way the encryption than Unidac does with SQLIte.

Is this correct? or, Does Unidac manages encryption strong enough with SQLite?

If so, what is the DLL or library I have to add in order to encrypt my sqlite databases?

regards

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

Re: Encryption

Post by AlexP » Mon 15 Jul 2013 08:16

Hello,

Encryption is not included into the free version of the SQLite library. To use encryption you have to use either a SQLite assembly that supports encryption, or the Direct mode (both in UniDAC and LiteDAC) which supports encryption. For more information, see the reference for these products at http://www.devart.com/litedac/docs/data ... yption.htm and http://www.devart.com/unidac/docs/datab ... yption.htm

FerCastro
Posts: 47
Joined: Mon 26 Jun 2006 17:32
Location: México City
Contact:

Re: Encryption

Post by FerCastro » Mon 15 Jul 2013 17:30

Hello Alex, thanks for your answer,

As I can read, the encryption with unidac is field based, and with litedac is database based encryptionj, right? I mean, if I use unidac i can encrypt fields but not the whole database, am I correct?

In the other hand, if I use LiteDAC I can encrypt the whole database as well as desired fields

Regards!

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

Re: Encryption

Post by AlexP » Tue 16 Jul 2013 11:16

Hello,

In the mentioned "Database File Encryption" articles, the SQLite database file encryption is described both in UniDAC and LiteDAC. If you want to encrypt separate fields, you can use the Data Encryption feature both in UniDAC and LiteDAC

Post Reply