sqlean.py

SQLite 3.45.1 + Sqlean 0.21.10.

pip install sqlean.py==3.45.1

PyPi

• Updated to SQLite 3.45.0.
• sqlean.py is now versioned according to SQLite.

• Added ARM support on Linux (courtesy of @no23reason)
• Added source distribution (courtesy of @edgarrmondragon)
• Removed support for Python 3.6 and 3.7.
• Updated to SQLite 3.44.0

sqlite 3.43.0 + sqlean 0.21.8.

Python 3.12 build (courtesy of @edgarrmondragon). No other changes.

Allow setting pragma without transaction:

import sqlean
conn = sqlean.connect("/tmp/t1.db")
conn.execute("pragma journal_mode=wal;")

See https://github.com/coleifer/pysqlite3/issues/58 for details.

Breaking: all extensions are disabled by default. You can still use sqlean as a drop-in replacement for sqlite3. To enable all extensions, call sqlean.extensions.enable_all() before calling connect():

import sqlean

sqlean.extensions.enable_all()

conn = sqlean.connect(":memory:")
cur = conn.execute("select median(value) from generate_series(1, 99)")
print(cur.fetchone())
conn.close()

To enable specific extensions, call sqlean.extensions.enable():

import sqlean

sqlean.extensions.enable("stats", "text")
# ...

Versions: sqlite 3.42.0 + sqlean 0.21.5.

sqlite 3.42.0 + sqlean 0.21.5.