Activity Synchronization & Data Grid Engine

Effortlessly synchronize your entire Strava history into SQL and manage your telemetry with a DataTables 2.x activity grid.

The Concept of Synchronization

Kinetiqo acts as a bridge between the Strava OAuth 2.0 API and your local relational database. It offers two distinct synchronization modes tailored for speed and accuracy:

⚡ Incremental Fast Sync (`FAST_SYNC`)

Fetches only activities newer than the most recent entry stored in your database. Lightweight, instant, and ideal for automated scheduling every 15 minutes.

🔄 Full Audit Sync (`FULL_SYNC`)

Audits your entire Strava activity history, imports missing historical workouts, and reconciles deleted activities. Perfect for daily off-hour maintenance.

Real-Time SSE Progress: During any sync operation, Kinetiqo streams live Server-Sent Events (SSE) progress bars to the web dashboard via HTMX reactivity, keeping you updated on payload parsing and database commits.

Searchable & Filterable Table

DataTables 2.x Activity Grid (`/activities`)

The central command center for your workouts. Powered by DataTables 2.x with client-side SRI protection and instant full-text filtering.

  • Multi-Field Search & Date Range Picker: Filter by workout name, sport type, distance, elevation, power, or custom date spans.
  • Column Reordering (ColReorder): Drag and drop column headers to reorder your view.
  • Persistent State: Column visibility, sorting criteria, search terms, and page lengths are automatically saved to localStorage.
Searchable DataTables Activity Grid

Grid Action Toolbar Buttons

Select single or multiple activity rows to trigger instant action workflows:

☑️ Bulk Selection & Deletion

Select individual rows or check-all to perform batch deletion from your database with CSRF confirmation.

🗺️ Map Track Action

Jump selected activities directly onto the Interactive Leaflet Map to compare GPS tracks.

⚡ Power Skills Jump

Send ride data to the Power Skills Radar Chart to evaluate mean maximal power curves.

🎨 Activity Poster Builder

Open selected workout in the Activity Poster Builder for high-res PNG export.

📊 CSV & PNG Data Export

Export filtered rows directly into CSV datasets or image snapshots via DataTables Buttons plugin.