Hello. I've been tinkering around with the Arduino for a while and am working on my first serious project.
I would like to store environmental sensor data collected by sensors attached to an arduino and transmitted via xbee in a mySQL database for later use. I can find good documentation and examples on everything except on perhaps the most critical part - taking data from the serial port of the always-on computer (Synology DS - linux) and inserting it into the mySQL db. I've managed to use php to talk to an arduino using the serial class but have so far not found any information about using php to move serial data from the arduino into the mySQL db despite spending many hours combing through forums, tutorials, etc.
Is php the best way to go and if so are there any examples out there?
I've also considered putting together a python script that reads from the serial port and inserts the data into the mySQL db. Would this be a workable solution and if so any idea if there are sample scripts avaiable to get me started?
Any and all comments are appeciated.