up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
Have you tried it out to see if its already enabled? (create/populate a DB with a password in 'open' then try to read from it without supplying the password) – symcbean Mar 11 '11 at 13:29
Yes I have :) No luck – meouw Mar 11 '11 at 13:36
feedback

1 Answer

up vote 0 down vote

You can also use Berkeley DB, which has a SQLite-compatible SQL API and includes encryption as a part of the download.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.