←
DuckDB1,245 posts
DuckDB avatar

DuckDB

@duckdb

DuckDB is an analytical SQL database management system. "DuckDB" and the DuckDB logo are registered trademarks of the DuckDB Foundation.

◷ Joined May 2019▧ 420 Photos and videos
DuckDB avatar
DuckDB@duckdb·Oct 21

🦆 Announcing DuckDB 2.0.0 LTS “Cinnamon Teal” We are proud to release DuckDB 2.0.0, named after the cinnamon teal (Spatula cyanoptera), a striking reddish-brown duck found in the western Americas. 🌎 DuckDB 2.0.0 is the biggest DuckDB feature release so far. It ships a polished version of the Quack protocol, which turns DuckDB into a full-fledged server. It improves performance and lowers costs through supporting asynchronous I/O, a first-class VARIANT type, and a dedicated “agent mode”. It also empowers extension developers with a new SQL parser that allows adding new statements, clauses, and keywords, a new API to build on, and a new mechanism to distribute extensions more easily. In our announcement blog post, we summarize the highlights and then walk through the key changes and give guidance on how to migrate to 2.0. For the complete release notes, see the release page on GitHub⁠. duckdb.org/2026/10/21/announ… #DuckDB

Post attachment
DuckDB avatar
DuckDB@duckdb·12h

Last week, the DuckDB User Group held its first workshop in Amsterdam with Pratik Patel from @huggingface leading the session. In one afternoon, attendees built a pipeline that finds the products with falling ratings in 2.1 million Amazon reviews and explains why. #DuckDB did the filtering and an LLM summarized the complaints. At the end, each attendee had a Hugging Face Space they could call as an API. Here’s what else you missed: duckdb.org/2026/11/17/duckdb…

Post attachment
DuckDB avatar
DuckDB@duckdb·Nov 16

Last chance to register for DuckDB × MySQL Day! ‼️ Tomorrow (November 17th), @DuckDB is joining MySQL, MariaDB, and the @OurSQLFdn for a free online conference focused on what happens when DuckDB sits next to your transactional data. Talks from builders and developers across the space will cover topics like: • Columnar engines • Analytical replication • Parquet • The road to HTAP and more If you’ve ever wanted DuckDB working directly against production MySQL data, this conference is for you. 📅 17 November 2026 🕙 10:00 a.m. - 2 p.m. U.S. ET | 16:00 - 20:00 CET 🧑‍💻 100% Virtual / Online Register today and we hope to see you soon: oursqlfoundation.org/events/… #DuckDB #MySQL #MariaDB

Post attachmentPost attachmentPost attachmentPost attachment
Roland Bouman avatar
⟳ DuckDB retweeted
Roland Bouman@rolandbouman·Nov 13

Huey 1.2.000 - Laplaigne is now released - github.com/rpbouman/huey This fixes a few bugs, and upgrades DuckDB-WASM to 1.33.1-dev114.0 bringing you @DuckDB 2.0. Expect considerable speedup when analyzing parquet files in the cloud. live demo: rpbouman.github.io/huey/src/…

DuckDB avatar
DuckDB@duckdb·Nov 13

Look who’s lined up (so far) to speak at DuckDB × MySQL Day on 17 November! 👀 • @VadimTk | OurSQL Foundation • @PeterZaitsev | @Percona • Zongzhi Chen | Alibaba Cloud • @deesix | VillageSQL • Roman Nozdrin | @mariadb • @clickslash | @dbtrail_ • Yevhen Patlan | Percona • @rene_cannao | @proxysql Watch this space as more speakers will be announced! 🦆 🐬 🦭 DuckDB × MySQL Day is a 1-day online conference organized by the @OurSQLFdn with the goal of bringing fast analytics to MySQL and MariaDB and presented by the people building the future of DuckDB working directly against production MySQL data. Come be inspired about how these technologies can work together in new ways. 📅 17 November 2026 🕙 10:00 a.m. - 2 p.m. U.S. ET | 16:00 - 20:00 CET 🧑‍💻 100% Virtual / Online Register today and stay up to date with new speaker announcements: oursqlfoundation.org/events/… #DuckDB #MySQL #MariaDB

Post attachmentPost attachmentPost attachmentPost attachment
DuckDB avatar
DuckDB@duckdb·Nov 12

“You should own your data. It can live on your computer, not everything has to live in the cloud. It can be synced via the cloud, but you decide when to keep it local and when not.” –@ilyabo , creator of SQLRooms From interactive maps to graph exploration, DuckDB makes it possible to analyze data without a database server. In this #DuckDB user story, Ilya Boyandin shares how this approach led to SQLRooms, a toolkit for building analytics applications that bring data, visualizations, and AI-assisted analysis together on the user’s machine. Read the rest of Ilya’s DuckDB story: duckdb.org/2026/11/12/local-…

