News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by blacktriangle on Thursday April 15, 2021 @09:38AM (#26820328)
By multi tenancy is dead easy in Postgres, are you talking about schemas?

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.

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.