Read and understand this document: https://www.sqlite.org/lockingv3.html It is the inside the engine on how to do things. There are exact steps that need

Read and understand this document: https://www.sqlite.org/lockingv3.html It is the inside the engine on how to do things. There are exact steps that need to be done the way the document reads to make it happen. There is a also big section on how to corrupt the database. It's a heads up that if you decide to do shortcuts there will not be a happy ending. A little more complicated doing concurrent use than with something like MySQL, but there is much more engine on the MySQL side. If multiple concurrent users with high transaction levels, SQLite may not be your best first choice.