Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy
a year ago
- #Python
- #Database
- #SQLAlchemy
- Advanced Alchemy is a companion library for SQLAlchemy, offering sync and async repositories with CRUD and bulk operations.
- Supports integration with major web frameworks like Litestar, Starlette, FastAPI, and Sanic.
- Includes custom-built Alembic configuration, CLI, and utility base classes with audit columns and primary keys.
- Features optimized JSON types, support for UUID6/UUID7, and Nano ID with optional extras.
- Tested with multiple database backends including SQLite, Postgres, MySQL, Oracle, and more.
- Provides pre-configured base classes, synchronous/asynchronous repositories, and service classes for easier data handling.
- Includes examples for Litestar, Flask, FastAPI, Starlette, and Sanic integration.
- Encourages community contributions with guidelines available in the contribution guide.