What problems can arise when the program works with a database file from a remote folder?

Question

SQLite

I have an idea to create the following application.
Clients are located on users' computers on the network. Local network 100 Mbps.
The database is located on the server in a shared folder. This is a simple SQLite file (for example).
Clients read/write to the database from a network share as if they were working with a local file.

It is assumed that: The
database will be relatively small
Clients will perform Insert queries (insert something), Select where id=1 (selection with the condition..."search the entire database")
Clients can work with the database simultaneously (at the same time insert data, read, etc.)

What problems can arise when the program works with a database file from a remote folder like this?

PS
The option with a standard database server that solves all the issues above is excluded so far.

Answer 1

Various - from very slow work to data corruption. SQLite is not intended for concurrency, use a full-fledged DBMS.

Answer 2

An encyclopedia of rakes on this subject has been collected by accounting departments for twenty years, "1C file problems" are googled.

Answer 3

Quite often you will get a broken base.

Answer 4

Everything is described in some detail here .

Answer 5

The option with a standard database server that solves all the issues above is excluded so far.

You are not looking for easy ways. Stop thinking in shared files as storage. This role is just completely taken by a full-fledged DBMS in your case.