Advanced-Alchemy – A framework agnostic library for SQLAlchemy

Hacker News

Hello HN! Advanced Alchemy is an optimized companion library for SQLAlchemy, designed to supercharge your database models with powerful tooling for migrations, asynchronous support, lifecycle hook and more. You can find the repository and documentation here: - GitHub Repository: https://github.com/litestar-org/advanced-alchemy - Official Documentation : https://docs.advanced-alchemy.litestar.dev/latest/ Advanced-Alchemy extends SQLAlchemy with productivity-enhancing features, while keeping full compatibility with the ecosystem you already know. At its core, Advanced-Alchemy offers: - 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 - Integrated support for Nano ID using fastnanoid - 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 - 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 (async or sync) (tested on 18c and 23c) - Google Spanner via spanner-sqlalchemy - DuckDB via duckdb_engine - Microsoft SQL Server via pyodbc or aioodbc - CockroachDB via sqlalchemy-cockroachdb (async or sync) The framework is designed to be lightweight yet powerful, with a clean API that makes it easy to integrate into existing projects. You can find a full example using FastAPI there: https://docs.advanced-alchemy.litestar.dev/latest/usage/fram... There are custom datatypes, a service and repository (including optimized bulk operations), and native integration with Flask, FastAPI, Starlette, Litestar and Sanic. Feedback and enhancements are always welcomed! We have an active discord community, so if you don't get a response on an issue or would like to chat directly with the dev team, please reach out. The library: https://github.com/litestar-org/advanced-alchemy

Visit product View on Hacker NewsApr 23, 2025

Share card

Actual performance

38points

12comments

Made the leaderboard

Launch Intel predictions

Analyze your own launch →

Indie HackersFits the IH revenue-focused audience · Strong signals: ios, including · Missing: supports, reddit linkedin, podcasting

90%90% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Product HuntOn track for Day 1 leaderboard · Strong signals: model, google, models · Missing: mac, agents, macos

74%74% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

Hacker NewsStrong engagement from HN community · Strong signals: exist, existing, io · Missing: https docs, excited, just released

54%54% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoMay struggle as an AppSumo deal · Strong signals: interface · Missing: plus, platform, intuitive

44%44% predicted probability of success on AppSumo, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Strong signals: ios, google, way · Missing: mobile apps, personal, entrepreneurs

42%42% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Strong signals: active · Missing: arr, mrr, revenue

15%15% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Strong signals: chat · Missing: web3, crypto, cryptocurrency

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Podium: framework agnostic NLP library for data loading, preprocessing51%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Podium: framework agnostic NLP library for data loading, preprocessing

Hacker News2

Advanced mocking features of Kotlin mocking library MockK37%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Advanced mocking features of Kotlin mocking library MockK

Hacker News3

RackoonIO – virtual audio-rack framework/library56%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

RackoonIO – virtual audio-rack framework/library

Hacker News3

Advanced Graph Algorithms Library54%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Advanced Graph Algorithms Library

Hacker News3

Joomla Framework55%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Joomla Framework

Hacker News1

IntercoolerJs – A Declarative Ajax Framework73%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

IntercoolerJs – A Declarative Ajax Framework

Hacker News22

Sirius – a coffeescript MVC framework55%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Sirius – a coffeescript MVC framework

Hacker News1

Nanoshell – A framework for Bash scripting54%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Nanoshell – A framework for Bash scripting

Hacker News3

Sirius MVC coffeescript framework55%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Sirius MVC coffeescript framework

Hacker News3

kast – An UDP multicast framework55%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

kast – An UDP multicast framework

Hacker News12

Browse all products Analyze your launch