Daniel ten Wolde
@dtenwolde.bsky.social
📤 391
📥 45
📝 24
PhD student at CWI, Database Architectures | Lead developer DuckPGQ extension | Working on graphs
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
4 months ago
1
5
0
🚀
#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.
6 months ago
0
2
0
reposted by
Daniel ten Wolde
DuckDB
7 months ago
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...
loading . . .
Daniël ten Wolde | DuckPGQ: A graph extension supporting SQL/PGQ
Disseminate: The Computer Science Research Podcast · Episode
https://open.spotify.com/episode/3e3ugp27paNzKthkN9wmUe?si=1fbaba4c1ee8401b&nd=1&dlsi=2e3b50cac4234ed6
1
13
4
🚀 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
8 months ago
0
17
4
🚀 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/...
loading . . .
DuckDB
https://www.youtube.com/@duckdb
8 months ago
2
21
3
reposted by
Daniel ten Wolde
archie.md
8 months ago
@duckdb-gsheets.com
is starting to get a lot of downloads credit for chart
@dtenwolde.bsky.social
duckdb-ce-analysis.evidence.app
1
23
2
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
add a skeleton here at some point
9 months ago
0
6
0
reposted by
Daniel ten Wolde
Peter Boncz
9 months ago
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!!
0
15
2
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!
loading . . .
DuckPGQ
DuckDB extension that adds support for SQL/PGQ and graph algorithms
https://duckpgq.org/
9 months ago
0
7
1
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
loading . . .
DuckPGQ: SQL/PGQ in DuckDB
YouTube video by LDBC Linked Data Benchmark Council
https://www.youtube.com/watch?v=Fzci3Ic0RBQ&t=307s
9 months ago
0
4
3
reposted by
Daniel ten Wolde
DuckDB
9 months ago
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/...
loading . . .
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...
https://duckdb.org/events/2025/01/31/duckcon6
1
25
9
🎉 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
🎶
loading . . .
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...
https://github.com/duckdb/community-extensions/pull/238
10 months ago
0
12
1
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
loading . . .
DuckDB extension weekly downloads
Explore dynamic insights into weekly and monthly download trends for DuckDB extensions, all in one interactive dashboard!
https://duckdb-ce-analysis.evidence.app/
10 months ago
1
24
4
🎶 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! 📊✨
10 months ago
1
27
4
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...
loading . . .
Nineteenth TUC Meeting
Linked Data Benchmark Council Website
https://ldbcouncil.org/event/nineteenth-tuc-meeting/
10 months ago
0
3
1
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!
10 months ago
1
24
5
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...
loading . . .
duckpgq
DuckDB Community Extensions Extension that adds support for SQL/PGQ and graph algorithms
https://duckdb.org/community_extensions/extensions/duckpgq.html
10 months ago
0
23
4
reposted by
Daniel ten Wolde
Peter Boncz
10 months ago
The closing of DBDBD 2024 was the "Amsterdam Data Systems" session, with talks from
@databricks.bsky.social
,
@motherduck.com
and
@clickhouse.com
(due to illness,
@weaviate.bsky.social
could not make it). These companies all have a significant presence in Amsterdam. Videos:
bit.ly/cwida-ams-da...
loading . . .
60fps of UX Joy with DuckDB+CloudBoaz by Boaz Leskes (DBDBD 2024)
The Dutch-Belgian DataBase Day (DBDBD) is a yearly one-day workshop, organized in a Belgian or Dutch university, whose general topic is database research. DBDBD 2024 will be held at Science Park in Amsterdam, The Netherlands. Website: https://cwida.github.io/dbdbd2024/ In the age of ever more powerful hardware, where your laptop can do more than your typical Datacenter server, MotherDuck leverages DuckDB’s state of the art analytical prowess to drive compute down to your laptop as well as making the most of the Cloud. Combine DuckDB’s versatility to run everywhere (including your browser), augment it with a server-less CDW, and you get (interactive) analytical sessions delivering results in unprecedented speed. So fast it updates your dashboard in 60fps. Biography: Boaz Leskes (MotherDuck Amsterdam) is part of MotherDuck’s founding team and leads its database group. In past life, he spent some years on distributed systems, (Elastic)search and cloud platforms. Will happily talk to any of these, or speed skating, kite surfing, rowing, or any other thing of interest.
https://bit.ly/cwida-ams-data-systems
0
12
4
reposted by
Daniel ten Wolde
Peter Boncz
10 months ago
Furthermore, we have now posted the videos of these lectures in the Dutch Seminar on Data Systems Design (DSDSD) YouTube channel:
bit.ly/cwida-dijkst...
many 🙏 to Daniel ten Wolde & Leonardo Kuffo Rivero for editing these!
loading . . .
Dijkstra Fellowship Acceptance Speech by Marcin Zukowski (Dijkstra Award 2024)
Website: https://www.cwi.nl/en/events/dijkstra-awards/cwi-lectures-dijkstra-fellowship/ About the Dijkstra Fellowship The Dijkstra Fellowship is named after former CWI researcher Edsger W. Dijkstra, who was one of the most influential scientists in the history of CWI. Dijkstra developed the shortest path algorithm, among other contributions. The first Dijkstra Fellowships were awarded to David Chaum and Guido van Rossum in 2019. Dijkstra Fellowship 2024 for Marcin Żukowski Marcin Żukowski started his career at CWI. He did his MSc and PhD research on database management system architectures in our Database Architectures (DA) group. As a PhD student under the supervision of Peter Boncz, he developed the innovative concept of vectorized execution to improve the performance of database queries. This research received the DaMoN 2007 Best Paper Award and also the CIDR 2024 Test of Time Award, established by the Conference on Innovative Data Systems Research (CIDR). After his PhD, Żukowski co-founded CWI spin-off VectorWise (now Actian), turning his research into a high performance and highly scalable analytical database system. It became the blueprint for analytical databases, that is still widely used. After yielding a rapid technological and commercial growth, he left the company in 2012 to co-found Snowflake in Silicon Valley. Snowflake offered the first cloud-based data warehousing service that is truly designed for the cloud. Notable features are that it is an ‘elastically’ growing and shrinking system based on how busy it is, separating computation from storage, and automating many administration and configuration tasks. Snowflake uses vectorized query execution and lightweight compression methods in its columnar data storage, two techniques that were co-designed by Żukowski during his PhD years at CWI. Role model After leaving Snowflake earlier this year, Marcin Żukowski stays connected with academia by supervising students, publishing papers and taking part in computer science events. He is also an investor and advisor, supporting technology development and innovation in his home country Poland. “Marcin is an excellent example of how to apply CWI's mission in practice. He used his PhD research at CWI to create versatile foundational software products that are now widely used, and shares his knowledge and experience with the public and in particular with young technology entrepreneurs”, CWI director Ton de Kok says. CWI Lectures combined with Dijkstra Fellowship award Topics of the CWI lectures are related to the architecture of data processing and analysis systems.
http://bit.ly/cwida-dijkstra-lectures-2024
0
9
3
reposted by
Daniel ten Wolde
Andy Pavlo
11 months ago
The Database Capital of Europe
2
80
10
Honored to see our paper on
#DuckPGQ
mentioned by
@andypavlo.bsky.social
during the CWI lectures! With the introduction of SQL/PGQ, we argue that relational systems (like
#DuckDB
) can seamlessly handle graph data. Check out the paper here:
www.cidrdb.org/cidr2023/pap...
11 months ago
0
22
6
🎨 As a little hobby project, I created visualizations for the
#DuckDB
community extensions using @evidence_dev! Check them out here:
duckdb-ce-analysis.evidence.app
🚀 Big thanks to
@archie.sarrewood.com
for the great feedback along the way! 🙌
loading . . .
DuckDB community extension weekly downloads
https://duckdb-ce-analysis.evidence.app/
11 months ago
3
15
6
#DuckPGQ
is now available again for
#DuckDB
v1.1.3! The major change is that property graphs are now persistent, making it easier to manage graph data across sessions 🎉 (Please don't overwrite the table with the name __duckpgq_internal, I use it for persistence 😬)
11 months ago
0
4
1
It turns out my ‘9,000 connections’ stat was… a little off (thanks to an API quirk that only returned the first 100 followers 🤦). No worries though—I fixed it, scraped more data (still more to come), and cooked up new SQL/PGQ example queries for you! Check them out:
github.com/Dtenwolde/bl...
loading . . .
GitHub - Dtenwolde/bluesky-follows-graph: Repo that scrapes the bluesky followers endpoint and runs graph queries with DuckDB and DuckPGQ
Repo that scrapes the bluesky followers endpoint and runs graph queries with DuckDB and DuckPGQ - Dtenwolde/bluesky-follows-graph
https://github.com/Dtenwolde/bluesky-follows-graph
11 months ago
0
3
2
Interesting discovery: there are roughly 9,000 accounts within 5 hops of those I currently follow! 🚀 (I assume I didn't mess up the data gathering) Powered by
@duckdb.org
with the seamless
#SQL
/
#PGQ
syntax supported in the
#DuckPGQ
extension. Amazing what you can uncover with the right tools!
11 months ago
3
25
6
you reached the end!!
feeds!
log in