The JusDB Database Engineering Blog

Migrate from DynamoDB to Aerospike for better cost-performance at scale. Real case study showing 60% cost reduction with improved latency and throughput.

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

A production guide to PostgreSQL full-text search — building tsvector generated columns, GIN indexes, multi-column search with setweight, ts_rank scoring, websearch_to_tsquery, and comparison against Elasticsearch.

Build a production-grade PostgreSQL HA stack using Patroni for failover and HAProxy for connection routing

Master MySQL index data structures and optimization strategies. Learn B+ tree internals, index selection, covering indexes, and real-world performance case studies.

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

A production guide to AWS RDS Proxy — how it works, when to use it, IAM authentication setup, and the connection pool sizing rules that prevent Lambda-induced database overload.

PostgreSQL PITR lets you recover your database to any point in time — down to the second — by replaying WAL segments on top of a base backup. Here's how to set it up correctly.

Monitor PostgreSQL streaming replication lag, replication slots, and standby health to ensure HA readiness

Build full-text search with MongoDB Atlas Search — analyzers, scoring, autocomplete, and relevance tuning

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.