Updated

PostgreSQL

Open-source relational database with SQL, transactions, JSON and a large extension ecosystem (PostGIS, pgvector).

98 makers' products we track use PostgreSQL. For database it's 4th most chosen of 23 options: 98 of the 1,263 makers' products we know the database of (8%). Among the 397 launched in 2026, 1% chose it, against 7% of those launched in 2024 or earlier. 622 open-source projects also declare it in their code. What makers like most: It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. Their most common complaint: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes. On GitHub, 116 public pull requests moved projects to PostgreSQL from tools we list, and 103 moved them away.

Open sourceSelf-hostableFree tier

Profile checked

Works with AI agents:Built into Replit
Ask your AI about this, with this page as the source:ChatGPT ↗Claude ↗Perplexity ↗

How makers use PostgreSQL

Makers' products we track use PostgreSQL for database (98), most often alongside Next.js (42%), Vercel (36%), Postmark (29%).

What PostgreSQL is used for

Database · Run it yourself →The engine behind most of the hosted options above, run on your own server or container for full control and a flat cost.Trade-off: Backups, upgrades, failover and connection pooling are yours to set up and watch.
Supabase573Firebase187MongoDB128PostgreSQL98Neon96Makers' products on each, for database

PostgreSQL vs the alternatives makers chose

For database, 98 of the 1,263 makers' products we know the choice of picked PostgreSQL (8%), behind Supabase (45%). Among those launched in 2026 it's 1%.

OptionMakers' products2026 launchesFree forAt 10,000 usersOpen source
Supabase573 45%63%~500 users$25/mo · ProYesCompare →
Firebase187 15%9%~2,000 users$9.66/mo · Blaze (pay as you go)No
MongoDB128 10%5%~500 users$58/mo · Atlas Dedicated M10NoCompare →
PostgreSQL98 8%1%——Yes
Neon96 8%11%None$22/mo · LaunchYesCompare →
Convex50 4%7%~630 users$29/mo · ProfessionalYes

For database: how many of the 1,263 makers' products we know the database of chose each option, and the share among the 397 launched in 2026, since a tool that came first has products from every year, and what each costs at 10,000 users.

Costs are the cheapest plan that fits, from each vendor's pricing page, at the usage our stack planner assumes for a product with that many users. Free for: the users its cheapest plan a business can use stays free for.

Often paired with

Share of the 98 makers' products on PostgreSQL that show this choice.

Markets that build with it most

Product Hunt markets where PostgreSQL is in far more of the stacks we know than across every market (1%).

When to use PostgreSQL, and when not

Pick PostgreSQL if

  • You already run your own server and want a flat monthly cost. Database →

Something else fits better if

  • You want the database, auth and file storage in one project, and plain SQL you can take elsewhere: Supabase.
  • You're building a live, collaborative app entirely in TypeScript: Convex.
  • Your traffic is bursty or you run many preview deploys, and idle hours shouldn't cost much: Neon.
From each decision's guide, written from what makers' products chose and why.

PostgreSQL is a relational database server: you define tables with types and constraints, query them with SQL, and it keeps data consistent through crashes and concurrent writes. It has been in development since 1986 at Berkeley and ACID-compliant since 2001.

More about PostgreSQL

The model to understand: one server process (the postmaster) listens for connections and starts a separate backend process for each client, which parses, plans and runs that client's queries. Clients talk to it over the PostgreSQL wire protocol, either through the C library libpq, which many language drivers wrap, or through independent implementations such as the Java JDBC driver.

What a small team gets in one database: all SQL-standard isolation levels including serializable, json and jsonb columns with indexing, built-in full-text search, many index types (GIN, GiST, BRIN and more), foreign data wrappers for querying other systems, and extensions such as PostGIS. Streaming replication keeps hot standbys in sync, and logical replication publishes changes table by table. It is free under a liberal license similar to BSD or MIT, and runs on all major operating systems.

