#Database-Design
3 notas · última:
Life Altering PostgreSQL Patterns
The post collects PostgreSQL patterns that reduce operational pain: UUID keys, timestamps, restrictive foreign keys, schemas, enum tables, soft deletes, status logs, special rows, careful use of views, and JSON queries.
Review — Is Designing Data-intensive Applications by Martin Kleppman Worth it?
The review argues that Martin Kleppmann’s book is a worthwhile, broad guide to data-intensive application design, with strong coverage of databases, distributed systems, reliability, scalability, and trade-offs.
Why Auto Increment Is A Terrible Idea
The post argues that serial integers expose growth, make enumeration easy, and can clash across tables, while UUIDv4 offers stable, non-predictable primary keys with practical PostgreSQL support.