Hacker News Reader

Countly can do that, and much, much more.

> I can't imagine systems with MySQL/PostgreSQL as database can handle this.

out of curiosity, why so?

500 000 000 requests per month is just about 200 request per second. Why there should be any problem for any DB?

As for question - I saw a lot of great reviews on ClickHouse DB

> 500 000 000 requests per month is just about 200 request per second

Not if you assume that some hours will have more web traffic than others.

Yes, there are some peaks with 10-20000 per sec.

Clickhouse seems very suitable as database. Does anybody know open source analytics tools that use it? Two parts would be needed: the client javascript tracker which injects into the database, and a GUI for reports.

Snowplow. 500 million events a month is nothing.