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?
Yeah, I tried ChatGPT too. It did offer some good alternatives, but then it started hallucinating. It literally told me of several existent books, except that the names of the authors were incorrect, or the plot was not quite the same, etc.
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.