How to replace sqlite3?

Question

SQLite

It constantly knocks out the Database is locked error due to many connections, increased the timeout, I immediately close the connection after using the database, but it does not help.
Is there a similar local database (without servers) that can handle a large number of connections?

Answer 1

More than 1 connection - only a full-fledged DBMS

Answer 2

No.

Answer 3

The essence of sqlite is the lack of a server. All logic is in the library.
But that's why access is blocked - because only one application can connect to one file.
The server solves this issue by the fact that the server is the one application that works with the file, and all the rest work through the server.
Therefore, without a server, there should not be architecturally multi-user access to a file.

Answer 4

https://peewee.readthedocs.io/en/latest/peewee/pla...