Updated

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.

Ask your AI about this, with this page as the source:ChatGPT ↗Claude ↗Perplexity ↗

Which fits you

Choose ClickHouse if
  • 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.

Choose DuckDB if
  • 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

ClickHouseDuckDB
Used by47 makers' products · 72 open-source projects12 makers' products · 54 open-source projects
Downloads3.4M/wk+43% vs npm1.5M/wk4.5× vs npm
PricingFree 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 tierYesYes
Open sourceYes · self-hostableYes
Incidents, 90 daysfrom its status page15 (1 major)no public status feed

Which makers on your framework pick

Makers' products built with each framework that chose either one, for database.

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).

LaunchedClickHouseDuckDBProducts
2022 or earlier7% 27% 227
20233% 10% 038
20244% 101% 3270
20252% 52% 6323
20261% 40% 1397

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.

On ClickHouse
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.
Basedash, the makerSep 2026 ↗
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.
Prefactor, the makerSep 2026 ↗
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.
ASO, the makerSep 2026 ↗
17 more on the ClickHouse page →
On DuckDB
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.
Evidence, the makerSep 2026 ↗
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.
Databox, the makerSep 2026 ↗
Enabled lightweight, high-performance local querying for structured data analysis.
Baselight, the makerSep 2026 ↗
7 more on the DuckDB page →

Loved and watch-outs

Themes that recur in makers' words and Hacker News comments, each linked to what it summarises.

ClickHouseOn Product Hunt: 5.0★, 29 reviews · mentioned most: fast performance, real-time analytics
DuckDBOn Product Hunt: 5.0★, 16 reviews · mentioned most: fast performance, in-process SQL engine, WebAssembly support

Who uses each

What makers pair each with

With ClickHouse
With DuckDB
Hosting
Frontend Framework
LLM API
SupabaseBackend platformPostgres plus auth, storage and realtime in one project.
ConvexBackend platformRealtime, collaborative apps written entirely in TypeScript.
FirebaseBackend platformMobile apps that need offline sync and client-side SDKs.
NeonManaged databaseServerless Postgres that scales to zero, with a branch per preview deploy.
PlanetScaleManaged databaseApps that expect heavy scale and want zero-downtime schema changes.
TursoManaged databaseSQLite at the edge, or one database per customer.
MongoDBManaged databaseDocument-shaped data and teams already fluent in Mongo.
PostgreSQLRun it yourselfThe engine behind most of the hosted options above, run on your own server or container for full control and a flat cost.

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.