Open source alternatives to ClickHouse

One project on starwire does the same job. Ranked by how much of what ClickHouse does each one covers, read from its README and website. Ties go to the most active.

What ClickHouse does

  1. Fast analytical queriescore
  2. Columnar storagecore
  3. SQL
  4. Real-time ingestion
  5. Compression
  6. Distributed clusters

Each dot in the table is one job, in this order. Square dots are core jobs and count double. Full means yes, half means partly. "See the evidence" under a project shows the line behind each one. Coverage is what a project documents, not how well it works or how hard it is to move to. How we score this

ProjectCoversStarsCommits, 12 weeksLast releaseClosed vs openedSetupLicense
pgrustPostgres rewritten in Rust, with benchmarks claimed to beat Postgres and ClickHouse Covers one part69%5.8k+36
3
23 days ago25% Needs a server AGPL-3.0
Covers all 2 core jobs. Partly: Real-time ingestion. Not shown: Compression; Distributed clusters.See the evidence
  • Fast analytical queriescoreYesyour analytics faster than ClickHouse
  • Columnar storagecoreYesholding columnar tables
  • SQLYesSQL dialect compatible with Postgres
  • Real-time ingestionPartlyA write is visible on the very next query.
  • CompressionNot shownNeither the README nor the website mentions it.
  • Distributed clustersNot shownNeither the README nor the website mentions it.

Vital signs from GitHub, checked weekly. How we read these · How setup is read

These also replace

All repos

New repos every two days, stars refreshed daily. Visits are counted without cookies, and the numbers are public. How it works Data RSS Newsletter

The best new open source, once a weekOne short email: the repo everyone is suddenly starring, a handful worth trying, and one hidden gem, each with a plain note on what it does. Free, with no tracking pixels.

Read past issues

↑ ↓ to move   Enter to choose   Esc to close

Follow starwire by RSSCopy an address into your feed reader.
The day's bestOne item a day: the repos rising fastest and the biggest new picks.starwire.foo/top.xml
Every new pickAll of them as they are added, up to 60 a day.starwire.foo/feed.xml
The weekly emailEach issue of the newsletter, once a week.list.starwire.foo/archive.xml