The App Nobody Talks About That Runs Half the Internet

There is software running on your phone right now that depends on a database that was started in 1986 by a Berkeley professor named Michael Stonebraker. That database — PostgreSQL — powers Instagram's media storage, Notion's entire workspace product, Stripe's transaction ledger, and an estimated 30-40% of all production database workloads on the internet.

It is maintained almost entirely by volunteers. It has never had a major security breach. It has never lost data in a properly configured deployment. It has been the world's most advanced open-source relational database for about twenty years, and most people who use products built on it have no idea it exists.

This is a story about infrastructure, and why the most important software is often the least glamorous.

What PostgreSQL Actually Is

PostgreSQL (pronounced "post-gres-Q-L," often shortened to Postgres) is a relational database management system. That means it's the software responsible for storing, organizing, and retrieving structured data.

If that sounds boring, consider what it means in practice: every tweet someone has ever saved as a draft, every Stripe payment record, every Notion page, every row of data in millions of business applications — this stuff lives somewhere. In an enormous percentage of cases, it lives in PostgreSQL.

Relational databases organize data into tables with defined schemas, enforce rules about data integrity (you cannot, for instance, create an order row that references a customer who doesn't exist), and allow complex queries across multiple tables using SQL — the query language that has remained essentially standard since the 1970s.

What makes Postgres remarkable among relational databases is how much it does beyond the basics.

The Features That Shouldn't Exist in a Free Tool

PostgreSQL has a feature set that embarrasses expensive commercial databases.

Full-text search. Most databases require a separate search engine for text search. PostgreSQL has a sophisticated built-in full-text search system with language support, ranking, and relevance scoring. Small to medium applications can do without Elasticsearch entirely.

JSON and JSONB support. PostgreSQL can store, index, and query JSON data with performance competitive with dedicated document databases. This has enabled a category of applications that use Postgres as both their relational and document database.

pgvector. Added via extension, pgvector turns PostgreSQL into a vector database — the kind needed for semantic search and AI applications. Pinecone and Weaviate sell this capability as standalone products. PostgreSQL users can add it for free.

PostGIS. A geographic extension that turns PostgreSQL into a fully capable geographic information system. The mapping features in applications that would otherwise require expensive GIS software can often be built on PostGIS.

Logical replication, streaming replication, point-in-time recovery. The reliability and redundancy infrastructure that serious production databases require — all built in.

Postgres is the only database you might start a project with and never need to replace, no matter how large the project gets.

The Governance Model That Shouldn't Work (But Does)

The PostgreSQL Global Development Group is a loosely organized collection of volunteers and company-sponsored contributors from around the world. There is no corporate parent. There is no VC backing. There is no CEO.

A new major version ships roughly every year. The release notes are scrupulously honest about what changed, what broke, and what the migration considerations are. Security patches are handled with quiet professionalism that large commercial vendors rarely match.

Compare this to the lifecycle of commercial database software: Oracle's licensing costs can run into crores for enterprise deployments, with annual maintenance fees, and the company's relationship with its users is adversarial enough that "avoiding Oracle" is a common engineering objective. Microsoft SQL Server is excellent but expensive and Windows-heritage in ways that create friction in Linux-first environments.

PostgreSQL is free, runs everywhere, and has a sixteen-year track record of not doing anything harmful to its users. It is one of the few pieces of software you can completely trust.

Why Instagram Chose It, and Why That Matters

When Instagram was a startup in 2010, they chose PostgreSQL. By 2012, they had one of the fastest-growing platforms in internet history running on it. In 2012, they published a blog post describing how they sharded their PostgreSQL deployment to handle hundreds of millions of rows across thousands of tables.

This matters because it established a proof point: you don't need to "scale beyond Postgres." You need to understand Postgres deeply enough to use it well at scale. The database isn't the bottleneck — the engineering understanding of the database is.

Notion, as of its public technical writing, runs essentially its entire product on PostgreSQL with careful sharding. Stripe has built significant payment infrastructure on it. Linear, the project management tool, is famously Postgres-first and has published extensively about how it achieves its speed.

The Indian Tech Stack Connection

PostgreSQL dominates the tech stacks of Indian startups in ways that go somewhat unnoticed. Razorpay, CRED, Zepto, Meesho — the majority of high-growth Indian tech companies use PostgreSQL as at least part of their data infrastructure. The combination of no licensing cost, excellent reliability, and strong community support maps well to the cost-consciousness and engineering-intensity of Indian startup teams.

The managed PostgreSQL market — AWS RDS for PostgreSQL, Google Cloud SQL, Supabase, Neon — has made running Postgres in production dramatically simpler than it was a decade ago. The operational burden that once required dedicated database administrators has largely been abstracted away.

The Point

The internet's infrastructure is held together by a remarkable amount of software that nobody has ever heard of, maintained by communities that receive almost none of the glory that consumer-facing applications do. PostgreSQL is among the most important of these — a piece of software that is technically excellent, reliably maintained, and entirely free, used by companies worth hundreds of billions of dollars collectively.

The people who maintain it do so largely because they believe good infrastructure should exist. That's not a business model. It's something better.

---