Sensor data to database

30 Aug 2011

I am trying to capture sensor data and upload it to a mysql database. I have 100 bytes every 1 second I wish to transmit.

I tried using a insert.php?sensor=1&d0=1&d1=2 etc for 100 bytes, I can get it to work with 70bytes but I think I'm running into a memory issue as it just hangs when trying to http.post the data.

I have a working mysql client program but again when I try and insert it hangs at: while (sqlLastResult == MYSQL_PROCESSING) { Net::poll(); }

I thought about creating a txt file and then pushing that to the server, I've tried reading the httptext and httpfile pages but I can't work my head around how they work and I haven't come across any example of uploading a txt file.

Can anyone suggest how I go about doing this?