Delt
CCConvex Community
•Created by Delt on 8/17/2023 in #support-community
Apps with one database per tenant
Great ideas, I'll try experimenting with this!
7 replies
CCConvex Community
•Created by Delt on 8/17/2023 in #support-community
Apps with one database per tenant
Wonderful response! This was exactly what I needed, thank you. Now I can continue with Convex and continue to sleep well 😀
7 replies
CCConvex Community
•Created by Delt on 8/17/2023 in #support-community
Apps with one database per tenant
Thank you for your answer @ian.
It would certainly be easiest to put them all in one database as you suggest. However, restoring data for a single tenant becomes complicated and is probably the biggest painpoint. Isolation is also important to prevent a tenants data being exposed to others if a dev writes an incorrect WHERE clause.
I suppose a database-per-tenant setup could be built with Convex once it goes open source. Say I start out with a single database per tenant for now and then later migrate tenant data from the single db to individual databases enabled by a Convex fork, built by e.g. me, that supports db-per-tenant.
About the backups, I guess it could be possible to automate the snapshot export and/or streaming of data using airbyte?
7 replies