Ready-to-go SQLAlchemy concoctions.
Project description
Advanced Alchemy
Check out the project documentation 📚 for more information.
About
A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy, offering features such as:
-
Sync and async repositories, featuring common CRUD and highly optimized bulk operations
-
Integration with major web frameworks including Litestar, Starlette, FastAPI, Sanic.
-
Custom-built alembic configuration and CLI with optional framework integration
-
Utility base classes with audit columns, primary keys and utility functions
-
Optimized JSON types including a custom JSON type for Oracle.
-
Pre-configured base classes with audit columns UUID or Big Integer primary keys and a sentinel column.
-
Synchronous and asynchronous repositories featuring:
- Common CRUD operations for SQLAlchemy models
- Bulk inserts, updates, upserts, and deletes with dialect-specific enhancements
- lambda_stmt when possible for improved query building performance
- Integrated counts, pagination, sorting, filtering with
LIKE
,IN
, and dates before and/or after.
-
Tested support for multiple database backends including:
- SQLite via aiosqlite or sqlite
- Postgres via asyncpg or psycopg3 (async or sync)
- MySQL via asyncmy
- Oracle via oracledb
- Google Spanner via spanner-sqlalchemy
- DuckDB via duckdb_engine
Usage
[!IMPORTANT]
Check out the installation guide in our official documentation!
Litestar
[!NOTE]
This section has not been completed (yet!)
Starlette/FastAPI
[!NOTE]
This section has not been completed (yet!)
Sanic
[!NOTE]
This section has not been completed (yet!)
Contributing
All Jolt projects will always be a community-centered, available for contributions of any size.
Before contributing, please review the contribution guide.
If you have any questions, reach out to us on Discord, our org-wide GitHub discussions page, or the project-specific GitHub discussions page.
A Jolt Organization Project
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for advanced_alchemy-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fbb524c4de0d393013e1b222a0648194903a126c330ea2435ab6c323a43cf586 |
|
MD5 | 498e5eb3dc7f060980d3c1f131247470 |
|
BLAKE2b-256 | 30d2e177ce36425a458c55caa02348711afedabbed40c3e0af83543f9dced42a |