pysqlite3-binary

0.5.4.post2 · active · verified Mon Apr 13

This library takes the SQLite module from Python 3 and packages it as a separately-installable module. The binary package is statically compiled, which makes it easy to embed the library and ensures a recent SQLite version with many features enabled, such as FTS (Full-Text Search), user-defined window functions, and native backup API. It is currently at version 0.5.4.post2 and is actively maintained.

Warnings

gotcha To replace the standard library's `sqlite3` module with `pysqlite3` for an entire application (e.g., in a Django project or for other libraries expecting `sqlite3`), you must explicitly swap the modules in `sys.modules` early in your application's startup. Otherwise, `import sqlite3` will still load the built-in version.
Fix: Add these lines at the very beginning of your main application entry point: `import pysqlite3 import sys sys.modules['sqlite3'] = sys.modules.pop('pysqlite3')`
gotcha On newer Python versions (e.g., Python 3.12+), the built-in `sqlite3` module might already include a sufficiently recent SQLite version. In such cases, installing `pysqlite3-binary` might be unnecessary and could potentially lead to confusion if the `sys.modules` swap is not used consistently.
Fix: Check your Python version's built-in `sqlite3` version (`sqlite3.sqlite_version`) before deciding to use `pysqlite3-binary`.
breaking Early versions (prior to 0.5.1 or 0.6.0, depending on the source) of `pysqlite3-binary` might not have been fully self-contained or provided pre-built wheels for all platforms, requiring manual compilation or system dependencies.
Fix: Upgrade to the latest `pysqlite3-binary` version (0.5.1+ or 0.6.0+) to ensure a fully self-contained binary distribution with wheels for common platforms.
gotcha If you intend to link against a system SQLite library or a specific custom SQLite build instead of using the self-contained binary, you must install the `pysqlite3` source distribution (not `pysqlite3-binary`) and follow specific build steps (e.g., `python setup.py build_static build` or `pip install pysqlite3 --no-binary pysqlite3`).
Fix: For source-based installations, install `pysqlite3` and consult its README for specific build instructions, rather than installing `pysqlite3-binary`.

Install

pip install pysqlite3-binary Install binary distribution

Imports

pysqlite3
```
import pysqlite3
```
Importing 'sqlite3' will typically load the standard library's version unless `sys.modules['sqlite3']` is explicitly overridden.

Quickstart

Demonstrates connecting to an in-memory SQLite database, creating a table, inserting data, querying, and closing the connection using the pysqlite3 module.

import pysqlite3

conn = pysqlite3.connect(':memory:')
cursor = conn.cursor()

cursor.execute('CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT)')
cursor.execute('INSERT INTO users (name, email) VALUES (?, ?)', ('Alice', 'alice@example.com'))
cursor.execute('INSERT INTO users (name, email) VALUES (?, ?)', ('Bob', 'bob@example.com'))

conn.commit()

for row in cursor.execute('SELECT * FROM users'):
    print(row)

conn.close()

view raw JSON →