sql

Tag

Cards List
#sql

PostgreSQL 19: A hands-on tour with runnable browser examples

Hacker News Top ↗ · 2d ago Cached

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.

0 favorites 0 likes
#sql

PostgreSQL 19 Released

Lobsters Hottest ↗ · 3d ago Cached

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.

0 favorites 0 likes
#sql

Infino AI

Product Hunt ↗ · 2026-11-02

Infino AI launches a tool that unifies search, vector retrieval, and SQL queries over a single Parquet copy of data, aimed at AI agents.

0 favorites 0 likes
#sql

Show HN: Automatic deduction of FlashAttention kernel from ~25 lines of SQL

Hacker News Top ↗ · 2026-10-30 Cached

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.

0 favorites 0 likes
#sql

Seqora

Product Hunt ↗ · 2026-10-26

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.

0 favorites 0 likes
#sql

DuckDB 2.0.0 LTS "Cinnamon Teal"

Hacker News Top ↗ · 2026-10-21 Cached

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.

0 favorites 0 likes
#sql

croft

Product Hunt ↗ · 2026-10-19 Cached

croft 是一款开源 TypeScript 数据管道工具,从 API 和文件拉取数据,用 SQL 或 TypeScript 转换,并通过调度保持更新,全部存储在一个 DuckDB 文件中,可由 Claude Code 驱动,无需 Python。

0 favorites 0 likes
#sql

How Postgres DELETE can actually scale

Hacker News Top ↗ · 2026-10-15 Cached

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.

0 favorites 0 likes
#sql

The DelightQL Query Language

Lobsters Hottest ↗ · 2026-10-14 Cached

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.

0 favorites 0 likes
#sql

@omarsar0: Agents will do more and more of their work inside systems of record, so those systems need to be built for them. Attio'…

X AI KOLs Following ↗ · 2026-10-14 Cached

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.

0 favorites 0 likes
#sql

@svpino: These guys put a SQL engine inside their CRM. This means an agent can query across all data, join records, and do math.…

X AI KOLs Timeline ↗ · 2026-10-14 Cached

Attio 为其 CRM 引入混合架构,在系统中内置 SQL 引擎并新增数据连接器,使 AI 代理能够跨全部数据进行查询、关联记录和执行计算。评论者强调,不支持代理的软件终将被淘汰。

0 favorites 0 likes
#sql

@Greptime: "Payment still failed after retries" is hard to grep for. GreptimeDB v1.3 adds experimental AI functions to SQL: ai_mat…

X AI KOLs Following ↗ · 2026-10-13 Cached

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.

0 favorites 0 likes
#sql

DataCube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals (1997)

Lobsters Hottest ↗ · 2026-10-13

Jim Gray 等人的经典论文,提出 data cube 关系聚合算子,将 GROUP BY 推广到 N 维聚合,并讨论高效计算方法,其中许多特性后来被纳入 SQL 标准。该论文是 OLAP 与数据仓库领域的奠基性工作。

0 favorites 0 likes
#sql

Visible Reasoning Is Not a Universal Optimizer: Persona- and Thinking-Dependent Effects in Analytics Code Generation

arXiv cs.LG ↗ · 2026-10-09 Cached

该论文通过一个查询匹配的 SQL-pandas 基准进行受控实验,发现可见思维链(CoT)并非普遍的准确率提升手段,其效果取决于 persona、目标语言、模型配置与内部推理设置,因此推理策略应与模型和任务联合选择,而非采用通用默认方案。

0 favorites 0 likes
#sql

@charles_irl: the ultra-high-throughput optimizations will continue until morale improves

X AI KOLs Timeline ↗ · 2026-10-07 Cached

Quail,一个开源 AI-SQL 引擎,新增了前缀共享(prefix sharing)支持,在对 1,772 条长 agent 轨迹使用 qwen3-4b 打标签的示例中,计算 token 减少 3 倍,查询速度提升 2.6 倍。

0 favorites 0 likes
#sql

DuckDB Ducklake

Hacker News Top ↗ · 2026-10-07 Cached

DuckLake 是一个基于 SQL 和 Parquet 构建的开放 Lakehouse 格式,其 DuckDB 扩展允许直接读写 DuckLake 数据,支持时间旅行、Schema 演进和变更数据流(CDC)等功能。

0 favorites 0 likes
#sql

The Query Transformation Pipeline

Hacker News Top ↗ · 2026-10-06 Cached

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

0 favorites 0 likes
#sql

Release of Polars 2.0

Hacker News Top ↗ · 2026-10-06 Cached

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.

0 favorites 0 likes
#sql

We ported the original Doom to SQL

Hacker News Top ↗ · 2026-10-03 Cached

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.

0 favorites 0 likes
#sql

@tom_doerr: Connects to PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server, and ClickHouse through a single native desktop appli…

X AI KOLs Timeline ↗ · 2026-10-03 Cached

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.

0 favorites 0 likes
Next →
← Back to home

Submit Feedback