Limits to know when running it yourself: each connection is a full server process, and the connection limit usually defaults to 100 and can only be changed by restarting the server. PostgreSQL does not include software that detects a failed primary and promotes a standby; that needs outside tools. Major-version upgrades need a dump and restore or pg_upgrade.

PostgreSQL pros and cons

What makers like most: It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. Their most common complaint: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes.

Pros

  • It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. PHPH 2PH 3PH 4
  • With pgvector, embeddings live next to relational data, so AI features need no separate vector database. PHPH 2PH 3PH 4
  • Extensions and features like PostGIS, JSON support and advanced indexing cover geospatial and semi-structured data too. PHPH 2PH 3
  • Being open source and offered by dozens of hosts, it avoids lock-in, and pg_dump makes switching providers easy. PHPH 2PH 3PH 4
Product Hunt review tags
reliability18
performance10
scalability10
advanced features8
open source8
advanced indexing4

Cons and watch-outs

  • Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes. HNHN 2
  • It has no loose index scan, so SELECT DISTINCT over large tables needs manual workarounds. HNHN 2
  • Timestamp versus timestamptz and AT TIME ZONE behavior are easy to get wrong, with edge-case bugs around daylight saving. HNHN 2HN 3

Themes that recur in makers' words and Hacker News comments, each linked to what it summarises, with how Product Hunt tags its reviews.

5.0★ from 77 reviews on Product Hunt ↗

What Hacker News says about PostgreSQL

On Hacker News, 14% of comments about PostgreSQL recommend it and 3% criticize it: net praise +11%, 8th best liked of 16 tools HN discusses for database.

By year

YearComments choosing it, per monthNet praise
202373+22%
202460+8%
202555+8%
2026 (8 mo)74+4%

In their words

  • “I’m very comfortable in Postgres and the setup cost is basically zero” HN, Aug 2026
  • “100% Vanilla Postgres. We run upstream Postgres, no modifications.” HN, Apr 2026
  • “Even with a proxy like PgDog the Postgres sharding story isn't solved.” HN, Jun 2026

Hacker News comments January 2023 to August 2026 that name PostgreSQL in a sentence like "I use" or "we moved to", Claude read a sample of 100 and the counts scale it to all of them; net praise is comments recommending it minus comments criticizing it, as a share of all comments about it. How it's counted, and how HN compares with makers.

Who switches

More projects move to PostgreSQL: 116 pull requests in, 103 out; the most come from MongoDB and leave for Neon.

Moving to PostgreSQLMoving away
PostgreSQL
MongoDB → PostgreSQL38 PRs
Supabase → PostgreSQL27+ PRs
Neon → PostgreSQL25 PRs
Firebase → PostgreSQL12 PRs
Turso → PostgreSQL6 PRs
PostgreSQL → Neon41 PRs
PostgreSQL → Supabase26+ PRs
PostgreSQL → MongoDB23 PRs
PostgreSQL → Firebase6 PRs
PostgreSQL → Turso4 PRs

Public pull requests on GitHub since Oct 2024 whose title says "X to Y" — real code changes moving a project from one tool to another, by developers in general.

Who uses it

98 makers' products, each linked to the source that shows it, and 622 open-source projects that declare it in their code. The best known on Product Hunt: Scispace (3,114 followers), InsForge (2,302 followers), Lightfield (2,260 followers), Atlas.co (2,124 followers), Skarbe (2,082 followers). 1 of the makers' products is gone now (domain lapsed, up for sale or taken down); it chose PostgreSQL while live.

The maker says so 64Job posting 34Declared in code 626How evidence is collected →
Supabase
SupabasePostgres-based backend: database, auth, storage, realtime and edge functions in one proj…

“At its core, Supabase is backed by Postgres, the gold standard for robust, reliable, and scalable databases.”

DatabaseMaker says so +1 · source ↗
Dodo Payments
Dodo PaymentsMerchant of record for SaaS, AI and digital products, with usage-based billing.

