A Preview of DuckDB v2.0

logancbrown•3 minutes ago

Funny to think one of my favorite software projects this decade is basically "lets make it easy to host your own OLAP database".

jtbaker•about 1 hour ago

DuckDB is one of the things I've been most excited about in a long time. Introduced it to projects at 3 companies since 2023, greatly lowering resource requirements and running it in a variety of environments. Just having the ability to do out of core bigger than memory data processing on lower end consumer grade hardware is remarkable.

Thanks to the team for everything!

fifilura•14 minutes ago

My favourite is AWS Athena (backed by Trino).

"If we use this we get indefinite RAM indefinite CPU and do not need to host a server".

I had an impression that DuckDB was not great at distributing work to other machines, but good at doing it locally? Am I wrong?

ericpauley•8 minutes ago

Athena + Clickhouse has been an absolute game changer for us. Perfect combo for OLAP + deeper filtering that we can’t necessarily pre-index for.

throwaw12•about 1 hour ago

Curious to learn more about how people are using it?

Are they downloading parquet files and running analyses locally, or are they connecting to Iceberg-like data lake and leveraging DuckDBs query engine capabilities or have you exposed an interface (REST, UI) to query your data?

arealaccount•about 1 hour ago

We use DuckDB WASM with parquet to build dashboards in-browser. It's cool to be able to write SQL directly in a browser and not have to rely on REST/Graphql/etc to access the data layer.

drums8787•29 minutes ago

We use WASM DuckDB as the target for an in-browser agentic feature. Generated SQL runs against the user's individual tables that then feed in-browser dashboards.

Excellent performance.

throw1234567891•23 minutes ago

How many accounts do you have besides these two? https://news.ycombinator.com/item?id=49332606

badatnames•7 minutes ago

Looks like an awesome release, but the smell of AI from that post is horrid.

Here is a wild idea: is it really so hard to edit out sentences structured and punctuated like this - it's so painfully obvious and distracts from the content. The effect is real.

srameshc•about 1 hour ago

I <3 DuckDB. It has become one of my go to tools for storing, data processing , integrations and now even graph. More importantly it's fun to use because it is so portable. Looking forward to v2.

fragebogen•about 1 hour ago

Ditto! Very happy with the upcoming async support! Now it'll be a nice little db for serving http traffic as well!

c9cf35860db4•about 1 hour ago

The last year of DuckDB enhancements feel like the shift from in-process execution engine (which it is phenomenal at) to an engine that can serve as the foundation of a cloud data warehouse. I know the founders were reticent about not wanting to build that, but I have a feeling it is in the works.

jbmsf•about 1 hour ago

I've been using MotherDuck as a data warehouse for some time now. No regrets.

ethagnawl•about 1 hour ago

UPDATE: Removed uninformed comment about the relationship between DuckDB and MotherDuck.

Tomte•38 minutes ago

Wait, what? I‘ve always assumed MotherDuck is the company by the main developers of DuckDB? They are unrelated?

ethagnawl•25 minutes ago

I was wrong. Apologies.

> They decided to work together, and DuckLabs would become a co-founder of the new endeavor.

https://motherduck.com/about-us/

anentropic•20 minutes ago

Please document the new "extensible PEG-based parser" for extension authors

jeffbee•6 minutes ago

"We reimplemented ICU" U+1F631 FACE SCREAMING IN FEAR

sv123•29 minutes ago

DuckDB is so cool, game changer when it comes to local data processing.

hnlb53nrpg•23 minutes ago

Same problem, different day

est•about 1 hour ago

This is cool

What about the runtime size? I care this because I intend to run a stripped WASM version of DuckDB in browser.

zcw100•29 minutes ago

What do you plan on stripping and what's your target? The Emscripten based build is ~10Mb. I have a component build so I'd be interesting on how you'd like to break it up.

markhalonen•about 1 hour ago

Was hoping to see procedural functionality like PL/pgSQL... regardless, an astonishing project overall.

A Preview of DuckDB v2.0

⚡ Community Insights

Discussion (23 Comments)Read Original on HackerNews