Compression with SQLitePlus
SQLitePlus features built-in strong TwoFish encryption
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
*** Now you can use SQL query commands against
encrypted data directly ***
You use the ENCRYPT and DECRYPT keywords directly in your SQL statements, like
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.