After spending weeks playing with my own 2-year GPS log, I wanted to colorize each track gradiently based on velocity.
While it sounds straight-forward to use the "trackpoints"
table in the same SpatiaLite database to achieve this, it turned out not so. Plotting millions of points is quite slow and …