asopi tech
asopi techIndie Developer

Asopitech With · Social fitness network

Strava with Alopex DB & Alopex Skulk

Strava is a social fitness network for recording and sharing runs and rides. What if we rebuilt it with Alopex DB and Alopex Skulk?

Updated: Oct 12, 2026

What the service does

Strava records and shares running and cycling activities. Fixed stretches of road are registered as segments, so people who covered the same stretch can compare times. The data is activities, heart rate, speed and position during the workout, and segments.

Where the data lives

  • Skulk time series: heart rate, speed, cadence and elevation are appended to Skulk, tagged by activity. Per-stretch averages and maximums come from time-bucketed aggregation.
  • Alopex DB tables: activities, gear, segments and segment efforts live in tables. Segment rankings come from SQL over the efforts table.

Writing the readings from devices and detecting when a segment was covered are app code.

Deployment

Skulk and Alopex DB are embedded in the app on the device. Readings collect on the device during the workout and keep going on a mountain trail with no signal. Shared segment rankings are served by an Alopex DB server.

Why Alopex DB and Alopex Skulk fit

Workout data is both fine-grained time series and a list of activities. Skulk ingests and aggregates the time series, Alopex DB holds activities and segments, and the device and the server use the same SQL.

Alopex Skulk for the time series during a run, Alopex DB for activities and segments. Give that pair a try for a workout app.