“Our primary database, offering strong consistency and robust transaction support.”

DatabaseMaker says so · source ↗
Songstats
SongstatsMobile-first Streaming Insights | Real-time Playlist Alerts | Track your Streams, Follow…

“Our tech stack combines React / React Native for the front, sitting on top of a Rails backend and a PostgreSQL database.”

DatabaseMaker says so · source ↗
Prisma
PrismaTypeScript ORM with a schema file and generated client; also offers hosted Prisma Postgr…

“Built on PostgreSQL. Prisma Postgres is our managed DB hosting for agents and TypeScript apps.”

DatabaseMaker says so · source ↗
JustPaid
JustPaidAutonomous AI for billing, contracts, and collections.

“Postgres is rock-solid and scales with us effortlessly. Its reliability and ecosystem make it a no-brainer over other databases.”

DatabaseMaker says so · source ↗
Byterover
ByteroverFile-based memory for agents with >92% retrieval accuracy

“Reliable database storing memory data with full-stack integration for user management.”

DatabaseMaker says so · source ↗
Warestack
WarestackEngineering delivery governance for GitHub organizations

“PGVector's native vector operations with PostgreSQL's ACID compliance works perfectly. We're storing millions of embeddings with sub-millisecond similarity search using cosine distance. The async connection pooling handles concurrent connections, while the vector indexing makes our query super fast. Having vector search, full-text search, and relational data in one database eliminates the complexity of managing multiple data stores.”

DatabaseMaker says so · source ↗
Permit.io
Permit.ioPermissions for The AI Era

“PostgreSQL gives us the best balance between well-structured data persistency and clean code principles”

DatabaseMaker says so · source ↗
Superexpert.AI
Superexpert.AIOpen-source platform for enterprise AI agents, web-first.

“Superexpert.AI uses this database -- used the pgvector extension to support vector embeddings in the database.”

DatabaseMaker says so · source ↗
VisionAR
VisionARTransform 2D images into immersive 3D models.

“Postgres is rock-solid. It handles complex data relationships gracefully and gives us the querying power we need as we scale. For relational data, it’s hands down the best choice for us.”

DatabaseMaker says so · source ↗
Skarbe
SkarbeAI email inbox for founders and others who do sales part-time; an assistant tracks conve…

“PostgreSQL is our go-to database because of its reliability, scalability, and powerful support for structured data, making it ideal for managing and syncing customer data across multiple platforms.”

DatabaseMaker says so · source ↗
Layer
LayerBrain-Inspired Planner

“PostgreSQL serves as our primary database, offering powerful SQL querying and reliable data storage for managing structured data and transactions.”

DatabaseMaker says so · source ↗
Open Paper
Open PaperA workbench for academic literature review

“ergonomic - easy to self-host, but also super easy to scale up to millions of users”

DatabaseMaker says so · source ↗
Neon
NeonServerless Postgres with branching and scale-to-zero.

“The best relational database out there. Loved by developers worldwide.”

DatabaseMaker says so · source ↗
Incerto
IncertoThe AI Copilot for Databases

“Postgres was the second database we added, and honestly, it needs no introduction. This OSS RDBMS is massive, reliable, and just incredible to work with.”

DatabaseMaker says so · source ↗
Morphik
MorphikAdvanced retrieval for technical and visual rich docs

“pgvector is easy to use, and generally postgres is super easy to setup and run, especially with supabase!”

DatabaseMaker says so · source ↗
Scispace
ScispaceYour AI Companion to Understand Any Research Paper

“PostgreSQL is indispensable, housing our vast repository of 300 million papers totaling terabytes of data.”

DatabaseMaker says so · source ↗
Semos.ai Manager Agents
Semos.ai Manager AgentsAI agents purpose-built for managers

“We picked PostgreSQL over MongoDB and dedicated vector databases because one proven database handles our relational data, JSON and agent memory, with no extra stores to run.”

