@duckdb.org
DuckDB is an analytical in-process SQL database management system. "DuckDB" and the DuckDB logo are registered trademarks of the DuckDB Foundation.
@duckdb.orgThe #DuckDB v2.0 CLI has an agent mode that gets AI coding agents to a correct result faster and with fewer tokens.
When the CLI detects an agent, it prints compact Markdown tables instead of padded boxes, says clearly when a result was cut, stops runaway queries early, and reports errors as JSON.
@duckdb.orgA #DuckDB file doesn't have to contain any data.
It can store nothing but view definitions pointing at files stored somewhere else, such as Parquet on object storage. The file stays a few hundred KBs no matter how large the data it describes. In this post, we create such a small shareable catalog:
@duckdb.org[Guest blog:]
When the analytics screen running on our main operational database got too slow, we moved 1 year of data into #DuckDB on the same server. Getting the data in was the hard part.
This is the story of every method we tried and why a table function written in Java is the one we shipped:
@duckdb.orgGrouping on repeated strings is expensive. 💰
By moving strings into a small dimension table with sorted, narrow integer keys, #DuckDB can aggregate on fixed-width integers and keep its hash tables compact.
Here’s how to achieve faster string aggregations with dimension tables:
@gmcd.bsky.socialReposted by @duckdb.orgMissed this originally, but: jev + @duckdb.org !
@openknowledgegraphs.comReposted by @duckdb.org🦆 Working with RDF in DuckDB (@duckdb.org)? duck_rdf 2.8.3 is out with SPARQL enhancements, Turtle/quads export fixes, and performance improvements. Read, write, and query RDF alongside your SQL workflows.
Release notes:
github.com/nonodename/d...
@duckdb.org🦆 DuckDB v2.0.0 ships in a few weeks. Here's an accurate depiction of our CI pipeline building the v2.0.0-dev clients.
🙌 Help us craft a great release by trying out the preview release and reporting any issues that you encounter.
@duckdb.orgDuckDB as an analytical runtime 📊 🦆
What if a DuckDB file could contain an entire analytics workspace?
In this talk from DuckCon, Ilya Boyandin from Foursquare / GeoVisually GmbH presents on building local-first analytics apps with SQLRooms and #DuckDB.
@duckdb.orgJev & DuckDB: Plain-English Conditions in SQL 😎 🦆 Jev is a model that answers with a typed value and a probability instead of a paragraph. A number of DuckDB + Jev community extensions have been published that let you filter, classify, and score DuckDB rows with plain-English conditions. More:
@duckdb.orgAnnouncing DuckDB 1.5.6 🦆 🦆 This is the sixth patch release in DuckDB’s 1.5 (Variegata) line. The release ships bugfixes, performance improvements, and security patches. Find the full release notes on GitHub or browse the overview here:
@kelseyhightower.comReposted by @duckdb.orgI've been playing with @duckdb.org and I gotta say the docs are amazing. The built-in web shell is a really nice touch. You can play with DuckDB right inside your web browser. This might be my SQLite replacement. duckdb.org/docs/current
@duckdb.orgDid you know that, since #DuckDB v0.10.3 (~May 2024), you can point a SELECT at a dataset on the Hugging Face Hub, using the DuckDB `hf://` protocol, and query it, without downloading it first? 🤗 🦆
This blog post covers how that Hugging Face + DuckDB integration works and the use cases it fits:
@duckdb.org[ICYMI:] Why SQL Won 🏁
In this interview with Let's Data Science, #DuckDB co-creator @hannes.muehleisen.org argues that the data industry misdiagnosed SQL’s problems a decade ago.
What developers *actually* hated in 2013 was the install, the server and the client protocol, not the language itself:
@duckdb.orgDuckDB Now Ships inside dbt v2 🦆 📦 In this blog post, Geertjan Wielenga walks you through how to set up dbt v2, DuckLake and Iceberg catalogs, querying dbt’s Parquet metadata with DuckDB, plus other v2 features that matter to DuckDB users, including migrating to dbt v2. Dive in here:
@duckdb.orgAttending the Rows & Columns Summit in San Francisco today?
*THE* @hannes.muehleisen.org, co-creator of #DuckDB, will give a talk on “Nobody Knows What OLTP Is: DuckDB Moves to the Middle” at 1:30 p.m. (today, Sept 22nd)
We hope to see you there! 🦆 🦆
Sassy abstract and more info here:
@duckdb.orgGrep your lakehouse: Search-first retrieval for DuckDB-powered agents 🦆 😎
In this DuckCon talk, Sylvain Utard at Altertable presents on bringing full-text and semantic search to DuckLake to increase agent effectiveness.
Watch the vid below or lurk the slides here: blobs.duckdb.org/events/duckc...
@duckdb.orgWhen DuckDB-Wasm was launched in 2021, databases couldn't be persisted: everything lived in the Wasm heap and vanished when the tab closed. Now, DuckDB-Wasm can use the Origin Private File System (OPFS) in modern browsers as a storage backend. @carlo.piovesan.io & Geertjan Wielenga show you how:
@duckdb.orgAre you attending #dbtSummit in Las Vegas? 😎
Don’t miss @hannes.muehleisen.org deliver his talk “dbt Without the Warehouse (or the Bill): DuckDB End to End”
Hannes’s talk starts at 10:00 a.m. PT on Friday, Sept 18th – on Level 3, Gracia 4. Don’t miss it!
And say hi to Hannes if you stop by!
@duckdb.orgDuckDB Skills for Claude Code The `duckdb-skills` plugin gives Claude Code a growing number of skills that use the DuckDB CLI to read data files, run queries, convert formats, explore object storage, search the docs, and recall earlier sessions. Here's how it works (and how you can get started):
@duckdb.orgAbsolutely! and thanks for having them!
