this post was submitted on 10 Oct 2023
25 points (100.0% liked)

Selfhosted

60451 readers
912 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago
MODERATORS
ruud@lemmy.world
Loki@lemmy.world
CannaVet@lemmy.world
devve@lemmy.world
ayyy@sh.itjust.works
curbstickle@anarchist.nexus
curbstickle_lw@lemmy.world
25
Looking for simple analytics (similar to Plausible) that supports cookies (upvote.au)
submitted 2 years ago* (last edited 2 years ago) by dan@upvote.au to c/selfhosted@lemmy.world
13 comments fedilink hide all child comments
 

Google Analytics is broken on a bunch of my sites thanks to the GA4 migration. Since I have to update everything anyways, I'm looking at the possibility of replacing Google Analytics with something I self-host that's more privacy-focused.

I've tried Plausible, Umami and Swetrix (the latter of which I like the most). They're all very lightweight and most are pretty efficient due to their use of a column-oriented database (Clickhouse) for storing the analytics data - makes way more sense than a row-oriented database like MySQL for this use case.

However, these systems are all cookie-less. This is usually fine, however one of my sites is commonly used in schools on their computers. Cookieless analytics works by tracking sessions based on IP address and user-agent, so in places like schools with one external IP and the same browser on every computer, it just looks like one user in the analytics. I'd like to know the actual number of users.

I'm looking for a similarly lightweight analytics system that does use cookies (first-party cookies only) to handle this particular use case. Does anyone know of one?

Thanks!

Edit: it doesn't have to actually be a cookie - just being able to explicitly specify a session ID instead of inferring one based on IP and user-agent would suffice.

you are viewing a single comment's thread
view the rest of the comments
[โ€“] shrippen@feddit.de 1 points 2 years ago (1 children)

Have a look at umami https://github.com/umami-software/umami

[โ€“] dan@upvote.au 1 points 2 years ago* (last edited 2 years ago)

Umami is one I'm considering. I don't think it allows a session ID to be provided though.

It also uses a row-based database (like MySQL or PostgreSQL) rather than a column-based database (like Clickhouse), which for analytics data is way less efficient and significantly slower once you have a lot of data. Pretty much all queries you'd want to run load a lot of data by column rather than row (eg charts of most common browsers, countries, etc over the past 6 months) so they benefit greatly from a columnar database.