OffNet Newsroom

Daily topic roundup

Database Technology

Sunday, July 26, 2026 · 8 stories, curated & summarized — click any story for the source.

Share this roundup on LinkedIn Full edition
Planet PostgreSQL database

Postgres Core Team Workshops AI Integration for Patch Review and Workflow Automation

AWS hosted a three-day AI workshop in Pittsburgh for Postgres committers and core team members. Participants focused on integrating Claude Code into development workflows to automate testing, benchmarking, and proof-of-concept patch creation. The sessions also addressed using AI to streamline email thread analysis and improve the review process for bug reports and patches.

  • Core committers are actively adopting Claude Code to handle repetitive tasks like testing and benchmarking.
  • AI is being used to generate proof-of-concept patches for complex ideas previously deemed too time-consuming.
  • Workflows for analyzing email threads and reviewing patches are being modified to leverage AI assistance.
  • Hands-on sessions focused on modifying the Postgres source tree to better support AI tooling integration.
HOW IT WORKSPostgres AI Integration Steps1Host AI workshop for core team2Integrate Claude Code into workflow3Automate testing and benchmarking4Streamline patch review process
Read at source →
Planet PostgreSQL database

PostgreSQL geqo: Touch only one GUC knob, ignore the rest

Christophe Pettus reviews the seven configuration parameters governing PostgreSQL's genetic query optimizer. He argues that practitioners should modify only a single specific GUC to avoid destabilizing query plans. The remaining six knobs are best left at their defaults to maintain optimizer stability.

  • PostgreSQL's genetic query optimizer exposes seven GUC parameters for tuning.
  • Most of these knobs should remain at default values for stable optimization.
  • Only one specific GUC is recommended for manual adjustment by engineers.
  • Altering multiple geqo settings can lead to unpredictable query performance.
Read at source →
Planet PostgreSQL database

EDB to Sponsor Postgres Summit US 2026 with Core Contributor Sessions

EDB is a gold sponsor for the upcoming Postgres Summit US 2026, held September 30 to October 2 in New York. The company will present sessions covering cloud-native transformations and database internals, featuring its core contributors. This event serves as a key venue for discussing the addition of approximately 200 annual features and major architectural milestones.

  • EDB sponsors Postgres Summit US 2026 at Convene, NYC, Sept 30-Oct 2.
  • Sessions focus on cloud-native shifts and deep database internals.
  • Core contributors present on handling 200+ annual feature additions.
  • Event replaces PGConf NYC, signaling a broader US scope.
Read at source →
GitHub Trending (daily) githubrepos ⚠ unverified date/source

Chat2DB: AI-Driven Cross-Platform SQL Client Supports 30+ Databases

Chat2DB is a free, open-source SQL workspace that runs locally on Windows, macOS, and Linux. It integrates an AI assistant that connects to user-provided models to aid development. The tool supports over 30 database engines including MySQL, Oracle, PostgreSQL, and ClickHouse via plugins.

  • Local execution ensures data privacy by keeping queries on-premises.
  • AI assistant allows connection to custom models for tailored assistance.
  • Broad vendor support covers major relational and NoSQL systems.
  • Cross-platform availability simplifies tooling for diverse dev teams.
Read at source →
InfoQ generaldevops ↺ since 07-24

DBOS Transact: Compiling Workflows into Databases for Durable Execution

DBOS Transact replaces external orchestrators by leveraging standard database tables, unique primary keys, and SKIP LOCKED queues to manage fault-tolerant AI workflows. This architecture aims to reduce operational overhead and latency by keeping execution logic within the database layer. The approach seeks to improve reliability by eliminating the complexity and failure points associated with separate distributed systems.

  • Eliminate external orchestrators to reduce failure points and operational complexity.
  • Use SKIP LOCKED queues for efficient, low-latency task dispatching within the DB.
  • Leverage standard tables and unique PKs to ensure durable, fault-tolerant execution.
  • Simplify AI workflow management by compiling logic directly into the database.
  • Reduce infrastructure overhead by consolidating execution and state management.
Read at source →
Percona Blog database ↺ since 07-23

MySQL Galera Cluster hits EOL Sept 2026; Percona outlines migration to XtraDB Cluster

MariaDB announced that MySQL Galera Cluster reaches end of life on September 30, 2026, ceasing maintenance and binary releases for that build. New clustering features will exclusively target MariaDB Galera Cluster. Percona provides guidance for migrating to Percona XtraDB Cluster as an alternative path.

  • MySQL Galera Cluster stops receiving updates after September 30, 2026.
  • MariaDB directs users to migrate to MariaDB Galera Cluster for new features.
  • Percona offers Percona XtraDB Cluster as a migration target for MySQL users.
  • Plan migration strategy now to avoid unsupported software risks.
THE SHIFTMySQL Galera Cluster Timeline2026CURRENT SUPPORT30EOL DAYSupport ends Sept 30, 2026
Read at source →
Planet PostgreSQL database ↺ since 07-22

Paul Jungwirth reviews TQuel paper to inform Postgres 19 temporal query optimization

With UPDATE/DELETE FOR PORTION OF likely arriving in Postgres 19, Paul Jungwirth is studying Richard Snodgrass's 1993 TQuel paper to understand temporal relational algebra. The goal is to identify algebraic identities that allow the query planner to transform queries into more efficient execution shapes. This research focuses on optimizing operations like filtering rows before joins to improve performance for temporal data.

  • Postgres 19 is expected to support UPDATE/DELETE FOR PORTION OF, enabling temporal row modifications.
  • Jungwirth is leveraging 1993 TQuel research to derive algebraic identities for the modern query planner.
  • Understanding these identities helps the planner push filters before joins for better performance.
  • This work connects historical temporal database theory to current Postgres optimization strategies.
HOW IT WORKSOptimizing Temporal Queries1Study 1993 TQuel paper2Derive algebraic identities3Transform query shapes4Push filters before joins
Read at source →
AWS What's New awsdatabase ↺ since 07-24

AWS RDS for MySQL adds MySQL 9.7 LTS to Preview Environment

Amazon RDS now supports MySQL 9.7 in its Database Preview Environment, allowing users to test the latest Long-Term Support release before general availability. This sandbox enables evaluation of new features and security patches specific to the community edition on RDS. Instances are retained for up to 60 days and automatically deleted afterward.

  • MySQL 9.7 is the newest LTS release, including bug fixes and security patches.
  • Preview instances are sandboxed and auto-deleted after 60 days.
  • Use this environment to validate application compatibility with MySQL 9.7.
  • Snapshots created in the preview environment can be retained beyond the instance lifecycle.
BY THE NUMBERSPreview Instance Lifespan60Days before auto-deletionSandbox instances expire automatically
Read at source →
↑