Open Source Integration
A SQLite database is created/opened for use via the sqlite3_open() API.
The sqlite3_prepare() API is commonly used to pass encryption parameters to an encrypted SQLite database. Once the encryption parameters have been passed, then SQLite database is accessed using the same functions as an unencrypted SQLite database. Thus providing a transparent seamless encrypted database solution.
A sample method, taken from the SQLiteCrypt implementation, showing how to interface with an encrypted SQLite database is:
The PRAGMA commands are entered into the SQLite database via the sqlite3_prepare() API. The PRAGMA command is used to pass encryption parameters and validate the software license.