Build production deployment for leader-app and front end

[geerlingguy]

Deployment Plan

• [x] Choose either docker-compose.yml setup, or bare deployment (and set it up in Ansible automation dir)
• [x] Mount database.sqlite on a volume from local disk (so we can easily manage via SSH)
• [x] #39
• [x] Test deploying to a bare Ubuntu 22.04 instance
• [x] Make everything as bulletproof and debugg-able as possible (e.g. consider adding some metrics)

Original Notes

I've been doing all my testing and development via flask run, but as it says right in its own output:

WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.

So this issue is to track setting up a Docker-ized environment in which to actually run the app, with a separate Docker volume so we can get at the data. If we're booting Linux on the NUC server, we could use a shared directory so we can get at the .sqlite database more easily from other computers on the network.

[geerlingguy]

Maybe use this setup: https://github.com/docker/awesome-compose/tree/master/flask

Or if that is not performing as well, run https://github.com/docker/awesome-compose/tree/master/nginx-wsgi-flask with Nginx as a proxy in front (though we want real-time... so ideally we can run it direct, even sacrificing a little performance. Though it would be nice to let Nginx cache all the static files!

[geerlingguy]

Also need to run React front-end, so maybe a docker-compose.yml file with a Dockerfile or two to build out each container, then have them all up and running?

Worst case just install junk flat on the server and run it YOLO style. Not the end of the world since that's literally all this server will be doing!

[geerlingguy]

Gotta work on this before Monday night.

[geerlingguy]

For the database, I would like to do two things:

1. Store it in like ../leader.sqlite and have a volume mount in the docker-compose.yml file.
2. Maybe add a web UI for it? Or Firefox plugin for viewing the database on the computer itself?

Also add a CI job in Actions that just builds the app in Docker and checks that certain URLs are working.