Retrieving Addon Data Directly from the Database

Development
1

Context

We have multiple addons with different versions installed on our AYON server. Our goal is to retrieve their data directly from the database, as fetching via the standard REST/GraphQL API or the addon’s exposed endpoints is not an option in this case.

Issue

  • The addon_data table in the public schema appears to be empty.
  • When a new addon is installed, it does not show up in the API response immediately.
  • However, after restarting the server, the newly installed addon becomes available via the API.

Requirement

We need a way to retrieve newly installed addon version data without restarting the server, as our use case requires checking if an addon is installed before triggering a server restart.

Question

Where can we fetch addon installation/version data directly from the database? Is there an alternative table or mechanism where this data is stored before it gets reflected in the API?

Any guidance or insights would be greatly appreciated!