Post attachment
DuckDB avatar
DuckDB@duckdb·Nov 11

Quack, quack! Join us for DuckDB × MySQL Day 🦆🐬🦭 This 1-day online conference organized by the @OurSQLFdn brings fast analytics to MySQL and MariaDB: columnar engines, analytical replication, Parquet, and the road to HTAP – all presented by the people building it. If you’ve ever wanted DuckDB working directly against production MySQL data, this free event is for you. 📅 17 November 2026 🕙 10:00 a.m. - 2 p.m. U.S. ET | 16:00 - 20:00 CET 🧑‍💻 100% Virtual / Online Explore the full list of speakers announced so far: oursqlfoundation.org/events/… #DuckDB #MySQL #MariaDB

Post attachment
DuckDB avatar
DuckDB@duckdb·Nov 10

It’s Time to Get Your Ducks in a Column 🦆 🦆 🦆 🦆 Why columns? DuckDB is fast – among other reasons – because of its columnar storage architecture. DuckDB stores each column separately instead of storing each row as one record. A query that touches three columns out of 50 reads only those three. Columnar storage compresses well because a column holds values of one type, and those values often repeat. And a query that asks for fewer columns does less work. This back-to-the-basics blog post covers DuckDB features that take advantage of that design choice: querying files in place, column-level SQL, aggregation shortcuts, window functions, ASOF joins, and writing well-organized Parquet. Also, the example is a dataset of 400 ducks, so 🦆 🦆 🦆 🦆 duckdb.org/2026/11/10/ducks-…

Post attachment
JetBrains DataGrip avatar
⟳ DuckDB retweeted
JetBrains DataGrip@datagrip·Nov 9

We shipped a new cross-database query functionality in our latest release. Here’s the story behind it, including why we embedded @duckdb, how it plugs into DataGrip’s query execution, and where it’s headed next.

How @jetbrains Built Cross-Database Queries into DataGrip with DuckDB 🧠 🦆 JetBrains users had long asked to join data across different database connections in a single query. Rather than build its own cross-database query engine, JetBrains embedded #DuckDB in DataGrip, using DuckDB’s custom table functions to connect it to the IDE’s existing query execution. This is why DuckDB won out over the alternatives, and where the integration goes next: duckdb.org/2026/11/05/jetbra…

Post attachment
DuckDB avatar
DuckDB@duckdb·Nov 7

🧭 Are you feeling particularly adventurous? While DuckDB v2.1 "Islandica" is still a long way off, we've already started shipping preview builds for it, and you can try it out today. Some highlights: better error messages, improved memory allocation and MATCH_RECOGNIZE support. Just don't deploy it to production yet! 🚧 duckdb.org/install/preview

Post attachment
DuckDB avatar
DuckDB@duckdb·Nov 6

How @jetbrains Built Cross-Database Queries into DataGrip with DuckDB 🧠 🦆 JetBrains users had long asked to join data across different database connections in a single query. Rather than build its own cross-database query engine, JetBrains embedded #DuckDB in DataGrip, using DuckDB’s custom table functions to connect it to the IDE’s existing query execution. This is why DuckDB won out over the alternatives, and where the integration goes next: duckdb.org/2026/11/05/jetbra…

Post attachment
DuckDB avatar
DuckDB@duckdb·Nov 3

Bringing Local Analytics to the Quant’s Desktop 🧮 After years building data platforms for banks and hedge funds, Ryan Hamilton wanted an analytical engine he could recommend to smaller teams without specialized infrastructure or expensive licensing. #DuckDB gave him a small, embedded way to bring fast local analytics into QStudio and Pulse, and it is now shaping his next open-source project, PeachQ. Read the latest DuckDB user story: duckdb.org/2026/11/03/bringi…

Post attachment
The New Stack avatar
⟳ DuckDB retweeted
The New Stack@thenewstack·Nov 2

Our next guest at the @ducklabs_com Amsterdam HQ is Gabor Szarnyas. As a developer advocate, @szarnyasg is passionate about telling people how @duckdb is a fast, free, easy to use, open source, in-process analytical database. And since last month's 2.0 release, its also a full-fledged client-server database. Thanks to @AWSOpen for facilitating the conversation.

Post attachment
DuckDB avatar
DuckDB@duckdb·Oct 30

[Podcast:] Databases for Humans & Agents with Hannes Mühleisen 🎧 In this episode of the Data Renegades podcast, DuckDB co-creator Hannes Mühleisen speaks with @clkao about building databases that people actually want to use. Hannes explains how conversations with frustrated statisticians shaped #DuckDB’s architecture and why useful software sometimes requires abandoning your own assumptions. They explore DuckLake, the Quack client-server protocol, and how a focus on human usability is paying off as AI agents begin choosing their own tools. Listen to the episode here or wherever you get your podcasts: heavybit.com/library/podcast… #agents #DuckLake

Post attachment