Archive for the ‘GPS’ Category

Standalone GPS SQL logging software for Linux

Thursday, May 10th, 2007

I was not able to find any decent standalone GPS data logging software for Linux (for use in my car computer), so I decided to write my own — and it works pretty well for what I want to do. Of course, I’m not quite sure what the practical implications are, but I guess I’ll figure that out later (and post it here, of course!). Anyways…

geoHist is a (relatively) simple program I wrote to log GPS data retrieved from GPSD into a MySQL database. It is designed to meet the following requirements:

  • Standalone
  • Run from system startup to shutdown
  • Small/fast, non-intrusive
  • Robust
  • Log data to an SQL database

geoHist will poll GPSD every 10 seconds and then send that data to a preconfigured MySQL database. It will attempt to detect if you are standing still, and if you are then it will NOT log the data. It decides this using a simple drift factor. It will always log position to the database at least once if there is a satellite fix.

All this program does is log your data into mysql. You will need to figure out what exactly you want to do with that data. At the moment, I’m not quite sure what I’m going to do with the data either, but if I figure something out I will surely include it in the next release.

I haven’t put it through a ton of use (yet), but it seems to be doing its job quite well. Now all I need to do is figure out a good practical application, and write some scripts to export the data from the database nicely.