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.
pip install sqlean.pyVerified import paths — ran on the pinned version, not inferred.
Demonstrates connecting to an in-memory database, enabling all Sqlean extensions, and executing a query that uses an extension function (median).
Call `sqlean.extensions.enable_all()` before `sqlean.connect()` to enable all extensions, or `sqlean.extensions.enable(name)` for specific ones.
Be aware that version updates primarily reflect SQLite updates. Check the release notes for the integrated Sqlean extension version.
Upgrade your Python environment to version 3.9 or a newer compatible version.
Run `pip install sqlean.py` in your terminal to install the package.
Replace `import sqlite3` with `import sqlean` and use `sqlean.connect()` to ensure the enhanced SQLite module with Sqlean extensions is used.
Connect to the database using `sqlean.connect()` and execute the function as part of a SQL query. For example, `conn.execute("SELECT jaro_winkler('apple', 'aple');")`.Consult the Sqlean documentation or reference the expected arguments for the specific function and provide them correctly in the SQL query. For `text_similarity`, two arguments are typically required, like `conn.execute("SELECT text_similarity('hello world', 'world hello');")`.No dependency data recorded yet.