Do you use ORM? What about native SQL features?

#discuss #orm #sql #database

I think there are scenarios here.

What if you are married to a dialect?
What if you want it flexible?

Top comments (13)

Maksim N Epikhin (PIKHTA) • Dec 21 '20

We used this on the example of large projects. It is convenient to use, but there are serious problems with memory and query speed. So, for example, in yii2, exporting data to csv format when using activerecord models gave out timeout or allowed memory ... While pure SQL solved the problem 100%. From my own experience, I can say that for small projects orm and activerecord are very good tools, but for large projects it is already necessary to deal with serious optimization.

vbilopav • Dec 21 '20

What if you are married to ORM library?

Pacharapol Withayasakpunt • Dec 21 '20

Which library, which language, in your case?

vbilopav • Dec 21 '20

Any library, any language.

The library might lose support, you might need to upgrade to a higher version with breaking changes.

Or perhaps you want to use some of the functionalities in different services with different languages or even reimplement the backend layer in a different language.

Those things are extremely hard if not even impossible when using ORM.

David Cantrell • Dec 24 '20

So pick the right ORM, one that is flexible, and which lets you feed it (parts of) SQL queries when necessary.

Yash_Jaiswal • Dec 21 '20

I prefer raw sql queries but then it increases the risk of SQL injection

Pacharapol Withayasakpunt • Dec 23 '20

I think ORM does translate to SQL queries, except that it isn't maintained by you.

Yash_Jaiswal • Dec 23 '20

Yes, but the execution of raw sql queries are faster.

Аqua 🜉іtæ ℠ • Dec 24 '20

What about native NoSQL for a small projects? I mean how fast would it be with MongoDB & GraphQL. How many of those pairs u're able to setup simultaneously?

Pacharapol Withayasakpunt • Dec 24 '20

You can do what you want, but the real strength of MongoDB lies in Aggregation framework.

Otherwise, it doesn't even matter which database you choose.

Аqua 🜉іtæ ℠ • Dec 24 '20

Well. The only thing do DATA-base stand 4 - the data. I mean types, memory allocation, responsiveness, etc. Any frameworks is stand for frame. So, no any relations. But my point was about GraphQL as ORM replacement. If it possible to say so. Just an analogy.