I interested in what is the easiest way to access our EDB database from Android. I want to create a prototype mobile app primarily to test the concept and evaluate which features of our currently win32 application can be ported to mobile/tablet applications.

Any opinions or possible solutions would be appreciated.

I created a DataSnap server.  Results get sent back to the server via TFDMemTable json so that I can load them into corresponding TFDMemTables in the client.   It's still a work in progress and I have a few technical issues that I need to figure out yet, but it seems to work fairly well both in terms of reliability and performance.

Anthony wrote:

I interested in what is the easiest way to access our EDB database from Android. I want to create a prototype mobile app primarily to test the concept and evaluate which features of our currently win32 application can be ported to mobile/tablet applications.

Any opinions or possible solutions would be appreciated.



REMObject's Data Abstract works well.

I have used TMS RemoteDB with Android successfully.

Thanks for the many suggestions, I previously tried TMS Remote DB years ago but experienced compatibility issues don't remember the details now but may be worth another look as I put mobile development on hold at the time.

I did take a look at Datasnap but it looks anything but simple unless I'm missing something,

I don't currently have Rem Objects but it does look comprehensive and easy to use so may be worth a look.

Has any one tried using EWB with the Delphi REST client, I'm having difficulties with the initial authentication process but is there any reason why it would not work?

On 5/21/2021 2:55 AM, Anthony wrote:
> I interested in what is the easiest way to access our EDB database from Android. I want to create a prototype mobile app primarily to test the concept and evaluate which features of our currently win32 application can be ported to mobile/tablet applications.
>
> Any opinions or possible solutions would be appreciated.
>

I'm bit late to the party but Tim technically has built a JSON API on
top of EDB (and DBISAM) in the Elevate  Web Builder product.

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb3&topic=Server_Database_Access_API

You can probably grab the trial and try out the EWB Web Server to see it
in action - and one can natively define EBD connections there.

I can't speak for Tim but would not be surprised if something similar
would not be added to EDB server as well (and maybe even some client
side useable in firemonkey in mobile)

Raul

Thanks Raul,

I have a license for EWB and can continue the discussing in the EWB forums if the specifics are more relevant there.

I was trying to use the Delphi REST components in a mobile app but failing to get them to authenticate as they do with other REST APIs.

On 6/10/2021 2:11 AM, Anthony wrote:
> I was trying to use the Delphi REST components in a mobile app but failing to get them to authenticate as they do with other REST APIs.

While i have not it those myself if you're using EWB server API then you
need to do your own auth request manually, extract the EWBSessionID
cookie and set it for future TRESTRequest data requests.

Raul

Thanks Raul, I think that's the bit i'm struggling with. I've used the REST Debugger and if I copy the EWBSessionID from a web browser after logging in with an EWB app I can get it to work just cant figure out the process in the REST Debugger so I can deploy to a Firemonkey application.

On 6/11/2021 9:14 AM, Anthony wrote:
> Thanks Raul, I think that's the bit i'm struggling with. I've used the REST Debugger and if I copy the EWBSessionID from a web browser after logging in with an EWB app I can get it to work just cant figure out the process in the REST Debugger so I can deploy to a Firemonkey application.

I tried quickly and in Delphi something as simple as this works (has no
error handling). Client does retain the cookie during session.

- you need to have an instance of TRESTClient, TRESTRequest and
TRESTResponse and hooked up


RESTClient1.BaseURL := 'http://localhost:8080/'; //use valid address
RESTRequest1.Resource := 'authentication?method=authenticate';
RESTRequest1.Params.Clear;
RESTRequest1.AddBody('{"User": "Administrator","Password":
"EWBDefault"}',ctAPPLICATION_JSON);
RESTRequest1.Method := rmPOST;
RESTRequest1.Execute;

//now request table data

RESTRequest1.Resource := 'databases/example/albums/data';
RESTRequest1.Params.Clear;
RESTRequest1.Method := rmGET;
RESTRequest1.Execute;

//received JSON is in "RESTResponse1.JSONText"


Raul