Multiuser local DB?

Question

Database

You need to write an application that contains a table with text entries. Approximately 1500 entries per year. Simultaneous connection of about 5-10 users.
I want the application to use its own local database. To use a shared folder, i.e. without installing a separate database server.
What is the best multi-user local DB to use?

Answer 1

SQLite. Supports several connections (but only one can still write to the database. But that’s okay, clients will survive 1500 inserts a year)

Answer 2

1500 entries per YEAR?
What DB?
Text files.

Answer 3

At first I also thought about SQLite, but after reading about
MySQL/MariaDB is still suitable, since for SQLite only one user has permission to write to the database at one time.
Configuring MySQL to use minimal memory
And solutions with files are likely to be bicycles, since locks must be taken into account.
You cannot install a DBMS on a shared folder - data can be damaged / lost due to the same locks and potential problems with networks.
In total, you need to have a DBMS on a dedicated PC/server when it comes to desktop applications.
If the resources are quite tense, then you can install it on one of the PCs. The main thing is that this PC never turns off and stands with a UPS .

Answer 4

Firebird for sure.