DatabaseMaker says so · source ↗
pgMustard
pgMustardpgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, s…

“I run pgMustard , which is an online tool for developers that helps them troubleshoot slow PostgreSQL queries.”

DatabaseMaker says so · source ↗
Cook Eat
Cook EatEntdecken Sie die umfassenden NFHS-Baseballregeln auf cookeat.ch, die Fairplay und Siche…

“Listed in their tool stack on Starter Story”

DatabaseMaker says so · source ↗
Exirio
ExirioExirio is a free wealth management app to track all your investments, in any currency. U…

“Google Workspace Discord GitHub AWS PostgreSQL REdis InfluxDB Python Flask …”

DatabaseMaker says so · source ↗
CamelAI
CamelAIAI Data Analyst - Chat with your data

“Postgres is so nice to work with. pg_dump was a lifesaver when we had to move database providers. Extensions like pgvector make it the best database for building AI apps.”

DatabaseMaker says so · source ↗
Router.so
Router.soHeadless Form Handling and Lead Routing for Developers

“Powers everything in Router.so and makes it easy to set up an open source instance.”

DatabaseMaker says so · source ↗
Qibble
QibbleFind out who's right

“Postgres stands out thanks to its rock‑solid reliability and rich feature set—think advanced indexing, robust JSON support, and strong concurrency. It’s open source, highly scalable, and keeps our data queries speedy without locking us into proprietary models. Alternatives Considered: MySQL: Popular, but we preferred Postgres’s deeper JSON and indexing capabilities. MongoDB: Excellent for flexible schemas, but we needed the reliability of SQL. MariaDB: Similar to MySQL, but Postgres’s community and extension ecosystem won us over.”

DatabaseMaker says so · source ↗
TheLifeSigns
TheLifeSignsLifeSigns is a simple and free service for people living alone. To make sure you are sti…

“Starting with my preferred editor vs-code to full-fledged SQL databases like PostgreSQL , none of these cutting-edge applications cost anything.”

DatabaseMaker says so · source ↗
Hook0
Hook0OpenSource Webhook as a Service, Secure and Enterprise Ready

“PostgreSQL reliability and scalability mean that as Hook0 grows, PGSQL grows with us, ensuring that your data is always safe, secure, and accessible in real-time”

DatabaseMaker says so · source ↗
Integrity
IntegrityUnified project brain: docs, canvases, and AI chats together

“Postgres is the backbone of our data layer. Rock-solid, feature-rich, and endlessly reliable, it let us scale with confidence while keeping queries elegant and our data safe.”

DatabaseMaker says so · source ↗
Monkt
MonktTransform files and web pages into AI-ready Markdown or JSON

“Rock-solid open source database that handles complex queries and high loads while maintaining data integrity. Production-ready and battle-tested.”

DatabaseMaker says so · source ↗
StatusSight
StatusSightReal-time outage alerts for the services you rely on

“StatusSight uses PostgreSQL to store and analyze health data for thousands of services and APIs. We chose it since it's performant, powerful, and well-documented.”

DatabaseMaker says so · source ↗

Open source: a project that declares PostgreSQL as a dependency in its public code — verifiable, but not necessarily a live product.

What its projects tell coding agents

266 of the 422 open-source products built with PostgreSQL that were worked on in the last 180 days keep instruction files for coding agents — 63%, against 53% of all the projects we read. AGENTS.md is in 212, CLAUDE.md in 161.

1,060words in the median file
pnpmthe package manager most named, in 60 of 240 files
70%say how to test a change
Named more in these files than in other projects' — in how many of the 240:
What AGENTS.md files say about other tools →What open-source products tell their coding agents →

Alternatives to PostgreSQL

All alternatives by situation →

Further reading

Questions makers ask about PostgreSQL

Is PostgreSQL good for production?

