Will this be good for apps syncing to client, which can be millions of client to the server? We can update any table data change on the server SQLite, and it will be synced to the clients. Will it support differential sync, keeping the network bandwidth to minimum?
Yes, it only sends what was modified. And this happens in both directions.
I have not tested it under these conditions of millions of nodes. If you do so, please inform the results.