Could you provide an example for how to update an external MySQL database?

[Nick Weston]

I noticed the tutorials which demonstrate how to create REST services to update a database inside Appery.io but is it possible to update any external MySQL database (for example, on a web host)?

[Alena Prykhodko]

Hi Nick!

Yes, you can update any externally hosted database in the same way.

[Nick Weston]

Hi Alena,

Can you give me an example? For example, if I create exactly the same table (but in an external MySQL database) as in this tutorial (http://docs.appery.io/tutorials/build...) for connecting to an Appery.io-hosted database table called "Wedding"...I get stuck on this step:

"From Projects view, Create New Database Services, select “Wedding” database"

...because I can only select from databases created in Appery.io.

[Alena Prykhodko]

You'll need to set up this service manually, go Create New Service Create service.

[Nick Weston]

Ok, so that leads back to my original question (because the setup process for externally-hosted db is different than for an Appery-hosted db): Could you provide an example for how to update an external MySQL database?

Based on my limited understanding, the data in an Appery-hosted db is automatically exposed via RESTful APIs...but what if the db is an externally-hosted MySQL database (i.e., on a web host)?

Thanks!

[Igor]

Hello,

Please take a look at similar question: https://getsatisfaction.com/apperyio/...
You could use RestXpress http://www.exadel.com/restxpress