Answers To Frequently Asked Questions

» Is SQLcrypt™ available for Linux?

SQLcrypt™ for Linux has been released in November 2005.

» Is SQLcrypt™ available for Pocket PC?

SQLcrypt™ for Pocket PC has been released in December 2005.

» Is an SQLcrypt™ interface available for PHP?

We're working on SQLcrypt™ for PHP5. A demo release should be available for download in early ~~November~~ December 2005.

» Does SQLcrypt™ do compression, in addition to encryption?

There is no plan at present to add database compression to SQLcrypt™.

» How do I change the passphrase to an SQLcrypt™ database?

SQLcrypt™ performs its cryptographic operations transparently at the storage layer. Internally, the storage layer organises data on a per-page basis, where each page is typically 1024 bytes. Changing the passphrase means changing the cipher key for the database: This operation should be atomic; the following sequence of operations carried out under application control ensures atomicity:

Close the existing SQLcrypt™ database.

Create a new database. Create the necessary tables, etc.

sqlcrypt3_passphrase() the new database with the new passphrase.

Attach the existing database to the new database:

attach_passphrase <old passphrase> <existing db> as curr

For each table %s your application uses,
```
insert into %s select * from curr.%s
```
detach curr