Often times when developing plugins, I’ve had to use the CustomField or PluginRowStore tables to store arbitrary data related to the plugin (for example, retort stores a string representation of reactions to a particular post as a PostCustomField)
This works well for simple data, but for anything a bit more complex, I’ve found myself wanting access to more than a postgres
text-valued column can provide. Postgres has supported the jsonb column type for several versions now (since 9.4), which provides some super-great features like finding and filtering by nested json fields, as well as indexing.
I wonder what the feasibility would be of adding a jsonb column to PluginStoreRow, or possibly converting the existing
value column to jsonb to allow for more complicated models to be stored there?