title: Android app how to store user favorite data to personalise dynamic data
body: <p>I have a remote database that contain data which loaded periodically to the Android app when a new version of data available - i.e. new data have been added or existed data been edited.  I need to keep user preferences of data even if the data has been reloaded. </p>
  
  <p>E.g.  data is a collection of quotes, there is no user registration, user can favorite any quote he like. To speed up the app, data is stored in sqlite database.</p>
  
  <p>Now when a new version available, the data will be reloaded, so what the best way to mark already favorited quotes (like favorited tweet), image below show the idea</p>
  
  <p><img src="https://i.stack.imgur.com/C8dea.jpg" alt="enter image description here"></p>
  
  <p>I thought of adding an extra binary column to the local database for favorite/unfavorite. In addition store  the ids of favorited qoutes in the device (SharedPreferences)
  When the updated data loaded, update the favorite column for qoutes that their ids stored in device with 1s, for the rest, the default value for favorite column is 0. 
  This should be work but I think there may be a better solution.
  Any suggestion, Thanks!</p>