[–] [S] 9 points 11 months ago (1 child)

Clickhouse definitely takes a lot of resources! There's unfortunately no way around that, though in my experience it runs fine on the cheapest Hetzner instances which are like $3-4 a month for 2GB of RAM. How lightweight is your VPS?

And yea, you don't need clickhouse for a simple static site. I chose clickhouse because it Postgres or MySQL does not scale well since the main site I personally use Rybbit for sends around 20 million events a month.

It pains me to plug my competitors, but check out Umami or Goatcounter if you want a platform that uses postgres.

  • source
  • parent
  • context
  • [–] [S] 14 points 11 months ago (12 children)

    Only very slightly so. One of the reasons I created Rybbit is because platforms like plausible and fathom have much inferior self-hosted versions (very limited featureset and basically never updated). We have a comparison here

  • source
  • parent
  • context
  • [–] [S] 8 points 11 months ago

    Posthog makes it almost impossible to actually self-host since they try to push you onto the cloud as much as possible. They say that the self-hosted version only works well up until 100k events ... which is insane since their cloud free tier is 1 million events. It's actually the reason why I built Rybbit. I tried to self-host posthog on my server but it ran it up to 100% CPU on 8 cores and didn't even work.

    Ok posthog rant done.

    The other main difference is that Posthog has like 10+ different products all in one. Their web analytics is good, but it's just kind of bland (imo) because it's not their main focus.

  • source
  • parent
  • context
  •  

    Hi guys, I've been working on a self-hostable web analytics platform since the start of this year after being frustrated with Google Analytics and Plausible.

    I've packed a bunch of cool web analytics features into Rybbit, but I've tried very hard to keep the interface simple to use,

    https://github.com/rybbit-io/rybbit

    Check it out!

    view more: next ›