![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 10 of 12 total |
![]() |
Wed, May 29 2013 12:39 PM | Permanent Link |
Alvaro | Hi all:
I have to deploy an EWB application to run on port 443 (https). For now I'm using the EWB Web Server, but does not have SSL, so I can not develop on that server the application in question. In development projects with EWB, I use the DataSet Manager with ElevateDB, forcing me to use the EWB Web Server in the implementation of the project. ......or so I think. I know I can use the JSON interface to work with tables directly (without using DataSet Manager), but not how. With Apache Server, I have implemented CGI applications with Delphi and MySQL, on port 443. I need a "guide" on how to develop applications with EWB, Apache and ElevateDB. I do not understand even as complement the three platforms, especially about JSON. Some time ago, Tim answered in the Forum plans to implement EWB Web Server with SSL. It would be interesting to know when. Thanks in advance. Alvaro |
Wed, May 29 2013 1:20 PM | Permanent Link |
Matthew Jones | Can I ask what OS your server will be on? And what database are you accessing
(assuming a database is needed)? What server side languages are you familiar with? Would you be able to use a Delphi service installed on a Windows box? Knowing these things may help get a better response. /Matthew Jones/ |
Wed, May 29 2013 2:00 PM | Permanent Link |
Alvaro | Matthew Jones:
Thanks for responding Regarding your questions answered as follows: I'm using Apache on Windows, since I have experience on that platform. Apache lets me secure connections over SSL. The database will be ElevateDB Unicode. (2.12b2) The language I use server side was on Delphi 5 (WebModule VCL), very little HTML and PHP with MySQL. Now I have developed with EWB, but I have very little knowledge of JS: I develop with Delphi XE3 Pro, with ElevateDB Unicode. With respect to a service of Delphi, you refer to a server build with Delphi using Indy libraries for example?? Thanks again.... Alvaro |
Wed, May 29 2013 3:28 PM | Permanent Link |
Ivan Mihailov | You can use ElevateDB for PHP extension, if you have some PHP experience.
Ivan Mihailov |
Wed, May 29 2013 4:20 PM | Permanent Link |
Walter Matte Tactical Business Corporation | I wrote my own server with RealThinClient components - it servers the web pages and does I have code my own responses to EWB Commit and Load - so it can deliver JSON data and JSON Meta Data and do the Add,Insert and Deletes basically I guess doing what Elevates Server does - but - I use StreamSec's SSL for HTTPS.
Look into RealThinClient if you want to roll your own. Walter |
Wed, May 29 2013 10:13 PM | Permanent Link |
Alvaro | Ivan Mihailov and Walter Matte:
Thanks for contributing ideas. They are well received. Regarding PHP, you should think about how to integrate PHP and EWB, all served by Apache. EWB really like me and has a lot of potential, I would not quit. I think the solution is to develop an external server, SSL tunnel and interface with JSON. I visited the site RealThinClient and what I read, it has some similar characteristics to François Piette ICS VCL. And others that make it much more versatile. I was also analyzing the Indy components that brings Delphi XE3. I want to continue using EWB, so I have to think about developing that server. I think the demo "testserver" upload by Tim, is a good start. I'll be back to forum for help with JSON. We must also expect a response from Tim about EWB Web Server with SSL. I look forward to new suggestions... Thanks again Best regards. Alvaro |
Wed, May 29 2013 10:22 PM | Permanent Link |
Raul ![]() | Alrvaro,
There are 2 steps here : 1. Serving up the EWB application with Apache and SSL : trivial since EWB app is just some files (html, js) so any existing Apache install can server up the EWB application itself. 2. Data - this is where you'd need to write your own web service to handle the request, access tables and return JSON. JSON is a fairly simple text format so writing your own back-end service for this is quite trivial using PHP. I ended up implementing the EWB JSON server side support in our product in about 1/2 day for the basic data (handling inserts, edit. deletes took bit longer cause we decided to do some it using web requests and not ewb datasets). See here for JSON reference: http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=JSON_Reference Raul On 5/29/2013 12:39 PM, Alvaro wrote: > Hi all: > I have to deploy an EWB application to run on port 443 (https). > For now I'm using the EWB Web Server, but does not have SSL, so I can not develop on that server the application in question. > In development projects with EWB, I use the DataSet Manager with ElevateDB, forcing me to use the EWB Web Server in the implementation of the project. ......or so I think. > > I know I can use the JSON interface to work with tables directly (without using DataSet Manager), but not how. > With Apache Server, I have implemented CGI applications with Delphi and MySQL, on port 443. > > I need a "guide" on how to develop applications with EWB, Apache and ElevateDB. I do not understand even as complement the three platforms, especially about JSON. > > Some time ago, Tim answered in the Forum plans to implement EWB Web Server with SSL. > It would be interesting to know when. > > Thanks in advance. > Alvaro > |
Thu, May 30 2013 4:45 AM | Permanent Link |
Matthew Jones | I'll just chip in that I used the RemObjects SDK to make a service that acts as a
web server and web service processor. RO-SDK uses Indy's SSL module. Obviously your main aim here is to work out how to make a module that fits into Apache, so it responds to requests. I'd be looking to do a REST or similar service that way. I don't know how it would be done though. The key is that because you are on Windows, you can use Delphi to write the required parts, and that gives you quite a bit of control. /Matthew Jones/ |
Thu, May 30 2013 1:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Alvaro,
<< I have to deploy an EWB application to run on port 443 (https). For now I'm using the EWB Web Server, but does not have SSL, so I can not develop on that server the application in question. In development projects with EWB, I use the DataSet Manager with ElevateDB, forcing me to use the EWB Web Server in the implementation of the project. .......or so I think. I know I can use the JSON interface to work with tables directly (without using DataSet Manager), but not how. With Apache Server, I have implemented CGI applications with Delphi and MySQL, on port 443. I need a "guide" on how to develop applications with EWB, Apache and ElevateDB. I do not understand even as complement the three platforms, especially about JSON. >> The issue here is that you won't be able to do SSL, period, with the EWB Web Server, so port 443/SSL is out with datasets, etc. The best option here is to use something like STunnel to front-end the EWB Web Server with an SSL tunnel: https://www.stunnel.org/index.html << Some time ago, Tim answered in the Forum plans to implement EWB Web Server with SSL. It would be interesting to know when. >> When it gets done, that's about all I can say. Scheduling really doesn't work for me, because the schedule gets destroyed as soon as a I make it. All it takes is one support issue taking too long, or some prior coding taking longer than expected. SSL in the EWB Web Server *is* a priority, though. It's the last thing preventing it being used exclusively for EWB projects. Tim Young Elevate Software www.elevatesoft.com |
Thu, May 30 2013 1:54 PM | Permanent Link |
Alvaro | I thank all who have made contributions on this topic.
Later will study the integration of JSON with PHP. And respond to the suggestion Tim provided. I was testing with OpenSSH and OpenVPN the possibility of making an SSL tunnel. Both options are not complicated for me. Although it is for users to connect to the server, even automating the installation on each of the remote PCs. I will study STunnel to compare with the other options. Thanks for your time and I look forward to the following: << SSL in the EWB Web Server * is * a priority >> Best Regards Alvaro |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Friday, February 14, 2025 at 12:13 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |