it’s not particulary Rails related question, but I hope you guys can
give me some tips.
I’d like to store in the database routes build of lots of single
points (latitude, longitude, time and maybe altitude and speed if
available) and later display the route i.e. on Google Maps or
Should I store each point as a single row in the db and give it some
route_id field to know which route it belongs to? If i.e. a single
route is built of 1000 points, having 1000 routes gives, well, a lots
Or would it be better idea to create a route model that has blob field
and simply put there all points as binary data and later parse it
every time I need to display the route?
Any suggestions? Thanks in advance