Hacker News new | ask | show | jobs
by simondotau 27 days ago
As long as you restrict yourself to an ORM-compatible schema, you are restricting the power of SQL available to you. Learning SQL properly means learning to model your data correctly, and this usually makes ORMs a non-starter.

Without an ORM you have to write a bit more boilerplate code to interact with the database. But by taking advantage of the power of your database engine, you could potentially avoid writing huge amounts of data manipulation logic. In my experience, an ORM is more of a code amplifier than a code simplifier.

2 comments

All of this depends on the problems you’re solving though. There is no one size fits all approach to database development.
Generally speaking if an ORM is a good fit, the thing you're doing probably isn't database development, it's application state management disguised as database development.
ORM is compatible with any schema, but perhaps you are thinking of something like the active record pattern?