HN

Comments (57)

• Menu

  otter-in-a-suit
  Super excited about Quack (partially due to the name). I use duckdb for both analytics and runtime, but I do have to serve/handle/manage a giant, multi-GiB duckdb file as effectively a runtime artifact[1]. I'm aware that this isn't the _perfect_ database for this, but the mix of it being fast, having spatial support, sane coding interfaces, great dbt integration, and me being able to do everything between "run a giant several hundred step dbt pipeline" to "query the output of said pipeline" to "read/query a csv on disk" with the exact same tool is just so nice. If I could centrally manage said asset more akin to a traditional database, I'd be very happy.I've partially solved this with separate databases for different steps in the data pipeline(s) and have even experimented with Clickhouse as a complete alternative, but I really like way too many things about duckdb to replace it.[1]: If you care: https://skaldmaps.com/blog/2026/07/zip-codes-are-a-bad-spati...
• Menu

  jtbaker
  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!
• noodlesUK
  I look forward to DuckDB being the engine that underpins the next gen of analytical data tooling. DuckLake already looks amazing and with the Quack protocol seems like it will be a great natural fit for lots more types of tooling, such as sensor data etc.
• Menu

  srameshc
  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.
• Menu

  c9cf35860db4
  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.
• aleda145
  Excited about a stable C++ API for extensions!I made a dry run extension a few months ago (https://github.com/aleda145/duckdb-dryrun), will be so nice to build it just once and know that it will always work.Also urge anyone to make an extension, the template makes it quite smooth: https://github.com/duckdb/extension-template
• orthoxerox
  DuckDB keeps getting better and better. I wonder when something like Apache Gluten will pick it up as a backend.
• Menu

  amluto
  If I could have a pet feature added to DuckDB, it would be some form of native ordered table. In a database like Clickhouse or any of the dedicated time series DBMSes or log stores, there’s a built-in concept that a table might have an order, and the database will optimize based on the order. But, for databases that are logically just bags of rows (traditional DBMSes and also DuckDB [0]), you either need an index or you need to rely on full table scans or at least scans of big blocks. DuckDB does the latter really well, but I think it would be quite nice for some workflows to have explicit ordering. Also, I bet compression could work a lot better with ordering hints.All that being said, I’m quite excited about DuckDB 2.0. I want to give the improved VARIANT support a try.[0] Documentation on DuckDB’s native format is rather sparse AFAICT. But the DDL has nothing resembling an ordered table.
• d33
  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
  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.
• drannex
  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.
• logancbrown
  Funny to think one of my favorite software projects this decade is basically "lets make it easy to host your own OLAP database".
• dzonga
  well done to the duckDB team - one of the features I'm waiting for is real time materialized views.
• formerly_proven
  In terms of project trajectory this is also an interesting contrast. DuckDB is "SQLite, but for OLAP".DuckDB 1.0 was in 2024. DuckDB 2.0 (new API, new storage format, new ...) is in 2026.SQLite has been 3.x since 2004.
• anentropic
  Please document the new "extensible PEG-based parser" for extension authors
• Menu

  est
  This is coolWhat about the runtime size? I care this because I intend to run a stripped WASM version of DuckDB in browser.
• sv123
  DuckDB is so cool, game changer when it comes to local data processing.
• Menu

  brunoborges
  How does DuckDB compares with PostgreSQL / MariaDB ?
• dartharva
  Would be really cool if they were to add statistical functions too. I'd jump at the chance of getting to use this over pandas
• markhalonen
  Was hoping to see procedural functionality like PL/pgSQL... regardless, an astonishing project overall.
• Menu

  badatnames
  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.
• Menu

  jeffbee
  "We reimplemented ICU" U+1F631 FACE SCREAMING IN FEAR
• giovannibonetti
  Disappointed, since I was expecting they would rewrite the implementation from C++ to Zig. I bet that would increase the number of positive pull requests they get, since most developers prefer to stay away from C++ nowadays.
• hnlb53nrpg
  Same problem, different day