How can I enable encryption for SQLite3 in PHP5.3?
- by meouw
The php manual for SQLite3::open has this information:
public bool SQLite3::open (
string $filename
[, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE
[, string $encryption_key ]]
)
Opens an SQLite 3 Database. If the build includes encryption, then it will attempt to use the key.
I would like to use encrypted SQLite databases for a project I'm working on, but I can't find any information anywhere on how to build the SQLite module including encryption.
Does anyone know how to do this?
Perhaps it's so obvious no one has published any information or perhaps only commercial modules are available.
I've noticed that the developers of SQLite offer a proprietary encryption extension. Is this the only way to go?