The JusDB Database Engineering Blog

Transform PostgreSQL into a vector database with pgvector. Learn embedding storage, ANN index creation, similarity search optimization, and AI/ML integration patterns.

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

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.

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

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.

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.

Deploy Vitess for horizontal MySQL sharding — VSchema design, vtgate routing, and migration from single-instance MySQL