Syncing a table records with a Service response frequently
Posted
by
Karthik Dheeraj
on Stack Overflow
See other posts from Stack Overflow
or by Karthik Dheeraj
Published on 2013-10-19T09:46:04Z
Indexed on
2013/10/19
9:54 UTC
Read the original article
Hit count: 233
I am requesting data from a service whose response in stored in a database.First, I have an empty table, whenever I make my very first request the records from the service comes to my database table.
from now, whenever I make second request, the service will provide me some records which may be same as my first response, may be new records, may be updated records etc.
my query is to how to update my table with respect to the responses coming from the service during my second request on-wards? so that Unchanged records will remain same, New records will be added, updated records will be updated.Do I need to write any stored procedure on my DB or any workaround ?what might be the scenario if I use Nomysql DB's like mongo DB ? Thanks In Advance.
© Stack Overflow or respective owner
