Files

1.3 KiB

type, title, description, tags, status, generated, verified
type title description tags status generated verified
Decision Own analytics tracker on SQLite Analytics are counted by Noel's own code in the gateway and stored as daily totals in SQLite; no third-party tracker, no Postgres.
decision
analytics
sqlite
go
stable
by at
claude-code/claude-opus-5-5 2026-10-11T12:15:30Z
by at
human:noel 2026-10-11T12:15:30Z

Decision

Write the tracker as middleware in the gateway. Store daily totals in SQLite via modernc.org/sqlite (pure Go, no cgo). SQLite is approved tooling.

Why

  • The gateway already sees every page view, PDF download and fall. No tracking script, nothing for ad blockers to block.
  • About 5 MB of memory, no extra pod. GoatCounter would need ~30 MB, Umami with Postgres ~300-400 MB, on a 4 GB shared server.
  • A learning project: owning the code is the point.

Rejected

Option Why not
Umami Needs Postgres, ~300-400 MB
GoatCounter Fine, but Noel wants his own
Postgres for the own tracker ~40-60 MB for a table of counters
Cloudflare analytics only Cannot count falls or PDF downloads

Revisit when

Noel wants to learn Postgres. The schema is plain SQL, so the move is small.