Non-file based database logging?
Hi there. Hoping I can gain a little bit of help with something I have been trying to wrap my head around. Long story made short I have a likely ~2500 mile (one way) road trip coming up in the next couple months and my nerd side is going nuts and wanting to set up a live tracking page on my web server with GPS data, OBD data, and pretty graphs and mapping however I can manage to get it going. Hardware setup currently planned is going to be my primary notebook, a bluetooth OBD adapter which I already have and extensively tested with approval from me, an old Nextel phone which will function as the GPS source (outputs standard NMEA over the USB port and stays charged at the same time, not to mention fairly accurate and quick locks), either GPSGate or Xport or both to split the signal for multiple applications as I need them, and most importantly a Mifi for 3G data.
My original thought was quite simple: Log to a MySQL db up on the server and parse it appropriately server side in PHP. All this I know well on my own short of actually getting the data up there. OBDII GPS Logger is the closest thing I have found to what I am wanting to accomplish but is missing that last key part of getting the data the right way so it isn't overly convoluted or difficult to get live data sent over the net and parsed elsewhere. Considering the laptop in question is running Windows, the plan would be to use Cygwin obviously to run it given it doesn't pose further problems. Otherwise could probably run a small temporary VM just for OBD GPS Logger. But this is preferably last resort. As it is running through my head now, software overload is inevitable. lol.
Any further insight and help on this is greatly appreciated. :)