Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Dumb question

 Post Reply Post Reply
Author
Schumann Michael View Drop Down
Member
Member
Avatar

Joined: 26 Sep 2015
Posts: 69
Post Options Post Options   Quote Schumann Michael Quote  Post ReplyReply Direct Link To This Post Topic: Dumb question
    Posted: 24 Jun 2019 at 11:11am
I am planning an application using TMS Webcore and would like to access my database directly like I work with Firedac in a client/server environment.

I would like NOT to use aurelius as the queried data is often complex queries that require some SQL acrobatics and I am a heavy SQL user who wants to have total control also over execution plans.

Is this possible with remote DB?

Thanks
Michael
Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2403
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 24 Jun 2019 at 12:44pm
RemoteDB is not safe to use from TMS Web Core, just because of the architecture of final application. You SQL statements will be visible from the browser and also any user with credentials could execute arbitrary SQL statements.
You should use XData. You don't need to use Aurelius, XData is a generic Rest/Json framework, Aurelius is just a helper - which you can still use to retrieve simple data. But you can simply use SQL statements: 
Back to Top
Schumann Michael View Drop Down
Member
Member
Avatar

Joined: 26 Sep 2015
Posts: 69
Post Options Post Options   Quote Schumann Michael Quote  Post ReplyReply Direct Link To This Post Posted: 24 Jun 2019 at 1:36pm
Thanks, I will go with XData ...
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down