How do you deploy updates of your app without downtime? (I know not all web apps need that but in case you do I would love to know about your approach)
How do deal with horizontal scaling or failovers in general? These are two of the reasons I am still unconvinced about using SQLite in production:
- if only one process can write to the db, how do you architect your system so that writes are performed by just one of the instances (the writer)
- how do you gracefully upgrade your app without any downtime?
Lately I have been migrating all my self-hosted stuff into a raspberry pi (instead of running a public instance in the cloud). It gives me a bit of piece of mind knowing that it adds an extra layer of security (to hit any of my endpoints/apps you would need to infiltrate my VPN). And it will save me a lot of money on hosting.
I don't need to expose my computers publicly or enable upnp or anything. It just works.