A self-hosted personal rowing tracker for Concept2 RowErg athletes. Syncs automatically from the Concept2 Logbook API, tracks personal bests, generates daily workouts, and turns your metres into virtual journeys around the world.
Built with Flask, SQLite, and Docker. Runs on a home server at a single port with no external dependencies.
Your server, your credentials, your data. Row Tracker is 100% self-hosted — there is no Row Tracker backend and nothing runs on infrastructure anyone else controls. You run the container yourself and supply your own Concept2 API credentials, so it talks directly to your Concept2 Logbook account, not through any server of ours. All data (workouts, PBs, badges, journeys) is stored in a SQLite file on your own machine, under your own control. Two features are the exceptions worth calling out explicitly: the optional AI coaching feature (workout context sent to Anthropic's API using an API key you provide — see AI-Assisted Coaching below), and the in-app 💬 Feedback button, which emails the developer directly using your own SMTP credentials — see below for what that does and doesn't send.
Dashboard
- Circular gauge for lifetime metres, progress toward the next milestone (100k up through 100M)
- Mini pace-trend and weekly-volume sparklines
- "Your Progress" checklist — every active or completed virtual journey at a glance
- "Journey Map" teaser — a decorative mini map preview of your most-progressed active journey, linking through to its full route page
Training Data
- Automatic sync from the Concept2 Logbook API — nightly at 3:00 AM, or on demand
- CSV import for seasons rowed before API access existed — upload a Concept2 Logbook export, duplicates skipped automatically
- Export workout history and personal bests as CSV or JSON, for use outside the app or as a portable backup
- Full workout history with paginated list and enriched detail view
- Enriched workout detail — heart rate (min/avg/max/ending with zone classification), per-split breakdown, avg watts, drag factor, stroke count
- Per-stroke pace & stroke-rate chart on the workout detail page, fetched from Concept2 on first view and cached
- 52-week volume heatmap — click any day to see that session's details
Personal Bests
- 8 categories: 100m, 500m, 1000m, 2000m, 5000m, 10000m, 30min, 60min
- Recalculated automatically after every sync
- Improvement delta vs previous PB
- Stale flag for PBs not tested in 90+ days
Charts
- Pace over time with 10-session rolling average
- Stroke rate vs pace efficiency scatter
- CAWR (acute:chronic workload ratio) load management chart
Workout of the Day
- Rule-based periodization engine — reads last 28 days to set training phase
- Target pace calculated from your 2k PB with zone offsets
- Warm-up, main set, cool-down, and coaching notes generated daily
- Optional AI-assisted coaching narrative (
USE_AI_WOD=true+ANTHROPIC_API_KEY) — Claude Haiku writes the warm-up/cool-down/coaching text for each WOD, tailored to your recent training load; the structured workout itself stays rule-based, and it falls back to the static text automatically if the API is unavailable - Random WOD generator — choose intensity, effort level, and workout type; your free-text notes are passed to the AI coach when enabled
- 27 distinct workout templates
- WOD history calendar — browse past months day by day, colour-coded for pending vs. completed, click any day for the full workout detail
Gamification
- 17 badges across Performance, Volume, Consistency, and Efficiency categories
- Season challenges — quarterly distance, PB attempts, consistency, monthly volume
- You vs. Past You — compare this month against last month, 3 months ago, and 12 months ago
- Stale PB nudges on the Achievements hub
- Email notifications when you earn a badge, cross a lifetime-metres milestone, or complete a virtual journey
Virtual Journeys
- Row the world's great routes — metres rowed move you along the route in real time
- Rhine River — Basel, Switzerland to Rotterdam, Netherlands · 820 km · 14 waypoints
- Holland Tour — Amsterdam scenic loop · 550 km · 17 waypoints
- Trans-Canada Highway — Victoria, BC to St. John's, NL · 7,821 km · 23 waypoints
- Route 66 — Chicago, IL to Santa Monica, CA · 3,940 km
- Waypoint ETAs based on 28-day rolling average pace
- Click any waypoint (map or list) for a popup with details and a Wikipedia link
- Multiple journeys can run simultaneously
Other
- Nightly automated database backup (30-day retention), written to
data/backups/ - Dark mode default with light mode toggle (persisted)
- Fully responsive — iPhone and iPad optimised with hamburger nav drawer
- Installable as a home-screen app (PWA) — manifest, app icon, and a service worker that caches static assets for a faster reload
- In-app feedback form (email delivery via Flask-Mail)
- FAQ and Quick Start guide included
| Layer | Technology |
|---|---|
| Backend | Python 3.11 · Flask · SQLAlchemy · Flask-WTF (CSRF) |
| Database | SQLite (single file, Docker volume) |
| Scheduler | APScheduler (embedded, nightly sync) |
| Frontend | Jinja2 · Vanilla JS · Chart.js |
| Container | Docker · Docker Compose |
| Flask-Mail · Gmail SMTP | |
| Data source | Concept2 Logbook API |
- Docker and Docker Compose — on Mac or Windows, the easiest way to get both is Docker Desktop, which bundles Compose automatically. On Windows, Docker Desktop requires WSL2, which its installer will prompt you to enable if it isn't already. On Linux, install Docker Engine directly (Compose is included as the
docker composeplugin in current versions). - A Concept2 Logbook account with workout history
- A Concept2 API bearer token (request from log.concept2.com)
- A Gmail account with an app password (for the feedback email feature)
1. Clone the repo
git clone https://github.com/dsubtle1/row-tracker.git
cd row-tracker2. Create your .env file
cp .env.example .envEdit .env and fill in your credentials:
SECRET_KEY=your-secret-key-here
C2_CLIENT_ID=your-c2-client-id
C2_CLIENT_SECRET=your-c2-client-secret
C2_REFRESH_TOKEN=your-c2-bearer-token
MAIL_USERNAME=your-gmail@gmail.com
MAIL_PASSWORD=your-gmail-app-password
USE_AI_WOD=false
ANTHROPIC_API_KEY=
ANTHROPIC_API_KEY is only needed if you set USE_AI_WOD=true — get one at console.anthropic.com.
The repo already includes a docker-compose.yml — nothing to write yourself, shown here so you can see what it does before running it (or copy the service block into an existing compose stack):
services:
row-tracker:
build: .
container_name: row-tracker
ports:
- "7376:7376"
volumes:
- ./data:/app/data
- ./csv-data:/app/csv-data:ro
env_file:
- .env
restart: unless-stopped3. Build and run
docker compose up -d --build4. Open the app
http://localhost:7376
Click Sync Workouts on the dashboard to pull in your full workout history from the Concept2 Logbook.
Everything in Row Tracker works fully offline with USE_AI_WOD=false (the default) — the WOD engine is entirely rule-based and never makes an external call. If you opt in by setting USE_AI_WOD=true and supplying your own ANTHROPIC_API_KEY:
- Row Tracker sends a small amount of workout context (workout type, target pace, recent training load, and any notes you typed into the Random WOD Generator) directly to the Anthropic API, using the key you provided.
- Anthropic's response — just the coaching text — is used to replace the warm-up/cool-down/coaching notes for that WOD. No other data (your name, account, history, or PBs beyond what's needed for that one prompt) is sent.
- Leave
ANTHROPIC_API_KEYblank (the default) and this feature is completely inert.
Everything else — sync, PBs, badges, journeys, charts — is between your server and the Concept2 API only, with one other exception below.
Every deployment's 💬 Feedback button sends to the developer's inbox, not your own — the recipient is fixed in the code, not something your .env controls. It sends using your configured Gmail credentials (MAIL_USERNAME/MAIL_PASSWORD), but the destination is always the same regardless of who's running the instance. It sends: the category you picked, an optional name you type in (defaults to "Anonymous"), your message, and which page you were on. Nothing else — no account data, no workout history, no PBs.
This is separate from badge/milestone/journey-completion emails, which use NOTIFY_EMAIL and go to your own inbox (see the Features list above) — those never leave your server's control.
If you'd rather not send anything to a third party at all, don't fill in Gmail credentials — the Feedback button will just fail with an on-screen error instead of silently doing nothing, so this is a deliberate opt-out (no .env flag currently gates it separately from AI coaching's USE_AI_WOD).
row-tracker/
├── app.py # Flask app factory
├── models.py # SQLAlchemy models
├── c2_api.py # Concept2 API client
├── pb_engine.py # Personal best calculation
├── badge_engine.py # Badge evaluation
├── wod_engine.py # WOD generation
├── ai_coach.py # Optional AI coaching narrative for WODs (USE_AI_WOD)
├── scheduler.py # APScheduler jobs: nightly sync, PB recalc, badges, backup
├── backup.py # Nightly SQLite backup with retention pruning
├── notify.py # Email notifications: badges, milestones, journey completions
├── blueprints/
│ ├── tracker.py # Core routes and HR zone filters
│ ├── wod.py # Workout of the Day routes
│ ├── gamification.py # Badges, challenges, journeys
│ └── feedback.py # Feedback form
├── templates/ # Jinja2 HTML templates
├── static/ # CSS, JS, PWA manifest and icons
├── data/ # SQLite database + nightly backups (Docker volume)
├── .env.example # Environment variable template
├── VERSION # Current SemVer, read by app.py at startup
├── CHANGELOG.md # Release history
├── docker-compose.yml
└── Dockerfile
- Force-curve / drive-recovery-time visualisation per stroke (basic pace & stroke-rate-over-time chart already shipped)
- Real map overlays for virtual journeys (Leaflet.js + OpenStreetMap)
- Publish pre-built images to a registry (e.g. GHCR) via GitHub Actions on each version tag, so
docker-compose.ymlcan pull instead of building from source — likely multi-arch (amd64 + arm64) for Raspberry Pi/NAS setups
Bug reports, small fixes, and doc corrections are welcome — see CONTRIBUTING.md for how to get set up and what's most useful.
MIT License — free to use, modify, and distribute with attribution.
Copyright (c) 2026 dsubtle1
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Built for a Concept2 RowErg. Tested on a Proxmox homelab with Docker and Portainer.