Database Technology

Shaun Thomas concludes his series on PostgreSQL 19 by highlighting the release's extensive scope, noting it contains more enhancements than previous versions. The post serves as a final overview of new syntax features and other marquee additions before the official launch. It emphasizes the importance of reviewing detailed changelogs to catch subtle but significant updates that might otherwise be missed.

• Postgres 19 is positioned as a major release with an unusually high volume of enhancements.
• Reviewing detailed release notes is critical to identify subtle syntax and feature updates.
• The author's series covers multiple marquee features beyond just syntax changes.
• This post acts as a final roundup of key improvements in the upcoming version.

Celld is an open-source daemon that enables self-hosting Cloudflare Workers and Durable Objects on private infrastructure. It addresses the limitations of shared databases by treating each object as an isolated SQLite database, with state replicated to an S3-compatible bucket for coordination. Nodes operate without a central control plane or consensus mechanism, relying instead on the object store for synchronization.

• Each Durable Object is its own SQLite database, eliminating contention and blast-radius failures of shared DBs.
• Nodes coordinate solely through an S3-compatible bucket, removing the need for a control plane or consensus layer.
• Idle cells hibernate to near-zero resource usage, optimizing cost and efficiency.
• Fleet shares deployment and state via S3, allowing decentralized scaling without complex infrastructure.

Percona has introduced Percona Search for MongoDB, a downstream distribution of mongot, the engine behind MongoDB Atlas Search. This release provides full-text and vector search capabilities to self-managed MongoDB deployments. It enables the use of advanced AI-driven search techniques without requiring a cloud provider.

• Percona Search is a downstream build of mongot, identical to the engine in Atlas Search.
• Enables full-text and vector search capabilities for self-hosted MongoDB instances.
• Supports AI application development using advanced search techniques on-prem or in private clouds.
• Offers a path to avoid vendor lock-in associated with managed MongoDB Atlas services.

The pgBackRest community has released version 2.59.0, continuing its reputation as a scalable backup and restore solution for PostgreSQL. This update introduces malware and ransomware protection capabilities alongside block incremental backups to optimize storage and performance. The release maintains support for parallel operations, multiple compression types, and encryption to ensure robust data safety across diverse infrastructure.

• Block incremental backups reduce storage overhead and speed up recovery windows.
• New malware/ransomware protection adds a critical layer of data integrity assurance.
• Parallel async archiving and resume capabilities minimize downtime during backups.
• Support for S3, Azure, GCS, and SFTP ensures flexible repository options.
• Page checksums validation during backup helps detect corruption early.

The pgAdmin 4 Development Team has released version 9.17, addressing seven security vulnerabilities including CVE-2026-17346 through CVE-2026-17351 and CVE-2026-17566. The update introduces new features such as including authenticated user identity in HTTP access logs and adding an opt-in Gateway API HTTPRoute template to the Helm chart. Additionally, a new preference allows capping the row count fetched by the plain View Data action to improve usability on large tables.

• Patch immediately to resolve 7 critical security vulnerabilities (CVEs).
• Update Helm charts to support opt-in Gateway API HTTPRoute templates.
• Configure row count caps in View Data to prevent performance issues on large tables.
• Enable authenticated user identity logging for improved access auditing.