I am very puzzled by this. Wasn't the very point of Sqlite to be local? If it's not anymore, why would you prefer to use it rather than any other relational database?
In this setup you use something like blobstore for public shared db access. Looks like single writer at a time.
In traditional databases you connect to a database server.
This is like having a cloud sync for your local app state - shared between devices on a cloud device.
Not quite. The very point is not needing a server. Subtle difference.
Think more data lake and less relational db.