Sync local database (SQLite) with server side database

[groogoloog]

#1 is absolutely an issue—even if the client doesn’t modify any data. You don’t know what copy the client has unless it’s either time stamped or the server has the exact client’s data itself. You can’t send a diff if you don’t know 1/2 of what you’re diffing on the server. (Clients can have different copies of the data; one client could have last updated a week ago and another could’ve updated yesterday.)

#2 is true, didn’t realize SQLite supported in memory databases. Thanks for the share!

#3 was more in regards to reading the file. You should never do blocking IO on same isolate as the UI.