Lightnews — Scholar-powered news

DuckDB @duckdb.org · 3d

🚀 We released DuckDB v1.4.1, the first bugfix release of our LTS edition.

🔎 We expect LTS users to be particularly curious about changes in the system, so we wrote up a short blog post highlighting the most important fixes and improvements.

duckdb.org/2025/10/07/a...

Announcing DuckDB 1.4.1 LTS

Today we are releasing DuckDB 1.4.1, the first bugfix release of our LTS edition.

duckdb.org

1 3 22

DuckDB @duckdb.org · 8d

Thanks a lot for letting us know about the existence of this site! We'll look into this.

DuckDB @duckdb.org · 8d

Swift is no longer supported as a main platform, unfortunately. We moved it to the "tertiary tier" (duckdb.org/docs/stable/...), which means that it gets updates on a best effort basis and can be out-of-sync with the latest stable version.

Tertiary Clients

Client API Maintainer Support tier Version Common Lisp ak-coram Tertiary Crystal amauryt Tertiary Dart TigerEye Tertiary Elixir AlexR2D2 Tertiary Erlang MM Zeeman Tertiary Julia The DuckDB t...

duckdb.org

DuckDB @duckdb.org · 9d

🌃 Nightly (preview) builds are still published on GitHub, but we are no longer recommending them for general use. They should only be used when troubleshooting issues or testing pre-release features.

2 1

DuckDB @duckdb.org · 9d

✨ We launched a new installation page for DuckDB!

🚀 The new page lets you install the latest stable DuckDB release with just one or two clicks. If the defaults don't fit your use case, no worries: alternative download methods remain available for many clients.

3 5 22

DuckDB @duckdb.org · 11d

Are you streaming into your Lakehouse?

Traditional formats suffered with the “many small files” problem — OLAP engines merge them reactively with long jobs. ⏳

DuckLake takes a proactive path: Data Inlining + async flush to parquet while always keeping data queryable ⚡

2 18

DuckDB @duckdb.org · 14d

We published a new deep dive by Laurens Kuiper, who recently redesigned DuckDB's sort.

One data point: ordering the TPC-H SF100 lineitem table with the memory limit set to 30 GB is 3× faster in DuckDB v1.4 than in v1.3.

Read more at duckdb.org/2025/09/24/s...

Redesigning DuckDB's Sort, Again

After four years, we've decided to redesign DuckDB's sort implementation, again. In this post, we present and evaluate the new design.

duckdb.org

9 32

Reposted by DuckDB

Delta Lake @deltalakeoss.bsky.social · 18d

“Open source is giving back, because it means everyone who supports our work can participate and benefit from the software we are making." — @hannes.muehleisen.org (@duckdb.org) at Open Lakehouse + AI Amsterdam 🇳🇱

Ready to shape the future of data, open source, and AI together? ⬇️

#opensource #oss

2 1 9

DuckDB @duckdb.org · 17d

Our website, duckdb.org, has recently crossed 4 million monthly unique visitors. It now handles 110M+ requests and serves more than one petabyte of data each month!

22

Reposted by DuckDB

IntelliJ IDEA, a JetBrains IDE @intellijidea.com · 17d

🚀 Kotlin DataFrame 1.0.0-Beta3 is here!
Working with data in Kotlin is now smoother thanks to Parquet and DuckDB support, improved compile-time schema tracking via the Compiler Plugin, and refreshed docs.
Read the full release notes 👇
kotl.in/w2eq2c

Release v1.0.0-Beta3 · Kotlin/dataframe

We're one step closer to DataFrame 1.0! We've been working hard to iron out bugs and improve documentation and examples throughout. Try out this release by updating to 1.0.0-Beta3 in your project o...

kotl.in

4 16

DuckDB @duckdb.org · 22d

🚀 We released version 0.3 of the DuckLake specification and the DuckDB ducklake extension today. It includes interoperability with Iceberg, support for geometry types and more.

Check the announcement blog for more details ducklake.select/2025/09/17/d...

11 38

DuckDB @duckdb.org · 24d

📈 DuckDB 1.4.0 is out! This is our first LTS release which comes with *one year of community support*. It also supports database encryption, the MERGE SQL statement and Iceberg writes.

