Advanced Alchemy: A High-Performance Companion Library for SQLAlchemy

2025-04-23
Advanced Alchemy: A High-Performance Companion Library for SQLAlchemy

Advanced Alchemy is a carefully crafted, thoroughly tested, and optimized companion library for SQLAlchemy. It offers sync and async repositories with common CRUD operations and highly optimized bulk operations. It integrates with major web frameworks including Litestar, Starlette, FastAPI, and Sanic, and features a custom-built Alembic configuration and CLI. Built-in features include a File Object data type supporting various storage backends (fsspec and obstore), optimized JSON types, support for UUID6 and UUID7, and pre-configured base classes. Advanced Alchemy simplifies CRUD operations on SQLAlchemy models and provides features like pagination, sorting, and filtering.

Development