umami/db/clickhouse/migrations
Mike Cao ce9e2416fb Add Web Vitals performance tracking (LCP, INP, CLS, FCP, TTFB)
End-to-end performance metrics tracking: dedicated database table with
percentile aggregation, tracker collection behind data-perf attribute,
/api/send handling, report API endpoints, and Performance dashboard page
with threshold-based metric cards, time-series chart, and per-page breakdown.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-08 19:25:20 -08:00
..
01_edit_keys.sql update backfill script. 2023-07-10 22:29:38 -07:00
02_add_visit_id.sql change views back to pageviews 2024-03-27 11:17:00 -07:00
03_session_data.sql update CH schema/migration to include session_data 2024-04-08 16:36:31 -07:00
04_add_tag.sql add tags table and filters logic 2024-10-15 16:46:57 -07:00
05_add_utm_clid.sql fix ch migration script 2025-04-13 18:46:53 -07:00
06_update_subdivision.sql app and db schema - region rename, hostname move 2025-04-24 22:42:33 -07:00
07_add_distinct_id.sql distinct_id schema changes and search on sessions page 2025-04-29 08:57:58 -07:00
08_update_hostname_view.sql change pagestable to visitors and update clickhouse hostname column to array 2025-07-13 22:44:09 -07:00
09_add_performance.sql Add Web Vitals performance tracking (LCP, INP, CLS, FCP, TTFB) 2026-02-08 19:25:20 -08:00