ClickHouse vs DuckDB
Of the 1,263 makers' products we know the database of, 47 chose ClickHouse (4%) and 12 DuckDB (1%). Among the 397 launched in 2026, ClickHouse is in 1% and DuckDB in 0%, against 4% and 1% of those launched in 2024 or earlier.
Two analytics (OLAP) options for database. When each fits, what it costs, who moves from one to the other, and what makers who chose it say.
Which fits you
- Fast aggregate queries over billions of rows of events, logs or metrics, self-hosted or on ClickHouse Cloud.
Use it whenDashboards or usage analytics are getting slow on your main Postgres.
Trade-offBuilt for bulk inserts and scans, not frequent row updates or transactions; runs next to your main database, not instead of it.
- Analytical SQL inside your app or script over local or S3-hosted CSV and Parquet files, with no server to run.
Use it whenOne process does the analysis — a report job, a data notebook, analytics in the browser via WebAssembly.
Trade-offAn embedded library, so it doesn't serve many concurrent writers like a database server does.
At a glance
| Used by | 47 makers' products · 72 open-source projects | 12 makers' products · 54 open-source projects |
|---|---|---|
| Downloads | 3.4M/wk+43% vs npm | 1.5M/wk4.5× vs npm |
| Pricing | Free to self-host (Apache 2.0); ClickHouse Cloud is usage-based with compute and storage billed separately, starting with a 30-day trial and $300 in credits. · paid from $53/mo (Basic) | Free and open source (MIT). |
| Free tier | Yes | Yes |
| Open source | Yes · self-hostable | Yes |
| Incidents, 90 daysfrom its status page | 15 (1 major) | no public status feed |
Which makers on your framework pick
Makers' products built with each framework that chose either one, for database.
| Framework | |||
|---|---|---|---|
| 17 | 2 | All 382 Next.js products' picks → | |
| 5 | 1 | All 27 Astro products' picks → | |
| 4 | 1 | All 73 React products' picks → |
New launches vs older products
A tool that came first has products from every year since, so its total runs ahead. Here is what products launched each year chose, as a share of those that made the database decision (by the year they launched on Product Hunt).
| Launched | Products | ||
|---|---|---|---|
| 2022 or earlier | 7% 2 | 7% 2 | 27 |
| 2023 | 3% 1 | 0% 0 | 38 |
| 2024 | 4% 10 | 1% 3 | 270 |
| 2025 | 2% 5 | 2% 6 | 323 |
| 2026 | 1% 4 | 0% 1 | 397 |
What makers say
Makers on using it for database, from Product Hunt and Starter Story interviews, each linked to the source. Products with a page of their own and fuller notes first.
ClickHouse backs Basedash Warehouse, every team's centralized warehouse in Basedash. It's incredibly fast for complex queries and scales to any size we need.
Spans are append-only and every screen in the product is an aggregate over millions of them, which is a columnar problem, so that's where they live.
ClickHouse saves us tons of gigabytes on disk space and delivers incredible performance. Without it, we wouldn’t be able to manage such a large volume of data efficiently. However, we’re still explore everything ClickHouse has to offer.
We use DuckDB WebAssembly as the core of Universal SQL and it has made it possible to deliver incredibly fast, interactive apps. The DuckDB team and community are phenomenal.
DuckDB does the heavy lifting for dataset preparation. It lets us process and structure large API responses efficiently, so users get clean, query-ready datasets without the overhead of a heavier database.
Enabled lightweight, high-performance local querying for structured data analysis.
Loved and watch-outs
Themes that recur in makers' words and Hacker News comments, each linked to what it summarises.
Who uses each
What makers pair each with
Neither quite right?
See the whole database decision →Questions
ClickHouse or DuckDB: which do makers choose?
Of the 1,263 makers' products we know the database of, 47 chose ClickHouse (4%) and 12 DuckDB (1%). Among the 397 launched in 2026, ClickHouse is in 1% and DuckDB in 0%, against 4% and 1% of those launched in 2024 or earlier. Choose ClickHouse if fast aggregate queries over billions of rows of events, logs or metrics, self-hosted or on ClickHouse Cloud; choose DuckDB if analytical SQL inside your app or script over local or S3-hosted CSV and Parquet files, with no server to run.

