🍄:Databases

Databases is a hard topic overall. I will collect some pieces of knowledge that I come across.

Books

• Designing data-intensive appications by Kleppman, I should re-read it.

• Kafka book — good book, probably worth re-reading if I need to work with a Java program called Kafka. Hopefully not and I will just use something like NATS.

Tools

• Citus is a distributed PostgreSQL database.

• HammerDB is a benchmarking tool for databases.

Multi-tenancy

• Our Multi-tenancy Journey with Postgres Schemas and Apartment (2016) claims that using PostgreSQL schemas for 100+ users and 100+ tables is really slow.