The JusDB Database Engineering Blog

Compare streaming and batch data processing — latency, throughput, tooling, and when each approach makes sense

Use pg_upgrade to migrate between PostgreSQL major versions — upgrade strategies, pre-checks, and rollback plans

ProxySQL pools thousands of application connections into a small backend pool, splits reads to replicas automatically, and lets you change routing without touching application code or restarting 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

A production guide to AWS Database Migration Service — replication instance sizing, endpoint configuration, Full Load vs CDC vs Full Load+CDC modes, performance tuning, and DMS vs Debezium vs pglogical.

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

Identify bloated indexes in PostgreSQL using pgstattuple, REINDEX CONCURRENTLY, and automated monitoring

Master AWS RDS connection limits for MySQL and PostgreSQL. Learn max_connections calculation, connection pooling strategies, and optimization techniques.

Debezium reads MySQL binary logs and PostgreSQL WAL to stream every row-level change as a Kafka event in near real-time — replacing nightly batch ETL with sub-second data propagation.

PostgreSQL views historically executed with the owner's privileges, bypassing row-level security policies. PostgreSQL 15 fixed this with security_invoker views — here's why it matters and how to use it in multi-tenant schemas.

Use Neo4j for relationship-heavy data — Cypher query language, graph algorithms, and fraud detection use cases