Print Page | Close Window

Dumb question

Printed From: TMS Software
Category: Business Tools
Forum Name: RemoteDB
Forum Discription:
URL: http://www.tmssoftware.com/site/forum/forum_posts.asp?TID=13577
Printed Date: 20 Oct 2019 at 12:59pm


Topic: Dumb question
Posted By: Schumann Michael
Subject: Dumb question
Date 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



Replies:
Posted By: Wagner R. Landgraf
Date 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: 
https://www.youtube.com/watch?v=2SCvzw0L27o - https://www.youtube.com/watch?v=2SCvzw0L27o


Posted By: Schumann Michael
Date Posted: 24 Jun 2019 at 1:36pm
Thanks, I will go with XData ...



Print Page | Close Window