@Kishore Nallan what would you suggest, what's the best and robust way to maintain changes to db and updating data in typesense ? is there a preferred way

a) What's your primary datastore? b) How frequently does your data change?

mysql and 10 15 changes a minute max but might get bigger in future

And do you need the data to be available for search immediately?

no ...not really

Then I suggest writing a cron that runs every minute or so, just querying your database for changes since the last cron run. That way you can accumulate the changes and do imports.

i can do corn method but how will i perform delete with that method ? i'm trying maintaining typesense in my backend so i can just query for all ids and try to match with all ids in the db and perform a delete on the ones that are no more in the db 😕

If you do logical deletion in your app you can identify deletions. By logical deletion I mean setting a is_deleted flag.

like a is_deleted columns in db ?

Yes.