Top
Best
New

Posted by ibotty 23 hours ago

A Preview of DuckDB v2.0(duckdb.org)
657 points | 116 commentspage 3
luizfelberti 14 hours ago|
> A repository is a name, a URL prefix, and one or more RSA public keys that are trusted to sign the extensions served from it.

Is it too late to beg Hannes and Mark to let us have something like minisign instead of RSA? :)

Very excited for 2.0, congrats folks!

logancbrown 20 hours ago||
Funny to think one of my favorite software projects this decade is basically "lets make it easy to host your own OLAP database".
rrgok 16 hours ago||
Sometimes I prefer DuckDB query language to MySQL or Postgres. It is not even about performance, it just feels right. I just connect to my DBS from DuckDB just to use its query language. And besides it gives you a single language frontend.
onnimonni 16 hours ago|
This! For example I tried to ask PosgreSQL to Add support for QUALIFY keyword since it makes window queries much more simpler to use. Postgres didnt want it. DuckDB maintainers are always thinking about the DX and all nice syntactic sugar.
hans_castorp 15 hours ago||
The Postgres devs rejected it, because it wasn't part of the standard back then, and apparently work was going on, to include it into the standard.

Now that it's included in the standard, there is work to implement it:

https://hackorum.dev/topics/51960#message-1125429

andyferris 11 hours ago||
I was curious to see they are advertising OLTP-like transactional processing speed. It would be super convenient to have one DB for OLTP and OLAP purposes!

Has anybody here tried using it that way?

(though I don't see any way to deal with write skew and other transactional guarantees - no SERIALIZABLE optimisitic concurrency, no SELECT FOR UPDATE pessimistic concurrency, etc)

anentropic 20 hours ago||
Please document the new "extensible PEG-based parser" for extension authors
drannex 20 hours ago||
Really looking forward to that new Async system, especially when reading/querying against thousands of parquet files. This is going to monumentally affect me and my work - I have to query against millions of massive parquet files and the speed has already been rather wonderful, but if those metrics are to be even 100% in range, this is going to make life so much better.

DuckDB is seriously an incredible utility.

HawtAds 16 hours ago||
How stable is DuckDB these days? I remember it was very buggy compared to Clickhouse.
est 21 hours 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 21 hours 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.
datadrivenangel 18 hours ago||
They're mostly using optional extensions for this new stuff, so the binaries are still small, like ~20mb?
d33 19 hours ago||
Are there improvements in how memory_limit works? I often had DuckDB get OOM killed because it went beyond its limit. It's definitely one of the reasons why I usually have an AI tune the environment for my datasets.
thejosh 19 hours ago|
I've been working on a demo database project, and have been really impressed by the UI. So glad they decided to put more effort into it, it has made building a "follow along" tutorial really nice.
More comments...