Reading up on DuckDB

The article previews DuckDB v2.0, highlighting upcoming performance gains, new SQL features, and improved extensibility for analytical workloads in embedded environments.

DuckDB is now available as a Clojure library, bringing its high-performance, in-process analytical database capabilities to Clojure developers for local data analysis on laptops.

The article argues DuckDB outperforms SQLite for analytical queries due to its columnar storage and vectorized execution, recommending it for data analysis tasks over SQLite's transactional strengths.

the-stats-duck v0.6.0 adds OLS regression, bootstrap, expanded distributions, and a Vega-Lite plot grammar to DuckDB SQL.

DuckDB's internal architecture makes it fast and easy to use for local analytical queries, often outperforming cloud data warehouses on data that fits on a laptop.

databow is a command-line tool for querying databases via ADBC, offering an interactive SQL shell, syntax highlighting, formatted output, and file export.

Perspective is an interactive analytics and data visualization component for large and streaming datasets, built with WebAssembly, Python, and Rust.

DuckDB's full-text search extension offers BM25 scoring, stemming, and stop-word removal but lacks result highlighting and phrase queries.

ggsql is a SQL extension that enables declarative data visualization within SQL queries using the Grammar of Graphics, currently supporting DuckDB and SQLite.

OpenDuck is an open-source DuckDB extension that adds distributed query execution with differential storage and hybrid local-remote processing.

DuckDB benchmarks show an 8 GB MacBook Neo can run ClickBench and TPC-DS SF300 workloads, outperforming some larger cloud instances.

DenchClaw is a local CRM built on top of OpenClaw that manages customer data and automates sales outreach through AI agents, sparking debate about security and ethics.

DenchClaw is an open-source AI CRM and workflow automation tool that runs locally on a Mac, using a Chrome profile to automate tasks like database queries, lead enrichment, and outreach.

Alibaba open-sourced AliSQL, a MySQL fork embedding DuckDB for columnar analytics and native HNSW vector search, claiming 200x faster analytical queries.

Repere is a local-first SQL data explorer that runs entirely in the browser via DuckDB WASM, enabling private, serverless spreadsheet-style querying and transformation of CSV, JSON, Parquet, or Excel files.

DuckDB is an excellent choice for data processing because it allows SQL queries directly on CSV, JSON, and Parquet files with high performance and simplicity.

mviz is a skill for Claude that generates static HTML charts and reports from compact JSON specs, optimized for fast, AI-driven ad hoc analysis with 17 chart types and a 16-column grid.

Andy Pavlo's 2025 database review covers PostgreSQL's continued dominance, emerging trends like vibe coding, and commentary on SQLite, DuckDB, and MCP security risks.

A tool serves 22 GB of Hacker News history via SQLite compiled to WASM, fetching only needed database shards in the browser.

SQLite can index JSON fields at full B-tree speed by creating virtual generated columns with json_extract and indexing them.

SQLFlow uses DuckDB to enable stream processing of Kafka data with SQL, claiming setup in under 5 minutes.