The JusDB Database Engineering Blog

PostgreSQL 19 Beta 1 (June 4, 2026) brings parallel autovacuum, the native REPACK command for online table rebuilds, 2x faster inserts under foreign-key load, online logical replication without a restart, WAIT FOR LSN for read-your-writes consistency, and default changes (JIT off, lz4 TOAST, RADIUS removed). A DBA-focused walkthrough of what changed and what to test before GA.

A step-by-step guide to migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server — covering native backup/restore via S3 with the rds_restore_database stored procedure, AWS DMS full-load + CDC for near-zero downtime, option group and IAM setup, cutover, and post-migration hardening.

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.