News for hackers. Stuff that matters.
Re:Shardines: SQLite3 Database-per-Tenant with ActiveRecord by andrewstuart on Sunday April 27, 2025 @02:50PM (#43814211)
Yeah but “schemas out of sync!” Is a never ending development and operations problem with SQLite database per tenant.

Postgres row level access control gives all the benefits of strong isolation with none of the pain of schemas getting out of sync.

Re:Shardines: SQLite3 Database-per-Tenant with ActiveRecord by julik on Sunday April 27, 2025 @07:09PM (#43815900)
You do need to keep tabs on whether they are or not, that is true - and you will have a bit of management to do if they are under constant heavy write load. For me, this all works out because I don't have too many tenants - and I have tools to block writes when running migrations.

It's all tradeoffs after all.