Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy

Summary

Project Status CI/CD Quality Package Community Meta Advanced Alchemy Check out the project documentation 📚 for more information. About A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy, offering: 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 Built in File Object data type for storing objects: Unified interface for various storage backends ( fsspec and obstore ) Optional lifecycle event hooks integrated with SQLAlchemy's event system to automatically save and delete files as records are inserted, updated, or deleted. data type for storing objects: Optimized JSON types including a custom JSON type for Oracle Integrated support for UUID6 and UUID7 using uuid-utils (install with the uuid extra) (install with the extra) Integrated support for Nano ID using fastnanoid (install with the nanoid extra) (install with the extra) 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 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 (async or sync) (tested on 18c and 23c) Google Spanner via spanner-sqlalchemy DuckDB via duckdb_engine Microsoft SQL Server via pyodbc or aioodbc CockroachDB via sqlalchemy-cockroachdb (async or sync) ...and much more Usage Installation pip install advanced-alchemy Important Check out the installation ...