3 ms·
What’s wrong with just namespacing tables per module/app/whatever? `wordpress_%app_table1` etc. if you want to do it ad-hoc. PostgresSQL support namespacing o
by deno 10y ago
What’s wrong with just namespacing tables per module/app/whatever?
`wordpress_%app_table1` etc. if you want to do it ad-hoc.
PostgresSQL support namespacing out of the box[1][2].
[1] https://www.postgresql.org/docs/9.3/static/ddl-schemas.html https://www.postgresql.org/docs/9.3/static/ddl-schemas.html
[2] http://jerodsanto.net/2011/07/building-multi-tenant-rails-apps-with-postgresql-schemas/ http://jerodsanto.net/2011/07/building-multi-tenant-rails-ap...
- jameshart 10y agoBecause giving a webapp sufficient permissions to CREATE, ALTER, and DROP tables is risky.
- emodendroket 10y agoIt gets harder to make assumptions about what tables are there when you want to migrate things. I also think it's a hassle if you want to do something like have multiple tenants in a single DB (not impossible, I suppose).