Back to browse
Repositron a typed CRUD for SQLAlchemy with no per-table boilerplate

Repositron a typed CRUD for SQLAlchemy with no per-table boilerplate

by felipeadeildo·Jun 26, 2026·1 point·0 comments

AI Analysis

●●SolidSolve My ProblemBig Brain

UNSET vs None distinction for updates solves a real SQLAlchemy pain point.

Strengths
  • Pagination requires order_by, turning production heisenbugs into compile-time errors.
  • UNSET sentinel distinguishes 'skip column' from 'set NULL' in partial updates.
  • Full end-to-end typing means repo.list() returns list[TaskDTO] with no casts.
Weaknesses
  • Repository pattern for SQLAlchemy already has multiple established implementations.
  • Niche audience—only matters if you're already committed to repository pattern.
Target Audience

Python backend developers using SQLAlchemy 2.0

Similar To

SQLModel · SQLAlchemy-Utils · FastAPI-Utils

Similar Projects

Spring CRUD Generator v1.2.0 – Flyway portability and Docker checks

Generates Spring CRUD code plus Flyway migration scripts and Docker healthchecks, and even adds support for JSON<List<Type>> collections and reserved-SQL-keyword handling. Practical fixes — consistent unique-constraint naming, Docker port config, and a demo repo — make it a useful time-saver for teams, but it sits in an already crowded landscape of Spring scaffolding tools.

Niche GemShip It
mzivkovicdev
204mo ago