News for hackers. Stuff that matters.
Re:Building the world’s fastest website analytics (2021) by wiredfool on Saturday October 15, 2022 @09:13AM (#33214484)
And that point is when you can’t find someone to host it for you.

Though, I’d be sorely tempted to spin up a bfc of clickhouse on bare metal.

Re:Building the world’s fastest website analytics (2021) by dravita on Saturday October 15, 2022 @09:38AM (#33214700)
That one was tried, among many others covered in the article.
Re:Building the world’s fastest website analytics (2021) by JackWritesCode on Saturday October 15, 2022 @09:53AM (#33214839)
Clickhouse isn’t really relevant for a lot of us. SingleStore outperforms clickhouse and the latter isn’t MySQL wire compatible. Far more features come with SingleStore too. And if you speak to people running Clickhouse, they’re also maintaining a Postgres set-up. With SingleStore, you get your OLTP and OLAP in one database. So our users & sites table sit in memory (backed up by disk), meaning ultra fast read/write speeds (comparable to clustered/high availability Redis). And then we put our pageviews/events in columnstore (disk) which offers rapid performance for analytical queries.