Ask HN: Is it reasonable to choose direct SQL over an ORM

Re:Ask HN: Is it reasonable to choose direct SQL over an ORM by cjbprime on Saturday March 23, 2019 @10:07AM (#19470498)

For something other than a webapp, sure.

If you're writing a webapp, I suppose I would suspect that you just haven't spent enough time with a good ORM. It's natural to get frustrated with it occasionally, but seems like you can drop to SQL for those cases as a one-off, rather than discard the ORM totally?

[ Parent | on HN ]

Re:Ask HN: Is it reasonable to choose direct SQL over an ORM by thymanl23 on Saturday March 23, 2019 @02:19PM (#19471614)

Hmm, yeah, but I think more than just not using a query building api, I prefer pure result objects. Even when dropping to SQL, the result objects are still database-aware objects. I prefer distinct layers between the business domain layer and the data access layer. Having a data access layer return pure business objects allows for this decoupling, but maybe I'm being to strict and forcing a distinction where there doesn't need to be one?

[ Parent | on HN ]