Shared data types for building collaborative softwareProject mention: Consider SQLite | news.ycombinator.com | 2021-12-29
You have to handle the merge conflicts yourself, see https://www.sqlite.org/session/sqlite3changeset_apply.html
So you need to be carful how you design your schema, but very possible.
One option is to use something like Yjs and a JSON column to get proper CRDTs for merging.
Are you hiring? Post a new remote job listing for free.