Mark,

Thank you very much for the detailed explanation. I would say that yours seems like a very clever and sophisticated approach to the REST thing and EWB capabilities. Congratulations.

Regards,
Mario

Mark Brooks wrote:

Mario Enríquez wrote:

>>Mark,
>>Do you use a particular framework for you REST API layer? is it Delphi based?
>>I'm interested in hearing more details about you approach, if it is ok for you to share it.
>>Regards,
>>Mario

Hi Mario - no problem

The REST Server is written by us in .NET. It provides a REST API that can be used to interact with our database. We use this API ourselves for our web clients and also licence it to some customers.

Our web clients are (mostly) written in EWB. We have a library of EWB code that includes a TCastrumConnection class. This class has a method for each of the API commands e.g. TCastrumConnection.GetCastrumTask. Every method includes a callback parameter (at least) to return an HTTP code and any associated JSON.

Inside the TCastrumConnection class we use an EWB TServerRequestQueue to perform the HTTP puts, posts, gets and deletes that make up the API. Even under very heavy duress this mechanism seems highly robust.

Any JSON that is returned by an API call (via the callback) is parsed within an appropriate class e.g. the JSON from a call to TCastrumConnection.GetCastrumTask would be parsed by an instance of TCastrumTask and used to populate that task accordingly. As such we have a wide range of classes that map onto the Castrum REST API.

Hope this makes sense.
Mark

Uli,

I did play a little with the EWB Server and managed to register a sample module and it did worked fine. But wonder how the EWB Server would scale and if it does support SSL, etc.

What has been you experience with EWB Server performance wise? Do you used EDB as the backend database or is another Database Engine?

Regards,
Mario

Uli Becker wrote:

After some troube with my own Indy-based server I am now using Tim's
server and some modules in addition to access datasets created by
StoredProcedures, sending mails etc.

Works fine without any problems.

Uli

Mario,

> What has been you experience with EWB Server performance wise? Do you used EDB as the backend database or is another Database Engine?

I can't say much about the performace, since there is no heavy traffic
on my server. And yes, I use EDB as the backend database.
SSL is not (yet) supported by Tim's server - that's why I wrote my own
server using the Indy components first.

Since I need an encrypted connection, I just installed sTunnel, easy to
install and works fine.

Uli

Uli Becker wrote:

> Since I need an encrypted connection, I just installed sTunnel, easy
> to install and works fine.

My solution was the RemObjects SDK server, which uses Indy and has all
the code needed to drop a component on the service module and hey
presto it's doing SSL. Having seen how much hassle you can have getting
Indy to work I was happy to use someone else's ready made solution!


--

Matthew Jones

On 10/13/2014 3:45 AM, Matthew Jones wrote:

> Having seen how much hassle you can have getting
> Indy to work I was happy to use someone else's ready made solution!

I'm not sure why that is - we use indy http server a far bit and it's
very trivial to get it working well (with or without ssl).

Raul

Raul wrote:

> > Having seen how much hassle you can have getting
> > Indy to work I was happy to use someone else's ready made solution!
>
> I'm not sure why that is - we use indy http server a far bit and it's
> very trivial to get it working well (with or without ssl).

Okay, glad to hear it. I was just happy to not have to do anything
other than put in two DLLs and some certificate files.


--

Matthew Jones