How to store GPS coordinates in a PHP web application?

-1

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.

    
asked by anonymous 07.08.2014 / 00:48

2 answers

0

It seems like a very cool project, I would use a faster database, like sqlite, the database could be on a server with ssd disk with high I / O and it does api to insert and fetch records from that server, to feed your application.

I would also make a way to have separate sqlite bases for each device, and would store the access (address) data of sqlite on any basis, be it mysql or postgres.

To do a lot of things, of several different forms, that was the idea I had, good luck

    
07.08.2014 / 01:02
0

Interesting project template, I believe that mysql would have no problem saving this amount of data, but a NoSQL database I think would be a more appropriate solution!

Also review this 5 second interval for sending the coordinates, what kind of communication? 3G? SMS? Radio?

Unfortunately the infrastructure of our country, especially with internet is still precarious, remember that not always have a good signal, and maybe the time of receiving your messages by the service can take more than 5 seconds, queuing and disrupting the process of receiving!

All this is clear, depending on the type of communication you are using, and what is the real need to have this data every 5 seconds. I did something of the sort, ran and supplied all the needs with an interval of 30sec.

Big hug

    
07.08.2014 / 02:44