From 077aa1700fbcaf3f499c2178e0e58e89ae9dcaf8 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Fri, 25 Sep 2026 08:46:58 +0200 Subject: Chart power vs time for official climb attempts Snapshot average power per attempt in a nullable average_power_w column (backfilled from stored rides), plot each powered attempt on the climb page as duration vs average watts with ride hover and click-through, and show avg power in the attempts table. --- .../20260925061236_ride_official_climb_attempts_average_power.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 db/migrations/20260925061236_ride_official_climb_attempts_average_power.sql (limited to 'db/migrations/20260925061236_ride_official_climb_attempts_average_power.sql') diff --git a/db/migrations/20260925061236_ride_official_climb_attempts_average_power.sql b/db/migrations/20260925061236_ride_official_climb_attempts_average_power.sql new file mode 100644 index 0000000..e0c4bf1 --- /dev/null +++ b/db/migrations/20260925061236_ride_official_climb_attempts_average_power.sql @@ -0,0 +1,6 @@ +-- Average power over the attempt interval; null for rides without a power meter. +-- migrate:up +ALTER TABLE ride_official_climb_attempts ADD COLUMN average_power_w real; + +-- migrate:down +ALTER TABLE ride_official_climb_attempts DROP COLUMN average_power_w; -- cgit v1.3