At $WORK, we use the same approach for integrations with 3rd party systems.
The data that is common for all integrations are stored as columns in a relational table. Data that are specific for each integration are stored in JSONB. This is typically meta data used to manage each integration that varies.
It works great and you get the combination of relational safety and no-schema flexibility where it matters.
The data that is common for all integrations are stored as columns in a relational table. Data that are specific for each integration are stored in JSONB. This is typically meta data used to manage each integration that varies.
It works great and you get the combination of relational safety and no-schema flexibility where it matters.