The JusDB Database Engineering Blog

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

Compare Delta Lake, Apache Iceberg, and Apache Hudi — ACID transactions, time travel, and format interoperability

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

Use Kafka Connect source and sink connectors to stream data between databases, warehouses, and event systems

Compare Snowflake, ClickHouse, and BigQuery on performance, cost, ecosystem, and real-world use cases in 2026

Compare ScyllaDB and Apache Cassandra — throughput, latency, operational complexity, and when to switch

Understand RDS Multi-AZ for HA and Read Replicas for read scaling — failover behavior, replication lag, and costs

Use Aurora Serverless v2 for cost-effective scaling — ACU configuration, scaling behavior, and when it fits

Apply DynamoDB advanced patterns — GSI overloading, sparse indexes, single-table design, and access pattern modeling

Choose the right Cassandra compaction strategy for your workload — STCS for write-heavy, LCS for read-heavy, TWCS for time-series

Model data in Cassandra around query patterns — partition key design, clustering columns, and anti-patterns to avoid