What is the best update mechanism for a software cataloguing application?
<p>I'm developing an Android application very much like the the Android Market (now Google Play) in which I offer various softwares to user for installation. The difference is here that I want the user to be able to browse the applications even when there is no internet connectivity. That means I have to store the data on a local database (here I want to use sqlite) and this data needs to be updated periodically.<br>
Now my question is this. How should I implement this update mechanism to have the best performance and availability?<br>
I think I have a few options which is as following:</p>

<ol>
<li>To update the whole database every time. This way I have to download every single record every time to have the updated content.</li>
<li>To update the data based on the date they were added. Although this seems a good way, but there is a possibility that the previously added content may be edited and they are omitted in this approach. Also there is this possibility that some of the items are deleted.</li>
</ol>

<p>These were what I thought I can do but I don't know which is best way to go on?! Also I am open to any other suggestion that might work here.</p>
