database network protection

[Efo74]

Hello Autoit Developers,

I have write a simple database program in Autoit, it reside in a network share. The program works very well, and I have made a backup to protect him. It's happen that a unknown user have delete the database file, more than one time in the year. What are our common policy for protecting a database in the network ?. Thank you.

[Jos]

A common best practice would be to setup an database server in stead of using a file that can be deleted.
In that way you can better protect the data and also refine the access to the tables.

Jos

Edited April 15, 2016 by Jos

[jchd]

@Efo74

Which engine are you talking about? You say "the DB file" and that would seem to mean you're trying to use SQLite over a network. If so, don't do that: SQLite is not for use over a network due to network file locking protocols being unreliable (all of them).

As Jos said, you'd be safer using a client/server engine which offers all the security walls you need.

[Efo74]

Than you,

and ... yes I use Sqlite with Autoit (in network) and I have never have problems with that.

can you reccomend me a client/server db that is supported in Autoit ??

[mLipok]

Using ado.au3 You can Use MySQL mssql POSTGRESQL 

[Efo74]

thank you guys for your help, I'll try mysql

[jchd]

Are your DBs used by more than one single program/thread/computer at a given time (that is: do your DBs incur any concurrency)? If yes, then SQLite will fail over a network, one day or the other.

Any client/server engine offering an ADO layer (ODBC) will do. Even SQLite if wrapped inside a client/server layer.

[mLipok]

1 hour ago, jchd said:

Even SQLite if wrapped inside a client/server layer

?? What you mean ?

[jchd]

There are many solutions: https://www.google.fr/search?q=sqlite+network+server&oq=sqlite+network+server&gs_l=serp.3..0i22i30.29585.30941.0.31809.7.7.0.0.0.0.161.768.0j5.5.0....0...1.1.64.serp..2.5.766.lkyRWwMEWn0

[mLipok]

Interesting. Thanks.