This repository was forked from https://github.com/newsoft/sqlite3-dbx.
SQLite3 has database encryption support, but this seems to be not publicly available as explained here: http://www.sqlite.org/see/doc/trunk/www/readme.wiki.
However, a Google search for "7bb07b8d471d642e" magic reveals that part of the source code is available from the SQLite website:
- http://www.sqlite.org/slt/vpatch?from=10318b880cb756b2&to=1d627f5850e271cf (encryption added)
- http://www.sqlite.org/slt/vpatch?from=1d627f5850e271cf&to=f85e9769888f9e76 (encryption removed)
- http://www.sqlite.org/sqllogictest/ci/f85e9769888f9e762ef3c8d2f18121ea8307b433?sbs=1
This project is based on the following SQLite version:
Version: 3.7.0
Source Id: 2010-07-02 19:04:59 336ce7d29767f76c4a92aa4bbc46d21e19871667
No Makefile is provided. Compilation (in debug mode) is as easy as:
$ gcc -o sqlite3 -I. -DSQLITE_HAS_CODEC shell.c sqlite3.c -Wall -ggdb -ldl -lpthread
Tested and supported platforms are:
- Linux (Ubuntu 10.04 x86)
- Windows (Cygwin)
- Mac OS X (10.7)
Warning: on recent Ubuntu versions, GCC command-line arguments ordering matters.
"The --as-needed option also makes the linker sensitive to the ordering of libraries on the command-line." (see https://wiki.ubuntu.com/NattyNarwhal/ToolchainTransition#How_to_Fix_a_Problem)
./sqlite3 -key 0123456789ABCDEF0123456789ABCDEF file.dbx
Note: The key length is only limited by the implementation size of int.
- Encryption key put into ~/.sqliterc file will NOT be taken into account.
- ".backup" and ".restore" meta commands will NOT encrypt the /other/ database (would be easy to implement anyway).
- Rekeying is supported by the API, but not implemented (yet).