GPS monitoring: Organizing data in a database?

Question

MySQL

I would like to get acquainted with your experience and knowledge of how to store gps data in a database.
I use mysql for the prototype. more familiar with it, BUT I will be glad to hear some other suggestions (besides postgis).
Ideally, based on these tracks, the following is planned:
1. statistics from the series total time, average speed, total distance (this moment can be cached at the time the tracker is added)
2. some separate general data on the track (also added at the time the track is added)
but where i have no idea how to store
3. heat map based on group of tracks
since for such a map we do not need every point of the track, there is an assumption that we need to take the track. and extract from it only those points that fall into a certain interval. then it would be possible to reduce the data dozens of times.
while writing the question himself and thought of it. but still. share your experience?

Answer 1

Create a table for points

---------------------------------------------------------------------
| id | geom(point) | track_id | track_pos | date_time | speed | ... |
---------------------------------------------------------------------

Build a spatial index and calmly cut out the desired areas by bbox.