Database Concepts

The ideas behind storing data well.

Easy

This is an overview — pick a sub-topic below.

Sub-topics (5)

Tables of rows linked by keys, queried with SQL.

Easy♥ 0🔖 0💬 0

Non-relational stores optimised for flexible documents (MongoDB), fast lookups (Redis), relationships (Neo4j) or massive scale (Cassandra).

Intermediate♥ 0🔖 0💬 0

Stores optimised for timestamped measurements (InfluxDB, TimescaleDB) or embedding similarity search (pgvector, Qdrant).

Intermediate♥ 0🔖 0💬 0

ACID transactions keep data consistent; indexes make lookups fast; `EXPLAIN` shows how a query runs.

Intermediate♥ 0🔖 0💬 0

Versioned scripts that evolve the schema safely over time.

Intermediate♥ 0🔖 0💬 0

Spotted a mistake or want to add detail? Suggest an improvement — Content Contributors' edits are reviewed by editors before they go live.