For more details, read the announcement blog post at
duckdb.org/2025/09/16/a...

22 54

Reposted by DuckDB

Hannes Mühleisen @hannes.muehleisen.org · 24d

We're testing a new distribution channel for @duckdb.org : #docker images. For now they live at `hfmuehleisen/duckdb`, feel free to test them out. And yes, hell got a little colder today.

hub.docker.com/r/hfmuehleis...

hub.docker.com

3 23

DuckDB @duckdb.org · 25d

Generative AI ✨

1

DuckDB @duckdb.org · 26d

$ duckdb

D .mode line
D SELECT stargazers_count FROM read_json('https://api.github.com/repos/duckdb/duckdb');

stargazers_count = 32768

In other words:

3 5 50

DuckDB @duckdb.org · 28d

We are beta testing a new, more streamlined installation site at duckdb.org/install. Let us know what you think!

DuckDB Installation

DuckDB installation page

duckdb.org

2 1 14

DuckDB @duckdb.org · 28d

Nederlandse Spoorwegen (NS) has been hosting a weekly puzzle where you have to guess the name of a train station for an anagram.

We already use the Dutch railway dataset in our demos, so writing a SQL solver for this puzzle was an interesting exercise. Read more at duckdb.org/2025/09/11/s...

Solving Letter Scramble Puzzles with DuckDB

In this lighthearted post, we solve a puzzle type that's on display in Dutch trains.

duckdb.org

10

DuckDB @duckdb.org · 28d

Sorry 🫣 PostNL recently suspended the shipment of parcels (www.postnl.nl/campagnes/on...). We can try sending a letter for you – please drop a line to [email protected].

www.postnl.nl

1 1 1

DuckDB @duckdb.org · Sep 10

We are holding the DuckDB Amsterdam Meetup next week, featuring talks by @rolandbouman.bsky.social, Tania Bogatsch and @qxip.bsky.social:

www.meetup.com/duckdb/event...

The event is already at capacity but consider joining the wait list because there are always last-minute RSVP cancellations.

1 4 16

DuckDB @duckdb.org · Sep 9

In the recent npm supply chain attack, DuckDB's Node.js and Wasm packages were compromised with malware. We have investigated the issue, deprecated the affected packages and released new versions.

We have released a security advisory that contains our full postmortem: github.com/duckdb/duckd...

DuckDB NPM packages 1.3.3 and 1.29.2 compromised with malware

The DuckDB distribution for [Node.js](http://node.js/) on [npm](https://www.npmjs.com/) was compromised with malware (along with [several other packages](https://www.aikido.dev/blog/npm-debug-and-c...

github.com

1 10 33

DuckDB @duckdb.org · Sep 9

Thanks for letting us know. We have released a security advisory that contains our postmortem and mitigation steps: github.com/duckdb/duckd...

DuckDB NPM packages 1.3.3 and 1.29.2 compromised with malware

The DuckDB distribution for [Node.js](http://node.js/) on [npm](https://www.npmjs.com/) was compromised with malware (along with [several other packages](https://www.aikido.dev/blog/npm-debug-and-c...

github.com

1

DuckDB @duckdb.org · Sep 8

Big Data on the Move: Can a Framework Laptop 13 ultrabook run terabyte-sized workloads with DuckDB?

@szarnyasg.org ran the experiments and shared his finding in our latest blog post: duckdb.org/2025/09/08/d...

Big Data on the Move: DuckDB on the Framework Laptop 13

We put DuckDB through its paces on a 12-core ultrabook with 128 GB RAM, running TPC-H queries up to SF10,000.

duckdb.org

3 5 31

DuckDB @duckdb.org · Sep 2

📩 If you are an author of a paper using DuckDB, please submit your work following the guidelines at the bottom of the page.

1 7

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

DuckDB @duckdb.org · Sep 2

🕐 🤔 Timestamps and time zones can be confusing! 😵

💡 To help you make sense of time zones in SQL, Richard Wesley wrote a short guide that covers some typical pitfalls: duckdb.org/docs/stable/...

Timestamp Issues

Timestamp With Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = ...

duckdb.org

1 4 30