This package provides an SQLite Python wrapper bundled with sqlean extensions. It's a drop-in replacement for the standard library's sqlite3 module.
pip install sqlean.py
import sqlean
# enable all extensions
sqlean.extensions.enable_all()
# has the same API as the default sqlite3 module
conn = sqlean.connect(":memory:")
conn.execute("create table employees(id, name)")
# and comes with sqlean extensions
cur = conn.execute("select median(value) from generate_series(1, 99)")
print(cur.fetchone())
# (50.0,)
conn.close()sqlean.py contains essential SQLite extensions:
- crypto: Hashing, encoding and decoding data
- define: User-defined functions and dynamic SQL
- fileio: Reading and writing files
- fuzzy: Fuzzy string matching and phonetics
- ipaddr: IP address manipulation
- regexp: Regular expressions
- stats: Math statistics
- text: String functions
- time: High-precision date/time
- uuid: Universally Unique IDentifiers
- vsv: CSV files as virtual tables
pip install sqlean.py
Note that the package name is sqlean.py, while the code imports are just sqlean. The sqlean package name was taken by some zomby project and the author seemed to be unavailable, so I had to add the .py suffix.
A binary package (wheel) is available for the following operating systems:
- Linux (x86_64/aarch64)
- macOS (x86_64/arm64)
Unfortunately, there are no wheels available for Windows.
All extensions are disabled by default. You can still use sqlean as a drop-in replacement for sqlite3:
import sqlean as sqlite3
conn = sqlite3.connect(":memory:")
cur = conn.execute("select 'sql is awesome'")
print(cur.fetchone())
conn.close()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")
conn = sqlean.connect(":memory:")
cur = conn.execute("select median(value) from generate_series(1, 99)")
print(cur.fetchone())
conn.close()Prepare source files:
make prepare-src
make download-sqlite
make download-sqlean
Build and test the package:
make clean build
Based on the pysqlite3 project. Available under the Zlib license.
The package is provided as-is. If you need a version for Windows or another operating system, please build it yourself — I don't have the capacity to deal with it.