DuckDB
In-process analytical SQL database engine for querying local and remote data files.
HN commenters like it as a fast, embedded SQL engine123 for querying CSV, JSON, Parquet and Excel files directly456 and as a replacement for pandas in data work.789 The most common caveat is that it is a single-node analytical engine, not a multi-user transactional database,101112 and concurrent access has needed workarounds.1314
Why people recommend it
Speed · 3
Commenters report large speedups over previous setups, from 6+ hours down to about half an hour and 40-80x faster.
“DuckDB is amazing.”
“duckDB is awesome”
Show 1 more
“But I am loving DuckDB for similar analytical workloads as it is built for such tasks.”
Querying files directly · 3
It runs SQL directly over CSV, JSON, Parquet, Excel and compressed files, and can join them as if they were tables.
“It's a really good daily multitool for data.”
“performant database that lets you directly query JSON, parquet, csv files with SQL queries and convert one to the other.”
Show 1 more
“I'm relatively new to DuckDB (coming from SQLite) and I love it so far.”
Pandas replacement · 3
Many have replaced pandas with it for transformations and say the SQL is more concise and less error-prone.
“Lots of places where we replaced Pandas with DuckDB for transformations.”
“With DuckDB with one SQL statement I can replace 40+ lines of polars/pandas.”
Show 1 more
“polars and duckdb are objectively better APIs in addition to their implementation improvements”
Ecosystem and extensions · 3
Commenters value its Postgres, spatial and dbt integrations and say community extensions are easy to build.
“DuckDB is amazing.”
“the mix of it being fast, having spatial support, sane coding interfaces, great dbt integration”
Show 1 more
“it's worth checking out in 2026”
Scales to large data · 3
Users say it handles anything from a few rows to billion-row tables and terabytes of data without special setup.
“I do think duckdb has a wider range of use cases than people here might think. It can whip through fairly large datasets (I use it for ~1B row tables all the time)”
“I use DuckDB for nearly everything data related because it’s simply the most scalable format/tool/lib from a handful of rows to billions.”
Show 1 more
“I use duckdb HEAVILY at work and it's been a game changer.”
No infrastructure · 3
It is embedded and lightweight, so single-node work needs no server or operational overhead.
“DuckDB just works for single-node use cases without any infrastructure overhead.”
“DuckDb fit better for the potentially massive datasets”
Show 1 more
“I love DuckDB genuinely more than sqlite”
Caveats and dissent
Not OLTP/multi-user · 3
It is built for single-user, in-process analytics rather than transactional client-server workloads.
“I do think duckdb has a wider range of use cases than people here might think. It can whip through fairly large datasets (I use it for ~1B row tables all the time)”
“Duckdb is exciting specifically because SQLite/duckdb aren't comparable; we can stop shoehorning OLAP into an OLTP database.”
Show 1 more
“DuckDB just works for single-node use cases without any infrastructure overhead.”
Concurrent access · 2
Users have needed workarounds for concurrent writes and could not open the UI while a server held the database.
“with duckdb is so cheap was simpler than really implementing concurrent writes and mutations”
“duckdb is my favourite technology of 2025/26. It has worked its way into so many of my workflows.”
Node/Bun support · 1
Node and Bun support lags behind Python, and dynamic linking prevents bundling it into a Bun executable.
“I love duckdb, I use it as much as I can.”
Rough edges · 3
Commenters mention sharp edges in spatial features, limited Quack client support and a partitioning gotcha.
“I use duckdb and its spatial stuff as my adapter.”
“It's very fast, especially on a decent sized cloud VM and when querying Iceberg.”
Show 1 more
“Lots of places where we replaced Pandas with DuckDB for transformations.”
AWS uncertainty · 2
Some commenters worry about how the AWS news will affect the project and its users.
“I love DuckDB, and we've adopted/extended it and ducklake very heavily at Krea for our research.”
“I use DuckDB extensively for local dev as well as a parquet viewer.”
Often compared with
4 moved from pandas to DuckDBPolars16 comments mention both
3 moved from Polars to DuckDB
2 moved from SQLite to DuckDB
1 moved from ClickHouse to DuckDBMalloy3 comments mention both
Who recommends it in their own words
From the makers not counted in the ranking
“DuckDB is really neat, recently added PDO interface for it for PHP”
Threads where it came up
- A Preview of DuckDB v2.0 9 mentions
- DuckDB Internals: Why Is DuckDB Fast? (Part 1) 9 mentions
- Why DuckDB is my first choice for data processing 9 mentions
- DuckDB 2.0.0 LTS “Cinnamon Teal” 4 mentions
- AWS Acquires DuckLabs 4 mentions
- Ask HN: What dev tools do you rely on that nobody talks about? 3 mentions
Data: duckdb.json. Quotes are verbatim; the verdict and theme labels are written by a model from these comments, and every clause links to its sources.
All comments 48
“It's a really good daily multitool for data.”
“I've used it for data migration combined with Jupyter Notebook.”
“I could have 3000 users logged into the same application, but all of them would be bringing their own CPU to run duckdb.”
“It's very fast, especially on a decent sized cloud VM and when querying Iceberg.”
“DuckDB is amazing.”
“DuckDB's come up a lot since I started my little journey to be honest.”
“I use duckdb and its spatial stuff as my adapter.”
“DuckDB for us is a pure read-only service pipe.”
“I tried loading TPC-H data and querying it with DuckDB, and it worked.”
“I've nearly entirely switched to DuckDB for anything more than like 500 or 1,000 rows”
“With DuckDB with one SQL statement I can replace 40+ lines of polars/pandas.”
“using DuckDB as the query engine”
“polars and duckdb are objectively better APIs in addition to their implementation improvements”
“I use polars or duckdb now exclusively. Better syntax, better performance.”
“I do duckdb processing which supports gzip transparently.”
“when I used duckdb and Python and Pycharm”
“I started looking more and more into DuckDB recently”
“So DuckDB is another interesting alternative to pandas.”
“built stupid simple framework ish coverage for connections and duckdb”
“MIT License https://github.com/duckdb/duckdb/blob/main/LICENSE”
“I love DuckDB, and we've adopted/extended it and ducklake very heavily at Krea for our research.”
“provide a leaner, faster and a more modern alternative to Athena.”
“I use DuckDB extensively for local dev as well as a parquet viewer.”
“I love SQL, and respect SQLite and DuckDB for what they are.”
“I love the idea of friendly SQL!”
“querying with SQL in DuckDB is the path I've been going”
“I'm currently, deploying Duckdb with AWS S3 Tables (Iceberg) to see how it fits for a use case I have.”
“Same.”
“I've moved from python/polars/pandas to DuckDB and have not looked back”
“I love reading all of the DuckDB love here. It's good software.”
“So yeah - fond of DuckDB.”
“I love DuckDB genuinely more than sqlite”
“i love duckdb and use it for a variety of projects”
“DuckDB has been a fantastic engine to build on (in python)”
“Lots of places where we replaced Pandas with DuckDB for transformations.”
“the mix of it being fast, having spatial support, sane coding interfaces, great dbt integration”
“Excited about a stable C++ API for extensions!”
“I had an impression that DuckDB was not great at distributing work to other machines, but good at doing it locally?”
“I love using duckdb and frequently query directly from zstd compressed files (and write out new ones).”
“why would I use this instead of duckdb and writing SQL as God intended”
“I do think duckdb has a wider range of use cases than people here might think. It can whip through fairly large datasets (I use it for ~1B row tables all the time)”
“Duckdb is exciting specifically because SQLite/duckdb aren't comparable; we can stop shoehorning OLAP into an OLTP database.”
“with duckdb is so cheap was simpler than really implementing concurrent writes and mutations”
“duckdb is my favourite technology of 2025/26. It has worked its way into so many of my workflows.”
“I'm relatively new to DuckDB (coming from SQLite) and I love it so far.”
“performant database that lets you directly query JSON, parquet, csv files with SQL queries and convert one to the other.”
“duckDB is awesome”
“DuckDB just works for single-node use cases without any infrastructure overhead.”