Daniel ten Wolde
dtenwolde.bsky.social
Daniel ten Wolde
@dtenwolde.bsky.social
400 followers 45 following 27 posts
PhD student at CWI, Database Architectures | Lead developer DuckPGQ extension | Working on graphs
Posts Media Videos Starter Packs
Pinned
#DuckPGQ is out again as a community extension for @duckdb.org v1.4.1!
Reposted by Daniel ten Wolde
🎞️ 𝘊𝘢𝘯 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.
GraphQL does not equal SQL/PGQ. Quality shitpost though, gave me a good laugh 😂
Reposted by Daniel ten Wolde
📣 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.
Installation instructions can be found here: www.duckpgq.org
#DuckPGQ is out again as a community extension for @duckdb.org v1.4.1!
I figured it could've been you :) I'm working on the new parser, and this was one of the queries it was failing on. But why exactly it was failing I haven't quite figured out yet! I admire your SQL skills
Whoever summoned this SQL abomination, I can’t tell if I should be impressed or horrified. Now I have to debug it…

ChatGPT: it's a recursive SQL simulation of the Fibonacci function, but instead of using simple recursion, it models the function as a concurrent task graph.

See: tinyurl.com/yjamy5pm
🚀 #DuckPGQ is available again for #DuckDB v1.2.2!

No major changes this time — 99% of my focus has been on the PhD (which will make its way into the extension eventually) 😄

One new simple pragma: create_vertex_table — does exactly what it says: creates a vertex table based on an edge table.
Reposted by Daniel ten Wolde
DuckDB @duckdb.org · Mar 24
Disseminate: The Computer Science Research Podcast released the second episode of its new series, “DuckDB in Research”.

In this episode, Daniël ten Wolde talks about his research on integrating SQL/PGQ into DuckDB, and the resulting DuckPGQ community extension.

open.spotify.com/episode/3e3u...
Daniël ten Wolde | DuckPGQ: A graph extension supporting SQL/PGQ
Disseminate: The Computer Science Research Podcast · Episode
open.spotify.com
🚀 The recording of my lightning talk at #Duckcon on #DuckPGQ is now live on YouTube! 🎥
Check it out here: www.youtube.com/watch?v=QDdT...

Basically, everything you need to get started is in this picture 😉👇

@duckdb.org #DuckDB #GraphDatabases #OpenSource
🚀 Today at #DuckCon, I’ll give a lightning talk on graph analytics in @duckdb.org using SQL/PGQ & the DuckPGQ extension! In just 5 mins, get up to speed on the new syntax & running graph queries inside DuckDB.

🎥 Live stream (3 PM CET): www.youtube.com/@duckdb
📅 Program: duckdb.org/events/2025/...
DuckDB
www.youtube.com
Reposted by Daniel ten Wolde
One more week until DuckCon #6! I’m excited to give a lightning talk on using DuckDB and the DuckPGQ community extension for graph analytics
duckdb.org DuckDB @duckdb.org · Jan 24
DuckCon #6 will start in 168 hours (January 31, 15:00)! If you plan to attend in-person, please register at duckdb.org/2025/01/31/d...

The stream will be available without registration.
Reposted by Daniel ten Wolde
CIDR2025 is a wrap!

Lived the many interesting papers & discussions, Gong Show, @duckdb reception..

ACM president Yannis Ioannidis gave an inspiring talk on open science.

Proceedings are in ACM DL & VLDB (see cidrdb.org).

🙏 all in+outside @cwi-amsterdam.bsky.social who helped organize!!
We’ve launched a new website for #DuckPGQ documentation! 🎉 Check out duckpgq.org to explore graph processing with #SQL/#PGQ and more. 🚀

The site is new and will continue to expand over time. The Notion page is now retired—everything you need is here. Feedback is welcome as always!
DuckPGQ
DuckDB extension that adds support for SQL/PGQ and graph algorithms
duckpgq.org
My @ldbcouncil.org TUC talk is online! 🎥 Learn about #DuckPGQ and #SQL/#PGQ here:
👉 www.youtube.com/watch?v=Fzci...

