{"library":"advanced-alchemy","type":"library","category":null,"description":"Advanced Alchemy provides ready-to-go SQLAlchemy concoctions, simplifying common database operations and patterns. It's built on SQLAlchemy and offers robust repository and service layers, DTO generation, and integrates seamlessly with frameworks like Litestar. Key features include SQLModel compatibility, read/write replica routing, Dogpile caching, and enhanced CLI tools. Currently at version 1.9.3, it maintains an active release cadence with frequent updates and bug fixes.","language":"python","status":"active","version":"1.9.3","tags":["SQLAlchemy","ORM","database","repository pattern","Litestar","async","migrations"],"last_verified":"Sun May 24","install":[{"cmd":"pip install advanced-alchemy","imports":["from advanced_alchemy.base import BaseORMModel","from advanced_alchemy.repository import SQLAlchemyAsyncRepository","from advanced_alchemy.repository import SQLAlchemySyncRepository","from advanced_alchemy.config import SQLAlchemyLitestarConfig","from advanced_alchemy.extensions.litestar.plugins import SQLAlchemyPlugin"]},{"cmd":"pip install advanced-alchemy[sqlmodel]","imports":[]},{"cmd":"pip install advanced-alchemy[litestar]","imports":[]},{"cmd":"pip install advanced-alchemy[alembic]","imports":[]}],"homepage":"https://advanced-alchemy.litestar.dev/latest/","github":"https://github.com/sponsors/litestar-org","docs":"https://advanced-alchemy.litestar.dev/latest/","changelog":"https://advanced-alchemy.litestar.dev/latest/changelog","pypi":"https://pypi.org/project/advanced-alchemy/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":3.8,"avg_import_s":null,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/advanced-alchemy/compatibility"}}