by markhalonen on 8/15/23, 7:23 PM with 0 comments
If you had a multi-tenant Postgres DB, how would you build a system such as Stripe Sigma? Where each tenant can only query their own data obviously.
Thanks for any recommendations!
More notes that could be helpful:
* dozens of tables
* data latency should be minimized, but 5 minutes is fine.
* not "big data", <10 GB per tenant
* need a post-processing step (for example, add a column of current balance to each transaction in an accounting system)