Author | Lightnews

Reposted by Daniel ten Wolde

DuckDB @duckdb.org · 11d

🎞️ 𝘊𝘢𝘯 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.

3 7 35

Daniel ten Wolde @dtenwolde.bsky.social · 14d

GraphQL does not equal SQL/PGQ. Quality shitpost though, gave me a good laugh 😂

1

Reposted by Daniel ten Wolde

DuckDB @duckdb.org · 16d

📣 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.

7 26

Daniel ten Wolde @dtenwolde.bsky.social · 21d

Installation instructions can be found here: www.duckpgq.org

Daniel ten Wolde @dtenwolde.bsky.social · 21d

#DuckPGQ is out again as a community extension for @duckdb.org v1.4.1!

1

Daniel ten Wolde @dtenwolde.bsky.social · Jun 10

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

Daniel ten Wolde @dtenwolde.bsky.social · Jun 6

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

1 5

Daniel ten Wolde @dtenwolde.bsky.social · Apr 10

🚀 #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.

2

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

1 4 13

Daniel ten Wolde @dtenwolde.bsky.social · Feb 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

3 17

Daniel ten Wolde @dtenwolde.bsky.social · Jan 31

🚀 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

2 3 21

Reposted by Daniel ten Wolde

archie.md @archie.sarrewood.com · Jan 30

@duckdb-gsheets.com is starting to get a lot of downloads

credit for chart @dtenwolde.bsky.social

duckdb-ce-analysis.evidence.app

1 2 23

Daniel ten Wolde @dtenwolde.bsky.social · Jan 24

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 @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.

6

Reposted by Daniel ten Wolde

Peter Boncz @peterabcz.bsky.social · Jan 22

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!!

2 15

Daniel ten Wolde @dtenwolde.bsky.social · Jan 15

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

1 7

Daniel ten Wolde @dtenwolde.bsky.social · Jan 14

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

3 4

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

1 8 25

Daniel ten Wolde @dtenwolde.bsky.social · Dec 23

🎉 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

1 12

Daniel ten Wolde @dtenwolde.bsky.social · Dec 16

Yes, that sounds like a nice addition! It should be really easy as anyone can remotely attach to the DuckDB database I use to store the data: github.com/Dtenwolde/du...

duckdb-community-extension-analysis/sources/downloads/download_data.duckdb at evidence · Dtenwolde/duckdb-community-extension-analysis

Contribute to Dtenwolde/duckdb-community-extension-analysis development by creating an account on GitHub.

github.com

1 2

Daniel ten Wolde @dtenwolde.bsky.social · Dec 16

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

1 4 24

Daniel ten Wolde @dtenwolde.bsky.social · Dec 13

Fair point about the URL! I always forget I can directly query them. There’s some fun analysis you can do on this data :)

Daniel ten Wolde @dtenwolde.bsky.social · Dec 13

🎶 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! 📊✨

1 4 27

Daniel ten Wolde @dtenwolde.bsky.social · Dec 10

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

1 3

Daniel ten Wolde @dtenwolde.bsky.social · Dec 3

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!

1 5 24

Daniel ten Wolde @dtenwolde.bsky.social · Dec 3

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

4 23