The JusDB Database Engineering Blog

Navigate the open source database landscape. Compare MySQL, PostgreSQL, MongoDB, Redis, and Cassandra with detailed feature analysis and selection criteria.

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

Use Apache Airflow to orchestrate database ETL, backup jobs, and maintenance tasks — DAGs, sensors, and best practices

Implement the transactional outbox pattern to publish events reliably from MySQL or PostgreSQL without dual-write problems

Use dbt to build modular SQL transformations — models, tests, documentation, and CI/CD for your data warehouse

Compare CDC, ETL, and ELT — latency, complexity, cost, and when each pattern fits your data pipeline needs

2025 was the year databases competed on operational simplicity. Serverless databases matured, pgvector merged vector search into PostgreSQL, and CDC became standard infrastructure. Here's what mattered and what's next.

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.

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.

Debezium 3.0 turns your database transaction log into a real-time event stream with full before/after row images. Learn to configure CDC for PostgreSQL WAL and MySQL binlog, avoid the offset storage trap, and monitor replication lag.

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

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