/** @jsxImportSource npm:hono@3/jsx */ import { sqlite } from "https://esm.town/v/std/sqlite?v=6"; import { reloadOnSaveFetchMiddleware } from "https://esm.town/v/stevekrouse/reloadOnSave"; import { Hono } from "npm:hono"; function setupTable() { return sqlite.execute(`create table if not exists counter_town ( time timestamp default current_timestamp, user_agent text, country text, referrer text, url text, browser text, device text )`); } // await setupTable(); // when a val is served by saascustomdomains the url field is // https://saascustomdomains.val.run/whatever/the/path/is // TODO - we should probably not expose this to our users // this rewrite removes that and stores the url underneath function removeCustomDomainRewriter(req) { const servedFor = req.headers.get("x-served-for"); return req.url.replace("saascustomdomains.val.run", servedFor); } function countRequest(req: Request) { console.log(req); return sqlite.execute({ sql: "insert into counter_town (user_agent, country, referrer, url, browser, device) values (?, ?, ?, ?, ?, ?)", args: [ req.headers.get("user-agent"), req.headers.get("cf-ipcountry"), req.headers.get("referer"), removeCustomDomainRewriter(req), req.headers.get("sec-ch-ua"), req.headers.get("sec-ch-ua-platform"), ], }); } export function counterTownMiddleware(handler) { return async function(req: Request) { // don't await this so it doesn't add to the timing countRequest(req).catch(e => console.error(e)); return handler(req); }; } const app = new Hono(); export default reloadOnSaveFetchMiddleware(counterTownMiddleware(app.fetch)); app.get("/", async (c) => { return c.html( Counter Town

Counter Town

Beta

Medium-scale web analytics powered by Val Town

Simple and privacy-focused for personal blogs and community sites

Get Started Browse the demo

Powered by Val Town

Counter.town runs entirely on Val Town's infrastructure, utilizing Val Town SQLite (Turso) for data storage.

Perfect for Small to Medium Sites

Ideal for personal blogs and community websites. Easy upgrade paths available as your needs grow.

Privacy-Focused

No cookies set. You have full control over your data. Retention policies customizable.

Open Source

Counter.town is{" "} open source on Val Town . Contribute, customize, and make it your own.

, ); }); // zipped execute async function execute(sql) { const results = await sqlite.execute(sql); return results.rows.map(row => Object.fromEntries(results.columns.map( (column, i) => [column, row[i]], )) ); } app.get("/dashboard", async (c) => { const timeRange = "7 days"; const stats = await execute(` SELECT COUNT(*) as views, COUNT(DISTINCT url) as visits, COUNT(DISTINCT user_agent) as visitors FROM counter_town WHERE time > datetime('now', '-${timeRange}') `); // Chart data const chartData = await execute(` SELECT date(time) as date, COUNT(*) as value FROM counter_town WHERE time > datetime('now', '-${timeRange}') GROUP BY date(time) ORDER BY date(time) `); // Top paths const topPaths = await execute(` WITH parsed_urls AS ( SELECT CASE WHEN instr(url, '://') > 0 THEN CASE WHEN instr(substr(url, instr(url, '://') + 3), '/') > 0 THEN '/' || substr(substr(url, instr(url, '://') + 3), instr(substr(url, instr(url, '://') + 3), '/')) ELSE '/' END ELSE CASE WHEN instr(url, '/') > 0 THEN substr(url, instr(url, '/')) ELSE '/' END END AS path, user_agent, time FROM counter_town ) SELECT path, COUNT(DISTINCT user_agent) as visitors, COUNT(*) as views FROM parsed_urls WHERE time > datetime('now', '-${timeRange}') GROUP BY path ORDER BY visitors DESC LIMIT 10 `); // Top referrers const topReferrers = await execute(` SELECT COALESCE(referrer, '(none)') as referrer, COUNT(DISTINCT user_agent) as visitors FROM counter_town WHERE time > datetime('now', '-${timeRange}') GROUP BY referrer ORDER BY visitors DESC LIMIT 10 `); // Top browsers const topBrowsers = await execute(` SELECT COALESCE(browser, '(unknown)') as browser, COUNT(DISTINCT user_agent) as visitors FROM counter_town WHERE time > datetime('now', '-${timeRange}') GROUP BY browser ORDER BY visitors DESC LIMIT 10 `); // Top countries const topCountries = await execute(` SELECT COALESCE(country, '(unknown)') as country, COUNT(DISTINCT user_agent) as visitors FROM counter_town WHERE time > datetime('now', '-${timeRange}') GROUP BY country ORDER BY visitors DESC LIMIT 10 `); // Top devices const topDevices = await execute(` SELECT COALESCE(device, '(unknown)') as device, COUNT(DISTINCT user_agent) as visitors FROM counter_town WHERE time > datetime('now', '-${timeRange}') GROUP BY device ORDER BY visitors DESC LIMIT 10 `); return c.html( Counter Town

Counter Town

📅

Views

{stats.views}

Visits

{stats.visits}

Visitors

{stats.visitors}

{/* We'll need to implement a server-side chart solution or use a simple HTML table for now */} {chartData.map((data) => ( ))}

Date	Value
{data.date}	{data.value}

Top Paths

{topPaths.map((path) => ( ))}

Path	Visitors	Views
{path.path.slice(1)}	{path.visitors}	{path.views}

, ); });