Make tactic work in docker with compartmentalized image for db server and load balancing frontend

[diegocortassa]

Is your feature request related to a problem? Please describe. It is difficult to build a docker image to run tactic separated from the DB server because the install script and some internal functions related rely on postgres command line utilities

Describe the solution you'd like It is already possible to run the install script without creating the sthpw db but there should be an option to only create db, it should be possible to run the "db only" installation with the DB server running on another host or separate docker image. We could create a Dockerfile running the "software only" installation at image creation and the "db only" installation in the entry point when the image is deployed. There are few modules in tactic relaying on postgres command line utilities (i.e. src/pyasm/search/database_impl.py) to create project databases, this code should be changed to support operating in pure python (psycopg2) on a remote DB server.

Additional context Adding a Dockerfile and a docker-compose.yml will make it easier to run tactic on different OSes and will supersede the tactic team distribution with a better/faster/more manageable solution

[listyque]

Adding a Dockerfile and a docker-compose.yml will make it easier to run tactic on different OSes and will supersede the tactic team distribution with a better/faster/more manageable solution

I think, installing docker and start using it, already can be hard for a cg artists who wants "just look" or use tactic on their own PC's.

[diegocortassa]

Hi @listyque, you are probably right, but it makes much easier to install it on different OSes keeping an homogeneous running environment, it is worth investigating...