Python's sqlite3 + extensions
ZLIB License
Bot releases are hidden (Show)
Published by nalgeon about 1 year ago
Python 3.12 build (courtesy of @edgarrmondragon). No other changes.
Published by nalgeon over 1 year ago
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.
Published by nalgeon over 1 year ago
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")
# ...