It's complexity you already have. You need some sort of HA for your app server and some sort of resilient storage for your database server. Using sqlite just me

It's complexity you already have. You need some sort of HA for your app server and some sort of resilient storage for your database server. Using sqlite just means the storage is used by the app server directly, nothing more.