Author | Lightnews

Reposted by Carlo Piovesan

Tobias Müller @tobilg.com · 12d

I just launched github.com/tobilg/sql-w...

It's a tiny (<10kb gzipped) wrapper around @duckdb.org WASM that can run queries interactively, and be embedded in plain HTML websites, as well as all other mayor frontend frameworks...

It's an early version, feedback warmly appreciated!

GitHub - tobilg/sql-workbench-embedded: Lightweight JavaScript library that transforms static SQL code blocks into interactive, browser-based SQL execution environments using DuckDB WASM

Lightweight JavaScript library that transforms static SQL code blocks into interactive, browser-based SQL execution environments using DuckDB WASM - tobilg/sql-workbench-embedded

github.com

3 7 22

Reposted by Carlo Piovesan

DuckDB @duckdb.org · 15d

📣 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

Reposted by Carlo Piovesan

DuckDB @duckdb.org · 13d

In a new guest blog post, Mark Harrison (Madhive) presents Frozen DuckLakes. These are read-only DuckLakes that only require object storage and are frozen in time. He shows a process for creating and freezing DuckLakes, and demonstrates their use and performance.

📖 ducklake.select/2025/10/24/f...

An iPhone 17 Pro in a MAGEASY case, held afloat by DuckLake floating keychains, querying a remote DuckLake in the online Wasm shell. Do not try this at home.

5 20

Reposted by Carlo Piovesan

Tobias Müller @tobilg.com · Oct 6

Created a DNS extension for @duckdb.org today:

github.com/tobilg/duckd...

Hopefully it will be available via the Community Extensions soon!

GitHub - tobilg/duckdb-dns: DNS (Reverse) Lookup Extension for DuckDB

DNS (Reverse) Lookup Extension for DuckDB. Contribute to tobilg/duckdb-dns development by creating an account on GitHub.

github.com

1 4 16

Carlo Piovesan @carlo.piovesan.io · Oct 7

Should be live, in duckdb v1.4.0:
```
INSTALL dns FROM community;
LOAD dns;
CREATE TABLE websites AS WITH websites(endpoint) AS (VALUES ('google.com'), ('duckdb.org'), ('community-extensions.duckdb.org')) FROM websites;
SELECT dns_lookup(endpoint) FROM websites;
```
duckdb.org/community_ex...

dns

DuckDB Community Extensions The DNS Extension enables DNS lookups and reverse DNS lookups from within DuckDB

duckdb.org

1 5

Reposted by Carlo Piovesan

Roland Bouman @rolandbouman.bsky.social · Sep 19

Huey 1.0.10 is now released:
github.com/rpbouman/hue...
demo:
rpbouman.github.io/huey/src/ind...

- DuckDB version upgrade (1.4.0)
- Support for translation files. Currently supported: English, Dutch and Brazilian Portuguese (thanks @nosklo!)
- bugfixes and UI improvements

Release Huey version 1.0.10 - Grimao Ermaôs · rpbouman/huey

What's Changed Ensure the lists have a min-height that matches their size attribute. by @rpbouman in #580 Fix #584 by @rpbouman in #585 Fix #587 by @rpbouman in #589 Fix #590 by @rpbouman in #591 ...

github.com

3 3

Reposted by Carlo Piovesan

qxip @qxip.bsky.social · Sep 17

Had a blast speaking about query.farm at the #DuckDB Amsterdam Meetup #3 where I had time to spend some time with my heroes @carlo.piovesan.io @samansmink.bsky.social @szarnyasg.org Tania Bogatsch and so many more awesome people! Thank You @duckdb.org for giving space to the community! #opensource

1 13

Carlo Piovesan @carlo.piovesan.io · Sep 3

There is also the "Science in DuckDB" section: duckdb.org/why_duckdb.h... and the follow up on "Standing on the Shoulders of Giants"

Why DuckDB

Why DuckDB There are many database management systems (DBMS) out there. But there is no one-size-fits all database system. All take different trade-offs to better adjust to specific use cases. DuckDB ...

duckdb.org

Reposted by Carlo Piovesan

DuckDB @duckdb.org · Sep 2

We just launched the “DuckDB in Science” site, a curated collection of papers, lectures and podcasts about DuckDB in research: duckdb.org/science/

🎡 If you would like to learn more about DuckDB in Science, consider joining our meetup in London this Thursday: www.meetup.com/duckdb/event...

2 15 46

Reposted by Carlo Piovesan

DuckDB @duckdb.org · Aug 18

🎓 On September 4, we are hosting a new kind of meetup in London which will focus on the use of DuckDB in Science and Education!

⚡️ We still have some spots for lightning talks. If you're working with DuckDB in your research and/or classroom, consider sharing your story!

🔗 duckdb.org/events/2025/...

DuckDB Meetup on Science and Education in London

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

5 14

Reposted by Carlo Piovesan

DuckDB @duckdb.org · Aug 8

We just published a deep dive on spatial joins in DuckDB by @maxxen.bsky.social.

In this blog post, Max explains how spatial joins evolved in DuckDB and how the current operator harnesses R-Trees.

Read the full post at duckdb.org/2025/08/08/s...

13 50

Carlo Piovesan @carlo.piovesan.io · Jul 26

Is anyone aware whether it’s possible to set CORS policies on the R2 (@cloudflare.social) Iceberg REST catalog?

cloudflare.social

Reposted by Carlo Piovesan

