Series |
---|
How to quickly share (and re-connect) to PostgresSQL databases
Over the years weโve tackled the subject of setting up Postgres databases for sharing in DaVinci Resolve. More recently, Postgres gained new importance as the linchpin for project sharing between multiple Resolve Studio stations for the Resolve Collaborative workflow. But if you pull up the Resolve 14 manual (the most recent as of this writing) and look up, โhow to enable database sharingโ you end up with instructions like Mixing Lightโs Insight #0012, which we wrote when we launched in 2013. And it ainโt pretty.
How comfortable are you in Terminal?
The instructions for enabling database sharing begin:
โOpen a Terminal windowโ.
For some of you, this immediately forces a trip to the Google machine figuring out where to find Terminal on your computer. And then begins your great Copy-and-Paste-Event where you abandon any actual typing in Terminal, since you keep making typographic mistakes (Terminal is unforgiving). Of course, some commands require you change various unique strings to match your specific setup โ resulting in a 2nd or 3rd round of frustration. All the while you keep thinking, โThere must be a better way!โ
Until DaVinci Resolve 14.1, there was NOT a better way. All we had was Terminal to enable database sharing. On top of that, if you disconnected from a postgres database in DaVinci Resolve and needed to re-connect to it at later date โ how did you find the name of that database? Again, if you consulted with the manual the instructions begin with:
โOpen the PG Admin appโ.
Then you begin your search anew, trying to figure out what that app is and how to use it to open your postgres database and find the name of the database youโre hunting down. Once again you ask yourself, โThere must be a better way?โ And once again until DaVinci 14.1, there was NOT a better way.
The DaVinci Resolve Project Server App to the rescue
With the release of Resolve 14.1 (and forward), all versions of DaVinci Resolve (free and paid) install both DaVinci Resolve and the new Project Server app. This bit of software is specifically designed to take the place of Terminal and the PG Admin app for managing your databases. Here are a few takeaways about this newโish app:
Takeaway #1: The โProject Serverโ is misnamed
Technically, the Project Server app has nothing to do with serving individual DaVinci Resolve Projects. It manages DaVinci Resolve Postgres Databases. And those databases contain all your Projects. To share a specific Project you first set the Database for โsharingโ. Others on your team connect to that Shared postgres database to access the shared Project.
Takeaway #2: The Project Server is Resolveโs replacement to the PGAdmin utility
Both Windows and Mac have the PGAdmin III utility for directly accessing your PostgreSQL databases. Typically, its only real use for Resolve users was to find the name of long-forgotten databases you need to reconnect. The DaVinci Resolve Project Server app is the functional replacement for the PGAdmin utility. While the Project Server app doesnโt replicate the myriad of tools in the PGAdmin utilityโฆ you donโt need those tools for DaVinci Resolve databases. And you certainly shouldnโt be manipulating your databases with PGAdmin unless you know precisely what youโre doing.
Takeaway #3: The Project Server app is a โwindowโ to the SQL database hosted on the computer youโre launching
The Project Server canโt be pointed to a remote database to manipulate. Itโs designed specifically to manipulate the SQL databases stored on the computer from which itโs launched. It lists all the Resolve databases ever created on that Server. You can not delete or manipulate those databases beyond the simple Optimize / Export / Import / Upgrade tools the Project Server provides.
What are features Iโd like to see implemented on the DaVinci Resolve Project Server App?
I think the Server app is a focused, limited purpose tool that executes its assigned functions very well. But here are a few features that will make it more useful:
- Enhanced Filtering of Databases: My biggest criticism of the Project Server is the inability to re-sort the list of databases with โdate createdโ or โdate modifiedโ metadata. If Iโm hunting for a database which Iโm unsure of its precise name then date modified and date created sorts will definitely help me hunt down those databases.
- Grouping of Databases: Beyond merely being a โwindowโ into the underlying SQL server, Iโd like the Project Server to create folders and help me organize those databases โ again, under the assumption that I have dozens (or more) databases that Iโm hunting through.
- Export an โInternal IPโ access key: When I create a database in the Project Server, it would be terrific if I could export an Access Key with the internal IP address of the machine. The idea here is: If Iโm running DaVinci Resolve on the same computer thatโs hosting the SQL server then Iโd want to export an Access Key that properly imports into DaVinci Resolve. As I show in this Insightโs video, we can hack the key to allow this behavior. Iโd like eliminate the hack and have a button to โexport with internal IP addressโ.
Use the Comments below to discuss!
This is a fairly dry topic. The video below goes over using the Project Server app, plus shows you my hack of the Access Key.
SQL servers are a source of confusion for those of us who havenโt used them. The Comments below are a good place to ask questions or share your tips.
Enjoy!
-pi
Member Content
Sorry... the rest of this content is for members only. You'll need to login or Join Now to continue (we hope you do!).
Need more information about our memberships? Click to learn more.
Membership optionsMember Login