> what exactly do you do when you have failure

Depends on the failure. What do you have in mind?

> when more than one process need to acces the DB

Easy, you use `journal_mode` set to `WAL` when you connect to the sqlite database.

> when you need RBAC

If you need RBAC, you aren't going to be using sqlite. In theory you could have your application handle the RBAC part since sqlite is embedded in your application.

Another solution is to leverage unix users and groups and set permissions appropriately for the database file and the application running.