Andy Wheeler @crimede-coder.bsky.social · Jun 29

Weekend project, using R2 + DuckDB wasm to build a low price frontend for big data analytics crimede-coder.com/graphs/GSUBo...

GSU Book Prices

GSU Book Prices Tables

crimede-coder.com

1 7

Carlo Piovesan @carlo.piovesan.io · Jun 24

Quack!!

Mathias Lafeldt @mathias.blog · Jun 17

Beyond excited to share that I'm now working with DuckDB Labs!

My first priority will be the DuckDB Rust client, which will receive a lot more love going forward.

🎉 🦆 ❤️

Mathias Lafeldt @mathias.blog · Jun 3

Signing a new freelance contract is always exciting. Being able to work on open source makes it doubly so.

Will share more soon. 😊

3

Reposted by Carlo Piovesan

Mathias Lafeldt @mathias.blog · Jun 17

Beyond excited to share that I'm now working with DuckDB Labs!

My first priority will be the DuckDB Rust client, which will receive a lot more love going forward.

🎉 🦆 ❤️

Mathias Lafeldt @mathias.blog · Jun 3

Signing a new freelance contract is always exciting. Being able to work on open source makes it doubly so.

Will share more soon. 😊

3 4 39

Reposted by Carlo Piovesan

__Alex Monahan__ @a13x.bsky.social · Jun 3

My #PyConUS talk is up! Tame data science file zoos with @duckdb.org!
Read files of many shapes from any cloud, including your messiest CSVs. Then, organize all of your input tables, output tables, views, and relationships in one DuckDB file. No final_v3.csv!
youtu.be/Yq-hxgysWLQ?...

Taming file zoos: Data science with DuckDB database files - Alex Monahan

YouTube video by PyCon US

youtu.be

4 18

Reposted by Carlo Piovesan

Jordan Tigani @jrdntgn.bsky.social · May 28

Yesterday DuckDB Labs announced DuckLake, a new Open data and catalog format. Here is a bit about why it is so awesome, how it solves some key problems with existing technologies, and why we're excited to host it in the cloud at MotherDuck.

MotherDuck @motherduck.com · May 28

S3 isn’t a database. But what if your lakehouse finally acted like one?

@jrdntgn.bsky.social shares why the current generation of lakehouse formats like Iceberg and Delta Lake might be missing the point—and how DuckLake, a new table format, changes the game.

motherduck.com/blog/ducklak...

A Duck Walks into a Lake - MotherDuck Blog

DuckDB introduces a new table format, what does it mean for the future of data lakes ? | Reading time: 9 min read

motherduck.com

5 36

Reposted by Carlo Piovesan

lloyd tabb @lloydtabb.bsky.social · May 27

Ducklake is a really elegant solution to the data lake. Radically simple and completely open.

DuckDB @duckdb.org · May 27

Today we're launching DuckLake, an integrated data lake and catalog format powered by SQL. DuckLake unlocks next-generation data warehousing where compute is local, consistency central, and storage scales till infinity. ⁠ducklake is an open standard and we implemented it in the "ducklake" extension.

1 23

Carlo Piovesan @carlo.piovesan.io · May 27

Classing "cache invalidation and naming things" are the most complex problems.

I think DuckLake is cute, but naming stuff is hard.

1 2

Carlo Piovesan @carlo.piovesan.io · May 27

And the biggest winner is... DuckDB support for running queries on [remote] parquet files.
This happens to be a basic building block of DuckLake and a few other alternative lake technologies

DuckDB @duckdb.org · May 27

Today we're launching DuckLake, an integrated data lake and catalog format powered by SQL. DuckLake unlocks next-generation data warehousing where compute is local, consistency central, and storage scales till infinity. ⁠ducklake is an open standard and we implemented it in the "ducklake" extension.

11

Reposted by Carlo Piovesan

DuckDB @duckdb.org · May 27

Today we're launching DuckLake, an integrated data lake and catalog format powered by SQL. DuckLake unlocks next-generation data warehousing where compute is local, consistency central, and storage scales till infinity. ⁠ducklake is an open standard and we implemented it in the "ducklake" extension.

8 40 140

Reposted by Carlo Piovesan

Torsten „Teggy“ Grust @teggy.org · May 22

Our USING KEY variant of recursive CTEs has landed in DuckDB 1.3 Formerly an off-the-beaten-path researchy idea, now available in a real off-the-shelf DBMS. Hooray! 🎉

duckdb.org/2025/05/23/u...

USING KEY in Recursive CTEs

Recursive CTEs in SQL allow for powerful iterative queries like graph traversals but can be memory-intensive and slow due to repeated row accumulation. DuckDB’s new USING KEY feature addresses this by...

duckdb.org

6 24

Reposted by Carlo Piovesan

DuckDB @duckdb.org · May 23

New post by Pedro Holanda, Ian Cook, Dewey Dunnington and Bryce Mecum:

Arrow IPC Support in DuckDB

This blog post introduces the new arrow community extension, which boosts interoperability by allowing to consume/produce data through the Arrow IPC Serialization Format.

duckdb.org/2025/05/23/a...

11 30

Reposted by Carlo Piovesan

DuckDB @duckdb.org · May 21

DuckDB v1.3.0 “Ossivalis” is out and it packs a ton of new features, fixes and optimizations.

See the announcement blog post: duckdb.org/2025/05/21/a...

18 60