A zero-filled daily series for charts
GROUP BY date skips days with no rows, which makes every chart lie. This fills the gaps before the data reaches the chart.
Stats and Reporting
Date-series queries, dependency-free SVG charts and traffic source reporting.
6 entries
Draw a line chart in SVG with no JavaScript
Server-rendered SVG with native tooltips. No chart library, no CDN, no build step — which is what makes it portable to a site you hand to someone else.
Horizontal bar chart in SVG
For ranked lists — top pages, top referrers, top earners. Horizontal because labels are words, and words do not fit under a vertical bar.
Donut chart in SVG using arcs
Proportions of a whole, drawn with stroked arc paths. Includes the one case that breaks every naive implementation: a single slice at 100%.
A chart palette that works for colourblind readers
Five colours separated by lightness as well as hue, so the chart still reads when the hues collapse — and a rule about never encoding meaning in colour alone.
Count unique visitors without a cookie
A daily rotating hash and a unique index. Honest numbers, nothing personal stored, and no consent banner needed for it.