how to interface arduino project with sql database using EF-COM GSM/GPRS

Projects General Guidance
1

hi everyone.

I really need guidance.

I have developed my arduino project which involves several sensors (hardware part) at the same time I have developed a web application which uses sql database.
what I want to achieve at the end of the day is to send my sensor readings to my database at a fixed interval like after every 15 minutes so that I can be able to display it on a web page.
knowing this I bought a EF-COM GSM/GPRS shield so that I can use it in GPRS mode to send this to my database.
someone gave me an advise to write an API.

I have tried to research but I cant find anything which can help me to achieve m goal.

can you please advise me on how I can go about this and if there are any links you can provide which might help me.

thank you.

2

I accomplished this by attaching my Arduino to a raspberry pi via USB. The raspberry pi runs a python script that wakes up on a regular cron schedule and asks the arduino for data. (I send a "W". by itself... so the arduino knows that means "send data now")

The python script then makes a connection to Mysql for me. That can be either a local Mysql database or one on the Ethernet lan.

This is probably the best way to make this happen... as using an Ethermet shield might be possible... by the time you had the mysql connection coded... you have no ram left for you own code.

It has been done thought... example: example