This service is the first-party telemetry backend for sqlMate.
It exists to measure:
- DMG/App Store installs that actually opened the app
- currently active users via heartbeats
- rolling active-install metrics such as DAU, WAU, and MAU
- public aggregated counters for
sqlMate-landing
- Runtime:
TypeScript - API framework:
Hono - Validation:
Zod - Database:
Postgres - ORM / SQL tooling:
Drizzle ORM - Hosting:
Cloudflare Workers - Managed Postgres:
Neon - Tests:
Vitest
Honokeeps the API tiny and fast for a 2-3 endpoint service.Cloudflare Workerskeeps ops low and deployment simple.Postgresgives reliable aggregation queries for active-user metrics.Drizzle ORMkeeps schema and SQL explicit without adding heavy framework complexity.- This stays fully first-party, which is a cleaner privacy/App Store story than embedding a third-party analytics SDK directly in the Mac app.
The first version will support:
POST /v1/telemetry/sessionPOST /v1/telemetry/heartbeatGET /v1/public/stats
It will not support:
- per-user accounts
- dashboards inside the service
- cross-device identity
- detailed event analytics beyond install/activity tracking
- vendor forwarding to PostHog or Mixpanel
total_installs_opened: count of uniqueinstallation_idvalues ever seenactive_30d: uniqueinstallation_idvalues seen in the last 30 dayscurrently_active: uniqueinstallation_idvalues with a heartbeat in the last 10 minutesdownloads: tracked separately from the app install ID flow, usually via landing-page or file-delivery tracking