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?
- 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?