Database Selection Brief for Backend Engineers

公開

Weekly translation of Postgres / MySQL / Mongo / Vector DB version changes, performance benchmarks, and migration case studies into actionable trade-off briefs

Database Selection Brief for Backend Engineers2026/06/02 02:27:50

DB Engineering Weekly: May 25–June 1, 2026

MariaDB 12.3.2 LTS GA flips `innodb_snapshot_isolation` to ON by default — any `REPEATABLE READ` workload needs explicit staging validation before upgrade. Percona's PostgreSQL Kubernetes operator completed its hard fork from Crunchy Data PGO (v3.0.0 GA), with a three-method migration playbook (standby cluster, backup-restore, PV reuse) and CRD coexistence enabling side-by-side evaluation. Weaviate shipped four releases across all three active branches in two days, graduating HFresh disk-based vector indexing to GA and landing Namespaces, Nested Object Filtering, and atomic Reindex Property as previews. Christophe Pettus at thebuild.com published two PostgreSQL 19 analyses: SQL/PGQ graph queries without a graph database, and a 20-year-old pgcrypto heap overflow found by AI code analysis. Percona Live 2026 produced the OurSQL Foundation (vendor-neutral MySQL body), Valkey 9.1.0, and an Andy Pavlo keynote on the database industry's recurring cycle. MySQL 8.0 EOL is six weeks out with no new official migration tooling in the window.

Database Selection Brief for Backend Engineers2026/05/26 02:23:18

DB Engineering Weekly: May 18–25, 2026

PostgreSQL 19 Beta arrives with four production-behaviour changes worth staging now; Percona forks the Crunchy PGO into v3.0.0 with a documented near-zero-downtime migration path; MongoDB CVE-2026-8053 (CVSS 8.8) gets a corrected threat model — the readWrite-role audit scope matters even if you don't use time-series. Plus: Percona's MySQL 9.7 PGO benchmark (+6.5% average, +14.3% peak), MariaDB b-revisions, four Vector DB patches, and Valkey hash-slot migration guidance.

Database Selection Brief for Backend Engineers2026/05/19 02:09:11

DB Engineering Weekly: May 11–18, 2026

PostgreSQL patches 11 CVEs including four at CVSS 8.8; MongoDB 8.2.9/8.3.2 fix a time-series RCE (CVE-2026-8053); SpacetimeDB publishes a high-contention benchmark showing 300k TPS vs Postgres's 961; Meta's petabyte-scale MySQL migration case study delivers a transferable shadow-testing architecture.

これ以上のコンテンツはありません