SaaSHub helps you find the best software and product alternatives Learn more →
ClickHouse Alternatives
Similar projects and alternatives to ClickHouse
-
-
TimescaleDB
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
-
Sonar
Write Clean C++ Code. Always.. Sonar helps you commit clean C++ code every time. With over 550 unique rules to find C++ bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
-
VictoriaMetrics
VictoriaMetrics: fast, cost-effective monitoring solution and time series database
-
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
-
materialize
Materialize is a fast, distributed SQL database built on streaming internals. (by MaterializeInc)
-
-
q
q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
-
tsbs
Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
-
-
Plausible Analytics
Simple, open-source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.
-
RocksDB
A library that provides an embeddable, persistent key-value store for fast storage.
-
-
Matomo
Liberating Web Analytics. Star us on Github? +1. Matomo is the leading open alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. We love Pull Requests!
-
Ackee
Self-hosted, Node.js based analytics tool for those who care about privacy.
-
pg_ivm
IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
-
zsv
zsv+lib: world's fastest (simd) CSV parser, with an extensible CLI for SQL querying, format conversion and more
-
-
-
redpanda
Redpanda is a streaming data platform for developers. Kafka API compatible. 10x faster. No ZooKeeper. No JVM!
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
ClickHouse reviews and mentions
-
Features I'd Like in PostgreSQL
Simply by larger sizes of compressed blocks, which are limited to page size in Postgres, and by improving the data locality by sorting, which is inherent for LSM-trees.
But if you want higher compression, you need to consider column-oriented DBMS, such as ClickHouse[1]. They are unbeatable in terms of data compression.
[1] https://github.com/ClickHouse/ClickHouse
Disclaimer: I'm a developer of ClickHouse.
-
I redesigned and open-sourced my SC2 search engine! Now featuring interactive filtering, fuzzy matching and search categories
Database: ClickHouse (OLAP DB) via Tinybird
-
anyone have experience writing data to parquet files? Is there a better alternative for storing large amounts of financial tick data?
clickhouse
-
Setting the TZ environment variable avoids thousands of system calls
Syscalls can be heavier than expected. One example is when an application is run inside gVisor. Another example is when a lot of eBPF code is attached. A third example is when a program is run under strace.
Disclaimer: I'm working on ClickHouse[1], and it is used by thousands of companies in unimaginable environments. It has to work in every possible condition... That's why we set the TZ variable at startup and also embed the timezones into the binary. And we don't use the glibc functions for timezone operations because they are astonishingly slow.
-
Ask HN: What's your favorite illustration in Computer Science?
https://en.wikipedia.org/wiki/De_Bruijn_sequence
I want to make use of it in ClickHouse, but we did not (yet), see https://github.com/ClickHouse/ClickHouse/issues/41195
- Faster PostgresSQL to BigQuery
-
Efficient and performance-portable vector software
It is a nice paper, but for practical applications on fixed-size numbers up to 64 bits, as well as for tuples on fixed-size numbers, and for partial sorting, it does not beat Radix Sort (on moderate-sized arrays).
I have tested it in ClickHouse, but end up with this:
https://github.com/ClickHouse/ClickHouse/blob/master/src/Com...
PS. It's strange that Google's paper dismisses djbsort: https://sorting.cr.yp.to/ - also in the class of sorting networks, but introduced a few years ago.
-
Show HN: HyperLogLog in Zig
[1] https://github.com/ClickHouse/ClickHouse/
What is often forgotten in designing a data structure for a cardinality estimator - is that it should work well not only for a few large states but also for a large number of small sets.
For example, in a query like follows:
SELECT URL, COUNT(DISTINCT UserID) FROM pageviews GROUP BY URL
-
Show HN: ClickHouse-local – a small tool for serverless data analytics
ClickHouse will throw an exception in case of not enough memory and continue to serve other queries. Under certain configurations it can OOM as well.
> How confident are you that your chosen dataset is neutral?
I have no idea if it is "neutral", I picked it randomly.
I test ClickHouse on every interesting dataset, see here: https://github.com/ClickHouse/ClickHouse/issues?q=is%3Aissue...
The reason - I love working with data :) If I see a dataset, I load it into ClickHouse - this is the first thing I do. This is not a kind of marketing or promotion of ClickHouse - you know, if it were some directed task, it would be uninteresting for me.
> curl https://clickhouse.com/ | sh
It feels a bit weird to not use a subdomain (install.clickhouse.com) or a specific route for this, and instead mix this in with your marketing site.
-
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea597599f0>
www.saashub.com | 1 Feb 2023
Stats
ClickHouse/ClickHouse is an open source project licensed under Apache License 2.0 which is an OSI approved license.