The JusDB Database Engineering Blog

Supabase, PlanetScale, and Neon each take a different approach to serverless databases. Compare their connection limits, branching features, cost models, and which fits your workload.

Use MySQL JSON columns effectively with path operators, functional indexes via generated columns, JSON_CONTAINS filtering, and partial updates with JSON_SET.

DuckDB brings OLAP query performance to your Python process without a server or cluster. Learn how to query Parquet files, replace heavy ETL jobs, and run analytics directly against PostgreSQL.

Operate Kafka Connect database pipelines with current JDBC and Debezium settings, protected REST access, deliberate DLQ handling, and task-level monitoring.

Design DynamoDB access patterns with composite keys, sparse GSIs, paginated queries, transactions, and evidence-based capacity planning.

Manage Elasticsearch indexes with ILM policies, correct shard sizing, and force merge for historical indices. Covers hot/warm/delete phases and cluster health monitoring.

Logical replication in PostgreSQL has a critical gap: slots do not survive failover. PostgreSQL 17 finally fixes this with failover slots, plus adds row and column filtering for selective replication.

Use Redis Streams for event sourcing and message queues. Covers XADD, XREADGROUP, consumer groups, XAUTOCLAIM for stale messages, and Python producer/consumer examples.

MySQL Group Replication and Galera Cluster both promise multi-primary high availability, but they behave very differently under load, network partitions, and node failures.

Connection exhaustion is one of the most common causes of database downtime at scale. Here is how production teams use PgBouncer and ProxySQL to handle 10,000+ concurrent connections.

ClickHouse Cloud is convenient but can cost 3-5x more than a well-tuned self-hosted cluster at scale. This breakdown shows exactly where the cost lines cross.

MySQL 8 introduced comprehensive password management — password validation policies, reuse history, expiration, and dual passwords for zero-downtime credential rotation.