If you use a programming language framework such as Django or Ruby on Rails, chances are you use an ORM to help you construct queries.
What’s an ORM?
If you’re not familiar with ORMs, an ORM is an Object-Relational Mapper, which helps you map objects in your code to tables in your database, without writing SQL. It basically writes the SQL for you, so your objects know how to store and retrieve themselves from a relational database like MySQL or Postgres.
ORMs can be a great productivity booster. Most SQL is tedious and repetitive, and maintaining it manually when you change classes (for example, adding or removing fields) is painful. Especially in the early stages of development when you aren’t sure of the final data model and you’re iterating rapidly, ORMs save a ton of work.
And frankly, ORMs make a lot of sense on an ongoing basis too, even for mature, high-traffic systems. You usually …[Read more]