biking_home/db/migrations/20260913000000_ride_official_climb_attempts.sql, branch mainUnnamed repository; edit this file 'description' to name the repository.
https://git.kagamino.dev/biking_home/atom?h=main2026-09-13T19:55:59ZPersist official climb attempts with climbs pages2026-09-13T19:55:59ZMartin Kagamino Lehouxmartin@lehoux.net2026-09-13T19:55:59Zurn:sha1:e3d0beee5be3dd2854b0f4fc10905a4fcdc08f47
Record one attempt row per (ride, climb, occurrence) when a ride detail
loads, snapshotting distance, elevation gain, slope, cotacol and attempt
timestamps; a climbs-backfill CLI command seeds all existing rides.
New /climbs list page aggregates attempts (medians computed in Go, best
time as min duration) with sortable columns, and /climbs/{id} shows the
median scalar stats, a median normalized elevation profile (50 steps
over each attempt's own length), the full-precision recorded route of
the median-distance attempt on an OSM map, and every attempt with time
at second precision.