database

Lobste.rs posts an interview with Deepthi Sigireddi from Supabase, the open-source Firebase alternative, with a discussion thread in the comments.

GreptimeDB v1.2.0 正式发布，新增 JSON2 结构化类型（支持 SQL 嵌套路径查询）、支持 Prometheus Remote Write 2.0，并带来可续传的并行 Import/Export V2，面向日志与 AI 代理事件场景。

Readyset 的这篇技术博客深入讲解其查询转换管线如何将 SQL 重写为数据流图——包括二元等值连接、非关联子查询改写以及派生表内联等约束与优化策略，以便增量维护物化视图。

The author shares an experiment where an AI autonomously developed and iterated on a database from scratch over 50 rounds, using self-evolution rules and profiling guidance, ultimately reaching 2x DuckDB's performance on TPC-DS SF100 with only 2 queries still slower.

This paper presents Dostoevsky, a system that improves the space-time trade-offs of LSM-tree based key-value stores by adaptively removing superfluous merging during compaction, yielding better performance than existing compaction strategies.

Part 1 of Percona's deep dive explains thread pooling in Percona Server for MySQL and community MySQL Server, covering how thread groups, round-robin connection assignment, and priority queues work, with configuration sweeps and benchmark results to follow in Part 2.

Gridex 是一个开源的跨平台（macOS/Windows/Linux）AI 原生数据库客户端，内置 AI 聊天可直接读取表结构并支持 Claude、GPT、Gemini 和本地 Ollama，同时提供带权限分级与审计日志的 MCP 服务，可同时连接 PostgreSQL、MySQL、SQLite、Redis、MongoDB、SQL Server 和 ClickHouse。

A tweet discussing how SQLite is open source yet rejects external contributions, prompting Turso to fork it into libSQL and later rewrite a SQLite-compatible database in Rust (originally named Limbo) to add async I/O, concurrent writes, vector search, and better WASM support.

pg-jev is an open-source Postgres extension that lets you filter, classify, and rank rows with plain-language conditions via TypeSafe's Jev model, needing no vector columns or embedding indexes.

Supabase is acquiring Turso to build AI-agent-oriented database infrastructure, combining Supabase's Postgres platform with Turso's SQLite-based cloud that can serve millions of databases on demand.

ExplainDB 是一个以可理解性为目标的教学数据库系统，包含 Jupyter notebook 教程和用 Python 实现的 didactic DBMS，配套萨尔大学 Jens Dittrich 教授的数据库系统课程。

ParadeDB responds to PlanetScale's new TIN Postgres text-search extension by closing its 8x BM25 performance gap through optimization passes rather than architectural changes, benchmarking both on the same StackExchange dataset.

A developer reports that while working with Claude in auto mode, the AI unexpectedly destroyed their database, highlighting risks of autonomous AI agent actions.

Orgtree v3.0.0, a visual open-source agentic orchestrator, is released with a major performance overhaul: a parallelized embedded PostgreSQL storage model replacing SQLite, plus multi-window support and an attention view, enabling thousands of concurrent agents with sub-100ms actions.

作者分享了为 AI agent 提供只读 Postgres 账号后发现其权限并不真正只读的经历（通过角色继承等机制可获得写权限），并开源了一个名为 agent-db-scan 的工具，用于审计给定 Postgres 连接串的有效权限、继承角色、可写表、RLS 及敏感列访问等。

Gergely Orosz highlights turbopuffer publicly documenting its in-progress rewrite of the tpuf storage engine (v3), grinding query plans in public rather than only celebrating after the rewrite is finished and fast.

This article explores FunSQL.jl, a Julia library for SQL query building, and compares its data-oriented interface with other query builders, highlighting its unique combination of compositional features and full SQL support.

This article introduces a web-based tool that checks the safety of PostgreSQL migrations using a WASM parser, helping developers validate database changes.

Quail is an open source AI-SQL engine that integrates query planning with LLM inference to achieve over 1 billion input tokens per minute on an H100 GPU.

The article explains that PostgreSQL's SELECT DISTINCT clause does not scale efficiently, as it always scans all matching rows, leading to performance problems in certain workloads, and provides insights and workarounds.