Topic
Databases
3 articles in Databases.
PostgreSQL backups: logical dumps vs point-in-time recovery
Compare PostgreSQL logical dumps and WAL-based recovery by what they restore, what they depend on and what recovery tests must demonstrate.
PostgreSQL constraints: CHECK, UNIQUE and foreign keys explained
Choose PostgreSQL constraints deliberately, understand NULL behavior and avoid accidental deletion cascades and redundant indexes.
PostgreSQL isolation levels: what concurrent transactions can see
Compare Read Committed, Repeatable Read and Serializable in PostgreSQL, including snapshots, serialization failures and transaction retries.