How to competently update a large database on a mobile client?

Question

iOS

Good afternoon,
Imagine that, for example, we are creating a mobile client for an online store and we need to be able to view products, filter, search, etc. on the mobile client. offline, that is, for this we need to store the database locally on the client, on iOS it will be CoreData / Realm / SQLite, how to update the data correctly?
So far, this option comes to mind: send the client a list of product IDs that need to be updated/deleted/inserted.

{
update: ["id1", "id2"],
delete: ["id3", "id4"],
insert: ["id5", "id6", "id7"]
}

Further, the client will make requests for these IDs for updating / deleting / inserting. What other options are possible?

Answer 1

https://pouchdb.com/faq.html

Answer 2

why not save the date/time of the last synchronization on the client and when requesting a directory, send this date to the server, and it will already return what has changed/added/deleted since then.