3 ms·
PriceTable is hosted on Gigalixir. The database is Postgres. Everything is in the same database, but each tenant has its own schema. When a new account/workspac
by enraged_camel 6y ago
PriceTable is hosted on Gigalixir. The database is Postgres. Everything is in the same database, but each tenant has its own schema. When a new account/workspace is created, we create a new schema and run a set of migrations on it to create tables, indexes, and so on. From there, each request is routed to that schema using the tenant's prefix.
https://www.viget.com/articles/multi-tenancy-with-postgres-schemas-and-ecto/ https://www.viget.com/articles/multi-tenancy-with-postgres-s...
- wizzzzzy 6y agoAh Thanks, thats interesting.