Live data from Hacker News

Ask HN: Good open source alternatives to Google Analytics?

news.ycombinator.com

71–80 of 154 posts

Re: Ask HN: Good open source alternatives to Google Analytics?

#73
post #40

As I predicted around 2018, most or all analytics/events products will eventually move to ClickHouse or related technology (forks). Plausible: ClickHouse PostHog: ClickHouse Panbelbear: Clickhouse https://pirsch.io/ : ClickHouse. PD: I should have a blog or something where I put this predicts :)

What is ClickHouse and why do all projects move to it?

https://clickhouse.com/

Re: Ask HN: Good open source alternatives to Google Analytics?

#74
post #40

As I predicted around 2018, most or all analytics/events products will eventually move to ClickHouse or related technology (forks). Plausible: ClickHouse PostHog: ClickHouse Panbelbear: Clickhouse https://pirsch.io/ : ClickHouse. PD: I should have a blog or something where I put this predicts :)

What is ClickHouse and why do all projects move to it?

ClickHouse is an extremely fast SQL data warehouse that supports vectorized query execution, column storage, and efficient compression. It's also Apache 2.0 licensed and sets up on a dev laptop in about 60 seconds. The SQL is somewhat ideosyncratic (in a good way, I believe). It takes some experience to use it to its full capabilities.

Not all projects move there but if you want fast analytic queries on a few billion rows up to a few petabytes, it's really hard to beat.

Disclaimer: I work for Altinity, which supports ClickHouse.

Re: Ask HN: Good open source alternatives to Google Analytics?

#76
post #27
post #14

I wrote two articles about this for LWN last year. Several of them are self-hostable. Summary: https://lwn.net/Articles/822568/ : lightweight options: GoatCounter and Plausible (open source), Simple Analytics and Fathom (closed) https://lwn.net/Articles/824294/ : more alternatives: Matomo and Open Web Analytics (fairly heavyweight but both open source), Countly (open core), Snowplow Analytics (open source but enterpr…

Fathom started as an open source project and then closed- when called on it one of the cofounders got extremely hostile and lied about saying it would stay open (then blocked people who shared the screenshots). Plausible on the other hand has been really engaged with the community on their Github Discussion board.

ahh that upsets me, i proposed and implemented it for a client about 6 months ago

Re: Ask HN: Good open source alternatives to Google Analytics?

#77
post #61

PostHog: https://github.com/PostHog/posthog if you want to deploy it yourself and https://posthog.com if you want the SaaS. I was using Avodocs ( https://www.avodocs.com ) to produce a privacy policy for our MLOps platform, https://iko.ai , but they didn't have PostHog in the list for the "Analytics" section, and they assumed that doing analytics implied sending user data to a third party site or something. I tweeted…

Side question. Posthog describes an event pipeline. Is there a saas/open source server with event pipelines where you can do add logic to do things, like: send email, notifications, send api call, maybe add custom logic etc. Ive seen things like segment.io, but didn't find a straightforward solution. Example: - if a user finished three workouts, send this notification. - if a user hasn't done a workout in a week remi…

PostHog released plugins recently (posthog.com/plugins) - these let you trigger webhooks in other systems based on realtime events that have taken place (as well as exporting/importing data/transformations etc).

You just write a few lines of TypeScript in the platform (avg LOC is something like 80) - see https://posthog.com/docs/plugins/build. There are a bunch prebuilt too.

Disclaimer: I work there

Re: Ask HN: Good open source alternatives to Google Analytics?

#78

Of the answers posted here I am curious if any of them are suitable for mobile (iOS/Android) or desktop (Mac/Windows) apps, or if they are all web-oriented?

PostHog has iOS/Android/Flutter/React Native libraries for analytics - full details https://posthog.com/docs/integrate#client-libraries. We don't have session recording / feature flags everywhere yet though (I work there)

Re: Ask HN: Good open source alternatives to Google Analytics?

#79

https://panelbear.com/ isn’t open source but privacy friendly. I found it on HN (the founder is on here), can’t speak more highly of it. If you are tracking more than one site and want to get a good overview I recommend it.

Panelbear is truly great. I moved crontab.guru to panelbear in October and I’ve been extremely happy. The site does millions of page views a month but the analytics are still fast and responsive.

crontab.guru is really amazing

Re: Ask HN: Good open source alternatives to Google Analytics?

#80

https://www.goatcounter.com/

I switched to goat counter recently and I’m happy with it. It’s not exactly an open source alternative to Google Analytics, because it’s more privacy oriented. If you want to track and profile your audience, it’s probably not what you want. I just want to get traffic numbers by page, though, so it’s perfect. They even support a hit counter pixel instead of adding a script tag if you want even more minimal, privacy-fr…

> They even support a hit counter pixel instead of adding a script

Or putting the pixel in a noscript tag lets you have some stats when JS is disabled.

Post reply on HN