Relational Databases
PostgreSQL and MySQL: the relational model, the planner and the operational differences between them.
NoSQL Databases
Redis, MongoDB and Neo4j: the data models that justify giving up a relational schema.
Batch Processing
Spark: the shuffle, the DAG and the cost of a wide transformation.
Stream Processing
Flink: event time, watermarks and state in an unbounded stream.
Lakehouse
Iceberg and Delta Lake: table formats that bring ACID and time travel to object storage.
Full-Text Search
Elasticsearch: the inverted index, analyzers and the query DSL.
Vector Search
pgvector and Milvus: approximate nearest-neighbour indexes and the recall/latency trade-off.