A Python ORM, inspired by Drizzle and the like. Whenever I come to Python I'm frustrated by the ORM options. They generally lack type-safety on inputs and outputs, or useful type hints.
SQLAlchemy is an institution but I think it's hard to use if it's not your full-time job. I check the docs for every query. I want something simple for the 80-99% of cases, that lets you drop easily into raw SQL for the remaining %.
I'm going to keep hacking at it, would love to from anyone who thinks this is worthwhile (or not). Also:
- The interface for update queries is clunky. Should I add codegen?
- Should I try to implement a SQL diffing engine (for migrations). Or just vendor sqldef/similar...?
A Python ORM, inspired by Drizzle and the like. Whenever I come to Python I'm frustrated by the ORM options. They generally lack type-safety on inputs and outputs, or useful type hints.
SQLAlchemy is an institution but I think it's hard to use if it's not your full-time job. I check the docs for every query. I want something simple for the 80-99% of cases, that lets you drop easily into raw SQL for the remaining %.
I'm going to keep hacking at it, would love to from anyone who thinks this is worthwhile (or not). Also: - The interface for update queries is clunky. Should I add codegen? - Should I try to implement a SQL diffing engine (for migrations). Or just vendor sqldef/similar...?