Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread Basic client/server access to a MySQL db server
Mon, Jan 28 2013 2:48 AMPermanent Link

thetoolwiz

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.)
Mon, Jan 28 2013 5:56 AMPermanent Link

Matthew Jones

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/
Mon, Jan 28 2013 9:34 AMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate


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.)
Mon, Jan 28 2013 3:44 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< 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 ! Smile), 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
Mon, Jan 28 2013 3:58 PMPermanent Link

Steve Gill

Avatar

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

Thanks Tim. Smile
Mon, Jan 28 2013 8:20 PMPermanent Link

thetoolwiz

Mon, Jan 28 2013 8:38 PMPermanent Link

thetoolwiz

Mon, Jan 28 2013 8:40 PMPermanent Link

thetoolwiz

Isn't there any way to edit or delete posts here?
Tue, Jan 29 2013 2:56 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

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]
Image