Need help with project.db file

Hi Everybody,

We are trying to automate some of Davinci projects functionality by working with project.db file directly rather than doing it manually in Resolve.

Currently we re-time a lot of the videos, which involves manually adding Speed Points and changing speed between those Speed Points - there can be quite a few of the 'segments' that need re-timing, so it is a lot of manual labor, also prone to errors.

Project.db is a SQLite DB and the idea is to create a process that will modify (insert or update) records in relevant tables to achieve the same that is currently done manually.

We have reviewed all 145 tables in the project.db, but can't seem to be able to identify which table (or tables) hold the data for Speed Points or re-timing information.

Would highly appreciate if you can point me in the right direction!

Thank you for your help !

[Shrinivas Ramani]

Hi

We strongly urge you not to work with the underlying database files - it is unsupported and can lead to data corruption. The .db files are specifically made to be Resolve-specific with its internal structures changing often for new features and optimisations.

Any secondary access will be at the risk of corrupting your projects. Please also see the concurrent access warnings here:
viewtopic.php?f=21&t=90190#22

accessing disk databases simultaneously using more than one software (including file-syncing services like DropBox) may compromise the integrity of the underlying project and configuration data.

Regards
Shrinivas

Hi

We strongly urge you not to work with the underlying database files - it is unsupported and can lead to data corruption. The .db files are specifically made to be Resolve-specific with its internal structures changing often for new features and optimisations.

Any secondary access will be at the risk of corrupting your projects. Please also see the concurrent access warnings here:
viewtopic.php?f=21&t=90190#22

accessing disk databases simultaneously using more than one software (including file-syncing services like DropBox) may compromise the integrity of the underlying project and configuration data.

Regards
Shrinivas

Hi Shrinivas,

Thank you for the information - is there an alternative solution you can recommend ? Is there a way to "automate" speed points and retiming ? An API functionality in development ?

Thanks!