News for hackers. Stuff that matters.

A comment on 12 requests per second: A realistic look at Python web frameworks. Parent comment

Re:12 requests per second: A realistic look at Python web fr... by vosper on Thursday February 18, 2021 @11:34PM (#26189789)
You can also use SQLAlchemy Core, which is an intermediate between the full-blown ORM and running actual strings of SQL. I've had a great experience with Core - I can easily have it output essentially the exact SQL I'd write by hand, but I get many benefits (like the ability to compose queries) that are nicer than dealing with raw SQL.
[ Parent | on HN ]
Re:12 requests per second: A realistic look at Python web fr... by SatvikBeri on Friday February 19, 2021 @12:15AM (#26190025)
Definitely agree, I'm happy to write raw SQL, but SQLAlchemy Core is even better than that because of composability.
[ Parent | on HN ]
Re:12 requests per second: A realistic look at Python web fr... by smoe on Friday February 19, 2021 @07:52AM (#26192585)
This is what I like most about SQLAlchemy, I can use the ORM most of the time, but in cases where it needs optimizations or aggregation queries I can drop down or refactor to core, while still using the same model/table definitions, ability to combine or filter queries dynamically and leverage IDE features like refactoring.
[ Parent | on HN ]