Updated
Ship and run

Database

Store your app's data somewhere reliable, and talk to it from code.

For your framework or language:FastAPIReactNext.jsAstro
Ask your AI about this, with this page as the source:ChatGPT ↗Claude ↗Perplexity ↗

Trends

DuckDB gained the most ground in package downloads: 4.5× against the median npm package over a year.

Public counts each month: pull requests on GitHub, package downloads, stars, Product Hunt followers. They show direction, not market share.

ToolDownloadsStarsProduct Hunt
PostgreSQL51.8M/wk+31% vs npm★ 22.4k456 followers
Supabase25.4M/wk+91% vs npm★ 111.4k58.4k followers
MongoDB14.2M/wk−46% vs npm—834 followers
MySQL14.1M/wk+15% vs npm★ 12.5k81 followers
Amazon DynamoDB10.8M/wk−15% vs npm——
SQLite10.1M/wk+71% vs npm★ 10.7k42 followers
Firebase9.5M/wk−22% vs npm—4.2k followers
BigQuery4.3M/wk+5% vs npm——
Neon3.7M/wk+32% vs npm★ 23.2k1.4k followers
ClickHouse3.4M/wk+43% vs npm★ 50.3k113 followers
Turso2.8M/wk+99% vs npm★ 17.3k228 followers
Snowflake2.4M/wk−13% vs npm——
DuckDB1.5M/wk4.5× vs npm★ 42.2k69 followers
Convex1.4M/wk4.5× vs npm—941 followers
Neo4j821.4k/wk+15% vs npm★ 17.3k55 followers
MariaDB782.2k/wk+38% vs npm★ 8.3k0 reviews
PlanetScale398.1k/wk−41% vs npm—168 followers
Apache Cassandra302.4k/wk−13% vs npm★ 10.1k—
PocketBase219k/wk+137% vs npm★ 61.3k261 followers
InstantDBMoving194.7k/wk+160% vs npm★ 10.5k428 followers
Appwrite59.6k/wk−45% vs npm★ 57.7k5.4k followers
Lately in this groupEverything that changed →

The real choice

Where the data lives: a whole backend platform (database, auth and storage in one project), a managed database you reach from your own code, or the raw engine on your own server. Postgres is the default unless you have a reason to pick otherwise; analytics and graph databases sit next to it for workloads it handles poorly, not instead of it. How your code talks to it is its own decision (Database Access & ORMs).

What makers chose1,167 live products, each with a source. Not market share.

Pick by situation

Tap the ones that are you — the tools that fit light up below.
  • You want the database, auth and file storage in one project, and plain SQL you can take elsewhereSupabase
  • You're building a live, collaborative app entirely in TypeScriptConvex
  • Your traffic is bursty or you run many preview deploys, and idle hours shouldn't cost muchNeon
  • You already run your own server and want a flat monthly costPostgreSQL

Compare the tools

Grouped by the side of the choice they answer, not ranked. Open a row for when to use it, the trade-off and what makers say.

ToolBest for
Backend platform3
Supabaseplatform · open source · free tierPostgres plus auth, storage and realtime in one project.573+90 open source$25Pro25.4M/wk+91% vs npm

Use it whenYou want one service for most of the backend and a SQL database you can take with you.

Trade-offAuth, storage and database in one vendor makes leaving harder later, and free projects pause after a week without activity.

llms.txtMCPCLIIn Bolt, Lovable, Rork, v0

Used by 1-bit.day, Accordio AI, Airbook AI, Alai, Almanac and 568 more · in 90 open-source projects.

One Postgres with RLS on every table is the reason a solo founder can ship contracts, invoices and a client portal without a backend team. Auth, storage and realtime came for free.
Accordio AI, the makerSep 2026 ↗
Firebaseplatform · free tierMobile apps that need offline sync and client-side SDKs.187+78 open source$9.66Blaze (pay as you go)9.5M/wk−22% vs npm

Use it whenYou're shipping a mobile app first and want the client to read and write data directly, including while offline.

Trade-offA document store without SQL joins; hard to migrate off.

llms.txtIn Lovable, Rork

Used by 1752vc Pitch Deck Analyzer, AI Visual Reasoning by Chance, BabyCheck, BestInterest for Coparents, Blink.new and 182 more · in 78 open-source projects.

Key role in helping us deliver results in real time, because the analysis streams onto the page as it completes instead of making founders wait for a finished report.
1752vc Pitch Deck Analyzer, the makerSep 2026 ↗
Convexplatform · open source · free tierRealtime, collaborative apps written entirely in TypeScript.50+17 open source$29Professional1.4M/wk4.5× vs npm

