> Le 13 juin 2016 à 15:02, R Smith <[email protected]> a écrit : > >> The application will be used by ± 10 users via RDP TSE clients. >> > Hi Luc, > There is no safe way to do what you need. Networked file systems do not play > nice with file-locking. SQLite is suitable for localized storage, not > Networked-multi-user-access systems. You need a client-server architecture > for that. > > Unless I am mistaken and all teh 10 users access the DB from the same > computer, or you have an interface application that accesses the DB and then > serves the data to the clients, there is no safe way to access an SQLite DB > file via a network from many clients - WAL or no WAL.
The OP will confirm us how to interpret his use-context, but Ryan, I think by mentioning RDP TSE (remote desktop protocol - terminal services clients), the application will actually run on the server-side, no database file access over a networked file-system. So WAL is not ruled out here. The rest is a matter of clean application design. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
