I don’t see the point of using schemas. Why not just one database per app and call it a day?
Scott —
One DB per app does not scale. Think about shopify. They have 1000 tenants probably. If they had to setup a new DB for every tenant they would be paying for a lot of extra servers
drhenner —
Also relevant is cost. DB’s often cost money, and at least early on in scaling, it’s cost effective to co-locate.
Comments
I don’t see the point of using schemas. Why not just one database per app and call it a day?
One DB per app does not scale. Think about shopify. They have 1000 tenants probably. If they had to setup a new DB for every tenant they would be paying for a lot of extra servers
Also relevant is cost. DB’s often cost money, and at least early on in scaling, it’s cost effective to co-locate.
Post a comment