

Ohh, SQLite isn’t “one” db. SQLite is file-based. I.e. a database in e.g. PostgreSQL (containing several tables, views, indexes, etc.) would translate to one SQLite file (e.g. mydatabase.db3
or myappdata.sqlite
). And each app has its own file/database. If the file corrupts, then it’s only affecting that specific app. (However, SQLite is pretty robust.) And since these are just files, you can backup them together with the application. No need to export data or shutdown the database first.
Fixed IP might be a problem as basically all carriers use CGNAT. From what I could
gathergoogle, Three seems to be the only one where you can manually change the APN to3internet
to get assigned a proper IP address.