The JusDB Database Engineering Blog

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.

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

pg_partman automates PostgreSQL partition lifecycle. This guide covers create_parent(), retention policies, partition pruning, and migrating existing tables without downtime.

Build a data-driven capacity planning process using historical metrics, growth trends, and resource modeling

Evaluate Google AlloyDB — columnar engine, read pool nodes, ML integration, and comparison with Aurora PostgreSQL

A deep dive into PostgreSQL JSONB vs JSON storage formats, GIN and B-tree indexing strategies, containment operators, and the performance characteristics that determine which to use for document storage workloads.

A production guide to Amazon Aurora PostgreSQL — the shared storage architecture, fast failover mechanics, Aurora Serverless v2 ACU scaling, Global Database, Parallel Query, and an honest comparison against standard RDS.

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

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

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.

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.

Achieve microsecond latencies at scale with Aerospike. Learn hybrid memory architecture, strong consistency, cross-datacenter replication, and use cases for AdTech and fraud detection.