Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread Windows Application Retrieving/Updating DBISAM Data From/To A Windows VPS?
Mon, Mar 5 2018 2:42 AMPermanent Link

Frederick Chin

Is it possible for a Delphi 7 Windows application to retrieve/update DBISAM data from/to a Windows VPS directly?

--
Frederick
Mon, Mar 5 2018 3:53 AMPermanent Link

Matthew Jones

Frederick Chin wrote:

> Is it possible for a Delphi 7 Windows application to retrieve/update DBISAM data from/to a Windows VPS directly?

If you have the DBISAM server running on any computer, then any other can connect to it, so "yes". It is generally a very unwise thing to do though, as any other computer can also connect to it and do whatever it wants. Fine if this is in your local network, quite risky if it is on the internet somewhere.

--

Matthew Jones
Mon, Mar 5 2018 4:04 AMPermanent Link

Uli Becker

> Is it possible for a Delphi 7 Windows application to retrieve/update DBISAM data from/to a Windows VPS directly?

Sure, using C/S.

Uli
Mon, Mar 5 2018 8:49 AMPermanent Link

Frederick Chin

"Matthew Jones" wrote:

/*
If you have the DBISAM server running on any computer, then any other can connect to it, so "yes". It is generally a very unwise thing to do though, as any other computer can also connect to it and do whatever it wants. Fine if this is in your local network, quite risky if it is on the internet somewhere.
*/

Even with DBISAM's server security, it would still be risky?

--
Frederick
Mon, Mar 5 2018 8:54 AMPermanent Link

Frederick Chin

Uli Becker wrote:

/*
Sure, using C/S.
*/

I suppose the speed of data retrieval by the Windows application would not be fast.

Will the EWB application and Windows application play nice with each other in terms of table locking and transaction processing?

--
Frederick
Mon, Mar 5 2018 10:06 AMPermanent Link

Matthew Jones

Frederick Chin wrote:

> Even with DBISAM's server security, it would still be risky?

If someone can get a login, they have all your data, or can delete it. And if you forget to remove a standard account, or it gets re-installed, then you are wide open. See all the MongoDB security issues as example. And SQL Server. And you can get the source to DBISAM, and see the flaws, so I could know how to break in too. Bypass the security. Three attempts and then a blank password works (see Apple!).

Does it matter? Is it likely? Depends on your data. If it is your record collection, doesn't matter. Medical records, definitely not. The usual way around it is a service that performs operations on the data, and never allows SQL to pass.

--

Matthew Jones
Mon, Mar 5 2018 10:11 AMPermanent Link

Raul

Team Elevate Team Elevate

On 3/5/2018 8:54 AM, Frederick Chin wrote:
> I suppose the speed of data retrieval by the Windows application would not be fast.

C/S is actually very fast - depending on what speed you mean but we have
our app running just fine over internet with remote users.

Main enemy in this case is internet latency and to lesser degree
available bandwidth.

Also application design might come into play - for example form with lot
of databound controls each of which requires a trip to the server to
load data might appear slow (but that's just due to the number of
separate trips needed to server and the latency mentioned above).

You also might want to read the C/S sections of manual and look at
things like remotereadsize settings for further optimization.


> Will the EWB application and Windows application play nice with each other in terms of table locking and transaction processing?
>

Yes - they will be fine as DBISAM handles locking and such for you already.

it will basically "look" like an normal multi-user system so normal
rules of change detection etc apply and of course your app has to deal
with things like loss of connection and re-connecting etc

Raul
Mon, Mar 5 2018 4:27 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Frederick,

<< Even with DBISAM's server security, it would still be risky? >>

Anything exposed to the Internet is risky.  Having said that, we use DBISAM Database Servers exposed to the Internet, but:

1) We only allow encrypted connections with a very strong password.

2) If you can, set up the list of authorized IP addresses in the DBISAM Database Server configuration so that only permitted IP addresses can connect to the database server.

Tim Young
Elevate Software
www.elevatesoft.com
Image