HTML5 and SQL database

[agraham147]

Hi everyone,

I'm in the process of creating an application which I want to deploy as a Livecode HTML5 Web App. I want my app display data from a SQL database I have set up on my hosting account (cPanel), but I've been made to believe that Livecode web apps don't support SQL database connections. Is this true and how can I code my web app to retrieve data from my database. I'm sorry to say that this is the first time I have tried web based applications and I'm not that experienced in how some things work, although I am happy to learn.

Any help would be greatly appreciated!
Thanks, Aaron

[FourthWorld]

Common industry practice is to protect the DB engine from the open Internet by using an intermediary layer on the server to provide a public-facing API. These often use REST style, but just about any reasonable HTTP access will do.

PHP is the most popular solution for this, though Perp, Python, Node.js, and many others can be used, even LiveCode Server.

[agraham147]

Hi Fourth World,

Thank you very much for your reply. Unfortunately my knowledge and understanding is somewhat limited when it comes to web development. Do I create an API using Livecode Server and are there any examples or tutorials for me to learn? Also, once the API has been developed, does that mean my HTML5 web app will be able to connect to my database on cPanel?

Sorry for all of the questions, I'm just really keen to understand how this works so I can create my end goal.

Thanks,
Aaron