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

General questions

 Post Reply Post Reply
Author
Sachs Gerhard View Drop Down
New Member
New Member
Avatar

Joined: 08 Nov 2012
Posts: 32
Post Options Post Options   Quote Sachs Gerhard Quote  Post ReplyReply Direct Link To This Post Topic: General questions
    Posted: 14 Aug 2014 at 3:49am
I am currently thinking about changing an existing business solution from the direct database connection to a 3tier solution.
Currently I am evaluating RemoteObjects DataAbstract.

Questions :
- DataAbstract connects via ADO to NexusDB, what about RemoteDB ?
- is there a way for clients to be notified if tables on the server change ?
- If tables on server are changing, does the whole table need to be reloaded or just the changed part ?
- It seems that TMS Remote DB is a rather new product and is not yet recommended for production use. Is there a schedule where a stable release is published ?

Regards
Gerhard Sachs
Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2434
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 14 Aug 2014 at 7:25am
Hi Gerhard,

- RemoteDB offers several options to connect to databases: dbExpress, FireDac, ADO, Unidac, SQLDirect and native components to access ElevateDB and NexusDB

- There is no client notification about server-side operations

- From the client point of view, RemoteDB works as a database server. You just execute SQL statements with it. The server is responsible to "forward" those requests to underlying database server. But clients just use a TDataset as if you were connecting to the database. Thus, as far as I know, there is no such mechanism available. You perform queries, you can call Refresh to reload the query, but the whole dataset I think

- RemoteDB is a very stable product. It has been used with some target customers for some time already before we released it. One of those users has an ERP software and he uses RemoteDB is several customers. One of customers has a 300-user base, which might reach up to 100 simultaneous users using the software. That's our largest customer so far. Yes, since the product is new, RemoteDB doesn't have a wide range of different scenarios (for example, this specific customer uses SQLDirect connecting to MS SQL Server). But when we analyze the customers that are already using, they've been doing for some time already.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down