On Wed, 23 Oct 2002 14:39, Chris Milham wrote:
> I would NOT try connecting to a DB directly over the internet unless you
> could encrypt the data and you could limit access to the database to only
> those authorised to use it. If you access IB directly over TCP/IP then
> requests will be flying around cleartext for the world to see. You could
> probably use some sort of encrypted tunnel (not that I know anything about
> this). Maybe set up a VPN.
[shameless plug] I have a product for Internet communication via 'direct'
Interbase connection. However I only suggest using it if you want to run an
existing application over the net and wish to secure the comms. Not only is
Interbase insecure (ie in the clear) it is also very 'talkative' - not very
good over dial up. Writing new apps to use direct DB over the net is *not* a
good idea.
A better solution?
I develop web applications using Java Servlets. This enables applications to
be easily ported between platforms and databases. For example I have had
applications running on:
- Windows NT/2K
- Linux
- Solaris
- Tru64
And have connected to databases such as
- Interbase
- MS SQL
- Postgresql
- Oracle
I have also been involved with a number of database and platform migrations
which have generally been pretty easy.
Delphi - and more recently Kylix - is still my tool of choice for GUI
applications. However browser based systems - or middleware - is better done
in Java, since it won't lock you into a specific platform or database. We are
also using Modelling Frameworks now, which make development of business logic
and database mapping much easier.
While Java is good for server side - browser based systems, it is still too
slow (at least Swing based GUI is). Other GUI technology is on the way for
Java which may unseat Delphi.
We have written Java based systems now that use Delphi and Kylix on the front
end. Mark is telling me to mention Soap and XML RPC - and Jabber - which can
be used for middleware.
Learning Java hasn't meant I don't do Delphi anymore - but it does give me a
bigger bag of tricks to throw at a problem.
Regards,
Peter
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
