datasnap clinet by UniDAC?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tanghz
Posts: 23
Joined: Wed 17 Jan 2007 02:40

datasnap clinet by UniDAC?

Post by tanghz » Wed 31 Jul 2013 14:12

As the title suggested,
I am wondering if I can use any UniDAC components to connect to a Datsnap server?
if not, do you have such a plan? thanks,

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: datasnap clinet by UniDAC?

Post by AlexP » Wed 31 Jul 2013 14:32

Hello,

UniDAC is designed for connection to a DB and can be used for development of a DataSnap Application server, not client. You can find an example of such usage at our blog: http://blogs.devart.com/dac/index.php/u ... pment.html

tanghz
Posts: 23
Joined: Wed 17 Jan 2007 02:40

Re: datasnap clinet by UniDAC?

Post by tanghz » Wed 31 Jul 2013 14:38

Thanks for the quick reply.
I have managed the dsServer with UniDAC as the connection component to the DBS. However, just feel 1)multi-tier structure server is more popular used than DBS for serious project. More flexible and robust structure compared to exposing DBS directly to the net. 2)Feel more reliable on your product rather than dbExpress or AnyDAC. At least I know AnyDAC needs MyDWL client lib to connect to the server, yours is directly connect. Great advantage. 3)Only a limited number of DBS, this idea may be sth new you can work on. :lol:

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: datasnap clinet by UniDAC?

Post by AlexP » Thu 01 Aug 2013 09:13

Hello,

As I wrote earlier, our components are designed for database access. DataSnap is an Embarcadero technology, and we are not going to release a product allowing work with a DataSnap server yet.

tanghz
Posts: 23
Joined: Wed 17 Jan 2007 02:40

Re: datasnap clinet by UniDAC?

Post by tanghz » Thu 01 Aug 2013 10:44

Don't worry. It is just my thought and suggestion.
It seems AnyDAC can do that.

Can your component used in FireMonkey? or EMBT's mobile platform.

All above is related to my selection of DB connection component for future projects.

thanks

stevel
Posts: 125
Joined: Tue 02 Nov 2010 19:01

Re: datasnap clinet by UniDAC?

Post by stevel » Thu 01 Aug 2013 11:22

Hello tanghz,

You wrote:
[
1)multi-tier structure server is more popular used than DBS for serious project. More flexible and robust structure compared to exposing DBS directly to the net.
]

Can you elaborate?

tanghz
Posts: 23
Joined: Wed 17 Jan 2007 02:40

Re: datasnap clinet by UniDAC?

Post by tanghz » Thu 01 Aug 2013 11:37

If I understand correctly, some implementation like datasnap is two tier application. it has two parts for handling client requests. The server side and client side. The server (e.g datasnap server, dsServer) will connect to the DBS (MSSQL, Oracle, etc)by using your UniDAC or specific DAC. The query and update logic is implement at this side.
The results will feed back to a client. The data transfer can be based on different protocals: TCP/IP or HTTP(S), REST. The Client can present the data in a application windows if u develope a dsClinet by Delphi. Certanly you can also develop the client within a web server/server (such as IntraWeb , or WebBroker). This will make a 3 tier implimentation.

As the dsServer will handle all the database preocess, (no matter what database, what queries you want to do), dsClient will reveived a single form of results, it split the task. These two can be on 2 different machine, avoid direct attach to database system port like MySQL 3306,etc. each step has own authentication process. For dsClient, it also give you more flexibility to connect it via web or REST or your own dsClient.

On the other hand, if you just dev an application using a UniDAC to connect a database via Internet, you are certainly expose your DBS into the Internet attack.
This wont be happening in serious project.

Hope my understand and explanation is correct.

stevel
Posts: 125
Joined: Tue 02 Nov 2010 19:01

Re: datasnap clinet by UniDAC?

Post by stevel » Thu 01 Aug 2013 12:00

Hi,
Your explanation is correct, except:

[
On the other hand, if you just dev an application using a UniDAC to connect a database via Internet, you are certainly expose your DBS into the Internet attack.
]

Nobody does that. Its not written/documented/recommended by anyone, anywhere and its certainly not recommended software development practice. Its a huge security risk. Web hosting companies do not expose by default the website databases that they are hosting directly to the internet precisely for this reason.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: datasnap clinet by UniDAC?

Post by AlexP » Thu 01 Aug 2013 12:36

Hello tanghz,

>Can your component used in FireMonkey? or EMBT's mobile platform.

Yes, our products support FMX and mobile application development

tanghz
Posts: 23
Joined: Wed 17 Jan 2007 02:40

Re: datasnap clinet by UniDAC?

Post by tanghz » Thu 01 Aug 2013 14:13

To Steve,
thanks for your comments. So you are testing me and you know all the details. :twisted:

To Alex,
Glad to hear your products can do those. I waiting for your DataSnap support to update mine. I believe you won't be beaten by AnyDAC as you have your own IP stuff. Just don't know why EMBT selected them as bundled software. Maybe it IP issues.

Post Reply