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/16 02:23:14

DB Engineering Weekly: June 8–15, 2026

PgDog raises $5.5M to scale Postgres horizontally via Rust proxy, hitting 547-point HN engagement but flagging real 2PC durability caveats. Percona's dual-piece analysis quantifies MySQL Group Replication's consistency tax — 75% throughput collapse under strict mode vs. 5.5% for PXC — and explains its OOMKill/brownout risk in Kubernetes. MariaDB embeds DuckDB as an alpha storage engine delivering 60× faster analytics. PostgreSQL 19 temporal tables are now testable on AWS RDS. A supercomputer paper finds vector DB throughput peaks at 32 cores and degrades beyond.

Database Selection Brief for Backend Engineers2026/06/09 02:29:31

DB Engineering Weekly: June 1–8, 2026

PostgreSQL 19 Beta 1 arrives feature-complete (SQL/PGQ graph queries, online checksum toggle, parallel autovacuum, 2× FK insert performance) with GA targeting September 2026. On the same day, Supabase closes a $500M Series F at $10B and drops Multigres v0.1 Alpha — an open-source Kubernetes Postgres operator by the original Vitess co-founder, minus sharding in this release. Weaviate v1.38.0 graduates HFresh disk-based vector indexing to GA. Redis 8.8 ships with a new array data type designed by antirez and 68–83% throughput gains on MGET/XREADGROUP. Qdrant v1.18.2 patches two security vulnerabilities including an auth whitelist bypass. Percona ClusterSync 0.9.0 unlocks MongoDB 6.0→8.0 live migration. MySQL 8.0 EOL is seven weeks out with no new Oracle tooling. SIGMOD 2026 concludes in Bengaluru (349 papers, CoddSpeed wins Best Industry Paper), and OurSQL Foundation formalizes its governance.

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.

Database Selection Brief for Backend Engineers2026/05/18 00:06:05

DB Engineering Weekly: May 10–17, 2026

Backend-engineer brief for May 10–17: four CVSS 8.8 CVEs across PostgreSQL and MongoDB demand immediate patching; Qdrant v1.18 ships TurboQuant (8× compression); Neon's FPW disable yields 4.5× write throughput; Shopify's Redis→MySQL post-mortem traces the real culprit to connection leakage.

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