Hannes Mühleisen
@hannes.muehleisen.org
I like databases and boats. Co-creator of @duckdb.org, Co-Founder and CEO DuckDB Labs.
Reposted by Hannes Mühleisen
Yeay!! I wrote a very opinionated list of tips for working with DuckDB in R! Hope others find it useful.
github.com/eriksquires/...
github.com/eriksquires/...
GitHub - eriksquires/DuckDB-With-R: Documentation Repo for tips on using DuckDB with R
Documentation Repo for tips on using DuckDB with R - eriksquires/DuckDB-With-R
github.com
January 5, 2026 at 5:56 PM
Yeay!! I wrote a very opinionated list of tips for working with DuckDB in R! Hope others find it useful.
github.com/eriksquires/...
github.com/eriksquires/...
Reposted by Hannes Mühleisen
Hey folks! I built a Canadian trade database to practice what I'm learning about DuckDB. The database includes all Canadian imports and exports from 1988 to present as per Statistics Canada. Here's a blog post I wrote with more details:
joshpersi.github.io/blog/posts/0...
#rstats #duckdb
joshpersi.github.io/blog/posts/0...
#rstats #duckdb
A Canadian trade database built with DuckDB – Josh Persi
joshpersi.github.io
December 28, 2025 at 9:03 PM
Hey folks! I built a Canadian trade database to practice what I'm learning about DuckDB. The database includes all Canadian imports and exports from 1988 to present as per Statistics Canada. Here's a blog post I wrote with more details:
joshpersi.github.io/blog/posts/0...
#rstats #duckdb
joshpersi.github.io/blog/posts/0...
#rstats #duckdb
Reposted by Hannes Mühleisen
You can now query Iceberg catalogs with DuckDB – from the convenience of your browser.
In our latest blog post, we break down how DuckDB's WebAssembly client makes this possible with zero setup and showcase it in action using Amazon S3 Tables.
👉 duckdb.org/2025/12/16/i...
In our latest blog post, we break down how DuckDB's WebAssembly client makes this possible with zero setup and showcase it in action using Amazon S3 Tables.
👉 duckdb.org/2025/12/16/i...
December 16, 2025 at 3:36 PM
You can now query Iceberg catalogs with DuckDB – from the convenience of your browser.
In our latest blog post, we break down how DuckDB's WebAssembly client makes this possible with zero setup and showcase it in action using Amazon S3 Tables.
👉 duckdb.org/2025/12/16/i...
In our latest blog post, we break down how DuckDB's WebAssembly client makes this possible with zero setup and showcase it in action using Amazon S3 Tables.
👉 duckdb.org/2025/12/16/i...
Reposted by Hannes Mühleisen
DuckDB Coverage
Apache Derby is retired, ModernSQL now covers DuckDB instead
modern-sql.com
December 16, 2025 at 3:41 PM
Reposted by Hannes Mühleisen
If you are into Iceberg or DuckDB, this is a major step: you can access existing Iceberg datasets, while they are appended on or updated by other users (possibly they can also be clicking buttons in a browser).
This has been very fun, was looking forward to be able to properly share, thanks flock!
This has been very fun, was looking forward to be able to properly share, thanks flock!
You can now query Iceberg catalogs with DuckDB – from the convenience of your browser.
In our latest blog post, we break down how DuckDB's WebAssembly client makes this possible with zero setup and showcase it in action using Amazon S3 Tables.
👉 duckdb.org/2025/12/16/i...
In our latest blog post, we break down how DuckDB's WebAssembly client makes this possible with zero setup and showcase it in action using Amazon S3 Tables.
👉 duckdb.org/2025/12/16/i...
December 16, 2025 at 4:02 PM
If you are into Iceberg or DuckDB, this is a major step: you can access existing Iceberg datasets, while they are appended on or updated by other users (possibly they can also be clicking buttons in a browser).
This has been very fun, was looking forward to be able to properly share, thanks flock!
This has been very fun, was looking forward to be able to properly share, thanks flock!
Reposted by Hannes Mühleisen
In seven weeks, we will host the first DuckDB Developer Meeting in Amsterdam.
We have four exciting talks lined up on building extensions in DuckDB, encryption in DuckDB, DuckPL and GizmoEdge.
For more details and the registration links, please head to duckdb.org/events/2026/...
We have four exciting talks lined up on building extensions in DuckDB, encryption in DuckDB, DuckPL and GizmoEdge.
For more details and the registration links, please head to duckdb.org/events/2026/...
December 12, 2025 at 1:55 PM
In seven weeks, we will host the first DuckDB Developer Meeting in Amsterdam.
We have four exciting talks lined up on building extensions in DuckDB, encryption in DuckDB, DuckPL and GizmoEdge.
For more details and the registration links, please head to duckdb.org/events/2026/...
We have four exciting talks lined up on building extensions in DuckDB, encryption in DuckDB, DuckPL and GizmoEdge.
For more details and the registration links, please head to duckdb.org/events/2026/...
Reposted by Hannes Mühleisen
We are happy to announce DuckDB v1.4.3 LTS, our latest patch release. Along with bugfixes, this release ships native extensions and Python support for Windows ARM64. Head to duckdb.org/2025/12/09/a... for the announcement blog post and installation instructions.
December 9, 2025 at 12:52 PM
We are happy to announce DuckDB v1.4.3 LTS, our latest patch release. Along with bugfixes, this release ships native extensions and Python support for Windows ARM64. Head to duckdb.org/2025/12/09/a... for the announcement blog post and installation instructions.
Reposted by Hannes Mühleisen
This is the most exciting time ever to be working in data, and I'm not talking about AI.
3 years ago, I wrote a database-centric guide in my book for analyzing the full 92 million record 1910 Census.
Now, with #rstats and @duckdb?
Analyze those 92 million rows in seconds.
3 years ago, I wrote a database-centric guide in my book for analyzing the full 92 million record 1910 Census.
Now, with #rstats and @duckdb?
Analyze those 92 million rows in seconds.
December 6, 2025 at 4:46 PM
This is the most exciting time ever to be working in data, and I'm not talking about AI.
3 years ago, I wrote a database-centric guide in my book for analyzing the full 92 million record 1910 Census.
Now, with #rstats and @duckdb?
Analyze those 92 million rows in seconds.
3 years ago, I wrote a database-centric guide in my book for analyzing the full 92 million record 1910 Census.
Now, with #rstats and @duckdb?
Analyze those 92 million rows in seconds.
Reposted by Hannes Mühleisen
modern-sql.com now covers DuckDB.
Modern SQL: A lot has changed since SQL-92
SQL has evolved. Beyond the relational model. Discover it now.
modern-sql.com
November 28, 2025 at 1:24 PM
modern-sql.com now covers DuckDB.
Reposted by Hannes Mühleisen
In DuckDB v1.4.2, we shipped a number of features and improvements to the DuckDB-Iceberg extension: insert, update, and delete statements are all supported now.
Read Tom Ebergen's new article on these features at duckdb.org/2025/11/28/i...
Read Tom Ebergen's new article on these features at duckdb.org/2025/11/28/i...
November 28, 2025 at 1:29 PM
In DuckDB v1.4.2, we shipped a number of features and improvements to the DuckDB-Iceberg extension: insert, update, and delete statements are all supported now.
Read Tom Ebergen's new article on these features at duckdb.org/2025/11/28/i...
Read Tom Ebergen's new article on these features at duckdb.org/2025/11/28/i...
Reposted by Hannes Mühleisen
DuckDB v1.4 introduced the much-requested feature of database encryption. In our new blog post, @ccfelius.bsky.social and @hannes.muehleisen.org explain how the encryption works under the hood: duckdb.org/2025/11/19/e...
November 20, 2025 at 6:24 PM
DuckDB v1.4 introduced the much-requested feature of database encryption. In our new blog post, @ccfelius.bsky.social and @hannes.muehleisen.org explain how the encryption works under the hood: duckdb.org/2025/11/19/e...
Reposted by Hannes Mühleisen
I’m thrilled to share that my new book (Spatial Data Management with DuckDB) is now published! 🎉
At 430 pages, this book provides a practical, hands-on guide to scalable geospatial analytics and visualization using DuckDB. All code examples are open-source and freely available on GitHub.
At 430 pages, this book provides a practical, hands-on guide to scalable geospatial analytics and visualization using DuckDB. All code examples are open-source and freely available on GitHub.
November 15, 2025 at 6:44 PM
I’m thrilled to share that my new book (Spatial Data Management with DuckDB) is now published! 🎉
At 430 pages, this book provides a practical, hands-on guide to scalable geospatial analytics and visualization using DuckDB. All code examples are open-source and freely available on GitHub.
At 430 pages, this book provides a practical, hands-on guide to scalable geospatial analytics and visualization using DuckDB. All code examples are open-source and freely available on GitHub.
Reposted by Hannes Mühleisen
🚀 We released DuckDB v1.4.2, the second patch release of our LTS edition.
🔎 We are shipping new Iceberg features, improved logger/profiler integration and several bugfixes. The new DuckDB version can also read and write Vortex files.
📖 For more details, read
duckdb.org/2025/11/12/a...
🔎 We are shipping new Iceberg features, improved logger/profiler integration and several bugfixes. The new DuckDB version can also read and write Vortex files.
📖 For more details, read
duckdb.org/2025/11/12/a...
November 12, 2025 at 1:22 PM
🚀 We released DuckDB v1.4.2, the second patch release of our LTS edition.
🔎 We are shipping new Iceberg features, improved logger/profiler integration and several bugfixes. The new DuckDB version can also read and write Vortex files.
📖 For more details, read
duckdb.org/2025/11/12/a...
🔎 We are shipping new Iceberg features, improved logger/profiler integration and several bugfixes. The new DuckDB version can also read and write Vortex files.
📖 For more details, read
duckdb.org/2025/11/12/a...
Reposted by Hannes Mühleisen
This profile in ‘Significance’ on DuckDB co-founder Hannes Mühleisen is quite interesting, and has helpful insights about data quality and the changing meaning of “big data.” Also some good professional advice in here for statisticians.
academic.oup.com/jrssig/artic...
academic.oup.com/jrssig/artic...
Is big data dead?
Abstract. Data, ducks and statistics – Sandra Alba gathers dispatches from Amsterdam and Auckland
academic.oup.com
November 9, 2025 at 5:47 PM
This profile in ‘Significance’ on DuckDB co-founder Hannes Mühleisen is quite interesting, and has helpful insights about data quality and the changing meaning of “big data.” Also some good professional advice in here for statisticians.
academic.oup.com/jrssig/artic...
academic.oup.com/jrssig/artic...
Reposted by Hannes Mühleisen
We took Canada’s Spatial Access Measures dataset (big, clunky CSVs) → turned it into a single GeoParquet file.
Add DuckDB-WASM + deck.gl & you get
- instant queries
- smooth maps
- no backend
Public data, but actually usable.
developmentseed.org/blog/2025-10...
@saadiqmohiuddin.bsky.social
Add DuckDB-WASM + deck.gl & you get
- instant queries
- smooth maps
- no backend
Public data, but actually usable.
developmentseed.org/blog/2025-10...
@saadiqmohiuddin.bsky.social
November 6, 2025 at 6:38 PM
We took Canada’s Spatial Access Measures dataset (big, clunky CSVs) → turned it into a single GeoParquet file.
Add DuckDB-WASM + deck.gl & you get
- instant queries
- smooth maps
- no backend
Public data, but actually usable.
developmentseed.org/blog/2025-10...
@saadiqmohiuddin.bsky.social
Add DuckDB-WASM + deck.gl & you get
- instant queries
- smooth maps
- no backend
Public data, but actually usable.
developmentseed.org/blog/2025-10...
@saadiqmohiuddin.bsky.social
Reposted by Hannes Mühleisen
pg_lake just went open source! (Apache 2.0)
pg_lake is a set of extensions (from Crunchy Data Warehouse) that add comprehensive Iceberg support and data lake access to Postgres, with @duckdb.org transparently integrated into the query engine.
Announcement blog: www.snowflake.com/en/engineeri...
pg_lake is a set of extensions (from Crunchy Data Warehouse) that add comprehensive Iceberg support and data lake access to Postgres, with @duckdb.org transparently integrated into the query engine.
Announcement blog: www.snowflake.com/en/engineeri...
November 4, 2025 at 4:04 PM
pg_lake just went open source! (Apache 2.0)
pg_lake is a set of extensions (from Crunchy Data Warehouse) that add comprehensive Iceberg support and data lake access to Postgres, with @duckdb.org transparently integrated into the query engine.
Announcement blog: www.snowflake.com/en/engineeri...
pg_lake is a set of extensions (from Crunchy Data Warehouse) that add comprehensive Iceberg support and data lake access to Postgres, with @duckdb.org transparently integrated into the query engine.
Announcement blog: www.snowflake.com/en/engineeri...
Reposted by Hannes Mühleisen
The PyData Amsterdam 2025 keynote “Minus Three Tier: Data Architecture Turned Upside Down” by @hannes.muehleisen.org is out now.
www.youtube.com/watch?v=DxwD...
www.youtube.com/watch?v=DxwD...
KEYNOTE: Hannes Mühleisen - Data Architecture Turned Upside Down | PyData Amsterdam 2025
YouTube video by PyData
www.youtube.com
October 31, 2025 at 2:05 PM
The PyData Amsterdam 2025 keynote “Minus Three Tier: Data Architecture Turned Upside Down” by @hannes.muehleisen.org is out now.
www.youtube.com/watch?v=DxwD...
www.youtube.com/watch?v=DxwD...
Reposted by Hannes Mühleisen
🎞️ 𝘊𝘢𝘯 you store a movie in DuckDB?
In today's blog post, @hannes.muehleisen.org shows how to store a movie as a table encoding the RGB codes pixel-by-pixel, and how to process it: duckdb.org/2025/10/27/m...
Now, whether you 𝘴𝘩𝘰𝘶𝘭𝘥 store a movie in DuckDB... we'll leave that to your judgment.
In today's blog post, @hannes.muehleisen.org shows how to store a movie as a table encoding the RGB codes pixel-by-pixel, and how to process it: duckdb.org/2025/10/27/m...
Now, whether you 𝘴𝘩𝘰𝘶𝘭𝘥 store a movie in DuckDB... we'll leave that to your judgment.
October 27, 2025 at 3:43 PM
🎞️ 𝘊𝘢𝘯 you store a movie in DuckDB?
In today's blog post, @hannes.muehleisen.org shows how to store a movie as a table encoding the RGB codes pixel-by-pixel, and how to process it: duckdb.org/2025/10/27/m...
Now, whether you 𝘴𝘩𝘰𝘶𝘭𝘥 store a movie in DuckDB... we'll leave that to your judgment.
In today's blog post, @hannes.muehleisen.org shows how to store a movie as a table encoding the RGB codes pixel-by-pixel, and how to process it: duckdb.org/2025/10/27/m...
Now, whether you 𝘴𝘩𝘰𝘶𝘭𝘥 store a movie in DuckDB... we'll leave that to your judgment.
Reposted by Hannes Mühleisen
📣 New blog post by @dtenwolde.bsky.social.
🕸️ In this post, we show how to use DuckDB and the DuckPGQ community extension to analyze financial data for fraudulent patterns with the SQL/PGQ graph syntax that's part of SQL:2023.
📖 Visit duckdb.org/2025/10/22/d... to read the post.
🕸️ In this post, we show how to use DuckDB and the DuckPGQ community extension to analyze financial data for fraudulent patterns with the SQL/PGQ graph syntax that's part of SQL:2023.
📖 Visit duckdb.org/2025/10/22/d... to read the post.
October 22, 2025 at 7:23 PM
📣 New blog post by @dtenwolde.bsky.social.
🕸️ In this post, we show how to use DuckDB and the DuckPGQ community extension to analyze financial data for fraudulent patterns with the SQL/PGQ graph syntax that's part of SQL:2023.
📖 Visit duckdb.org/2025/10/22/d... to read the post.
🕸️ In this post, we show how to use DuckDB and the DuckPGQ community extension to analyze financial data for fraudulent patterns with the SQL/PGQ graph syntax that's part of SQL:2023.
📖 Visit duckdb.org/2025/10/22/d... to read the post.
Reposted by Hannes Mühleisen
duckdb-mlpack 0.0.2: mlpack is now a duckdb community extension
Bringing mlpack machine learning to duckdb SQL
dirk.eddelbuettel.com/blog/2025/10...
Bringing mlpack machine learning to duckdb SQL
dirk.eddelbuettel.com/blog/2025/10...
October 26, 2025 at 1:58 PM
duckdb-mlpack 0.0.2: mlpack is now a duckdb community extension
Bringing mlpack machine learning to duckdb SQL
dirk.eddelbuettel.com/blog/2025/10...
Bringing mlpack machine learning to duckdb SQL
dirk.eddelbuettel.com/blog/2025/10...
Reposted by Hannes Mühleisen
🇫🇮 We are hosting a pub session next week during the @helsinkidataweek.bsky.social, where you can chat with DuckDB's co-creator, @hannes.muehleisen.org and have a drink with members of the DuckDB community.
🎟️ Sign up on Luma: luma.com/s5sl9qxx
🎟️ Sign up on Luma: luma.com/s5sl9qxx
October 20, 2025 at 2:29 PM
🇫🇮 We are hosting a pub session next week during the @helsinkidataweek.bsky.social, where you can chat with DuckDB's co-creator, @hannes.muehleisen.org and have a drink with members of the DuckDB community.
🎟️ Sign up on Luma: luma.com/s5sl9qxx
🎟️ Sign up on Luma: luma.com/s5sl9qxx
Reposted by Hannes Mühleisen
ML quacks: Combining duckdb and mlpack
dirk.eddelbuettel.com/blog/2025/10...
A 'minimally viable product / demo' of extending @duckdb.org with #mlpack
dirk.eddelbuettel.com/blog/2025/10...
A 'minimally viable product / demo' of extending @duckdb.org with #mlpack
October 17, 2025 at 6:13 PM
ML quacks: Combining duckdb and mlpack
dirk.eddelbuettel.com/blog/2025/10...
A 'minimally viable product / demo' of extending @duckdb.org with #mlpack
dirk.eddelbuettel.com/blog/2025/10...
A 'minimally viable product / demo' of extending @duckdb.org with #mlpack
Reposted by Hannes Mühleisen
I'm grateful that Jack Waudby gave me the chance to set the CTE record straight on his @disseminatepodcast.bsky.social. Hear us talk about what you can do with iterative queries in SQL, how efficient variants of recursion in SQL found their way into @duckdb.org, and how trampolines come into play.
October 17, 2025 at 9:16 AM
I'm grateful that Jack Waudby gave me the chance to set the CTE record straight on his @disseminatepodcast.bsky.social. Hear us talk about what you can do with iterative queries in SQL, how efficient variants of recursion in SQL found their way into @duckdb.org, and how trampolines come into play.
Reposted by Hannes Mühleisen
Learn how to build powerful yet lightweight #data workflows using #Python, #DuckDB, and #Smallpond with Valery C. Briz, #Pythonista, senior #dataengineer on the 23rd of October in our #online #workshop 18:00-19:30 CEST
Register here: www.meetup.com/pyladiesams/...
Register here: www.meetup.com/pyladiesams/...
October 7, 2025 at 6:43 PM
Learn how to build powerful yet lightweight #data workflows using #Python, #DuckDB, and #Smallpond with Valery C. Briz, #Pythonista, senior #dataengineer on the 23rd of October in our #online #workshop 18:00-19:30 CEST
Register here: www.meetup.com/pyladiesams/...
Register here: www.meetup.com/pyladiesams/...