I'm getting ready to start building a simple wireless GPS device. This device will use an arduino, and a cellular GSM module paired with a GPS device (an example is the SIM5320a aka the FONA 3G from adafruit). To be clear I've never used SQL or GPS before but I'm very familiar with cellular GSM devices.
Basically my question is how to wirelessly send the GPS coordinates from the arduino to a remote server such as SQL. I'm not looking for you to do all my work for me. I'm looking for some general answers about how this can be done.
Some ideas I have are using the cellular GSM device to send the coordinates, basically using a data connection. I've sent data to a server before using MQTT which is basically a lightweight communication protocol. However, that is power intensive. I would not like my device to use all it's battery trying to maintain a data connection to the Internet.
Is there a better more power efficient way to get my GPS coordinates into a database? I was wondering if SMS or phone calling could somehow be utilized to get the information where I need it. SMS is much less intense on the batteries and would probably be a lot easier to do.
Can anyone help me out and give me some pointers?