This library takes pysqlite3 and makes some small modifications so it is suitable for use with sqlcipher (sqlite with encryption).
Additional features:
- User-defined window functions (requires SQLite >= 3.25)
- Flags and VFS an be specified when opening connection
- Incremental BLOB I/O, bpo-24905
- Improved error messages, bpo-16379
- Simplified detection of DML statements via
sqlite3_stmt_readonly. - Sqlite native backup API (also present in standard library 3.7 and newer).
A completely self-contained binary package (wheel) is available starting with version 0.6.2. This package contains the latest release of SQLCipher compiled with numerous extensions, and requires no external dependencies.
If you prefer to build yourself, a source distribution is available on PyPI.
Note that since SQLCipher 4.7.0 the build system for SQLCipher has changed
substantially and it no longer provides a libsqlcipher but is intended to
overwrite the system libsqlite3.
Install a wheel using pip:
$ pip install sqlcipher3
Because SQLCipher 4.7.0 and newer no longer provide a system libsqlcipher, there is no great way to link against a system library. The best route if you wish to use a different version of SQLCipher than the one bundled is to check-out the source code and replace the vendored sources with your own desired SQLCipher amalgamation.
# Copy your specific sqlcipher amalgamations into the vendor/ directory at the
# root of the sqlcipher3 checkout:
$ cp sqlite3.[ch] vendor/
# Build your library.
$ pip install .
# Or alternately,
$ python setup.py build
Nor aught availed him now to have built in heaven high towers; nor did he scrape by all his engines, but was headlong sent with his industrious crew to build in hell.
Beware to those who would build their own wheels! See what has been wrought and tremble.
