Using Smart Mobile Studio to interact with a mySQL database

Question

Is there any way what-so-ever of SMS interacting with a mySQL database on my host site?

What if I make the SMS code reside there?

Is there any kind of web code (PHP, Perl, JavaScript, ect. that I can use to call from within the SMS code to perform SQL transactions (Selects, Inserts, Updates, Deletes, etc.)? i.e., can I create a library on the host side to be called from within SMS?

I have a website that has a mySQL backend and I would like to write a small app for my phone that will pretty much be a Mobile version of my site (less many features and graphics)

Thanx

Shane

Answer 1

You can't access mysql directly from a webbrowser (only when it has some kind of http interface with rest/json but no database server has this?). But of course you can call any http server, whether it is made with php or something else, rest, soap, json etc: you only need to know which url and maybe some "low level" javascript in a asm block.

For now, the easiest way would be to make a server in Delphi with RemObjects. In the SmartMobileStudio (SMS) IDE you can import the SOAP-like interface file, and all client side code (pascal) will be generated for you (with type safety)! :)

With some more effort you can make a SOAP server, but then you probably need to make some javascript code yourself (and you need a JS library with SOAP support).

In the next major release there will be support for node.js, which is a server side javascript server! Then it is very easy to acces mysql in node.js (or files etc, it has no webbrowser sandbox) and with socket.io you can easily access this node.js server (in the cloud if you wish) and send data with json. Nice thing with socket.io is that you can also push data to the client, because it supports websockets (realtime two-way tcpip communication over http).