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.

Version 3.0
SQLite 3.0 has support for BLOB data, so there is no more need to encode data to remove Nulls from the data.  SQLitePlus allows you to encrypt and compress data into these BLOB-type fields. Since there is

Version 2.8
SQLite 2.x stores all data as null-terminated text, including numeric data, which turns out to be a very good thing when in comes to encryption.  SQLitePlus can encrypt data of any field type, including numeric fields, and you can even query the encrypted data.  This is makes it so your database can be completely secure.