Tag
PostgreSQL 19 was released on 19 November 2026, and this hands-on tour walks through new SQL features like IGNORE NULLS, get-or-create inserts, JSONPath transformations, range subtraction, native REPACK, and logical/physical replication with runnable browser-based examples.
PostgreSQL 19 is released with new features like REPACK (CONCURRENTLY) for non-blocking table maintenance, the pg_plan_advice extension for query plan stability, and improved parallel autovacuum to simplify administration at scale.
Infino AI launches a tool that unifies search, vector retrieval, and SQL queries over a single Parquet copy of data, aimed at AI agents.
Show HN: xarray-sql lets you query Xarray datasets with SQL, pivoting them into tables so you can run queries on engines like DuckDB, Polars, PostgreSQL, BigQuery, and Arrow Flight SQL, with lazy round-tripping back to Xarray.
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.
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.
croft 是一款开源 TypeScript 数据管道工具,从 API 和文件拉取数据,用 SQL 或 TypeScript 转换,并通过调度保持更新,全部存储在一个 DuckDB 文件中,可由 Claude Code 驱动,无需 Python。
DBOS explains how Postgres DELETE can scale for high-throughput workloads by tuning cache locality and index performance when enforcing data retention policies on tens of thousands of workflows per second, despite MVCC's inherent overhead.
DelightQL is a query language that transpiles to SQL, drawing on logic and functional programming to make queries succinct, reusable, and capable of building nested data shapes while retaining SQL's relational power.
Attio announced a hybrid architecture designed for AI agents, allowing agents to query all of Attio's data via SQL while business logic, policies, and compliance rules remain enforced behind every query. The release also adds data connectors, support for hundreds of millions of records, and Activities in beta.
Attio 为其 CRM 引入混合架构,在系统中内置 SQL 引擎并新增数据连接器,使 AI 代理能够跨全部数据进行查询、关联记录和执行计算。评论者强调,不支持代理的软件终将被淘汰。
GreptimeDB v1.3 introduces experimental provider-neutral AI functions in SQL — ai_match, ai_choose, and ai_score — allowing users to filter, classify, and rate text rows using natural-language prompts via TypeSafe's Jev model backend.
Jim Gray 等人的经典论文,提出 data cube 关系聚合算子,将 GROUP BY 推广到 N 维聚合,并讨论高效计算方法,其中许多特性后来被纳入 SQL 标准。该论文是 OLAP 与数据仓库领域的奠基性工作。
该论文通过一个查询匹配的 SQL-pandas 基准进行受控实验,发现可见思维链(CoT)并非普遍的准确率提升手段,其效果取决于 persona、目标语言、模型配置与内部推理设置,因此推理策略应与模型和任务联合选择,而非采用通用默认方案。
Quail,一个开源 AI-SQL 引擎,新增了前缀共享(prefix sharing)支持,在对 1,772 条长 agent 轨迹使用 qwen3-4b 打标签的示例中,计算 token 减少 3 倍,查询速度提升 2.6 倍。
DuckLake 是一个基于 SQL 和 Parquet 构建的开放 Lakehouse 格式,其 DuckDB 扩展允许直接读写 DuckLake 数据,支持时间旅行、Schema 演进和变更数据流(CDC)等功能。
Readyset 的这篇技术博客深入讲解其查询转换管线如何将 SQL 重写为数据流图——包括二元等值连接、非关联子查询改写以及派生表内联等约束与优化策略,以便增量维护物化视图。
Polars 2.0 ships with out-of-core spill-to-disk support, a streaming engine as the default for LazyFrame collects, first-class SQL support that leads DuckDB and DataFusion in TPC-H/TPC-DS benchmarks, a new Map dtype, and stricter dtype handling.
CedarDB ported the original 1993 Doom's game logic and BSP-based renderer entirely into SQL queries, running the game loop at 35 FPS with a full playable deathmatch demo inside the database.
Gridex is an AI-native database IDE for macOS, Windows, and Linux that connects to PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server, and ClickHouse through a single native desktop application with a built-in MCP server and AI chat.