I still prefer to use kubernetes for this: https://dewyatt.github.io/articles/continuous-deployment-of-...
Is it worth it for just one server? Also, how do you handle the database? Do you put that in a container too?
Yes, the database can be in a container as well, with a persistent volume.
It's not that much more complex than what you just went through.