Database Selection Brief for Backend Engineers

Público

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

2026-07-20

DB Weekly: upgrade gates and vector hardening

PostgreSQL 19 Beta 2 makes compatibility and observability the week's main upgrade work, while Milvus, Weaviate, Qdrant, MongoDB, and MySQL updates sharpen the operational and lifecycle checks backend teams should run now.

Database Selection Brief for Backend Engineers

2026-07-13

DB Weekly: lock convoys and column stores

This week’s brief frames the database trade-off around workload boundaries: Postgres remains the transactional default, but lock-convoy incidents, Postgres-to-ClickHouse migration outcomes, and DuckDB-in-MySQL experiments show where specialized columnar execution starts to matter. It also covers vector DB stability releases, managed-platform control-plane shifts, and the MySQL 8.0 support deadline.

Database Selection Brief for Backend Engineers

2026-07-06

DB Weekly: Patch windows and boundaries

This week’s brief focuses on immediate database engineering decisions: PostgreSQL JDBC channel-binding mitigation, Weaviate RBAC privilege escalation, MariaDB 10.6 EOL, and Percona’s MySQL ELS path. It also frames PG19, PgDog, DBOS, Lakebase/LTAP, and vector DB release activity as boundary-setting decisions rather than raw release churn.

Database Selection Brief for Backend Engineers

2026-06-29

DB Engineering Weekly: June 22–29, 2026

This issue frames the week around operational control: Oracle’s CSPU changed Percona’s MySQL release train, lifecycle deadlines are now close enough to force sequencing decisions, and benchmark numbers need workload-specific interpretation.

Database Selection Brief for Backend Engineers

2026-06-22

DB Engineering Weekly: June 15–22, 2026

Two MongoDB CVEs demand immediate triage by network exposure (CVE-2026-9740 pre-auth BSON stack overflow, CVSS 8.7; CVE-2026-11933 use-after-free, CVSS 8.8), with patches landing in 8.0.26/8.2.11/8.3.4. MySQL 9.7.1 ships as a CSPU release, MariaDB Exa's HTAP Technical Preview claims 800× analytical speedup without ETL, pgEdge ColdFront v1.0.0-beta1 brings writable PostgreSQL→Iceberg cold tiering, and three EOL deadlines stack within six weeks (MariaDB 10.6 Jul 6, MySQL 8.0 Jul 31, MongoDB 8.2 Jul 31).

Database Selection Brief for Backend Engineers

2026-06-15

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 Engineers

2026-06-08

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 Engineers

2026-06-01

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 Engineers

2026-05-25

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 Engineers

2026-05-18

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 Engineers

2026-05-17

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.

No hay más contenido

Ver todo el archivo de contenidoDescubrir más canales