Hacker News: Kumzyhttps://news.ycombinator.com/user?id=KumzyHacker News RSShttps://hnrss.org/hnrss v2.1.1Wed, 16 Sep 2026 15:37:11 +0000<![CDATA[New comment by Kumzy in "Talk Python in Production"]]>Seems interesting, read the online summary. I am curious to read about your part on Chapter 14 (I am part of Litestar maintainer). Thank you for the book anyway !

]]>Thu, 09 Oct 2025 06:45:41 +0000https://news.ycombinator.com/item?id=45524342Kumzyhttps://news.ycombinator.com/item?id=45524342https://news.ycombinator.com/item?id=45524342<![CDATA[New comment by Kumzy in "Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy"]]>I would acknowledge they have been lacking and if they'd reviewed them recently. If so, maybe see if they'd offer some improvement areas. Do you have anything in mind in the documentation that you would like improved?

]]>Wed, 23 Apr 2025 19:30:28 +0000https://news.ycombinator.com/item?id=43775809Kumzyhttps://news.ycombinator.com/item?id=43775809https://news.ycombinator.com/item?id=43775809<![CDATA[New comment by Kumzy in "Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy"]]>Hello, OP there, I have many use cases that fall outside of FastAPI or web apps in general, and this pattern allows me to consolidate that logic in a re-usable way.

We also have SQLSpec[1] (Work in progress) that could maybe a better use case for you with raw SQL

1. https://github.com/litestar-org/sqlspec

]]>Wed, 23 Apr 2025 18:14:26 +0000https://news.ycombinator.com/item?id=43775004Kumzyhttps://news.ycombinator.com/item?id=43775004https://news.ycombinator.com/item?id=43775004<![CDATA[Show HN: Advanced-Alchemy – A framework agnostic library for SQLAlchemy]]>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

Comments URL: https://news.ycombinator.com/item?id=43771816

Points: 38

# Comments: 12

]]>Wed, 23 Apr 2025 13:17:48 +0000https://github.com/litestar-org/advanced-alchemyKumzyhttps://news.ycombinator.com/item?id=43771816https://news.ycombinator.com/item?id=43771816