Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 10 of 12 total |
Web Server in source code included, or have anyone build a module for anydac (firedac)? |
Mon, May 27 2013 9:09 AM | Permanent Link |
Harald | I would like to know if the source code for the Web Server is included. Especially the part with the JSON ADO converter. I like to have a anydac (firedac) connection and don't like to build it from zero.
Thank you in advance for any help. |
Mon, May 27 2013 11:48 AM | Permanent Link |
Matthew Jones | <Harald> wrote:
> I would like to know if the source code for the Web Server is included. > Especially the part with the JSON ADO converter. I like to have a anydac > (firedac) connection and don't like to build it from zero. > > Thank you in advance for any help. I don't know the answer to this, but it is worth asking questions about security in any such interface. I don't know the supplied server at all, but access to the underlying database needs to be controlled in some way. If you are using the application entirely internally, then you maybe don't need to worry, but otherwise you need some sort of authentication. Given that the source of the application is sitting in the browser, and easily accessible to anyone, that authentication should not be in code. If a server allows you to add, edit and delete data then care is needed. One option to consider is whether you should use a REST interface, or other system like the RemObjects SDK (which I use). You can then write your web service server to dish out JSON using the standard JSON library, and access any data you wish, with full control over what the interface is and what can be done to the data. I am using https, a password (with optional storage on the device for ease of use) and the service has a DBISAM database underneath (because I'm too familiar with it!). It may be that these issues are all handled in the standard server, but it is not hard to make your own to satisfy your needs exactly. -- Matthew Jones |
Mon, May 27 2013 12:50 PM | Permanent Link |
Harald | Matthew Jones wrote:
<Harald> wrote: > I would like to know if the source code for the Web Server is included. > Especially the part with the JSON ADO converter. I like to have a anydac > (firedac) connection and don't like to build it from zero. > > Thank you in advance for any help. I don't know the answer to this, but it is worth asking questions about security in any such interface. I don't know the supplied server at all, but access to the underlying database needs to be controlled in some way. If you are using the application entirely internally, then you maybe don't need to worry, but otherwise you need some sort of authentication. Given that the source of the application is sitting in the browser, and easily accessible to anyone, that authentication should not be in code. If a server allows you to add, edit and delete data then care is needed. One option to consider is whether you should use a REST interface, or other system like the RemObjects SDK (which I use). You can then write your web service server to dish out JSON using the standard JSON library, and access any data you wish, with full control over what the interface is and what can be done to the data. I am using https, a password (with optional storage on the device for ease of use) and the service has a DBISAM database underneath (because I'm too familiar with it!). It may be that these issues are all handled in the standard server, but it is not hard to make your own to satisfy your needs exactly. -- Matthew Jones Thank you for answer. I'm new in the www and of course security is important. I will take a look at RemObjects, but my hope is that the provided server can use in real world applications too. |
Mon, May 27 2013 2:17 PM | Permanent Link |
Raul Team Elevate | Harald,
Not in EWB itself. There is a web server component in ElevateDB which i assume the EWB server is based on but that's just a guess. You might want to email supprot direct to ask this. JSON converter i would assume is same for all of the backend db access methods - since it's in delphi i would assume the web server just gets the TDataSet and then JSON works on that. Look in demos newsgroup for the the "Test Web Server" that Tim posted - that has most of the code needed for JSON side and likely is an earlier version of the web server he now ships. Raul On 5/27/2013 9:09 AM, Harald wrote: > I would like to know if the source code for the Web Server is included. Especially the part with the JSON ADO converter. I like to have a anydac (firedac) connection and don't like to build it from zero. |
Tue, May 28 2013 7:43 AM | Permanent Link |
Harald | Raul wrote:
Harald, Not in EWB itself. There is a web server component in ElevateDB which i assume the EWB server is based on but that's just a guess. You might want to email supprot direct to ask this. JSON converter i would assume is same for all of the backend db access methods - since it's in delphi i would assume the web server just gets the TDataSet and then JSON works on that. Look in demos newsgroup for the the "Test Web Server" that Tim posted - that has most of the code needed for JSON side and likely is an earlier version of the web server he now ships. Raul On 5/27/2013 9:09 AM, Harald wrote: > I would like to know if the source code for the Web Server is included. Especially the part with the JSON ADO converter. I like to have a anydac (firedac) connection and don't like to build it from zero. Hello Raul, thank you so much. At the first look insert/modify is missing, but I think it puts me in the right way and it is what I am searching for. |
Tue, May 28 2013 3:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harald,
<< I would like to know if the source code for the Web Server is included. Especially the part with the JSON ADO converter. I like to have a anydac (firedac) connection and don't like to build it from zero. >> EWB 1.02 includes TEWBDatabaseAdapter and TEWBDataSetAdapter components and has support for custom dataset modules in the web server, and these two features will allow you to create web server modules that support custom databases/datasets and use them with your EWB applications. If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com |
Wed, May 29 2013 2:22 AM | Permanent Link |
Harald | "Tim Young [Elevate Software]" wrote:
Harald, << I would like to know if the source code for the Web Server is included. Especially the part with the JSON ADO converter. I like to have a anydac (firedac) connection and don't like to build it from zero. >> EWB 1.02 includes TEWBDatabaseAdapter and TEWBDataSetAdapter components and has support for custom dataset modules in the web server, and these two features will allow you to create web server modules that support custom databases/datasets and use them with your EWB applications. If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com Tim, this sounds perfect. Thank you. |
Wed, Jun 26 2013 12:38 PM | Permanent Link |
Harald | Hello Tim,
I try the new demo "datasetclient" which works fine for displaying data. I use the EWBSRVR, register the module and set "Custom Datasets Module" to "datasetmodule". First: I see no picture Second: If I edit the data and then press commit nothing happens (except the transaction level goes to "no Transaction"). I don't see any changes in biolife.xml. Sorry for the new questions. Harald |
Thu, Jun 27 2013 10:30 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harald,
<< First: I see no picture >> Are you using the code as-is ? How are you compiling the datasetmodule project (what version of Delphi, etc.) ? << Second: If I edit the data and then press commit nothing happens (except the transaction level goes to "no Transaction"). I don't see any changes in biolife.xml. >> That's on purpose - it's using a TClientDataSet, so it doesn't actually update anything in the source .XML file. Tim Young Elevate Software www.elevatesoft.com |
Fri, Jun 28 2013 10:53 AM | Permanent Link |
Harald | Tim,
<< First: I see no picture >> > Are you using the code as-is ? How are you compiling the datasetmodule > project (what version of Delphi, etc.) ? No source code changes and compile with XE 2. Tested. with IE10.09.... and Chrome 27.0.1453.116. I had attached the dll. Hint: I see the TextBlob correct. I check it inside and outside of the IDE. << Second: If I edit the data and then press commit nothing happens (except the transaction level goes to "no Transaction"). I don't see any changes in biolife.xml. >> > That's on purpose - it's using a TClientDataSet, so it doesn't actually > update anything in the source .XML file. If I replace with a standard DataSet would the demo code update the source table. Or must I implement more code to do this? Attachments: datasetmodule.dll |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |