strava-to-sqlite 0.1.1

Create a SQLite database containing data pulled from Strava

Table of Contents

1. strava-to-sqlite
   1. Get started
      1. Install
      2. Auth and fetch
      3. Explore
   2. Roadmap
   3. Links, Resources and Thanks

strava-to-sqlite

Get started

Install

pip install strava-to-sqlite

Auth and fetch

# - Allow auth via browser oauth flow
# - Saves credentials to database
strava-to-sqlite auth strava_dump.db

# - Fetches and stores strava activities since last sync for all users
strava-to-sqlite sync strava_dump.db

Explore

Strava API sends polylines which are transformed to GeoJSON LineString by strava-to-sqlite and can rendered on map with datasette-leaflet-geojson and datasette.

# assuming datasette is installed
datasette install datasette-leaflet-geojson
datasette strava_dump.db

Roadmap

• Overall clean-up/refactor
• Add tests
• Client side rate-limiting and retries
• Option to fetch for individual user (currently fetches for all authenticated users)

Links, Resources and Thanks

• Strava: Forum | Strava API | Rate Limits | Auth | Swagger UI
• Similar Projects
  • stravalib/stravalib
  • brendano257/Strava2SQL
  • ghing/strava-to-sqlite
  • yihong0618/running_page
  • marcusvolz/strava_py