Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread How to deploy web database application on external hosting site
Sat, Aug 31 2013 7:19 AMPermanent Link

kamran

Hi

I just need some clarification on how i can get an application to run from an externally hosted web setup.

My hosting has a linux/php/mysql setup.

2. How to run the ewb server run on such a setup ? is that even possible or is the web page handling done automatically ?

3. Is is correct that i just copy the deployment folder to the root and point to the .html file to get the application going?

is it that simple ?

4. What about the data access side of things? is that automatic ?

5. In summary what do i need/requirements to run a database type web app on an external hosting site

6. I note that Tim is running his demo web apps from his website .. what setup is he using I wonder ?

Thanks

Kamran
Sun, Sep 1 2013 1:41 AMPermanent Link

Franck - Midi pyrénées - France

Esteves Ducilia

Avatar

Hello Kamram

There are two ways to work with EWB.

The first is to write only the client part (the part that will run on the browser). For that you have to deploy on  your http server files generated by EWB is an html file + and javascript. Nothing else.

Then if you want to work with mysql databases on your linux / apache server / mysql, you have to use TServerRequest to launch a php script as an ajax request (see the guide on this subject). Your script should return data that will treat you to decorate your display. The format fashionable at the moment is the JSON format.  You have a function for that in php.  


The second way is to install the EWB server to access data and use the EWB component to access data. But the server uses only the file format ElevateSoftware ( ElevateDB ou dbisam)
In addition, the EWB server runs on a Windows environment, not Linux.
Sun, Sep 1 2013 2:27 AMPermanent Link

Franck - Midi pyrénées - France

Esteves Ducilia

Avatar

You can also use TDATABASE AND TDATASET  to populate automatically your editing componants  .
In TDatabase, use property URL to specifiy a script php what return json data .

Look at this in the forums

http://www.elevatesoft.com/forums?action=view&category=ewb&id=ewb_general&msg=2937&start=1&keywords=MYSQL&searchbody=True&forum=EWB_Announce&forum=EWB_General&forum=EWB_Binaries&forum=EWB_Themes&forum=EWB_Demos&forum=EWB_Discussion#2937
Mon, Sep 2 2013 11:49 AMPermanent Link

Raul

Team Elevate Team Elevate

> I just need some clarification on how i can get an application to run from an externally hosted web setup.

EWB is used to write client-side applications - meaning they run in the
browser and can be hosted on any web server since they are just
javascript/html/css/etcfiles.

If you application needs to access back end database or more generically
any back-end service then that service needs to be written as well (EWB
is one such back-end but is Windows only).

Specs are well documented as to what the web service has to return :

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=JSON_Reference


> My hosting has a linux/php/mysql setup.

EWB will not work for you so for now you need to write your own back-end
in PHP (see link for JSON reference above).

> 2. How to run the ewb server run on such a setup ? is that even possible or is the web page handling done automatically ?

You can't at this time.


> 3. Is is correct that i just copy the deployment folder to the root and point to the .html file to get the application going?

For the EWB app (client-side) side yes that is all.


> is it that simple ?
For the client side yes - meaning an app that would have no back-end
database would be fully deployed at this time.


> 4. What about the data access side of things? is that automatic ?
No, EWB app simply issues http requests so you need somethign to respond
to those requests - custom web service (or EWB but in your case you
cannot use it).


> 5. In summary what do i need/requirements to run a database type web app on an external hosting site
1. You need database (e.g. mysql)
2. You eitehr run EWB Web Server (if on Windows) OR you need to write
your own web service that can access the database and respond to web
requests from clients (see JSON reference above again for format).
3. You need to develop and deploy your EWB application
4. you need to point the browser to the EWB application html file



> 6. I note that Tim is running his demo web apps from his website .. what setup is he using I wonder ?

He's running on Windows so he is likely using a EWB Web server or
variation of it.

Raul
Tue, Sep 3 2013 1:32 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kamran,

<< 2. How to run the ewb server run on such a setup ? is that even possible
or is the web page handling done automatically ? >>

You cannot currently run the EWB Web Server on Linux, no.

<< 3. Is is correct that i just copy the deployment folder to the root and
point to the .html file to get the application going? >>

Yes.

<< 4. What about the data access side of things? is that automatic ? >>

Not unless you're using the EWB Web Server.  I'm working on a PHP layer that
will work with EDB databases (no DBISAM directly because it doesn't have a
PHP extension) along with any PDO database drivers (MySQL, etc.).

<< 6. I note that Tim is running his demo web apps from his website .. what
setup is he using I wonder ? >>

We're using the EWB Web Server running on Windows Server 2008 R2, listening
on port 8080.

--
If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Image