Use it whenYou want queries that update the UI live without writing sync code.

Trade-offIts own data model and query API rather than SQL.

llms.txtCLI

Used by Brew, Brutal Verdict, Clipwing, Conduit, Fastlane and 45 more · in 17 open-source projects.

Love their UI, their reactivity is insanely good. Was initially with supabase, but have shifted to convex now. Also don't like writing SQL, so Convex was a no-brainer.
PayPing, the makerSep 2026 ↗
Managed database4
MongoDBdatabase · self-hostable · free tierDocument-shaped data and teams already fluent in Mongo.128+174 open source$58Atlas Dedicated M1014.2M/wk−46% vs npm

Use it whenYour team already knows Mongo, or your records vary so much in shape that a fixed schema gets in the way.

Trade-offNo joins or schema by default, so relational data and migrations take discipline you'd get for free in Postgres.

llms.txt

Used by ASO, Aupair Valley, Bolt, Brand.dev, DevRev and 123 more · in 174 open-source projects.

Shoutout to MongoDB for providing a powerful, flexible database solution that scales with our needs. Your platform helps us manage and analyze vast amounts of data seamlessly!
Exploit Alarm, the makerSep 2026 ↗
Neondatabase · open source · free tierServerless Postgres that scales to zero, with a branch per preview deploy.96+20 open source$22Launch3.7M/wk+32% vs npm

Use it whenYou want every pull request's preview deploy to get its own copy of the database.

Trade-offCold starts after idle periods add latency to the first query, and heavy always-on workloads can cost more than a fixed server.

llms.txtMCPCLIIn v0

Used by BaseHub, BrandingStudio.ai®, Central, ClientJam, Comigo and 91 more · in 20 open-source projects.

Serverless Postgres with branching is a game changer for solo builders. Scale to zero means no idle costs, and the connection pooling just works. Perfect for an early-stage product.
Relay, the makerSep 2026 ↗
PlanetScaledatabaseApps that expect heavy scale and want zero-downtime schema changes.29+9 open source$7.40Postgres PS-5 (single node)398.1k/wk−41% vs npm

Use it whenYour tables are big and busy enough that a locking migration would mean downtime.

Trade-offNo free tier.

llms.txt

Used by Cushion, Graphy, Heima, Hoplite, Langtail and 24 more · in 9 open-source projects.

A joy to work with. Branching, schema changes, and zero-downtime deploys make PlanetScale perfect for our evolving data models. Developer-friendly + production-safe = rare combo.
RunLLM, the makerSep 2026 ↗
Tursodatabase · open source · free tierSQLite at the edge, or one database per customer.13+36 open source$5.99Developer2.8M/wk+99% vs npm

Use it whenEach customer should get their own isolated database, or reads need to happen close to users worldwide.

Trade-offSQLite semantics — one writer at a time, fewer extensions — suit read-heavy apps better than write-heavy ones.

llms.txtCLI

Used by Parseflow.io, VoltAgent, 10xlaunch.ai, Anarlog, CoffeeChat Bot and 8 more · in 36 open-source projects.

Lightweight, distributed SQLite that just works. Perfect for edge setups and production use cases.
VoltAgent, the makerSep 2026 ↗
Run it yourself1
PostgreSQLdatabase · open source · free tierThe engine behind most of the hosted options above, run on your own server or container for full control and a flat cost.98+622 open source—51.8M/wk+31% vs npm

Use it whenYou already run a server, or want extensions and settings a managed provider doesn't offer.

Trade-offBackups, upgrades, failover and connection pooling are yours to set up and watch.

In Replit

Used by Baselight, BooleanMaths Pulse, Boondockers Welcome, Byterover, Calmer and 93 more · in 622 open-source projects.

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.
VisionAR, the makerSep 2026 ↗

Cost: the cheapest plan that fits database size 8 GB, data transfer 50 GB, document or row reads 10 million reads, document or row writes 2 million writes, from list prices. Try your own numbers →

Cost as you grow

Each contender's cheapest usable plan as usage rises.

$0$50$200$500$1,0000.51582050100500
MongoDBTursoPlanetScaleNeonFirebaseConvexSupabasex: database size (GB), other usage scaled with it; held at 730 hours (compute hours per month) · cheapest usable plan at each point, list prices · try your own numbers

Who switches to what

Public pull requests on GitHub since Oct 2024 whose title says "X to Y" — real code changes, by developers in general rather than makers only. Pick a flow to see its pull requests.

