platform longevity by design

PostgreSQL outlasted 40+ databases over 30 years by designing for change, not speed FOSSASIA
TL;DW
  • PostgreSQL survived 30 years and outlasted 40+ databases by designing for change, not by being fastest or easiest.
  • 90% of web frameworks from mid-2000s are obsolete; 60% of infrastructure open-source projects abandoned within 5 years—PostgreSQL is rare exception.
  • PostgreSQL's core design assumption: the database model itself will change over time, enabling long-term architectural flexibility.
  • Extension framework separates stable core from innovation ecosystem, proving new features (e.g., pglogical→logical replication) before bringing into core.
  • Databases that bet on single new models (object databases, XML databases, NoSQL) without conservative approach didn't survive long-term.
  • PostgreSQL adapted to AI era not by becoming an AI database, but by safely adopting AI workloads through pgvector, pgai, and extensions.
  • Managed cloud services and distributed systems challenged PostgreSQL more than competitor databases, yet it adapted through platform flexibility.
  • Databases that specialized narrowly (vector DBs, distributed systems) or got acquired/refocused (Informix, Sybase) faded despite early strength.
  • PostgreSQL succeeded through strong community, stable architecture, and avoiding vendor lock-in—not aggressive marketing or technological dominance.
  • Stagnation is fatal in infrastructure software; PostgreSQL thrived by incremental, conservative evolution paired with extensible innovation ecosystem.

Evans traces PostgreSQL's survival through four computing eras—hierarchical, commercial RDBMS, NoSQL, and cloud/AI—showing how competitors failed by specializing too narrowly or rewriting for trends. PostgreSQL's extension framework absorbed each wave (pgvector, pgAI) without destabilizing the core.