Page 1 of 1

how to connect and query a MySql database

Posted: Thu Oct 17, 2013 9:03 pm
by Matt Christenson

I am really trying to figure out the best way to connect to a MySql database and run query's. I am trying to set up the REST service, but I just cannot get it set up properly. I have tried to look for documentation on how to set this up, but I just cannot find any useful information. Any suggestions?
Thank you!


how to connect and query a MySql database

Posted: Thu Oct 17, 2013 9:18 pm
by Alena Prykhodko

Hello Matt!

You can connect to any data source available on the Internet as long as it’s exposed via REST API.
We recommend to use RestXpress http://www.exadel.com/restxpress


how to connect and query a MySql database

Posted: Mon Nov 11, 2013 10:06 pm
by Paul Birch

So does that mean that in order to use appery.io with an external mySQL database, we need to license and install RestXpress @ $2,500/year ?


how to connect and query a MySql database

Posted: Mon Nov 11, 2013 10:24 pm
by maxkatz

That's one option..you do get 30 days trial. You can also use any other tool that will expose your database via REST APIs.


how to connect and query a MySql database

Posted: Fri Nov 15, 2013 4:26 pm
by Corinne

Im using Apperys rest services to connect to php scripts on my server. You cant connect directly with mysql.

I wont run JS on my server so php is a better option.

Works perfectly!!


how to connect and query a MySql database

Posted: Tue Apr 08, 2014 6:49 pm
by Koning Voetbal

Hi Corinne,

Can you give me a small example how to use Appery's Rest Service to connect to php?

I have a mysql database on our own server with a login system.

I want to build an app to connect to this database (a website version is already running for a few years).

As I understand you connect from Appery to a php file in which you goiive all the database query's. How to get this results to appery?

Any help would be appriciated!

Kind regards,

Arie


how to connect and query a MySql database

Posted: Tue Apr 08, 2014 7:18 pm
by Kateryna Grynko