Types of Databases

Find and compare the right database for your system

Database chat

All database types

How it works

  1. Describe what you need the database for, or which qualities matter: the shape of the data, how much of it there is, how fresh reads must be.

  2. You get the database types that fit and specific databases to look at, with a reason for each.

  3. Open the database catalog, tick two or three databases and get a side-by-side table: license, data model, transactions, scaling, typical use.

Questions

What types of databases are there?

The main ones are relational, document, key-value, wide-column, graph, time-series, search and vector. The list above gives a one-line description and examples for each.

How do I choose a database?

Start from your data and your queries. Tables with relations and strict consistency point to a relational database. Records that vary in shape point to a document store. Fast lookups by key point to key-value. Then check the size: one server, read replicas, or many servers.

What is the difference between SQL and MySQL?

SQL is a language for querying relational databases. MySQL is one database that uses it. PostgreSQL, SQLite, SQL Server and Oracle use SQL too, each with its own additions.

Which databases can I compare?

The ones in the catalog, up to three at a time. A database that is missing from the catalog can still come up in a chat answer. It is then marked as AI knowledge.

Where do the facts come from?

From the official documentation of each database. Every fact in the comparison table links to its source.

More tools