Re:SQLite the only database you will ever need in most cases
by andrewstuart on Thursday April 15, 2021 @10:04AM
(#26820633)
Refer to this comment elsewhere in this thread: https://news.ycombinator.com/item?id=26817468
No I am not using schemas - I found them to be brittle and complex as a solution for multitenancy.
I use Postgres row level security.
I use Python/Django.
Read this entire comment thread for more info from other posters on row level security.
If so, have you run into any scaling issues with the number of tenants you can support. I looked into using schemas for multi tenancy but the various reports I found said around 50 tenants or so things started breaking down very quickly.