Hacker News Reader

This looks great. Just wondering if you can share any details on what hosting / architecture you're running this on? Is each user's space running in it's own container or everything in the same DB for example?

View on HN

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-s...

Ah Thanks, thats interesting.

Reply on news.ycombinator.com