Re:Migrating to SQLAlchemy 2.0
by BiteCode_dev on Thursday February 18, 2021 @04:00PM
(#26185440)
There is absolutely a lack of a decent SQLA tutorial for IRL code.
The doc is very formal, and if you want to make a website, a quick script or a data migration, you are left on your own to find the proper setup.
Re:Migrating to SQLAlchemy 2.0
by WesleyJohnson on Thursday February 18, 2021 @07:08PM
(#26187681)
I use Django with "real data" as well and, generally, it's pretty good once you learn how to wield it. My biggest issues are lack of multi-column primary keys and inefficient queries when doing .count(), that often introduce unnecessary group by statements in the subquery. If either of those could be addressed, I'd enjoy it so much more.
Like... Query.join(),
https://docs.sqlalchemy.org/en/13/orm/tutorial.html#querying... .
Whereas I've used Sqlalchemy and getting it to do a basic join, turns out there's 3 different ways of doing it all with an insane amount of crap to find the right way of doing things. I actually left my old job in part due to Sqlalchemy being too painful to work with.