News for hackers. Stuff that matters.

A comment on Multi-Tenant Architectures. Parent comment

Re:Multi-Tenant Architectures by number6 on Monday August 31, 2020 @01:53AM (#24328852)
What about postgres' schema to isolate tenants?

https://www.postgresql.org/docs/current/ddl-schemas.html

[ Parent | on HN ]
Re:Multi-Tenant Architectures by treis on Monday August 31, 2020 @09:12AM (#24331086)
These guys wrote the most popular Ruby on Rails multitenant gem and eventually moved away from it:

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.

[ Parent | on HN ]
Re:Multi-Tenant Architectures by pvorb on Monday August 31, 2020 @02:35AM (#24329005)
I'm using this in practice and it has served me well for years.
[ Parent | on HN ]