Which Database Should You Use? πŸ—„οΈ

The database matters as much as the language β€” pick the wrong one and everything from performance to how much you pay gets harder. Ranked by real reported usage share (2026 developer survey data), grouped by category.

Jump to: πŸ”‘ Key-value/cache β†’ πŸ“„ Document/NoSQL β†’ ☁️ Cloud & BaaS β†’ πŸ”Ž Search & analytics β†’ πŸ•ΈοΈ Specialized β†’
If you only learn one thing

Learn SQL and then PostgreSQL specifically. Postgres is used by over half of developers surveyed, it's free and open-source, and the SQL you learn on it transfers almost directly to MySQL, SQL Server, and SQLite β€” the whole relational-database world speaks the same core language.

Relational (SQL) Databases
🐘
#1 Β· 55.6%
PostgreSQL
A free, open-source relational database known for strict standards-compliance, powerful advanced features (JSON columns, full-text search, custom types), and being the default choice for most new backend projects today.
🐬
#2 Β· 40.5%
MySQL
The database behind WordPress, most of the early web, and huge amounts of PHP-stack software β€” free and open-source, slightly simpler than Postgres, with an enormous amount of legacy hosting support.
πŸ“¦
#3 Β· 37.5%
SQLite
Not a server at all β€” a full relational database stored as a single local file, with zero setup or configuration. Ships inside nearly every mobile app, browser, and desktop app that needs local storage.
πŸͺŸ
#4 Β· 30.1%
Microsoft SQL Server
Microsoft's enterprise relational database β€” deeply integrated with the .NET/Windows ecosystem, common in large corporate IT environments that standardized on Microsoft's stack.
🦭
#7 Β· 22.5%
MariaDB
A community-driven fork of MySQL, created after Oracle acquired MySQL β€” nearly drop-in compatible with it, but fully open-source with no corporate ownership concerns.
πŸ”΄
#9 Β· 10.6%
Oracle Database
A powerful, expensive, heavily-licensed enterprise database β€” dominant in large legacy corporate and government systems (banking, insurance, government records) that were built decades ago and never migrated off it.
β˜•
#14 (tie) Β· 5%
H2 Database
A lightweight, embeddable Java SQL database β€” extremely common as the test/dev database swapped in for a "real" database (like Postgres) during automated testing in Java/Spring projects.
πŸ—ƒοΈ
#16 Β· 4.8%
Microsoft Access
A desktop database bundled with Microsoft Office β€” built for small, single-office applications (inventory trackers, simple internal tools) built by non-specialist office staff, not for real production software.
πŸ”‘ Key-Value & Cache
⚑
#5 Β· 28%
Redis
An in-memory key-value store used for caching, session storage, and real-time features (leaderboards, rate limiting, pub/sub messaging) β€” blazing fast because it lives in RAM, almost always paired alongside a "real" database rather than replacing one.
πŸ“Š
#10 Β· 9.8%
DynamoDB
Amazon's fully-managed, serverless key-value/document database β€” scales automatically with no server to manage, deeply tied into the AWS ecosystem.
πŸ”·
#24 Β· 2.4%
Valkey
A Linux Foundation-backed open-source fork of Redis, created after Redis changed its license terms β€” nearly identical to Redis in behavior, for developers who want to stay fully open-source.
πŸ“„ Document & NoSQL
πŸƒ
#6 Β· 24%
MongoDB
The best-known document database β€” stores flexible, JSON-like records instead of rigid rows and columns, popular in JavaScript-stack apps (the "M" in the classic MERN stack) where the schema changes often during early development.
πŸ”₯
#13 Β· 5.7%
Cloud Firestore
Google Firebase's document database β€” real-time syncing to connected clients out of the box, tightly integrated with the rest of the Firebase platform (auth, hosting, functions).
πŸ”₯
#14 (tie) Β· 5%
Firebase Realtime Database
Firebase's original real-time database, predating Firestore β€” a single large JSON tree synced live to every connected client, simpler than Firestore but less structured for complex queries.
🐦
#22 Β· 2.9%
Cassandra
A wide-column database built for massive write-heavy workloads spread across many servers with no single point of failure β€” originally built at Facebook, now widely used anywhere data volume outgrows a single-server database.
πŸ“Œ
#28 (tie) Β· 1%
PocketBase
A single-file, open-source backend built on SQLite β€” bundles a database, auth, and file storage into one small self-hosted executable, popular for indie/solo projects that want a Firebase-like experience without the cloud bill.
☁️ Cloud, Analytics & Backend-as-a-Service
πŸ“ˆ
#11 Β· 6.5%
Google BigQuery
Google Cloud's fully-managed data warehouse β€” built to run massive analytical SQL queries across billions of rows in seconds, priced by how much data you scan rather than a server you keep running.
⚑
#12 Β· 6%
Supabase
An open-source "Firebase alternative" built on real PostgreSQL β€” gives you a hosted Postgres database plus auth, file storage, and auto-generated APIs, aimed at developers who want Firebase's convenience with SQL underneath.
🌐
#17 Β· 4.6%
Cosmos DB
Microsoft Azure's globally-distributed, multi-model database β€” can behave like a document store, key-value store, or graph database depending on the API you choose, built for apps that need to run in multiple regions worldwide.
❄️
#18 Β· 4.1%
Snowflake
A cloud data warehouse built around separating storage from compute β€” you can scale query power up and down independently of how much data you store, popular for large enterprise analytics teams.
🧱
#20 Β· 3.4%
Databricks SQL
SQL querying built on top of the Databricks "lakehouse" platform, blending data-warehouse-style querying with the massive raw-file storage of a data lake β€” popular with data engineering and ML teams already using Databricks/Spark.
πŸ¦†
#21 Β· 3.3%
DuckDB
Sometimes called "SQLite for analytics" β€” an embedded, zero-setup database optimized for fast analytical queries over local files (CSV, Parquet), popular with data scientists working locally in Python/R notebooks.
πŸ”Ί
#27 Β· 2.3%
Amazon Redshift
AWS's data warehouse, built on a modified version of PostgreSQL under the hood β€” designed for large-scale analytical queries across an organization's AWS-hosted data.
πŸͺ³
#28 (tie) Β· 1%
CockroachDB
A distributed SQL database designed to survive entire data-center outages without losing data β€” speaks standard SQL (Postgres-compatible wire protocol) while replicating data across regions automatically.
πŸ”Ž Search & Analytics Engines
πŸ”
#8 Β· 16.7%
Elasticsearch
A search and analytics engine built for fast full-text search and log analysis at scale β€” not a general-purpose database, but the standard choice whenever "search this text really fast" is the actual requirement.
πŸ“Š
#24 (tie) Β· 2.4%
ClickHouse
An open-source columnar database built for extremely fast analytical queries over huge datasets β€” often used for real-time dashboards and analytics where traditional row-based databases get too slow.
πŸ•ΈοΈ Specialized (Graph, Time-Series, Immutable)
πŸ•ΈοΈ
#23 Β· 2.6%
Neo4j
The best-known graph database β€” stores data as nodes and relationships rather than tables, built for problems that are naturally about connections (social networks, recommendation engines, fraud detection).
⏱️
#19 Β· 3.7%
InfluxDB
A database built specifically for time-series data β€” sensor readings, server metrics, IoT device data β€” where every record is timestamped and queries almost always involve a time range.
πŸ”΅
#26 Β· 2.4%
IBM Db2
IBM's long-running enterprise relational database β€” still common on mainframes and large legacy corporate systems (banking, insurance, government), similar niche to Oracle.
🧬
#30 Β· 0.6%
Datomic
An unusual immutable database β€” instead of overwriting data, every change is recorded as a new fact, so you can query the entire database as it existed at any point in its history. Built primarily for use with Clojure.

Usage percentages reflect a 2026 developer-tools survey; most developers use more than one database, so shares don't sum to 100%.

β†’ Start with the SQL cheat sheet