we are currently in the process of setting up qube to match our needs in the best possible way, so expect more questions soon
After a bit of fiddling around i was wondering what the best way to persist data would be. Ideally i'd like to remove deletion privileges from users (can be done via default permissions afaik) and keep the jobs for statistical and reference reasons. Now i'd like to get them out of the way of the artists (and for performance also the supervisor i guess) after certain amounts of time. So ideally it would simply be moved to a legacy database and removed from the main db. Is there anything built-in to help with such a setup?
If not, i just took a quick look at the db, and it seems that qube is creating quite a lot of databases. What is that based on? A new DB after x jobs ? Will these databases (and the corresponding job tables!) simply keep counting upwards forever? Would the strategy have to be something like "use qube API to find jobs older x, iterate over jobs over *qube databases (brr), copy all data to legacy db, delete records". That sounds a tad scary to be honest hehe.
Any input on that ?