Really need some help, stuck in this problem for almost 1 month. We are building a SaaS platform where our customers integrate their data from Salesforce, segment and Stripe. Each of our customers data can have different traits linked with it, we have built a single source of truth table in Postgres.
But after trying with Jsonb and multiple other options, either it's too slow or doesn't work.
The only solution I can think of now is to have each of our customer's dynamic data stored in separate tables.
But wherever I read it's listed as an antipattern can't seem to find a solution out of it.
Any help would be appreciated.