I'm just getting up to speed with this and I'm trying to find something that explains how to set up a basic client/server model where the app mainly needs to pull data from a back-end MySQL server somewhere.

You seem to have the bases covered as long as someone is using a Windows-based server.  But what about the bazillion LAMP-based hosts that abound?

Maybe you could put together a php module that can run in a LAMP environment and act as a back-end proxy and interface for apps written with this software?  (Maybe you did and I just haven't found it.)

I got this tool because: (1) I'm extremely fluent in Delphi; and (2) I really don't like having to write web apps in php.  I also have lots of server access, 100% of which is LAMP-based. Big corporations can afford the staffs to deal with Windows servers, but I frankly don't want to waste my time with them. (When I look at my server logs, they are stuffed to the gills with traces of attempts by hackers to break-in using exploits that assume vanilla Windows IIS installations. I rarely if ever see traces that suggest they're looking for LAMP environments, which puzzles me mainly because it's pretty easy to query a server and find out whether it's LAMP or Windows-based.)

If you search on Google for "REST Interface for MySQL" you will find a fair few
solutions. Some mention PHP, but you could probably add that to the search.

What I will say though is that you should consider security carefully. Ensure it
uses https and requires a password in the application somehow. Giving full access
unfettered to your database could be dangerous!

/Matthew Jones/

There is not one but all you'd need to do is write the EWB compatible
server service to return the data (assuming you wish to use EWB datasets).
See JSON reference for details:
http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=JSON_Reference

Raul

On 1/28/2013 2:48 AM, thetoolwiz wrote:
> You seem to have the bases covered as long as someone is using a Windows-based server.  But what about the bazillion LAMP-based hosts that abound?
>
> Maybe you could put together a php module that can run in a LAMP environment and act as a back-end proxy and interface for apps written with this software?  (Maybe you did and I just haven't found it.)

<< Maybe you could put together a php module that can run in a LAMP
environment and act as a back-end proxy and interface for apps written with
this software?  (Maybe you did and I just haven't found it.) >>

I've got it on the list (haven't forgotten about you Steve Gill ! ), but
don't have anything completed yet.  Essentially, as Raul indicated, you need
the PHP layer between the MySQL database and the EWB application that can
handle consuming the JSON for transactions as well as emitting the proper
JSON for the datasets.

Tim Young
Elevate Software
www.elevatesoft.com

<< I've got it on the list (haven't forgotten about you Steve Gill ! ), but
don't have anything completed yet.  >>

Thanks Tim.

Maybe this:

https://git.netways.org/mysql-rest-proxy

-David

Maybe this:

https://git.netways.org/mysql-rest-proxy

or this

http://perplexed.co.uk/4497_a_proxy_for_windows_live_rest_ful_interface_in_php.htm

-David

Isn't there any way to edit or delete posts here?

thetoolwiz

>Isn't there any way to edit or delete posts here?

Thankfully not, and the moderator (aka Tim) does a good job of not doing anything.

These newsgroups are both on-line and off-line so whilst the standards allow for posts to be deleted an awful lot of off-line clients don't.

Personally I prefer off line, and I prefer these ngs to ones like Delphi's where the threads are often broken. Wether that is just down to editing or there is some other factor I don't know but editing does seem to destroy the reference link chain.

Roy Lambert [Team Elevate]