98 makers' products we track run on it, and 1 of them have since gone (the product, not necessarily because of PostgreSQL). On GitHub, 116 public pull requests moved projects to PostgreSQL from tools we list, and 103 moved them away. The watch-out makers raise most: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes.

What is PostgreSQL used for?

Open-source relational database with SQL, transactions, JSON and a large extension ecosystem (PostGIS, pgvector). Makers' products we track use it for database (98).

What are the pros and cons of PostgreSQL?

Pros makers name: It is rock-solid, keeps data consistent with strong transactions, and handles complex relational queries well. With pgvector, embeddings live next to relational data, so AI features need no separate vector database. Extensions and features like PostGIS, JSON support and advanced indexing cover geospatial and semi-structured data too. Cons: Built-in full-text search lacks corpus-wide relevance ranking like BM25 and can need very large indexes. It has no loose index scan, so SELECT DISTINCT over large tables needs manual workarounds. Timestamp versus timestamptz and AT TIME ZONE behavior are easy to get wrong, with edge-case bugs around daylight saving.

What are the alternatives to PostgreSQL?

For database, the other options makers' products we track chose most are Supabase (573), Firebase (187), MongoDB (128), Neon (96), Convex (50). Open source or self-hostable among them: Supabase, MongoDB, Neon, Convex. Each alternative, with the situation it fits, is on the PostgreSQL alternatives page.

Is PostgreSQL still popular with new products?

Less than before: among the 397 makers' products launched in 2026 that made the database choice, 1% chose PostgreSQL, against 7% of the 335 launched in 2024 or earlier.

Do developers switch to or away from PostgreSQL?

On GitHub, 116 public pull requests moved projects to PostgreSQL from tools we list, most from MongoDB (38), Supabase (27), Neon (25); 103 moved them away, most to Neon (41), Supabase (26), MongoDB (23).

When should you use PostgreSQL?

You already run your own server and want a flat monthly cost (database). Something else fits better if: you want the database, auth and file storage in one project, and plain SQL you can take elsewhere, pick Supabase; you're building a live, collaborative app entirely in TypeScript, pick Convex.

How long is each version supported?

A new major version comes out about once a year, and each major version is supported for five years. Minor releases with bug and security fixes ship at least every three months. source ↗

How do I upgrade to a new major version?

Major versions change the on-disk format of system tables, so you either dump and reload, or use pg_upgrade, which reuses the existing data files and avoids a full dump and restore. Minor upgrades only need new binaries and a restart. source ↗

Can PostgreSQL store JSON?

Yes. There are two types, json, which keeps the exact input text, and jsonb, which stores a decomposed binary form that is faster to process and can be indexed. A jsonpath type supports queries into documents. source ↗

Does it have built-in full-text search?

Yes. Full-text search finds natural-language documents matching a query and can rank them by relevance, going well beyond LIKE and regex operators. source ↗

How many connections can it handle?

max_connections usually defaults to 100 and can only be changed at server start; raising it increases shared memory and other resources, because every connection gets its own backend process. source ↗

Does PostgreSQL fail over automatically?

Not on its own. It can keep warm or hot standbys current through WAL shipping or streaming replication, but it does not provide the software that detects a failed primary and promotes a standby; external tools do that. source ↗

Can I replicate only some tables to another database?

Yes. Logical replication uses a publish and subscribe model, replicating chosen tables and their changes by primary key, and subscribers can re-publish for cascading setups. source ↗

Is PostgreSQL free?

Yes — it is free, open-source software.

Is PostgreSQL open source or self-hostable?

Open source, and you can self-host it. source ↗

Can AI coding agents work with PostgreSQL?

Replit set it up natively.

Who uses PostgreSQL?

98 makers' products we track, each with a source, and 622 open-source projects declare it in their code. The best known of them on Product Hunt: Scispace (3,114 followers), InsForge (2,302 followers), Lightfield (2,260 followers), Atlas.co (2,124 followers), Skarbe (2,082 followers). source ↗