DEV Community 👩‍💻👨‍💻

DEV Community 👩‍💻👨‍💻 is a community of 966,904 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create account Log in
Anubhav Singhal
Anubhav Singhal

Posted on

Why we should always use ORM?

Interacting with the database is a key component of an application and the manner that we do it makes a big impact in the process of development and user experience.

There are several techniques, one of which is ORM. Let's talk in depth about it.

Note: I'll be using Django as a reference, but the same principles apply almost everywhere.

What is ORM ?


ORM is an acronym that stands for Object Relational Mapping. An object is what you use in your programming language, a relation is your database, and mapping is the link between the two.

ORM is a technique that lets you query and manipulates data from a database using an object-oriented paradigm. It encapsulates the code needed to communicate with the database, so you don't use SQL anymore; you interact directly with an object in the same language you're using.

Read more at What is an ORM, how does it work

ORM Lazy-Loading

In ORM, Querysets are known to be lazily loaded in order to load only what is required rather than the entire database.

Lazy loading means that until you perform certain actions on the queryset, such as iterating over it, the corresponding DB query won't be made.

For. e.g

result= Person.objects.all()
# Query hasn't been executed yet

# Query still hasn't been executed

for obj in temp:

# Now query has been excecuted
Enter fullscreen mode Exit fullscreen mode

ORM Caching


Interacting with large databases is a time consuming task, that's why Querysets are cached. The primary motive for ORM caching is to increase performance through localised data access as an alternative to making a database round trip to retrieve it.

For e.g. (Continued from last example)

result= Person.objects.all()
# Query hasn't been executed yet

# Query still hasn't been executed

for obj in temp:
# Now query has been excecuted

for obj in temp:
    print(obj.age,": ", obj)
# Query hasn't been executed this time, because of caching.
Enter fullscreen mode Exit fullscreen mode

Read more at Django Optimization: Or how we avoided memory mishaps

Pros of using ORM

Today's developers (2)

Production: You don't have to be an expert in SQL queries, since you don't have to write SQL. Also, a lot of stuff is done automatically, hence Your code becomes short, clean, and easy to maintain.

Flexibility: it is generally available in the language of your choice, and lets you use OOPs goodness like inheritance very easily.

Cons of using ORM

  • ORM has tendency to slow down a little, as compared to direct communication with SQL.
  • Developer has to go through ORM library, and understand it's functions and utilities so as to be able to use it efficiently.

To summarise, I believe in most of the use cases benefits of using ORM easily exceeds drawbacks. I've been using ORM for a while now, and it's significantly improved my development experience.

What do you think? Put down in the comments. As always suggestions are always welcome.

Find me on: Twitter | GitHub | LinkedIn

Happy Coding.

Top comments (2)

honatas profile image
Jonatas de Moraes Junior

In general, the main drawbacks to me are:

  • You have to learn SQL anyway;
  • You lose raw SQL power (no unions, no subqueries in from clause);
  • You are forced to model your tables according to the ORM's mapping limitations;
  • You lose performance.

I only use an ORM when all of these are acceptable. Here are my two cents:

anubhavitis profile image
Anubhav Singhal Author

Bro, your article is good. I love your writing style.

And yes, I agree with you. I just meant, in most of the use cases these points are acceptable.

🌚 Friends don't let friends browse without dark mode.

Sorry, it's true.