remote my SQl call from a microcontroler

[Amalinda]

is there any possibility using a microcontroler such as ARM Cortex-M or MSp430 or PIC to add data to my remote database located at hostgator? (perform a remote DB call)

please note I do not want to use RTOS or any operating system. I strictly want to use C.

let me know if there is at least a conceptual way of doing it.

thanks for all replies.

 

[horace1]

if your microcontroler has a network connection (e.g. ethernet or wireless) or a TCP/IP enabled modem you could use TCP protocols to access the database

 

[Amalinda]

hey Horace1,

thanks for the answer.
yes, my development board (https://www.ti.com/tool/ek-tm4c1294xl) has ethernet. It also has a Wifi sheild(CC300 Wifi cape by TI). Assuming I already have an internet connection through ethernet could you please give me a little guidance to write the code? I only require a little guidance for the SQL part.

my DB ip lets say 124.43.29.78 and DB username USER password : PASSWORD.
DB name : DBNAME and table, DBTABLE.

//lets say internet is given by the following function
ethernet_activate ();

Could you please tell me how I should approach it? where can I find the libraries?

- - - Updated - - -

I found this great article. (its one article altogether)
http://drcharlesbell.blogspot.com/2013/04/introducing-mysql-connectorarduino_6.html
library files : https://launchpad.net/mysql-arduino

but I dont know how I can fit these auduino libraries to any TI ARM Cortex-M or a any PIC or a MSP430G253. I cannot use Auduino since its not allowed.

 

[horace1]

I have never attempted to connect to a MySql server - just simple UDP or TCP connections to my own servers

if you do a web search there are a number of links to sites discussing connecting microcontrollers to MySql, e.g.
https://stackoverflow.com/questions/9999914/can-the-pic32-post-to-a-mysql-database#

https://www.microchip.com/forums/m319295.aspx

 

[Amalinda]

The stackoverflow one is good! thanks.
its simply calling a URL havign all variables in the URL itself.

but my question is
1. How do we make sure the data reached the server with o errors?
2. How to we make sure that this method is secure? may be by usign https?

i think anyhow, there is no need to use remote DB updates over a micro after seeing this method. one should be able to encrypt the data and send.

thanks again!

 

[horace1]

if you use a TCP connection it will tell you if there are errors

encrypt your data if it need to be secure, e.g.
https://www.codeproject.com/Articles/1400/A-C-Implementation-of-the-Blowfish-Encryption-Decr