Catalogue: CI for automatic database visualization
Feedback and discussion thread for the automation suggestion from last weeks. The idea is to use https://www.schemacrawler.com/ to automatically generate a png illustration of the DB schema when it is changed. That way the one we have is never out of date, and there is less manual labor when making changes. Schemacrawler provides a docker image, so it should be quite straight forward.
I see two ways of going about this (or even doing both):
- A job which one launches manually when creating a merge request that includes a schema change. The job generates an image and commits it to the branch to replace the existing file.
- A job which ties into the CI of eoscta.docs.cern.ch/, such that the image artifact is uploaded there. This is a little cleaner in terms of not having artifacts inside of the code repository, but might make the image more difficult to find.