ORM in 1 minute or less.

Since I enjoy using Python, I will quickly explain ORM in the context of Python programming and why it's used.

What is ORM?

ORM (Object Relational Mapper) is a library that automates data interaction between a relational database and a python application by converting that data to objects that can be used by that application. An example would be Django ORM.

With an ORM, Python developers can write python scripts instead of an SQL Statement to retrieve or update information in their database.

orms-bridge.png

This comes with various advantages. A few of them are as follows:

  • From a theoretical aspect, Python applications can switch between any relational databases with minimal code modification without worrying about Query Statement modification.

  • Prototyping becomes faster since there's no need to switch languages or bothering about the proper Query Statement to use.

There are so many advantages but the intention is to give a very basic understanding of what an ORM does in an application.

To know more kindly reference FullstackPython, Wikipedia or Coursera.