Why doesn’t each of your users have a SQLite database writing up to a main?

You can have as many as you want - and one is often plenty.