The JusDB Database Engineering Blog

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

Model Cassandra from access patterns, distribute and bound partitions, and operate time-series TTL and compaction without relying on dangerous shortcuts.

Design MongoDB sharded clusters — choose shard keys, manage chunk balancing, and avoid hot shards in production

Use Redis Streams for event sourcing and message queues. Covers XADD, XREADGROUP, consumer groups, XAUTOCLAIM for stale messages, and Python producer/consumer examples.

An honest comparison of MongoDB and PostgreSQL in 2026 — document model vs relational model, JSONB as a document store, ACID transaction trade-offs, horizontal scaling, licensing, and migration paths.

TiDB's write path crosses multiple layers — SQL parser, planner, TiKV region leader, Raft log replication, and 2PC commit — before a transaction is durable. Here's a complete walkthrough.

Use Apache Flink CDC to capture MySQL and PostgreSQL changes — stateful processing, exactly-once semantics, and Kubernetes deployment

Compare CockroachDB, Google Spanner, and YugabyteDB — consistency models, PostgreSQL compatibility, and operational costs

Deploy Vitess for horizontal MySQL sharding — VSchema design, vtgate routing, and migration from single-instance MySQL

A production guide to PostgreSQL Row Level Security — policy creation, USING vs WITH CHECK clauses, performance implications with indexes, and multi-tenant SaaS patterns with real schema examples.

Go beyond basics with Debezium — handle schema evolution, manage connector offsets, and build resilient CDC pipelines

Understand Google Spanner's architecture — TrueTime, interleaved tables, schema design, and cost model