I’ve developed a Pipeline (https://prism-pipeline.com/), which is based on a folder structure. At the moment I’m thinking about adding a database (mysql) to it, but I have some concerns.
One thing that works really nice with Prism is that the team can work at different locations without being in the same network and without a global server. The project folder will be synchronized with a cloud service like Dropbox or Google. So even if someone has no internet connection (or the connection is blocked by other up-/downloads) he can create new shots and when the internet conntion works again, Dropbox will sync all new files and folders to the other team members.
Does this workflow works with a database, too? If two people create two different shots on their PC without internet, will Dropbox sync the database so that both shots exists later on?
Are there other advantages/disadvantages for databases specifically related to VFX Pipelines?