PostgreSQL

The article discusses the importance of using strict memory overcommit in PostgreSQL to prevent issues with the OOM Killer. It emphasizes that this configuration is crucial for system stability and performance.

Databricks claims to unify OLTP and OLAP workloads through its LTAP system, which combines Lakebase (a PostgreSQL-based database) and Reyden compute engine. The system stores data in a data lakehouse, but engineers and competitors note that it involves two data copies: one in pageserver format for OLTP and another in Parquet for OLAP analytics.

PostgreSQL, originally developed by Michael Stonebraker as a successor to Ingres, was abandoned in the 1990s but survived due to a dedicated open-source community. The volunteer team expanded its capabilities with standard SQL while maintaining its extensible architecture, leading to its current role as a foundation for modern cloud infrastructure.

PostgresBench is a reproducible benchmarking tool designed for PostgreSQL services, introduced in a blog post by ClickHouse. The article provides a link to Hacker News comments for community feedback.

Microsoft's SQL Server received minimal attention at the Build event, with no major announcements despite the recent release of SQL Server 2025. Analysts note reduced focus on SQL Server as key personnel like Rohan Kumar have left, and Arun Ulag now oversees it alongside open-source database services. Licensing changes allowing SQL Server on AWS RDS and concerns about Azure-centric updates have raised doubts about its future prioritization.

Rimini Street CEO Seth Ravin advocates for 'headless ERP' as a solution for enterprises to bypass traditional ERP upgrade cycles by using open-source databases like PostgreSQL and MongoDB. Salesforce's Headless 360 and SAP's policy shift on AI agents highlight growing interest in decoupling ERP systems from monolithic vendors. A survey by Rimini Street found 70% of executives doubt traditional ERP's future, favoring modular, API-driven, or AI-driven alternatives.

AMD's Zen 5 architecture demonstrates performance improvements through Cache Aware Scheduling in PostgreSQL and Valkey benchmarks. The article highlights specific gains in database and in-memory computing workloads.

HeidiSQL is a lightweight database management tool supporting MariaDB, MySQL, SQL Server, PostgreSQL, and SQLite. The article provides links to its GitHub repository and Hacker News discussion, which has 14 points and 3 comments.

The article argues that PostgreSQL can handle durable workflows without additional tools, and it has received positive engagement on Hacker News with 66 points and 20 comments.

The OurSQL Foundation, a nonprofit representing MySQL users and developers, aims to foster transparency and collaboration with Oracle to improve MySQL's development and community engagement. Oracle, which acquired MySQL in 2009, has faced criticism for its opaque development practices, while the foundation seeks to position MySQL as a competitive open-source database alongside rivals like PostgreSQL.

Drupal has released security updates for a highly critical vulnerability (CVE-2026-9082) in Drupal Core that could allow attackers to achieve remote code execution, privilege escalation, or information disclosure on PostgreSQL sites. The vulnerability has a CVSS score of 6.5 and resides in the database abstraction API.

A group of companies including AWS and Percona have stepped up to fund the maintenance of pgBackRest, a PostgreSQL backup tool, after its sole maintainer David Steele sounded an alarm about its future. The tool provides a backup and restore solution for the PostgreSQL RDBMS. The new funding ensures the project's stability and continuity.

Google is encouraging database developers to use AI coding tools for PostgreSQL work, aiming to accelerate contributions to open source projects. Google has announced new contributions to PostgreSQL and is using AI coding tools to improve productivity. The company's VP of Databases, Sailesh Krishnamurthy, emphasizes the importance of accountability in AI-assisted development.

MLJAR Studio is a desktop application that uses natural language to generate Python code for data analysis, saving workflows as reproducible Jupyter notebooks. It supports local execution, multiple data formats, and integrates with various databases and AI models like Ollama or OpenAI. Priced at $199 with a 7-day trial, it aims to bridge the gap between manual Jupyter Notebooks and cloud-based AI tools.

A project named SNEWPAPERS has been developed to extract and categorize historical newspaper articles from the 1730s to 1960s, utilizing OCR, semantic search, and a multi-model pipeline. The creator spent 3,000 hours addressing challenges like layout variability and scan quality to enable full-text searches and personalized query tools.

The article introduces 'gitgres', a private GitHub alternative built using PostgreSQL, showcased by Caleb Win. It is shared on Hacker News with 3 points and no comments as of the report.

Linux 7.0 introduced a preemption regression that disrupted PostgreSQL's performance, causing stability issues. The article explains how this kernel update negatively impacted the database system.

Pgbackrest, a PostgreSQL backup tool, is no longer being actively maintained. The announcement was made via its GitHub repository, with a Hacker News discussion thread receiving 96 points and 30 comments, indicating community interest and concern.

A developer created a new Bitcoin Explorer in Rust for bulk address searching and data exporting, achieving 13k transactions per second indexing into PostgreSQL. The tool allows exporting large datasets (e.g., 100 million rows to CSV) and invites users to test its SQL performance. The explorer currently counts transaction inputs/outputs rather than unique transactions.

Honker is a project that implements Postgres' NOTIFY/LISTEN semantics for SQLite, enabling real-time database communication features typically found in PostgreSQL. The project was shared on Hacker News by developer russellromney and has received moderate engagement.

PgQue is a new PostgreSQL queue system designed to minimize bloat, offering a lightweight solution for task queuing. The project, hosted on GitHub, has received positive attention with 51 points and 4 comments on Hacker News.

The article details the author's process of exploring PostgreSQL's source code to develop a custom WAL receiver, highlighting technical challenges and insights gained. It provides a behind-the-scenes look at PostgreSQL's internals and the practical steps involved in implementing a WAL receiver.

A project emulates the MOS Technology 6502 microprocessor using pure SQL within PostgreSQL. The GitHub repository demonstrates this SQL-based implementation of an 8-bit processor.

The article discusses strategies for maintaining a healthy Postgres queue, published by Planetscale's blog. It focuses on best practices for queue management in PostgreSQL databases.