Is it a bad practice to create DB tables from a plugin?

PeerTube
1

Hi,

We’re developing a plugin where we will store a lot of information in the database. We’re aware of the storage manager, but since everything is stored in a single JSONB column it will be a lot of data in and out for each query. Therefore we’re thinking about creating a separate Postgres table for this plugin. Can you see any drawbacks with such a solution?

2

Hi,

I think it’s okay if you choose table names with a custom prefix (like pluginName_ since PeerTube doesn’t use _ in table names) + you don’t use foreign keys to peertube tables (as column names can be changed between peertube versions)