Firebase → Supabase: 297 pull requestsSupabase → Neon: 170 pull requestsSupabase → Firebase: 113 pull requestsMongoDB → Supabase: 75 pull requestsNeon → Supabase: 63 pull requestsSupabase → Convex: 50 pull requestsPostgreSQL → Neon: 41 pull requestsMongoDB → PostgreSQL: 38 pull requestsSupabase 333Firebase 297MongoDB 113Neon 63PostgreSQL 41Supabase 435Neon 211Firebase 113Convex 50PostgreSQL 38Moving fromMoving to
Firebase → Supabase297 PRs · Compare →

What Hacker News says

Hacker News commenters choose PostgreSQL most often for database, and like DuckDB best (net praise +27%). Among products launched since 2024 that show their choice, 52% use Supabase.

ToolHN comments choosing itNet praise on HNMakers' launches since 2024
PostgreSQL2,852+11%5% 49
SQLite1,496+16%0% 0
MySQL765−2%1% 5
MongoDB377−11%10% 100
Supabase357+12%52% 518
DuckDB297+27%1% 10
ClickHouse255+30%2% 19
Firebase241−2%13% 129

Comments January 2023 to August 2026 that name the tool in a sentence like "I use" or "we moved to", estimated from a sample Claude read; net praise is comments recommending it minus comments criticizing it, as a share of all comments about it. Makers: of 990 launches that show what they use here. HN commenters and makers are different crowds — where they agree and where they split.

Before you choose

How to approach it

Pick a managed Postgres unless you have a reason not to. Turn on backups before your first real user, and use the provider's connection pooler from serverless functions.

Common mistakes
  • Never restoring a backup until the day you need one — the first bad migration or stray DELETE is a bad time to learn the backup is missing or too old.
  • Opening a fresh database connection in every serverless function call, which runs Postgres out of connections under modest traffic; use the provider's connection pooler.
  • Changing the schema by hand in the production console instead of through migrations, so local, preview and production databases quietly drift apart.

Other options

Real choices most makers here won't need to weigh.

ClickHouseAnalytics (OLAP)Fast aggregate queries over billions of rows of events, logs or metrics, self-hosted or on ClickHouse Cloud.47 makers' productsTinybirdAnalytics (OLAP)Managed ClickHouse that turns SQL over event streams into fast API endpoints for dashboards and usage analytics in your product.29 makers' productsSnowflakeAnalytics (OLAP)A managed data warehouse that joins data from your app, billing and other sources, on the AWS, Azure or Google Cloud region you choose.24 makers' productsNeo4jGraphData that is mostly relationships — social graphs, recommendations, knowledge graphs — queried with Cypher.19 makers' productsDuckDBAnalytics (OLAP)Analytical SQL inside your app or script over local or S3-hosted CSV and Parquet files, with no server to run.12 makers' productsMySQLRun it yourselfPHP, Laravel, WordPress and Rails stacks, and teams that already know MySQL well.10 makers' productsAppwriteBackend platformA Firebase-style backend — database, auth, storage, functions and messaging — that is open source and can be self-hosted.8 makers' productsXanoBackend platformA backend — database, API endpoints, business logic and auth — built visually instead of in code.8 makers' productsBigQueryAnalytics (OLAP)SQL analytics over large tables on Google Cloud with no cluster to run, and a free tier of 1 TiB of queries a month.7 makers' productsPocketBaseBackend platformA whole backend — database, auth, files, realtime and admin UI — in one self-hosted executable.5 makers' productsCockroachDBManaged databaseA Postgres-compatible SQL database that keeps serving reads and writes when a node, zone or whole region fails, managed or self-hosted.2 makers' productsAivenManaged databaseManaged PostgreSQL, MySQL, Valkey, Kafka or ClickHouse from one provider, on the cloud and region you pick.2 makers' productsCloudflare D1Managed databaseA serverless SQLite database for apps running on Cloudflare Workers or Pages, with a free tier and no egress fees.1 makers' productXataManaged databasePostgres branches that copy instantly and scale to zero, for a separate database per developer, pull request or agent, optionally filled with anonymized production data.1 makers' productSQLiteRun it yourselfA database that is just a file in your app — desktop and mobile apps, single-server web apps, tests and prototypes.Amazon DynamoDBManaged databaseA serverless key-value and document database on AWS that scales with no servers to manage, with an always-free tier.MariaDBRun it yourselfA MySQL-compatible open-source database, the default MySQL on many Linux distributions and hosts.Apache CassandraRun it yourselfVery high write volumes spread across many nodes and data centers with no single primary, such as event logs, messaging and time series.InstantDBBackend platformMoving users · Aug 2026Realtime, multiplayer and offline-friendly apps where the frontend queries and writes data directly, with auth, permissions and storage included.2 makers' products

Decided alongside

What the 1,167 makers' products here chose for their other decisions.

Further reading