Quote:
Originally Posted by ownedbycats
Also, sqlite is not a server. It's not designed to be used in such a manner. If you want multiple users, use the content server.
|
Yes. The sqlite is just a sort of api. It's simply accessing files.
Ultimately a server based database is just accessing files, but the client is only accessing a server process and the files are private to it. The Server process will track row and table usage and lock rows or sometimes tables or indexes.
Even then, for success, the Client app has to be written multuser aware and do something sensible when it finds it can't recreate a table or update a row or rebuild an index.