ClickHouse Indeed does not do "Separate Compute from Storage" yet it is architectural decision not a feature gap. Running ClickHouse with directly attached storage and built in replication can be super fast and cost efficient. It works best for stable workloads
ClickHouse, a column-oriented DBMS to generate analytical reports in real time
31–33 of 33 posts
Re: ClickHouse, a column-oriented DBMS to generate analytical reports in real time
#32CloudFlare is using ClickHouse. That does say something
https://blog.cloudflare.com/http-analytics-for-6m-requests-p...
Re: ClickHouse, a column-oriented DBMS to generate analytical reports in real time
#33Earlier quoted context omitted.
monetDB is a sort of drop-in replacement for a regular database with all expected features and good compatibility. On other hand ClickHouse will be incompatible with most of existing tools and it's better to learn well its limitations and workaround technics in advance. But once you dump into it substantial amounts of time series data you'll find it 10+ times faster and 2-3 times smaller than monet.
Is there a way to handle scenarios where the data does update? Like backfill of latent events within a 1-2 day window.
You can copy the stable data to another table, then insert the updated data. The database has excellent compression and copying from one table to another is super fast.