I know that latest rails suggests SQLite as one of the production options. I don’t get how it’d work with concurrent access though. Time to look into it.
I know that latest rails suggests SQLite as one of the production options. I don’t get how it’d work with concurrent access though. Time to look into it.
Because sqlite is extremely fast. Most projects won't hit its limits
Can use one sqlite per tenant or look into the new multi writer lib on github.
This one? https://github.com/sqliteai/sqlite-multiwriter
Wal or wal2 can help you with that.