database

Major improvements to session storage and access for Hermes Agent, saving 20-40% disk space and improving speed.

This paper describes Gorilla, an in-memory time series database developed at Facebook that achieves high performance through a novel compression algorithm, enabling storage of billions of time series and fast querying for production monitoring.

pgBackRest, a popular PostgreSQL backup tool, announces it will continue development thanks to a coalition of sponsors including Amazon Web Services, Supabase, and others, ensuring long-term sustainability.

GreptimeDB is a unified database for metrics, logs, and traces, offering OpenTelemetry-native ingestion, SQL/PromQL querying, object storage for cost reduction, and edge-to-cloud deployment.

A practical blueprint for designing a backend system capable of handling 1 million concurrent users, covering architecture decisions like language selection, load balancing, database sharding, multi-layer caching, and resilience patterns.

This paper proposes out-of-place write optimizations for database systems to fully leverage SSD performance, achieving 1.65-2.24x throughput improvement and 6.2-9.8x reduction in flash writes on OLTP benchmarks.

A user describes an AI agent that autonomously fixed product images, frontend bugs, and descriptions from a database, used browser automation and web search, and ran for two hours while the user met founders, highlighting impressive AGI-like capabilities.

This paper presents techniques and best practices for writing to SSDs efficiently, covering aspects such as write patterns, buffering, and file system optimizations.

Basedash has introduced MCP connectors, enabling its agent to take actions in connected tools like Linear, HubSpot, Slack, and more, expanding from read-only to interactive capabilities via chat.

Explains the subtle differences in how ORDER BY handles bare identifiers versus expressions in SQL, using PostgreSQL examples to show that identical-looking queries can produce different results due to different code paths.

NanoTDB is a small embedded append-only time series database for resource-constrained hosts, written in Go, with no runtime dependencies. It uses a WAL and partitioned data files, supports line protocol ingestion, and provides efficient time-range queries.

PostgreSQL has released security updates for versions 18.4, 17.10, 16.14, 15.18, and 14.23, fixing 11 CVEs and over 60 bugs. Notable fixes include CVE-2026-6473 (integer wraparound, CVSS 8.8) and CVE-2026-6475 (symlink overwrite, CVSS 8.8).

The article traces the evolution of SQL's ORDER BY clause from the 1980s to modern standards, clarifying common misunderstandings about syntax and evaluation order.

Comie.dev provides a production context for AI applications, integrating logs, databases, and error tracking.

ZenithDB is a new open-source Rust database designed for storing and querying AI agent traces. It achieves sub-millisecond trace fetch latency at 1 billion rows by colocating all spans of a trace during compaction, and includes embedded full-text search and late materialization.

This article explains how rqlite, a distributed SQLite database, takes control of SQLite's Write-Ahead Log to enable efficient snapshotting for Raft consensus, avoiding full database copies by using the WAL as incremental state.

An analysis of three new Postgres-compatible cloud databases—Snowflake Postgres, Databricks Lakebase, and Azure HorizonDB—highlighting their distinct architectures and the vendor lock-in implications for enterprise data platforms.

DuckDB introduces 'Quack', a new client-server protocol that enables DuckDB instances to communicate via HTTP, supporting concurrent writers and remote access while maintaining simplicity and performance.

HelixDB is a new open-source database built in Rust that combines vector, graph, and other data models into a single engine, backed by Y Combinator. It aims to replace separate vector, graph, and application databases for AI stacks, offering native vector search, graph traversal, and MCP support.

Ardent is a Y Combinator-backed tool that clones any PostgreSQL database in under 6 seconds at TB scale, enabling coding agents and developers to test code on production-like clones without risking downtime. The tool is already being used by companies like Supermemory and Surface Labs.