{"id":2782,"library":"sqlean.py","title":"Sqlean.py","description":"Sqlean.py bundles SQLite with a collection of useful extensions (e.g., crypto, fuzzy, ipaddr, math, stats, text, uuid). It provides a drop-in replacement for the built-in `sqlite3` module, offering enhanced functionality. The current version is 3.50.4.5, and it closely follows SQLite's release cycle for major versions, integrating Sqlean extensions.","status":"active","version":"3.50.4.5","language":"en","source_language":"en","source_url":"https://github.com/nalgeon/sqlean.py","tags":["database","sqlite","extensions","data-processing"],"install":[{"cmd":"pip install sqlean.py","lang":"bash","label":"Install latest version"}],"dependencies":[],"imports":[{"symbol":"sqlean","correct":"import sqlean"}],"quickstart":{"code":"import sqlean\n\n# Enable all Sqlean extensions. This must be called before connect().\nsqlean.extensions.enable_all()\n\nconn = sqlean.connect(\":memory:\")\ncur = conn.execute(\"select median(value) from generate_series(1, 99)\")\nresult = cur.fetchone()\nprint(f\"Median: {result[0]}\")\nconn.close()","lang":"python","description":"Demonstrates connecting to an in-memory database, enabling all Sqlean extensions, and executing a query that uses an extension function (median)."},"warnings":[{"fix":"Call `sqlean.extensions.enable_all()` before `sqlean.connect()` to enable all extensions, or `sqlean.extensions.enable(name)` for specific ones.","message":"Since version 0.21.5.1, all Sqlean extensions are disabled by default. Simply importing `sqlean` will behave like the standard `sqlite3` module without additional functionality.","severity":"breaking","affected_versions":">=0.21.5.1"},{"fix":"Be aware that version updates primarily reflect SQLite updates. Check the release notes for the integrated Sqlean extension version.","message":"Starting with version 3.45.0, `sqlean.py`'s major version now aligns with the underlying SQLite library version (e.g., 3.45.0 for SQLite 3.45.0), rather than its own internal versioning scheme.","severity":"gotcha","affected_versions":">=3.45.0"},{"fix":"Upgrade your Python environment to version 3.9 or a newer compatible version.","message":"Support for Python 3.6 and 3.7 was removed in version 0.21.8.5. `sqlean.py` now requires Python 3.9 or newer.","severity":"breaking","affected_versions":">=0.21.8.5"}],"env_vars":null,"last_verified":"2026-04-10T00:00:00.000Z","next_check":"2026-07-09T00:00:00.000Z"}