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.

<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

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.

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.

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.

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 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.

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

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

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?