Hacker News new | ask | show | jobs
by qatanah 1944 days ago
Thanks for the hardwork zzzeek! I've been using sqlalchemy for 5+yrs now and it's great to work with!

I like SQL and I like the ORM. When things go tough like doing complicated JOINs or OLAP. I just go raw sql. If it's OLTP, updates and simple lookups, ORM makes the code readable.

The alembic migration is also great! I can craft the models to design with postgres features (index, multi key index, pk uuid) and etc..

I'd would love sqlalchemy to invest more on scaling. Although scaling is an entire book of discussion. Not much resources are there for handling multiple db, sharding (maybe too much to ask).

My opinion is, love SQL and Love the ORM. You'll need both to appreciate it's power. It's like learning VIM, a long term investment tool and hard to :wq