Postgres vs DISK database

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline
User avatar

Elliott Balsley

  • Posts: 616
  • Joined: Sat Oct 13, 2012 5:45 pm
  • Location: Southern California

Postgres vs DISK database

PostFri Nov 16, 2012 7:24 am

Hello. For a single user workstation running Resolve 9, what are the pros and cons of Postgres vs a project-based "disk database"?
Speed? Data integrity and backups? Features?
Thank you.
Elliott C. Balsley
DIT, Colorist, Cinematographer
www.llamafilm.com
Offline

Peter Chamberlain

Blackmagic Design

  • Posts: 8385
  • Joined: Wed Aug 22, 2012 7:08 am

Re: Postgres vs DISK database

PostFri Nov 16, 2012 8:16 am

We added the disk database specifically for facilities that don't need, or want, the complexity of PostGres. PostGres needs a server app to run and is ideal for facilities with multiple systems that need to share projects all the time.

Disk database saves the project metadata in a simple folder structure that easy to backup with normal IT procedures, even TimeMachine or a disk copy.

The disk database files are located in logical paths, details in the manual and you can still export whole projects to import to a other system if you wish to share.

I recommend using disk database unless u have a specific need for live sharing of projects
Peter
DaVinci Resolve Product Manager
Offline
User avatar

Paul Provost

  • Posts: 1044
  • Joined: Wed Aug 22, 2012 6:17 am

Re: Postgres vs DISK database

PostSat Nov 17, 2012 7:37 am

Does using disk based affect browsing stills libraries of previous projects? I use that a lot.
Can I convert an existing v9 database install to disk based?
Should I just RTFM?
Paul Provost - colorist
Twitter: @4kfinish
www.4kfinish.com
Offline

Peter Chamberlain

Blackmagic Design

  • Posts: 8385
  • Joined: Wed Aug 22, 2012 7:08 am

Re: Postgres vs DISK database

PostSun Nov 18, 2012 5:40 am

If you are now using a Disk Database you can still import and open your old v8 projects and then save them, one at a time, to the new v9 disk database.
The database does not store the stills or clips.. just pointers to where they are.
Peter
DaVinci Resolve Product Manager
Offline
User avatar

Paul Provost

  • Posts: 1044
  • Joined: Wed Aug 22, 2012 6:17 am

Re: Postgres vs DISK database

PostSun Nov 18, 2012 6:17 am

Sorry I was mixing terms. And I have no v8 projects I need to access.
I am in ver 9 Postgres. All my current projects are in that database. How do I switch over to disk database?
Do I need to uninstall resolve and Postgres?
And then reinstall v9 and select disk database?
I had a v8 lite Postgres on my system when I installed v9 full and I think it automatically updated to the old Postgres.
Paul Provost - colorist
Twitter: @4kfinish
www.4kfinish.com
Offline

Peter Chamberlain

Blackmagic Design

  • Posts: 8385
  • Joined: Wed Aug 22, 2012 7:08 am

Re: Postgres vs DISK database

PostSun Nov 18, 2012 7:37 am

My mistake, sorry, I didn't read your post correctly. No need to uninstall or reinstall. And yes, if you had a PostGres DB before v9 would not automatically change you to the disk DB.

In the database manager you can make a new Disk Database. Then make that the active DB. In the Project Manager you can select the global list of databases and select your v9 projects to import to your new Disk DB.
Your PostGres DB will remain on the computer unless you delete it and Resolve will keep using the Disk DB until you select the other.

Peter
DaVinci Resolve Product Manager
Offline
User avatar

Paul Provost

  • Posts: 1044
  • Joined: Wed Aug 22, 2012 6:17 am

Re: Postgres vs DISK database

PostTue Nov 20, 2012 3:41 am

Ok thanks Peter
That sounds safe. Time to say goodbye to the old database style. (Once I finish the last couple episodes of the season)
Paul Provost - colorist
Twitter: @4kfinish
www.4kfinish.com
Offline
User avatar

Dana Bunescu

  • Posts: 15
  • Joined: Tue Sep 03, 2013 5:40 pm

Re: Postgres vs DISK database

PostSun Feb 26, 2017 7:45 am

Hello. Wow it's been 5 years. So I'm wondering that is Postgres sql database working in another local network computer?
Offline
User avatar

Dana Bunescu

  • Posts: 15
  • Joined: Tue Sep 03, 2013 5:40 pm

Re: Postgres vs DISK database

PostSun Feb 26, 2017 7:49 am

I mean, my scenario is one Postgres sql database and and three separated but locally connected computer (all are mac and have studio dongle)

Is it possible?
Offline
User avatar

roger.magnusson

  • Posts: 1390
  • Joined: Wed Sep 23, 2015 4:58 pm

Re: Postgres vs DISK database

PostSun Feb 26, 2017 6:18 pm

Yes, that's one of the major benefits of using a SQL database instead of the file-based database.
Offline
User avatar

Dana Bunescu

  • Posts: 15
  • Joined: Tue Sep 03, 2013 5:40 pm

Re: Postgres vs DISK database

PostSun Feb 26, 2017 7:46 pm

roger.magnusson wrote:Yes, that's one of the major benefits of using a SQL database instead of the file-based database.

Thanks :)

Return to DaVinci Resolve

Who is online

Users browsing this forum: Google [Bot], Google Feedfetcher, posercomposer and 63 guests