sqlean.py
sqlite3 with extensions
Decision gist · record as of 2026-08-14
Yes, if you are on Linux or macOS and need sqlean extensions in a Python SQLite environment. The permissive license and zero runtime dependencies make it low-risk. However, the abandoned repository status means you should not rely on it for long-term production systems expecting active maintenance or future Python compatibility patches. Windows users will need to build from source.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- No Windows wheels available; requires Python 3.9 or later; requires manual build on unsupported platforms.
- Medium install friction due to compiled wheels; prebuilt binaries available for Linux and macOS (x86_64/aarch64) but not Windows.
- Repository is archived and marked abandoned as of the fact sheet date, with no active maintenance.
License · maintenance · safety
zlib/libpng (permissive) — Licensed under zlib/libpng (permissive), allowing use in commercial and proprietary projects with minimal restrictions.
last release 2025-10-25 (293 days) · last repo commit 2026-02-04 · 146 stars · archived
0 known vulnerabilities (OSV.dev, 2026-08-14) · 1,186,871 downloads/mo, #4,249 on PyPI
Alternatives
Verify before relying
pip install sqlean.py
import sqlean
sqlean.extensions.enable_all()
conn = sqlean.connect(":memory:")
result = conn.execute("select median(value) from generate_series(1, 99)").fetchone()
conn.close()- Whether the abandoned status affects long-term compatibility with future Python or SQLite versions.
- Whether the 293 days since last release indicates sufficient stability or potential staleness for production use.
What it is and what it does
sqlean.py wraps SQLite with a collection of optional extensions that add domain-specific SQL functions. It maintains full API compatibility with Python's standard sqlite3 module, so you can use it as a direct replacement without rewriting connection or query code. The extensions—covering cryptography, fuzzy matching, statistics, regex, file I/O, IP address handling, and more—are disabled by default but can be enabled globally or selectively before opening a connection.
The package is distributed as precompiled wheels for Linux and macOS, making installation straightforward on those platforms. However, the repository is archived and no longer maintained, which means bug fixes and compatibility updates with future Python or SQLite versions are unlikely. The codebase is based on pysqlite3 and is available under a permissive zlib license.
Use it for
- Add statistical functions (median, percentiles) to SQLite queries without external dependencies.
- Perform fuzzy string matching and phonetic searches directly in SQL.
- Hash and encode data using crypto functions within SQL expressions.
- Parse and manipulate IP addresses as part of SQL queries.
- Read and write files from SQL using fileio extension functions.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you are on Linux or macOS and need sqlean extensions in a Python SQLite environment.
The permissive license and zero runtime dependencies make it low-risk. However, the abandoned repository status means you should not rely on it for long-term production systems expecting active maintenance or future Python compatibility patches. Windows users will need to build from source.
Install
sqlean-py on PyPI
Before you install
Medium install friction due to compiled wheels; prebuilt binaries available for Linux and macOS (x86_64/aarch64) but not Windows. Repository is archived and marked abandoned as of the fact sheet date, with no active maintenance.
No Windows wheels available; requires Python 3.9 or later; requires manual build on unsupported platforms.
License in practice
Licensed under zlib/libpng (permissive), allowing use in commercial and proprietary projects with minimal restrictions.
Quickstart
pip install sqlean.py
import sqlean
sqlean.extensions.enable_all()
conn = sqlean.connect(":memory:")
result = conn.execute("select median(value) from generate_series(1, 99)").fetchone()
conn.close()Verify before relying
- Whether the abandoned status affects long-term compatibility with future Python or SQLite versions.
- Whether the 293 days since last release indicates sufficient stability or potential staleness for production use.
Package facts
| License | zlib/libpng permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Medium. Platform-specific wheel |
| Runtime dependencies | None |
| Maintenance | Abandoned 293 days since the last release |
| Last repo commit | repository archived |
| First released | |
| Downloads | 1,186,871 / month, #4,249 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersOperating System :: MacOS :: MacOS XOperating System :: POSIXProgramming Language :: CProgramming Language :: PythonTopic :: Database :: Database Engines/ServersTopic :: Software Development :: Libraries :: Python Modules |
Evidence: sqlean_py-3.50.4.5-cp310-cp310-macosx_10_15_x86_64.whl; sqlean_py-3.50.4.5-cp310-cp310-macosx_11_0_arm64.whl; sqlean_py-3.50.4.5-cp310-cp310-manylinux_2_28_aarch64.whl; sqlean_py-3.50.4.5-cp310-cp310-manylinux_2_28_x86_64.whl; sqlean_py-3.50.4.5-cp311-cp311-macosx_10_15_x86_64.whl; sqlean_py-3.50.4.5-cp311-cp311-macosx_11_0_arm64.whl; sqlean_py-3.50.4.5-cp311-cp311-manylinux_2_28_aarch64.whl; sqlean_py-3.50.4.5-cp311-cp311-manylinux_2_28_x86_64.whl; sqlean_py-3.50.4.5-cp312-cp312-macosx_10_15_x86_64.whl; sqlean_py-3.50.4.5-cp312-cp312-macosx_11_0_arm64.whl; sqlean_py-3.50.4.5-cp312-cp312-manylinux_2_28_aarch64.whl; sqlean_py-3.50.4.5-cp312-cp312-manylinux_2_28_x86_64.whl; sqlean_py-3.50.4.5-cp313-cp313-macosx_10_15_x86_64.whl; sqlean_py-3.50.4.5-cp313-cp313-macosx_11_0_arm64.whl; sqlean_py-3.50.4.5-cp313-cp313-manylinux_2_28_aarch64.whl; sqlean_py-3.50.4.5-cp313-cp313-manylinux_2_28_x86_64.whl; sqlean_py-3.50.4.5-cp314-cp314-macosx_10_15_x86_64.whl; sqlean_py-3.50.4.5-cp314-cp314-macosx_11_0_arm64.whl; sqlean_py-3.50.4.5-cp314-cp314-manylinux_2_28_aarch64.whl; sqlean_py-3.50.4.5-cp314-cp314-manylinux_2_28_x86_64.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlite3 extensions”
- sqlean.pyA drop-in replacement for Python's sqlite3 module that bundles sqlean…
- pysqlite3pysqlite3 packages SQLite as a standalone Python module, letting you…
- opentelemetry-instrumentation-sqlite3Adds OpenTelemetry tracing instrumentation to SQLite3 database calls,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also pysqlite3 · pysqlite3-binary · sqlcipher3-wheels · sqlcipher3 · sqlcipher3-binary · sqlite-fts4 · fudgeo · opentelemetry-instrumentation-sqlite3 · sqlalchemy-mate · pgvecto-rs