Pedalytics

Pedalytics is a single-user, single-bike cycling tracker for manually entering completed rides and reviewing simple statistics. It is built as a compact MVP with server-side SQLite persistence, a clean Fastify API, and a polished Svelte interface.

Tech Stack

• Monorepo with npm workspaces
• Frontend: Svelte 5, TypeScript, Vite, Chart.js
• Backend: Fastify, TypeScript
• Database: SQLite with Drizzle ORM
• Validation: Zod
• Tests: Vitest

Install

npm install

Run

Start the API:

npm run dev --workspace @pedalytics/api

Start the web app in another terminal:

npm run dev --workspace @pedalytics/web

The API defaults to http://localhost:3333 and the web app defaults to http://localhost:5173.

To try the app with the committed demo database:

npm run dev:demo

Database

Run migrations:

npm run db:migrate

Add sample locations, settings, and rides:

npm run db:seed

The private SQLite database is stored at apps/api/data/pedalytics.db unless DATABASE_URL is set. This file is ignored by Git and should remain local.

The repository also includes apps/api/data/pedalytics.demo.db, a fake onboarding database that can be used immediately with npm run dev:demo.

Rebuild the demo database:

npm run db:demo:populate

The demo rebuild command wipes and recreates only the demo database, then populates it through the API with fake rides, curated Greater Montreal park destinations, and historical weather snapshots.

Tests

npm test

MVP Scope

• Dashboard summary cards and distance-by-day chart
• Ride CRUD with reusable departure and destination locations
• Location CRUD
• Single-row settings with home location and metric unit preferences
• Weather service abstraction with wind direction conversion and a weather preview endpoint

Not included in this first draft: authentication, multi-user support, multiple bikes, GPX/FIT imports, route computation, live ride tracking, social features, browser-side persistence, or complex analytics.