Encryption and Compression with SQLitePlus

SQLitePlus features built-in strong TwoFish encryption (click here for more info about TwoFish encryption).  The SqliteDb COM class has methods for encrypting and decrypting any type of data, and the Column class can also automatically encrypt and decrypt on the fly, making it very easy to create and use encrypted database fields.  Any field type can be encrypted, making SQLitePlus the secure desktop database of choice for Windows developers.

*** Now you can use SQL query commands against encrypted data directly ***

You use the ENCRYPT and DECRYPT keywords directly in your SQL statements, like this:

    SELECT DECRYPT(LastName) FROM Customers WHERE UPPER(DECRYPT(LastName)) = 'SMITH'

To encrypt, do something like this:

    UPDATE Customers SET LastName = ENCRYPT('Smith') WHERE CustomerId = 1

Compression is just as easy with SQLitePlus.  It features built-in ZLib compression (click here for more info about ZLib compression).  And like encryption you can have SQLitePlus compress column data automatically, making it so your code is the same whether compressing, encrypting or neither.