Catch me at @fosdem.bsky.social on Feb 1 in the Data Analytics room, where I’ll continue spreading the word about #DuckPGQ and #SQL/#PGQ. Hope to see you there! 🚀 #FOSDEM2025
DuckPGQ: SQL/PGQ in DuckDB
YouTube video by LDBC Linked Data Benchmark Council
www.youtube.com
Reposted by Daniel ten Wolde
DuckDB @duckdb.org · Jan 14
Only 2.5 weeks until DuckCon #6 in Amsterdam.

We have a strong line-up: the presenters will explain how to use DuckDB for tabular, spatial and graph-shaped data, how to solve financial and healthcare use cases, and how to orchestrate and visualize queries.

Full program: duckdb.org/events/2025/...
DuckCon #6 in Amsterdam
DuckDB is an in-process SQL database management system focused on analytical query processing. It is designed to be easy to install and easy to use. DuckDB has no external dependencies. DuckDB has bin...
duckdb.org
🎉 DuckPGQ v0.2.1 is here! 🐥

Highlights:
- Bug fixes 🛠️
- PRAGMA show_property_graphs ✨
- CREATE PROPERTY GRAPH IF NOT EXISTS 🎯
- From v0.2.0: Create property graphs on attached databases (such as #SQLite)

Learn more: duckdb.org/community_ex...

Happy holidays! 🎄❄️ I'm off to enjoy the #top2000 🎶
Update DuckPGQ to v0.2.1 by Dtenwolde · Pull Request #238 · duckdb/community-extensions
Changelog Overview Summary of the changes for DuckPGQ v0.2.1 Features Added a grammar rule for creating property graphs with IF NOT EXISTS [4433108]. Added a pragma show_property_graphs to display...
github.com
I just updated the #DuckDB extension visualization site to also include regular DuckDB extensions like Spatial and HTTPFS. Did you know there were nearly 6M extension downloads last week alone? 🚀

Check it out: duckdb-ce-analysis.evidence.app
Feedback is always welcome!
Made using @evidence.dev
DuckDB extension weekly downloads
Explore dynamic insights into weekly and monthly download trends for DuckDB extensions, all in one interactive dashboard!
duckdb-ce-analysis.evidence.app
Fair point about the URL! I always forget I can directly query them. There’s some fun analysis you can do on this data :)
🎶 One of my favourite Dutch traditions is the #Top2000! Between Christmas and New Year, the 2000 most-voted songs are played non-stop. 🌟 They even share an Excel sheet with all the songs and their release years. With just three lines of #DuckDB, you can create a histogram of music history! 📊✨
This Friday, Dec 13th, I’ll present DuckPGQ and our implementation of SQL/PGQ at the 19th @ldbc.bsky.social TUC meeting in London. If you’re in town, feel free to join—entry is free! A Zoom link is also available. More details: ldbcouncil.org/event/ninete...
Nineteenth TUC Meeting
Linked Data Benchmark Council Website
ldbcouncil.org
Excited to speak at #DuckCon #6 in Amsterdam on Jan 31, 2025!🎉

I’ll share how #DuckDB unlocks graph analytics with SQL/PGQ from the SQL:2023 standard using the #DuckPGQ extension.

📍 Free to attend & livestreamed on YouTube!
📅 Details + register: duckdb.org/events/2025/...

🚀 Hope to see you there!
Exciting milestone: The DuckPGQ extension for #DuckDB has surpassed 10,000 downloads!🎉

A huge thanks to the community for supporting DuckPGQ for graph analytics. Stay tuned—the next update will bring property graph creation over attached databases!

Explore DuckPGQ here: duckdb.org/community_ex...
duckpgq
DuckDB Community Extensions Extension that adds support for SQL/PGQ and graph algorithms
duckdb.org