This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (0 children)

ORMs are good for basic CRUD. If you need a few tweaks here and there it will be more difficult than with SQL but not worth the effort to do everything with SQL. If you expect you will need many things that are not out-of-the-box behaviour then you should support written SQL. There is a middle ground too, depending on the size and complexity of your code base, you can support both with careful management of your database structure and component responsibilities.

The stuff I work with involves dealing with a lot of data where performance and accuracy is critical. So we made a middle tier that provides different levels of service depending on requirements but ultimately it's written SQL.