#database

Scalple is a tool that provides structured production database access with an immutable audit trail. It enables secure database querying while maintaining a complete record of all data access activities.

Oracle has released MySQL 9.7.0 LTS, introducing expanded community capabilities and dynamic data masking for Enterprise users. The update enhances the open-source database with new features aimed at improving usability and security.

A benchmark evaluates DuckDB's performance for insert, update, and delete operations from Java, comparing it against H2 and SQLite across varying batch sizes. DuckDB shows strong throughput for bulk inserts and competitive update/delete performance, though it has higher per-row overhead for small batches. The results position DuckDB as a fast embedded analytical database for Java applications.

Xata has open-sourced its Postgres platform that includes branching capabilities using copy-on-write technology. The platform enables developers to create isolated database branches for development and testing purposes. This approach allows for efficient resource usage while maintaining data consistency across branches.

pg-retest is a tool for capturing and replaying Postgres workloads at scale. It enables developers to test database performance by recording real production traffic and replaying it in testing environments.

Mike Stonebraker, a Turing Award winner, discusses the development of Postgres and expresses disagreement with Google's approach to database systems in this video interview.

PostgreSQL 19 will include a new contrib module called pg_plan_advice that provides query plan recommendations. The module analyzes queries and suggests potential performance improvements through index creation or query rewrites.

A solo developer running an SQL tutoring app on Supabase's free tier hit the 5GB egress limit, causing all API requests to fail with 402 errors. The only options were waiting for the billing cycle reset or upgrading to the $25/month Pro tier, which provides 250GB egress - far more than needed. The developer questions whether there should be a middle-tier pricing option for solo builders.

The article discusses SQLite's WAL architecture in 2026, focusing on checkpoint starvation issues and concurrency boundaries. It examines how the write-ahead logging system handles concurrent transactions and potential starvation scenarios.

ClickHouse is planning to introduce native JSON support in 2026, with development progress tracked through individual pull requests. The implementation aims to enhance the database's capabilities for handling JSON data directly.

Malext.io is a new database tracking malicious Chrome extensions. The platform aims to help users identify potentially harmful browser add-ons by providing information about their malicious activities and behaviors.

Pgrust is an ambitious project to rebuild PostgreSQL in Rust using AI assistance. The initiative aims to leverage modern programming language features while maintaining compatibility with the original database system.

A GitHub repository called SlothDB claims to be an OLAP database that outperforms DuckDB on Parquet, CSV, and JSON formats. The post asks whether these performance claims are accurate.

MariaDB's implementation of snapshot isolation reportedly introduces new issues while attempting to fix existing problems. The feature appears to create more complications than it resolves according to the analysis presented.

Gyrus is an open-source, self-hosted AI agent framework for Snowflake, SQL Server, and Postgres databases. It provides total control over credentials and model selection while implementing safety features like hard-coded blocks for destructive commands. The Snowflake agent will soon support open-source Gemma 4 models with comparable accuracy to state-of-the-art options.

pg_roast is a Postgres extension that provides critical feedback on database design and performance. The tool analyzes database configurations and offers blunt assessments to highlight potential issues.

Xata's open-source Postgres branching uses copy-on-write technology to create instant, isolated database branches. This approach enables developers to work with separate database copies without duplicating storage until changes are made. The system provides efficient branching for development and testing workflows.

Researchers have developed an AI system capable of generating correct streaming SQL queries. The technology represents an advancement in automated database query generation for real-time data processing applications.

Myanon is a fast, deterministic MySQL dump anonymization tool that preserves data structure while anonymizing sensitive information. It processes database dumps to protect privacy while maintaining referential integrity across tables.

The article details PostgreSQL's Multi-Version Concurrency Control (MVCC) implementation at the byte level, explaining how multiple row versions are stored to enable concurrent operations without locking. It examines the physical storage layout including tuple headers and transaction visibility mechanisms.

ShannonBase is a database agent platform that enables users to interact with databases using natural language. The platform allows for querying, analysis, and data manipulation through conversational AI agents.

The SQLite amalgamation combines all C code into a single source file for easier compilation. This approach includes debugging code and results in approximately 238,000 lines of code. The amalgamation simplifies building SQLite across different platforms.

Frappe Cloud engineers diagnosed random MariaDB freezes caused by a kernel bug in Ubuntu 22.04. The issue was resolved by applying a specific kernel patch that addressed the problem with the system's memory management.

DuckDB has added support for the Dutch language, allowing users to interact with the database using Dutch commands and queries. This enhancement expands the accessibility of DuckDB for Dutch-speaking users and developers.

The article discusses pgweb, a web-based PostgreSQL client that allows users to query and manage databases through a browser interface. It highlights the tool's features including SQL query execution, table browsing, and data export capabilities.

Xata introduces database branching that allows developers to create isolated database copies for testing and development. This feature integrates with Git workflows, enabling branches to be created from pull requests and automatically cleaned up. The approach aims to simplify database management in development environments.

The weekly update discusses how the platform has evolved from a simple website and database to include serverless functions, edge computing, new data storage structures, and different query mechanisms for email address searches.

SQLite 3.53.0 is a major release with accumulated improvements including ALTER TABLE support for NOT NULL and CHECK constraints, new json_array_insert() function, and CLI enhancements via a new Query Results Formatter library.

Datasette-ports 0.3 has been released with updates to help monitor Datasette instances. The tool now displays the working directory derived from each process ID and shows the full path to each database file. The output format has been improved to provide more detailed information about running Datasette instances.

The datasette-export-database plugin version 0.3a1 has been released to address compatibility issues with Datasette 1.0a27, which no longer sets the ds_csrftoken cookie used by the plugin's custom signed URL system.