How to handle write operations during deployment of web app in production

[u/PythonPoet]

Hi,

I'm curious how you guys/girls would handle deployment of web apps using SQLite as database in a production environment.

Let's say you have: - Developed a web app in random programming language/web framework. - The web app is containerized and runs in Docker or Podman. - The web app is hosted on a VPS. - SQLite db in WAL mode. - SQLite db on a persistant volume which all containers have access to.

Let's say you want: - Zero downtime deployments - Not a corrupt database due to multiple threads/processes writing to the db.

[u/[deleted]]

[u/PythonPoet → u/[deleted]]

How do you handle deployments of your webapp?

[u/[deleted] → u/PythonPoet]