Hacker News new | more | comments | ask | show | jobs | submit login

And it allows you to write specific queries that can then be post filtered / ordered / paginated by a more general mechanism.

Or you can write queries and play around with loading strategies later / change them over time as the shape of the data changes without having to change any other code.

Every time the ORM thing comes up on HN most people jump on the ORMs are evil bandwagon. I think sqlalchemy is probably a bit of an exception in terms of just how flexible it is, however in my experience you get all the benefits with next to no downside (performance overhead being the most obvious). I generally wouldn't start a project without it these days.

Applications are open for YC Summer 2019

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact