Can use one sqlite per tenant or look into the new multi writer lib on github.

Wal or wal2 can help you with that.