The JusDB Database Engineering Blog

Hatchet transforms raw MongoDB JSON logs into actionable insights — surfacing slow operations, connection storms, and namespace hotspots that are impossible to spot in raw log files.

Apply GitOps principles to database changes — PR-based schema reviews, automated migrations, and rollback strategies

Use pgvector for exact and approximate similarity search, relational filters, and hybrid retrieval while measuring recall, latency, storage, and write cost.

How to size your database connection pool correctly — the HikariCP formula, the variables that determine optimal pool size, and the mistakes that cause connection exhaustion or underutilization.

MySQL 8.0 introduced EXPLAIN FORMAT=TREE — a hierarchical, human-readable query plan format that reveals join order, access methods, and cost estimates in a way that the traditional tabular EXPLAIN cannot.

Compare CockroachDB, Google Spanner, and YugabyteDB — consistency models, PostgreSQL compatibility, and operational costs

MySQL 8.0 introduced multi-valued indexes — allowing you to index individual elements of a JSON array so queries using MEMBER OF or JSON_OVERLAPS can use an index.

A production guide to zero-downtime database migrations — why ALTER TABLE causes downtime, the Expand-Contract pattern, safe migration patterns for PostgreSQL and MySQL, and tooling with Flyway, Liquibase, pt-osc, and gh-ost.

UUIDs as primary keys can destroy database performance. Learn why 50M rows went from 0.5ms to 2.3ms inserts, and how to fix it with hybrid approaches.

Add data quality checks to your pipeline — row count validation, schema drift detection, and anomaly alerting with Great Expectations

Detect query plan regressions in PostgreSQL using auto_explain, pg_hint_plan, and plan baseline management

AWS RDS, Aurora, and Aurora Serverless v2 all run MySQL and PostgreSQL — but their pricing models differ dramatically. Learn when to use each and how to avoid expensive I/O surprises.