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 ↗
PostgreSQL
Open-source relational database with SQL, transactions, JSON and a large extension ecosystem (PostGIS, pgvector).
Works with AI agents:Built into ReplitAsk your AI about this, with this page as the source:ChatGPT ↗Claude ↗Perplexity ↗
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.
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.
Where it fits
Who uses it
74 makers' products, each linked to the source that shows it, and 542 open-source projects that declare it in their code.
SupabasePostgres-based backend: database, auth, storage, realtime and edge functions in one proj…
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 ↗“Listed in their tool stack on Starter Story”
DatabaseMaker says so · source ↗
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 ↗
NeuralAgentPersonal AI Assistant That Operates Your Entire Computer“The best relational database!”
DatabaseMaker says so · source ↗
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 ↗“Listed in their tool stack on Starter Story”
DatabaseMaker says so · source ↗
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 ↗“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 ↗
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 ↗
MedusaThe world's most flexible commerce platform“Database for all your commerce data.”
DatabaseMaker says so · source ↗
ReviewradarFigure out what users want, fast.“Great solution for a SQL database. Our first choice.”
DatabaseMaker says so · source ↗
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 ↗“Listed in their tool stack on Starter Story”
DatabaseMaker says so · source ↗
Moneo AI#1 Aesthetic Workspace - Saving time has never been easier“Absolutely love it - so easy and awesome!”
DatabaseMaker says so · source ↗
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 ↗
BaselightThe data layer for humans & AI“Offered a robust, scalable database for structured data storage and querying.”
DatabaseMaker says so · source ↗
Hexclave (Stack Auth)Open-source auth and user management with prebuilt UI, teams and a hosted dashboard; for…“Best SQL database: it has a great ecosystem and excellent performance.”
DatabaseMaker says so · source ↗
NeonServerless Postgres with branching and scale-to-zero.“The best relational database out there. Loved by developers worldwide.”
DatabaseMaker says so · source ↗
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 ↗
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 ↗
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 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 ↗Open source: a project that declares PostgreSQL as a dependency in its public code — verifiable, but not necessarily a live product.
What makers say
51 makers on why they use PostgreSQL, in their own words on Product Hunt.
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.
QibbleSep 2026 ↗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.
QibbleMar 2025 ↗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.
WarestackSep 2026 ↗PostgreSQL is a powerful, open-source relational database system known for its robustness, extensibility, and SQL compliance. It's ideal for developers needing a reliable, scalable database solution with advanced features and strong community support.
ScrapInSep 2026 ↗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.
SkarbeSep 2026 ↗Loved and watch-outs
Themes that recur in makers' words and Hacker News comments, each linked to what it summarises, with how Product Hunt tags its reviews.
Most loved
- 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
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
On Product Hunt 5.0★ · 77 reviews
reliability 18performance 10scalability 10advanced features 8open source 8advanced indexing 4pgvector extension 4extensibility 3
Read the reviews on Product Hunt ↗Who switches
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. Open a row to see the pull requests.
Supabase → PostgreSQL48+ PRs
- Move backend from Supabase to Neon Postgres with Better Authsaadibnainan/edu-tracker · 2026-10-02
- Migrate CRM routes from Supabase to Neon PostgresOverclock-Accelerator/overclock-tool-calling · 2026-10-01
- Migrate snapshot storage from Supabase to Neon Postgresafhaque/MeridianHealth-App · 2026-10-01
- Migrate from Supabase to self-hosted Postgres + Auth.jsynni-llan-energy/ynni-llan-energy · 2026-09-21
- BRAWUKA-507: staging app data moved off Supabase to Dokploy VPS Postgreslyuzizheng/coffeemode · 2026-09-20
- Migrate from Supabase to Railway Postgresbrawlstarsleon538/rabka-bloom-boutique · 2026-09-19
- Build the monitoring system and move off Supabase to Postgres, Prisma and Better Authtariq-khan9/webpulse · 2026-09-18
- feat(db): migrate from Supabase to Neon Postgres + Drizzle ORM (phase 1)thisisouvik/trustlend-stellar · 2026-09-12
- Migrate from Supabase to Railway Postgresair-planes/3rd-bass · 2026-09-09
- Migrate storage and auth from Supabase to Neon Postgres.Ed1305/Demographics · 2026-09-07
MongoDB → PostgreSQL46 PRs
- refactor(db)!: migrate Payload CMS from MongoDB to Postgresm6-o4/payload-template-pg · 2026-09-25
- Migrate contact form storage from MongoDB to Supabase PostgresGreenbergEnterprise/greenberg-enterprisegroup-website · 2026-09-15
- Migrate persistence from MongoDB to Supabase Postgres (SQLAlchemy async)naheedroomy/valorantsl-new · 2026-08-14
- feat(db): move the data layer from MongoDB to Postgres with pgvectorjohnbekele/infracanvas · 2026-08-09
- Migrate ROI calculator from MongoDB Atlas to Neon PostgresAONIQQ/fastrackwebsite · 2026-08-06
- fix: rewire merchant read path from MongoDB to Postgres, delete Merch…Syed-web-coder/expense-project · 2026-07-27
- Migrate backend from MongoDB to Supabase Postgressatishkengam2017-ops/InvoiceAI · 2026-07-24
- feat: migrate database from MongoDB to Supabase Postgresfdrive422/React-Admin-Dashboard · 2026-07-14
- Migrate storage from MongoDB to Postgres, hosting from Render to Vercelprashanth-ds-ml/workhub-office-time-tracker · 2026-07-13
- migrate ConnectionRequest feature from MongoDB to Postgres (Drizzle)Dikshant441/merge_me · 2026-07-08
Neon → PostgreSQL29 PRs
- fix(db): migrate off Neon (402 quota) to DO Managed PostgresCitrateNetwork/citrate-explorer · 2026-09-30
- Switch local DB setup from Neon to Docker Compose Postgreshenrilhos/compasso · 2026-09-21
- infra: migrate production database from Neon to Railway Postgreskayibabe/qwantej · 2026-09-19
- Switch DB client from Neon HTTP to postgres.js for Supabasedoommir/novapath-website · 2026-09-10
- fix(ops): bump backup-neon to postgres:18-alpine, add pipefailj00su3/DMC_Proyecto · 2026-09-05
- Migrate database from Neon to self-hosted Postgres on k3sLeadKitchen/platform · 2026-09-04
- Migrate database connectivity from Neon to PlanetScale PostgresRocktown-Labs/chewbuu · 2026-08-24
- Migrate analytics DB from Neon to Railway Postgresckrohg/a2w-control · 2026-08-23
- docs(plan): move Postgres off Neon to Render Postgres (Plan 26)hh2110/thandkoi-clinics · 2026-08-17
- feat(db): move off the Neon driver to plain Postgresbeydemirfurkan/todox · 2026-08-15
Firebase → PostgreSQL15 PRs
- Migrate from Firebase Firestore to Neon Postgresfreelancing15081997/expense-tracker · 2026-09-10
- Migrate DB from NoSQL in firebase to Postgres in SupabaseDarshan-AS/postfolio · 2026-09-01
- Migrate from Firebase to Vercel Postgres for data syncrechefe/roiroi-trips-app · 2026-08-12
- Experiment/Firebase to Postgres migrationcioos-siooc/metadata-entry-form · 2026-07-06
- Migrate from Firebase to Neon Postgreslauregit/conges-equipe · 2026-07-01
- Bridge Firebase identity to the Postgres data layerEriclyfe2/GlobalBridge · 2026-06-02
- Migrate backend from Firebase to Postgres+DriveAssociation-of-Rajarata-ICT/arict-paper-portal · 2026-05-28
- Migrate backend from Firebase to Neon Postgres + Dart shelf REST APIAnis-Dje/ProLink · 2026-04-25
- Nick 6 migrate off firebase and google maps to postgres flutter mapJonKissil/Geocache · 2026-04-03
- 6 migrate off firebase and google maps to postgres flutter mapJonKissil/Geocache · 2026-04-02
Turso → PostgreSQL10 PRs
- web: theme votes, page views and cookbook sales move from Turso to Postgresprofullstack/hqtui · 2026-09-25
- Move the waitlist from Turso to Postgresprofullstack/opensourcelegends.com · 2026-09-25
- Migrate from Turso to Postgres (happy path)tryy3/warera-tools · 2026-09-19
- feat(api): move the database from Turso to Neon Postgres (JEF-342)mankatcheung/trakwyn · 2026-09-18
- Migrate database layer from Turso to Supabase PostgresEllaggon/fastt · 2026-07-22
- Port DB from SQLite/Turso to Postgres on Neon (#96, #97, #98)zachradtka/nextopp · 2026-05-27
- fix: migrate hosted DB from libSQL/Turso to Neon Postgresjoerickson/Wallet-Scanner · 2026-04-25
- feat: migrate database from Turso to Neon Postgresrlfarman/rej-studio · 2026-04-05
- Switch from Turso to Vercel Postgres (no extra signup)AlaudaAI/google-review-skill · 2026-02-16
- change vote from turso to Postgres test using filter by label = Milodatum-cloud/datum.net · 2025-06-18
PostgreSQL → Neon41 PRs
- Switch Phase 0 Postgres from Compose to Neonthomasnoe/fulfillment-exception-triage · 2026-09-19
- fix(render): move dev Postgres to external NeonMemoFlow/memoflow-api · 2026-09-14
- infra: move local Postgres to Neon, add staged startup for resource-c…pranav2004-bit/DECENTRALISED-SLOT-BOOKING-SYSTEM-USING-BECKN-PROTOCOLS · 2026-09-01
- feat(infra): cut Postgres over to Neon (CAL-152, Teams-only)caseyluna/hoop-brain · 2026-08-30
- Move production Postgres from Render free tier to Neonadab-tech/globalopportunities · 2026-08-25
- Port Postgres from Fly to Neonjeffko77/learn2drive · 2026-08-21
- Move DB hosting from Render Postgres to Neonconorlum/ValoMaths · 2026-08-17
- CI builds its own Postgres instead of talking to NeonDantheMan1991/superapp · 2026-08-15
- Move the database off Render's expiring free Postgres to Neon, and back it upradim-zhor/mini-ground-station · 2026-08-03
- feat(infra): migrate Postgres to Neon and object storage to Cloudflare R2AlaskanTuna/SolarSim · 2026-07-30
PostgreSQL → Supabase29+ PRs
- Database: plain Postgres driver, so the site can move to Supabasesalamituns/ng-gov-graph · 2026-10-02
- fix(db): move production Postgres from Neon to Supabase (v1.21.2)batashof/JobRadar · 2026-09-30
- Media: move files from Postgres to Supabase StorageElAmir-Mansour/instagram-dm-automation · 2026-09-26
- ops: move Postgres from Railway to self-hosted Supabaseprofullstack/niche-db · 2026-09-23
- add Postgres schema via Flyway and connect to Supabasecs203-proj/cs203-project · 2026-09-22
- chore(deploy): move production Postgres from Render to SupabaseSiddharthP123/Project-3-Kelly-Poker-Simulator · 2026-09-13
- Migrate database from local Postgres to SupabaseHDAli00/MySaldo · 2026-09-03
- Move prod's Postgres from self-hosted CNPG to Supabaseyesid-lopez/homelab · 2026-08-24
- Migrate active n8n workflows from Postgres to Supabase nodeDenckerStudio/Folkets-meninger · 2026-08-23
- Migrate Postgres to Supabase (managed DB + Realtime)PeopleDrivenMusic/pdm · 2026-08-20
PostgreSQL → MongoDB23 PRs
- feat: migrate NestJS persistence from Prisma/Postgres to MongoDB (Mongoose)Diatech226/Bikiengasite · 2026-09-30
- transparency-service: Postgres to MongoDB Atlasaimozart/entropa-public · 2026-09-28
- Switch backend storage from Postgres to MongoDB.Debarun1205/valmont-financial-group · 2026-09-25
- Change the db from postgres back to mongodbBOL-DEV/zentry-backend · 2026-09-16
- Codewithbasu postgres to mongodbCodeWithBasu/Life-RPG · 2026-09-13
- feat: migrate Prisma/Postgres backend to MongoDB (Prisma 6, ObjectId)Diatech226/Maryme-backend · 2026-09-06
- feat(db): migrate primary data store from Postgres to MongoDBByte-Quill/user-management-system · 2026-08-06
- Move hq from Postgres to MongoDBzoworkhq/zoblocks · 2026-08-06
- Move logs from Postgres to MongoDBMuhammetAli2828/Ops_center · 2026-07-21
- Migrate chocolate-store from Postgres to MongoDBaninamu/chocolate-store · 2026-07-13
PostgreSQL → Firebase6 PRs
- Migrate Zeiterfassung from Postgres to Firebase Firestoreteamtrack1019/AquaCon-Zeiterfassung · 2026-09-29
- Move the app from Python/Postgres to Firebasesmackmathew/psychic-telegram · 2026-09-26
- Migrate auth and result persistence from Neon/Postgres placeholders to FirebaseHallengren06/mattefysikprovet · 2026-06-22
- refactor: migrate backend persistence from Prisma/Postgres to Firebasefratellilenzi/prova · 2026-02-12
- feat(migration): migrate from NextAuth/Postgres to Firebase Auth/Fire…Okpeyemi/cohezi-comp · 2026-01-17
- Migrated from Postgres to firebase rtdb dominickdupuy/DHAM · 2025-11-30
PostgreSQL → Turso4 PRs
- Migrate Payload DB from Postgres to Turso SQLitehephatech/feelings.bar · 2026-07-29
- Migrate database from Netlify (Postgres) to Turso (SQLite)smkdwiguna/dwiguna-info · 2026-06-08
- feat(repo): migrate database from Neon Postgres to Turso (libSQL)johinsDev/loyalty-app · 2026-05-27
- 133 f migrates from postgres to tursoacmutsa/ClubKit · 2025-03-03
Alternatives to PostgreSQL
All alternatives by situation →
MySQL
Convex
PlanetScale
ClickHouseQuestions makers ask about PostgreSQL
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?
74 makers' products we track, each with a source, and 542 open-source projects declare it in their code. source ↗