You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SQLite has very few functions compared to other DBMS. SQLite authors see this as a feature rather than a bug, because SQLite has extension mechanism in place.
There are a lot of SQLite extensions out there, but they are incomplete, inconsistent and scattered across the internet.
sqlean brings them all together, neatly packaged by domain modules and built for Linux, Windows and macOS.
Binaries are 64-bit and require a 64-bit SQLite version. If you are using SQLite shell on Windows (sqlite.exe), its 64-bit version is available at https://github.com/nalgeon/sqlite.
Usage
CLI usage:
sqlite> .load ./stats
sqlite> select median(value) from generate_series(1, 100);
IDE usage:
select load_extension('/path/to/extension/stats');
select median(value) from generate_series(1, 100);
In-app usage:
importsqlite3connection=sqlite3.connect(":memory:")
connection.enable_load_extension(True)
connection.load_extension("./stats.so")
connection.execute("select median(value) from generate_series(1, 100)")
connection.close()
You can specify any other supported extension instead of stats.