Advanced Alchemy

A Jolt Organization Project

About

A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy, offering features such as:

• 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

• Optimized JSON types including a custom JSON type for Oracle.

• 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
  • lambda_stmt when possible for improved query building performance
  • 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
  • Google Spanner via spanner-sqlalchemy
  • DuckDB via duckdb_engine

Usage

Note

This section has not been completed (yet!)

Contributing

Note

This section has not been completed (yet!)