Database Insights

PostgreSQL 13 will officially reach end of life on November 13, 2025. After this date, the PostgreSQL Global Development Group will stop releasing security patc

Compare Liquibase and Flyway for schema migration management — features, abstraction level, and team fit

Configure pgBackRest for full, differential, and WAL archiving backups with S3 storage and point-in-time recovery

Compare Liquibase and Flyway for production database schema management. Learn changelog formats, rollback strategies, team workflows, and CI/CD integration patterns.

TiDB performs schema changes online without blocking reads or writes — using a distributed DDL queue across TiDB nodes. Here's how it works and how to monitor DDL jobs in production.

AWS DMS can migrate terabytes of data with zero downtime — but default settings leave significant performance on the table. Here's how to tune DMS for production-grade migrations.

Teams take down production for hours with migrations that could be zero-downtime operations. Learn to use gh-ost and CREATE INDEX CONCURRENTLY, implement rollback plans, and apply the expand-contract pattern for breaking changes.

MySQL's foreign key implementation has evolved significantly from 5.7 through 8.4 — with changes to metadata locking, instant DDL interactions, and Group Replication behavior that every DBA needs to understand.

Query remote PostgreSQL and MySQL databases from PostgreSQL with Foreign Data Wrappers. Covers postgres_fdw setup, IMPORT FOREIGN SCHEMA, and EXPLAIN pushdown verification.

Implement database CI/CD with Flyway migrations, GitHub Actions pipelines, pytest schema tests, and blue-green deployment patterns. Eliminate ad-hoc schema changes.

Upgrade PostgreSQL major versions with sub-second downtime using logical replication. Step-by-step guide covering schema copy, subscription setup, lag monitoring, and sequence resync.

Execute MySQL schema migrations safely with the expand-contract pattern, batched backfills, backward-compatible changes, and migration tooling comparison (Flyway, Liquibase, gh-ost).