Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The php manual for SQLite3::open has this information:

public bool SQLite3::open (
    string $filename
    [, 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?

share|improve this question

closed as off-topic by Chris S Mar 1 '14 at 19:27

  • This question does not appear to be about server, networking, or related infrastructure administration within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the 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
Obviously your build doesn't include encryption. Apart from bdb mentioned by desgleau, you could try mysql. – ott-- Nov 3 '12 at 19:02
See this identical question on Stack Overflow. SQLite with encryption/password protection – Michael Hampton Mar 11 '13 at 23:19
@MichaelHampton - Thanks Michael, the identical question you point out has a suitable answer for my needs. – meouw Mar 12 '13 at 13:54

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

share|improve this answer

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