[carderne]

Embar: https://github.com/carderne/embar

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...?

[Bombthecat]

You have my vote! Go for it! After I left ruby on rails, I always felt like that python ( orm) could be better

[1ark]

I feel you about SQLAlchemy, so I switched to peewee, which is beautiful to work with.

[carderne]

peewee is nice, but I can't write un-typed Python anymore, so it's not an option for me.