Get the latest tech news
Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy
A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy - litestar-org/advanced-alchemy
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. Optimized JSON types including a custom JSON type for Oracle Integrated support for UUID6 and UUID7 using uuid-utils(install with the uuid extra) Integrated support for Nano ID using fastnanoid(install with the nanoid extra) Pre-configured base classes with audit columns UUID or Big Integer primary keys and a . 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.
Or read this on Hacker News