Database per user

[@astroNexx]

love the alternative approach & exploration

[@constantinegeist1854]

Per-tenant SQLite DBs work great for b2b tenants, i.e. organizations, because you want to isolate organizations' data from each other, and SQLite's single writer restriction becomes a non-issue

[@notrab]

With Turso specifically we queue those up and are played so writes aren’t missed.

[@aryzen2781]

i read sqlite only allows 125 connections with attach. what if you have a lot of users? how would you do that?

[@notrab]

It depends if you need to ATTACH. If you’re performing aggregate queries, perhaps you run tasks where to run queries against each of the databases and then do what you need.

[@edhahaz]

Give every table it's own database for each database user.

[@mylotundinho]

😂