> 3. We must use just a single connection to each database file. Do not let many apps access the same database file. Each instance must use its own db file
There are file locking mechanisms you can opt into (compile time options) to have multi-process access to the same database file - it does require either some coordination and/or more error handling, especially when writing to the database.