The JusDB Database Engineering Blog

Use PostgreSQL FDW to query MySQL, S3, MongoDB, and other databases from within PostgreSQL — setup and performance tips

Use Spark with JDBC to read from and write to relational databases — partition strategies, predicate pushdown, and write modes

Replicate OLTP databases to analytical warehouses — CDC, bulk load, incremental sync, and schema evolution handling

A production guide to TimescaleDB — hypertable setup, automatic chunk management, columnar compression policies, retention policies, continuous aggregates with time_bucket(), and comparison against InfluxDB and Prometheus.

Build a MySQL CDC pipeline using binlog and Kafka — Debezium, Maxwell, or Canal — trade-offs and production setup

Understand Kafka from a database perspective — partitions, offsets, consumer groups, and durability guarantees

Deep dive into advanced database indexing strategies including composite indexes, covering indexes, and partial indexes. Optimize query performance with expert indexing techniques.

Manage SQL schema migrations with Flyway — versioned and repeatable scripts, CI/CD integration, and team workflows

Deploy Airbyte to replicate data from MySQL, PostgreSQL, and MongoDB to your warehouse — connectors, scheduling, and transforms

Navigate the complex landscape of database technologies. Compare SQL vs NoSQL, OLTP vs OLAP, and learn decision frameworks for selecting the perfect database for your use case.

Discover how jemalloc, tcmalloc, and mimalloc can dramatically improve MySQL memory management. Real benchmarks showing 2-4x performance improvements and memory leak prevention.