4 ms·
What about postgres' schema to isolate tenants? https://www.postgresql.org/docs/current/ddl-schemas.html https://www.postgresql.org/docs/current/ddl-schemas.ht
by number6 6y ago
What about postgres' schema to isolate tenants?
https://www.postgresql.org/docs/current/ddl-schemas.html https://www.postgresql.org/docs/current/ddl-schemas.html
- pvorb 6y agoI'm using this in practice and it has served me well for years.
- treis 6y agoThese guys wrote the most popular Ruby on Rails multitenant gem and eventually moved away from it: https://influitive.io/our-multi-tenancy-journey-with-postgres-schemas-and-apartment-6ecda151a21f https://influitive.io/our-multi-tenancy-journey-with-postgre... Some things were mistakes but others look like pretty fundamental flaws. Performance is a problem, database changes are a problem, and you aren't able to query across tenants.