/plushcap/analysis/timescale/orms-in-production-postgresql-friend-or-foe

ORMs in Production PostgreSQL: Friend or Foe?

What's this blog post about?

Object-relational mappings (ORMs) are popular among developers as they allow for the connection of object-oriented programming languages with databases, such as PostgreSQL. ORMs provide an object-oriented model and a familiar language interface, making them convenient to use. However, they also come with downsides, including complexity, inefficient SQL queries, difficulty in managing migrations or updates, and potential vulnerabilities hidden beneath abstraction layers. While ORMs can be helpful during initial development, they may become obstacles when scaling down the line. Therefore, it is not recommended to use ORMs on large-scale production Postgres systems.

Company
Timescale

Date published
July 1, 2024

Author(s)
Team Timescale

Word count
1014

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.