2

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?

meouw
  • 123
  • 1
  • 5
  • 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 03 '12 at 19:02
  • 3
    See this identical question on [so]. [SQLite with encryption/password protection](http://stackoverflow.com/q/5669905/1068283) – 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
  • This question appears to be off-topic because it is about Programming. It should have been migrated, but wasn't, and can't be now. See the linked Question in the comments. – Chris S Mar 01 '14 at 19:27

1 Answers1

-1

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

dsegleau
  • 99
  • 1