database

PlanetScale explains how its Neki database performs a planned primary-to-replica switchover with minimal disruption, covering preflight validation, convergence/promotion, WAL position tracking, and client recovery.

Silicon Valley database company ClickHouse is now valued at $15 billion, with revenue tripling in a year. Its core edge lies in storing the massive volume of machine logs from the AI era at the lowest cost, competing with Datadog and acquiring AI evaluation tool Langfuse.

Jepsen 的这份分析报告测试了面向 AI 工作负载的多模型数据库 ParticleDB（1.1.4 至 1.1.18.11.rc-22），发现其宣称的"完全 ACID"并不成立，共报告 96 个问题，包括崩溃、死锁、数据丢失及各类一致性异常，最新的 1.1.19-rc.13 声称已修复全部问题。

PostgreSQL 19 is being delayed until November because LLMs have made it far easier to discover bugs, leading to a 60-74% jump in back-patch commits and several late feature reverts as maintainers are flooded with fixes to review.

YC's Lightcone podcast interviews Supabase co-founder Paul Copplestone about the open source Postgres platform reaching 13 million users, with ~70% of new activity driven by AI agents, and how the product is being redesigned agent-first.

Seqora is a new tool that lets developers design database schemas visually on a canvas and automatically generates the corresponding SQL. It launched on Product Hunt.

PostgreSQL 的 recovery_prefetch 功能可能导致数据库服务中断，文章警示该特性在恢复过程中的稳定性风险。

DuckDB 2.0.0 LTS "Cinnamon Teal" is announced as the biggest feature release yet, shipping a polished Quack client-server protocol, asynchronous I/O, a first-class VARIANT type, agent mode, triggers, and an extensible SQL parser, built from nearly 20,000 commits since DuckDB 1.5.

All 1.5 million databases running on Manus are hosted on TiDB, most used once and then discarded, reflecting a shift in primary database users from humans to AI agents. The article analyzes this trend from four angles: who is building them, the scale, the cost advantages, and the trade-offs. Sources include PingCAP press releases and Huang Dongxu's blog.

Security team FULCRUMSEC has publicly disclosed a large-scale data breach at PingCAP TiDB Cloud. Approximately 10.6 TB of data (including the control plane, customer SQL, API keys, source code, etc.) was exfiltrated continuously for nearly two months without being detected.

Hackers publicly disclosed a massive breach of PingCAP's TiDB Cloud, exfiltrating 10.6 TB of data including 4.9 million files, 115,308 plaintext customer API keys, and control-plane records from 180,046 tenant organizations, going undetected for months.

KiviDB 是一个用 Rust 编写的多线程 Redis 兼容内存数据库与向量缓存，支持 RESP2/RESP3 协议及内置全文与向量搜索，在 32 核上实现每秒 2100 万次流水线 GET，约为 Redis 8 的 9 倍。

介绍 duckdb_object_storage——一个基于 SlateDB 与 Apache OpenDAL 的 DuckDB 社区扩展，可将原生 DuckDB 数据库直接存于 S3 等对象存储，无需额外运行目录服务或协调器，支持单写多读且性能接近本地原生 DuckDB。

开发者正在构建一个分支式数据库，让每个 AI 代理先在私有分支中自由读写生产数据，随后通过三行级三方合并、读取追踪与 SQL 校验来审查并安全合并更改，目前正在寻找协作者与早期试用者。

SurrealDB 创始人 Tobie 宣布推出基于其多模型数据库的 Agent Memory，可将对话和文档转化为带溯源与时序历史的结构化实体、关系和事实，并在 BEAM 基准上达到 77.2% 准确率。

PostgreSQL developer Peter Eisentraut reflects on why an unusual number of features were reverted from the PostgreSQL 19 branch after beta began, citing LLM-assisted code review raising the quality bar, the Vulnpocalypse diverting senior developers, and late discovery of defect long tails.

ClickHouse 发布了 clickhouse-c：一个 header-only 的 C 语言客户端库，用于通过原生二进制协议（Native Protocol over TCP / Native Format blocks）与 ClickHouse 通信，可嵌入 PostgreSQL 扩展中使用。

APSW（Another Python SQLite Wrapper）是一个开源 Python 库，将完整的 SQLite C API 与 Python C API 粘合在一起，支持全文搜索、虚拟表、VFS、JSON 及异步框架，旨在提供比内置 sqlite3 模块更完整的 SQLite 使用体验。

MotherDuck 的技术博客详细解析 DuckDB 2.0 alpha 版本为何更快，重点介绍了通过独立下载线程池实现的异步 I/O，使 S3 上的 Parquet 查询性能显著提升，并分享了实际基准测试数据。

GreptimeDB 通过将 TopK 运行时边界下推到扫描层（基于 DataFusion 的动态过滤器），把一个 ~5-6B 行 trace 表上的 ORDER BY ... LIMIT 10 查询从 28.9 秒优化到 0.21 秒。