The JusDB Database Engineering Blog

Implement MySQL table partitioning with RANGE and HASH strategies. Covers instant partition drops for data lifecycle, partition pruning verification, and key gotchas.

Explore PostgreSQL 18 revolutionary features including async I/O, improved parallelism, enhanced JSON support, and developer experience improvements coming in 2025.

Compare three PostgreSQL multi-tenant patterns: shared schema with RLS, schema-per-tenant, and database-per-tenant. Includes hash partitioning for shared schema at scale.

Two years after the Elastic license change, Elasticsearch and OpenSearch have diverged significantly. Both are mature forks but the right choice depends on your use case, vendor lock-in tolerance, and team expertise.

Harden MySQL user permissions with host-scoped grants, validate_password plugin, account locking, and privilege auditing. Essential for SOC2 and PCI-DSS compliance.

Implement least-privilege access in PostgreSQL with role hierarchies, ALTER DEFAULT PRIVILEGES, schema separation, and privilege auditing queries.

Aurora and RDS share the MySQL engine but diverge at the storage layer in ways that produce very different cost and performance profiles — the right choice depends entirely on your I/O pattern.

Implement MySQL audit logging for SOC2, PCI-DSS, and HIPAA compliance. Covers MariaDB Audit Plugin, general query log, trigger-based auditing, and SIEM integration.

A detailed comparison of ClickHouse and BigQuery for analytical workloads — MergeTree engine vs Capacitor storage, self-hosted vs serverless cost models, query latency, real-time ingestion, and when to choose each.

Configure PostgreSQL TLS with self-signed or CA-signed certificates. Force TLS via pg_hba.conf, set minimum TLS version, and verify server certs from clients.

Authenticate to RDS and Aurora using IAM credentials instead of passwords. Eliminates long-lived passwords with 15-minute token-based access. Covers PostgreSQL and MySQL setup.

MySQL InnoDB full-text search is underused and often misconfigured. With 8.4 LTS, new defaults and tuning opportunities can cut FTS query time by 60% or more.