Drizzle for Python?

[meads2]

Python is becoming a popular developer langugage with the interest in AI and agent based apps as well as the awesome FastAPI framework. Is there any exploration of making a drizzle-python library? I think the python ecoysystem has been lacking a mature ORM since SQLAlchemy in flask days, but async isn't really good with it and types are flakey.

[kravetsone]

just use typescript

[leetdavid]

I don't want to have drizzle ported to Python (Python has other ORMs albeit not as good as drizzle). However, being able to check that I have the correct table and field names in Python for a schema that was written in drizzle would be great.

[diramazioni]

+1 for a python version like Prisma does.
That's the reason I use Prisma, my app is half in typescript and half in python

[kravetsone]

+1 for a python version like Prisma does. That's the reason I use Prisma, my app is half in typescript and half in python

prisma schema language is target agnostic so it really good multi-language prisma

but not in dirzzle case

just use something else in python

also i guess no one from drizzle team is interesting in this

[trevorbroad]

+1 I'm interested in this!

[misterdojo777]

yup same here! Our stack is typescript<>Pyhon and it would be nice to have a unified ORM. EdgeDB is an alternative (the only one afaik) if you don't mind learning their GraphQL syntax.

[TechWithTy]

Anything yet?

[aajaces]

Claude code wrote me a plugin using ts-morph fairly quickly. 400 lines of code. Seems trivial as a workaround for now

[romainPrignon]

@aajaces can you share ? 😊

[aajaces]

Yup! (again, it's AI-slop) - https://github.com/jaces-com/jaces/blob/main/apps/web/scripts/drizzle-to-python.ts

[romainPrignon]

thanks 🙏

[parasdaryanani]

@aajaces the link is broken, please can you republish as a gist maybe?

[aajaces]

https://gist.github.com/aajaces/9bcd14d40c19f71303bfa80eebfe14a8

[1216892614]

TBH, Python's type hint community is so terrible, and drizzle's advantages very based on ts