-1
I am making a web application that will monitor the displacement of individuals through receiving every 5 seconds of GPS coordinates.
I can receive the coordinates and plot on the screen with the Google Maps API, however, I need a way to store the data for audit, to later verify the path traveled in a certain period of time.
Initially I thought about Mysql, but this seems a bit expensive, by default, I calculate 1Gb per device, annually.
I’ve also been reading about file-oriented solutions like Mongodb, Cassandra and Hypertable. I even considered XML file storage, with rotation and backup in compressed files.
Have you thought of any kind of compaction or overriding repeated coordinates? Could put a sample of coordinates and the fields you would need to save?
– Jader A. Wagner
I don’t see any problem using Mysql for this solution. I have databases that hold 10 or 20 GB a day and work well.
– TCB13
Perhaps it would be better for you to send in small intervals (10s) only when the difference passed a certain limit, and when they were coordinates within a predefined radius of the one sent last, send in a longer interval (30s, for example). And yet, in the second case, it would even be to check if the signal is alive only, because you instead of storing again, would only update the date/time in DB.
– Bacco