OOmnistu

Topic

Databases

3 articles in Databases.

All stories

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.

Databases·2026-11-16·4 min read

PostgreSQL constraints: CHECK, UNIQUE and foreign keys explained

Choose PostgreSQL constraints deliberately, understand NULL behavior and avoid accidental deletion cascades and redundant indexes.

Databases·2026-11-16·5 min read

PostgreSQL isolation levels: what concurrent transactions can see

Compare Read Committed, Repeatable Read and Serializable in PostgreSQL, including snapshots, serialization failures and transaction retries.

Databases·2026-11-16·4 min read