3 ms·
The idea is prevent a simple SQL mistake from exposing information across tenants.
by barrkel 6y ago
The idea is prevent a simple SQL mistake from exposing information across tenants.
- latch 6y agoRLS seems like a simpler solution.
- barrkel 6y agoHow well does that work with mysql 5.5 in 2012? Exactly. (It's not actually simpler when query execution over 100s of millions of rows is a perf bottleneck, and each tenant has several billion rows in the main tables. Then you're grateful you can schlep them around, and keep small tenants fast, etc. Even now, Postgres would still be a dubious choice due to the unpredictability of its query planner, though I use it for all my hobby projects.)