So, I've been playing around with the GPX file format and PostGIS. My goal is to build a tool where I can run my own server that collects GPX tracks from bike rides, and match them against predefined routes. Like a self-hosted Strava if you like.
I started this because the enshittification of Strava has reached a tipping point and I cannot in good faith upload anything to them anymore.
Once I get this working, I want to add the ability to share rides and favourite segments via the Fediverse. Not entirely sure how far you can take that, but that's something to think about later.
Anyway, it seems I can use PostGIS to match a ride against a set of segments, at least when using a small set of test tracks and some synthetic data that I've generated.
Is there anyone here that is familiar with PostGIS who would be willing to advice me as to whether I'm actually doing this right? I can't help but think that my successful experiments are actually pure luck.