The JusDB Database Engineering Blog

A complete guide to MySQL JSON functions — JSON column type, JSON_EXTRACT and arrow operators, JSON_SET vs JSON_INSERT vs JSON_REPLACE vs JSON_MERGE_PATCH, functional indexes, and multi-valued indexes for arrays.

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.

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.

Design PostgreSQL HA with Patroni 4.1, a protected quorum DCS, HAProxy role checks, explicit durability choices, and rehearsed switchover and recovery.

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