I'm doing a Web application that will monitor the movement of individuals by 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 auditing, to later check the path traveled in a certain period of time.
At first I thought about MySQL, but this seems a little expensive, by the way, I calculate 1Gb per device annually.
I've also been reading about file-oriented solutions like MongoDB, Cassandra, and HyperTable. I even managed to store in XML file, with rotation and backup in compressed files.