PostgreSQL 19 ships, adding pg_plan_advice query hints
The new major version is generally available, with an officially supported way to pin query plans. PostgreSQL 14 reached end of life the same week.
Tagged
Everyone knows to eager load. The queries that actually take sites down are the ones hiding in an accessor, a Blade partial, or a policy. There is a one-line switch that finds all of them.
Most slow queries are one index away from being fast. The reason people do not add it is that nobody ever explained what the index is actually doing.
WordPress will happily let you write a query that scans a million meta rows. Here is which arguments are expensive, why, and what to do instead.
The new major version is generally available, with an officially supported way to pin query plans. PostgreSQL 14 reached end of life the same week.
The Lock component gets native advisory locking on MySQL and MariaDB, so you no longer need Postgres, Redis or a polling database table just to coordinate processes.
An agent built into PlanetScale reads your Query Insights data, proposes a fix and opens a pull request in your own code style, using OpenAI and Anthropic models under a zero-retention policy.
VPC Services can present a client certificate and trust a private certificate authority, so Workers no longer have to disable TLS verification to reach internally secured databases.
A German security firm scanned 159,041 apps built on the AI platform Lovable and found 24,664 Supabase-backed sites returning database records with no login required.
Neon enforces Viewer, Editor and Admin project roles on Object Storage, Functions and AI Gateway credentials, closing gaps where any member could previously act.
AI Search runs a read-only query against D1 and indexes each row as a document, with scheduled syncs keeping it current. The feature is in beta.
Versions 18.7, 17.12, 16.16, 15.20 and 14.25 all shipped the same day. The worst flaw, rated 8.8, lets a type confusion bug in ALTER ... SET DATA TYPE run arbitrary code.
supabase-flutter 3.0.0 generates Dart types from your schema and swaps callbacks for streams. Four underlying packages are renamed and marked discontinued.
Workers Paid accounts can now pool far more origin database connections per Hyperdrive configuration, and run far more configurations per account.
Correlated Logs links events by requestId, traceId or userId in Studio, and the CLI gets a terminal log explorer with SQL queries and JSON export.
Five years after its release, PostgreSQL 14 gets its final patch and stops receiving community security fixes.
Running a GQL query against a BigQuery graph used to mean provisioning an Enterprise or Enterprise Plus capacity reservation first. Google now lets on-demand pricing cover it too.
A new setting stops large IN (subquery) lookups from dying with an out-of-memory error. The release also speeds up GROUP BY on LowCardinality columns by 30%.
A new neon postgres command manages computes directly from the terminal, while the same release caps paid-plan read replicas at six per branch.
BOLT cuts binlog commit latency for huge transactions from minutes to about two seconds, and AWS has sent the optimisation back to community MySQL.
Enterprise Platform 2027 bundles a durable state store for AI agents and a cache that skips repeat model calls, alongside a self-reported throughput jump over the last major version.
Redis Iris grows from a memory and context tool into six composable capabilities, so agent routing, auditing and inter-agent messaging run on the Redis instance you already have.
Emergency backups copy data straight from a live primary or replica instead of starting from the last snapshot, for when scheduled backups have stopped working.
Claude can now issue the identity assertion enterprise SSO needs for Supabase MCP access, skipping identity providers that do not support the spec yet, but offboarding works differently.
A major CLI release changes which project your commands hit by default, requires confirmation before touching a hosted project, and drops the supabase-go binary.
Supabase launched an open-methodology site comparing managed Postgres providers on throughput, price-performance and latency, though Supabase sponsors it and its own engine wins every category.
An outdated tzdata package meant AT TIME ZONE conversions for Vancouver, Edmonton and Casablanca were wrong on older Postgres builds. Stored data is fine, only the conversion was off.
Managed Better Auth, Data API, Functions, Object Storage, AI Gateway and Realtime can now handle protected health data, and Better Auth adds Apple and Microsoft sign-in.
The Postgres admin tool's latest release lets you edit data through simple views and export query results as JSON or XML, alongside fixes for 15 security bugs.
Queries that return more than 50MB will start failing with a dedicated error. Cloudflare says it only affects the top 0.001% of requests, but large exports and unbounded SELECTs are the ones that will break.
A new Postgres extension built on Pinecone's own search engine claims smaller indexes and better filtered-search accuracy than pgvector, and runs entirely inside your database with no API key needed.
Multigres, built by the Vitess team, promotes a replica within seconds of a primary failing, using one unchanged connection string and no fork of Postgres.
OrioleDB swaps Postgres heap storage for an undo log, and early benchmarks show up to 1.8x more transactions once data outgrows memory. Not for production yet.
A new private alpha runs long-lived services, background jobs and AI agents inside your Supabase project instead of on a separate platform.
Two new Preview functions, ai.extract and ai.classify, pull structured fields and labels out of unstructured text inside a query, no separate extraction pipeline required.
Service tokens in PlanetScale's dashboard, API and CLI now show the IP, location and network operator they were last used from, making a leaked credential easier to spot.
Oversized PUBLISH and SPUBLISH messages over the cluster bus could overflow a heap buffer in Redis Cluster. Seven release lines got the fix on 26 October, with no CVE number assigned yet.
The Data API opt-out that already applies to new Supabase projects rolls out to every existing project on 30 October, closing a default that exposed new tables before RLS could be configured.
The D1 undelete API now rejects any request for a database deleted more than a week ago, returning an error instead of restoring it.
Managed Better Auth adds an OAuth 2.1 authorization server mode and a new @neon/oauth SDK in beta, so users can sign into your MCP server or API with an account they already have.
The embedded analytics database adds a first-class VARIANT type, triggers and an extensible SQL parser, but older DuckDB builds cannot read files it writes.
MySQL REST Service ships as a server component in MySQL 26.10, replacing the need for a separate MySQL Router process, alongside a Community Edition Health Monitor and WebAuthn login.
AI.CHUNK_DOCUMENT reaches general availability as a table-valued function that splits unstructured documents into chunks sized for embeddings, keeping each chunk aware of its surrounding headings.
A new PreventStaleDatabaseReads middleware and a usingWritePdo method fix the classic read-replica-lag bug where a user saves something and then does not see it.
A restore that hits a corrupted database page used to carry on; now it halts by default, and expire will not retire a backup that would leave checksum errors behind.
Five new pieces, including a query_logs MCP tool and a Database Connections page, let Claude, Codex or Cursor check your Supabase project on a schedule and report what changed.
A power event in europe-west2-b took out dozens of Cloud products overnight on 19 to 20 October, and some of the knock-on outages at platforms built on top of it lasted longer than the incident itself.
Oracle's October Critical Patch Update, out today, fixes 98 MySQL vulnerabilities with a top CVSS score of 9.8. None are confirmed exploited yet, but the clock is ticking.
Canada's cyber centre confirms attacks on CVE-2026-25243 after honeypots caught scripted exploitation attempts on 16 and 17 October. Upgrade to Redis 8.6.3 or later.
A new public beta lets any SQL query push live updates to the client, with SSR support and instant local writes, so you can drop the polling and refetch code.
The feature backfills then continuously syncs charges, customers, subscriptions and invoices into a dedicated schema, authenticated with short-lived OAuth tokens rather than a stored database password.
RC1 lands with a native REPACK command that can rewrite a table online, plus parallel autovacuum and logical replication that no longer needs a restart to turn on.
Hyperdrive, previously Postgres-only, now pools MySQL connections in production, after a beta that fixed 20 bugs including a caching flaw that returned empty query results about once in every 100,000 requests.
PlanetScale databases are now available on Azure, in three regions to start, though its Vitess MySQL offering stays AWS and GCP only.
You can now provision and connect S3 buckets from inside a Vercel project, with short-lived OIDC credentials instead of stored AWS keys.
Version 1.26.1 fixes an authentication bypass reachable by anyone who knows one SCRAM password, plus two unauthenticated denial-of-service bugs.
A new opt-in flag resets read/write routing between queue jobs, and the same release adds DB::olap() for PlanetScale and makes Mercure broadcasts synchronous by default.
Project HTTP APIs stop offering CBC-mode cipher suites. Clients stuck on old TLS libraries will fail to connect, and the error won't show up in API logs.
A new dashboard view shows which Cloudflare location served the most read and write traffic for an R2 bucket, instead of just a single global total.
Scoped PATs limit a token to specific projects or permissions instead of full account access, and are now the default when you create one in the dashboard.
The Rust-based dataframe library adds out-of-core spilling, first-class SQL support and a native Map type, and silently drops row-order guarantees unless you opt back in.
Any database user who can create an IVFFlat index could trigger an out-of-bounds write and run code inside Postgres. The extension ships on every major managed Postgres provider.