The difference Database, project file, project archive in DaVinci Resolve

so today we're diving into the differences between the project database the project file and the project archive how they are different from one another and how you use them so without further ado let's jump into it explore a wide selection of pre-made creative tools for davinci resolve like titles transitions slideshows and infographs like bar charts and callouts and much much more link in the description for more information so first starting up davinci resolve you'll probably see a screen like this and this is going to typically be where your local database is going to be and you're not going to have any idea where that file is unless you remember exactly where you selected to have it stored this is going to be all of our edit information but none of the media that is a part of those edits so all of your video files all of your images all of your audio none of that is going to be stored in the project database the pros to this is it's much quicker and this also works with a system that allows you to also do a network database as well i'll dive into that in a second here so a project database is a little bit different than a project file because the project file is going to be one particular instance of that project but the project database can store a lot of other parameters and tie them all together like i was saying all of the different projects you can have your different project folders and you can also if i click here you can all also have project backups and i kind of talked about this about backing up files project backup's pretty much what it is is it allows you to have uh version control for your files if you have like an auto backup system enabled davinci resolve has this um and pretty much when you click on a on a project and we take a look at the uh the project backups we can see when backups were and when they were modified and that it was on auto backup and stuff like that you can always restore back to those so that's kind of like your version control right so if you deleted something yeah you got out and you went back in and it wasn't there you could go back to one of those uh versions uh i talked about that more in a in another video and then you can also have different databases as well so if we click this little button over here we can have multiple different databases now we have disk databases and we have postgres databases uh one second on the differences between those two one thing that i did want to show is let's say all of our local databases this one here has this little wheel you you will see this anytime you do big updates and they change a different parameter within the database they add a new table they add a new field whatever it may be uh they require you to do what's referred to as an upgrade database right so down here the upgrade database and that is going to add whatever that new metric is in the database and it makes it ill-reversible that particular database so i'm currently using davinci resolve 17 as you can see down here this is this database is for davinci resolve 16. so one of the things to keep in mind here is that when i update or upgrade i can't go back so let's say davinci resolve 17 wasn't running very well on my system and i wanted to go back to davinci resolve 16. just hitting that button i cannot go back with this particular database and all of the projects that are in it so before you ever click this button you want to do a pro a database backup and to do that we're going to come right up to here we'll click this button and it'll ask us our location and where we want to store a backup of the database this isn't going to be a live database it'll be a separate file wherever you put it and so if something happens and you go back to to 16 i can grab whatever that file is and come over here click this button this is going to then restore from that file back to the way it was before i did the upgrade hopefully you're following there so then we can use all of the previous projects that we have in our database even though we upgraded it uh and so on so just a way to to save database you can also do backups if you ever want to store all of your your database and put it on like a backup server or something of that nature in case you feel that the current hard drive that this database is stored on could potentially die so that's one thing to keep in mind so what is the difference between a disk database and a postgres database primarily one is on the network and one is on your specific computer it being on the network has a couple of pros to it if your system dies that database doesn't die that's one thing um with postgres there's a lot of other services that you can run alongside of it to save the database in other locations so you don't have to be concerned about losing edits and stuff like that the other thing and this is new that will be in 17 for everyone that is interested in this is davinci resolve always had the ability to do like a collaborative edit so you could have multiple editors working on the same project at the same time before this was only a studio only element of davinci resolve but now they're including it into davinci resolve 17 for the non-studio version and the reason that they said that they were doing this is because everyone is currently working at home this allows remote editors a whole new ability to if you don't have the studio version to now use uh this one studio feature so that is a cool thing if you are looking into postgres and you do any searching you're going to see super comp complicated uh ways to uh set up a postgres server what i would recommend if you're not that tech savvy or you don't feel comfortable diving into doing that you can get different services that uh will automatically run you through like a wizard or if you have something like a synology i believe that they have it maybe qnap has it as well uh within their login there is typically a little wizard that you can click next next next you know make a username next next next and it gives you an ip address to connect so you have that option as well so that's pretty much what databases are one centralized location for all of your edits it also holds a lot of other information about those edits when it comes to version control with the backups but it does not contain any of your media that the project is using it only has the location so if you go into your media pool you right click and you look at the information and it says that it's stored on your main hard drive and it's in this folder that folder that's the only information that the database will have it won't have the actual video clip itself so that's another thing to keep in mind going from that into project files now project files are similar in nature because they don't have any of the media attached to them they only have the location of that information so to to make a project file we just simply go into one of our databases we right-click and then we go export project right and that's going to give us a drp i believe davinci resolve yeah drp davinci resolve project it's going to give us a file and then we can do whatever we want with that file it's not going it's only going to have the information of where the media is stored that is all of your video images video images and audio it's not going to contain any of the media it's only going to contain its location so if you were to put it on someone else's computer they have to have the same locations or they have to re-link things because when they start up davinci resolve and they they use that uh project file it's going to say that the media is offline so you just have to re-link it to wherever it is on their system and that's pretty much a project file in a nutshell once they get it they go into their database and obviously they go import project once they're in the project then they can relink everything going off to the next one which is a project archive now a project archive like a project the only difference is now we're bringing all of the media with the cool thing about this is let's say you're working on a big project that has um a tv show and we're on season one episode one and location one inside location one you have camera one camera two camera three and we have take one two three four five whatever it may be all of the structure that you had set up for that project will all be saved when you bring the when you uh create a project archive so clicking create project archive what it's going to do is it's going to make a folder with a davinci resolve project and all of your media the difference between that project file that's in there and the project file if you go export project file is the project file inside an archive is going to link inside the archive a project file might say something like this as where a project archive is going to say something like this and now if we bring it in using uh restore project archive all of the media is going to be linked now this is media that we used as well as media we didn't use anything that is inside the media pool it's going to bring with it so that's something food for thought if you're doing a project archive you're going to store it and it's not going to someone else but you're saving it there might be you know information in there that you really don't need to have like a whole music library in there you really didn't you could just uh there's ways to filter out this the the media you used versus the media you didn't use and remove all of that before you make your project archive so you're not backing up all that use you know stuff that you really didn't need so that's something else to keep in mind the only other thing that i can say about a project archive in its current state if you were in fusion and you use a loader node the information inside the loader node is just going to be a location of the media the same way it would be in a in any other thing is not going to bring that media with in its current state of davinci resolve that's how it's set up it does not bring that a lot of people don't use loaders that are you know working inside davinci resolve that's typically something fusion users will use but that's something to keep in mind currently if you have a loader inside of fusion it will not bring that media because it's not in the media pool and it doesn't have a resolve id that's kind of getting maybe a little off topic but that is it's just going to have the location of its current like where it's currently uh looks like in the project so if it says that it goes to joeshmo folder um when you load up the project archive it's just going to say joeshmo folder but if you don't have the connection to that folder you're not going to also bring that media with so that's just something else to to keep in mind there uh and i think that kind of covers everything with the differences between the three but um hopefully that helped uh yeah i don't think i missed anything and so with that being said i hope that answered a lot of your questions for those that watched the video because they had a question on this and for those that are just randomly watching it hopefully you learned something but with that being said my name's j.r stay safe have a good one guys you

Channel: JayAreTV

Views: 9,822

Keywords: blackmagic, DaVinci Resolve, resolve, tutorial, how to, DaVinci Resolve 17, Fusion

Id: 9cfB4RE1Img

Length: 12min 34sec (754 seconds)

Published: Wed Jan 13 2021