Ask HN: Are ORMs overkill for using SQL databases?
SQL is something fundamental we learn with programming. The syntax is mostly standard.
Why trade this 'CONSTANT' with myriad variations of ORMs across languages/frameworks for using same flavour of SQL.
I feel ORMs are overkill. For simple queries ORMs are ok but with complex queries - there is extra effort spent on translations/debugging/optimisations etc.
- -
Having said that - ORM can be helpful in one-off cases like below:
- if-and-when database migration happens from one type of database to other (eg: postgres->mariadb etc)
Why trade this 'CONSTANT' with myriad variations of ORMs across languages/frameworks for using same flavour of SQL.
I feel ORMs are overkill. For simple queries ORMs are ok but with complex queries - there is extra effort spent on translations/debugging/optimisations etc.
- -
Having said that - ORM can be helpful in one-off cases like below:
- if-and-when database migration happens from one type of database to other (eg: postgres->mariadb etc)
What is your take on this ?
edit: rephrased sentence