loading...

re: ORM vs. SQL? VIEW POST

FULL DISCUSSION
 

I prefer to always use SQL, mainly because I know SQL and I don't want to always re-learn a new tool from scratch every time I pick a different technology.

Benefits:

  • Fine performance tuning
  • Infinite possibilities for requests building
  • Clear/concrete and easy to debug
  • Very easy to maintain or migrate/convert

Downsides:

  • Require to know both SQL and your RDBMS
  • May be harder to set up properly (with stores, injection etc)

A good mix I like is raw SQL with a small query building factory, like easydb in PHP

code of conduct - report abuse