Databases

How to choose a DB

Long Term Storage

Data Warehousing

Live Analytical Processing)

CDC (Change Data Capture)

ETL

Internals

Calculations Database vs Application

Unique Identifiers (UUID, ULID, SnowFlake, …)

RDBMS Indexes

ACID (SQL) & BASE (NoSQL)

Sharding

Normalization

Vector Databases

Atomicity

LLM → SQL

Migration

Security

Optimization

Databases:

Postgres

MongoDB

Elasticsearch

Hasura

Hadoop (HDFS)

Redis

EdgeDB

ScyllaDB (Cassandra without Java)

Scalable Solutions for traditional databases:

Neon (Postgres)

Vitess (MySQL)

Cassandra

Query Engines:

TODO HIVE (Hadoop Ecosystem)

TODO Presto

https://architecturenotes.co/things-you-should-know-about-databases/

https://soatok.blog/2023/03/01/database-cryptography-fur-the-rest-of-us/

https://chartio.com/learn/data-warehouses/the-data-storage-hierarchy-lakes-warehouses-and-marts/

![[Untitled 485.png|https://elephantscale.com/wp-content/uploads/2020/05/hadoop-illuminated.pdf]]

🌱 Back to Garden