Content Deep Dive
ORMs in Production PostgreSQL: Friend or Foe?
Blog post from Tiger Data
Post Details
Company
Date Published
Author
Team Tiger Data
Word Count
1,248
Language
English
Hacker News Points
-
Summary
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.