On 23 Mar 2017, at 5:45pm, Stephen Chrzanowski <[email protected]> wrote:
> The remote > system is a Linux based OS. […] How 'remote' is this ? What protocol is used to do the remote access ? > What would be a recommended way to setup the > connections for a DEV-only arena where the below paragraph describes? … or is that what you’re asking for advice on here ? > By EXTREMELY LIGHT WEIGHT use, I mean I *DO* guarantee that although I have > one permanent open file handle to the database via SEP, and that Linux OS > will only open a handle periodically while I'm writing the script, > multiple accesses of reading or writing to the DB at the exact same time > just will not happen. Set a timeout of at least 10 seconds on all connections to the database. Apart from that I can’t think of anything you haven’t mentioned. I do more complicated things by using SQLite as a back end to a web-facing system without problems. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
