This library takes the SQLite module from Python 3 and packages it as a separately-installable module.
This may be useful for creating SQLite modules capable of working with other versions of SQLite (via the amalgamation option).
Additional features:
sqlite3_stmt_readonly
.A completely self-contained binary package (wheel) is available for versions
0.4.1 and newer as pysqlite3-binary
. This package contains the latest release
of SQLite compiled with numerous extensions, and requires no external
dependencies.
If you intend to use the system SQLite, you can install with:
$ pip install pysqlite3
Alternatively you can clone or download the repo and use setup.py
to
build pysqlite3
linked against the system SQLite:
$ python setup.py build
To build pysqlite3
statically-linked against a particular version of SQLite,
you need to obtain the SQLite3 source code and copy sqlite3.c
and sqlite3.h
into the source tree.
# Download the latest release of SQLite source code and build the source
# amalgamation files (sqlite3.c and sqlite3.h).
$ wget https://www.sqlite.org/src/tarball/sqlite.tar.gz?r=release \
-O sqlite.tar.gz
$ tar xzf sqlite.tar.gz
$ cd sqlite/
$ ./configure
$ make sqlite3.c
# Copy the sqlite3 amalgamation files into the root of the pysqlite3 checkout
# and run build_static + build:
$ cp sqlite/sqlite3.[ch] pysqlite3/
$ cd pysqlite3
$ python setup.py build_static build
You now have a statically-linked, completely self-contained pysqlite3
.
A binary package (wheel) is available for linux with a completely
self-contained pysqlite3
, statically-linked against the most recent release
of SQLite with many features/extensions enabled.
$ pip install pysqlite3-binary