title: Best way to determine if a database has been changed?
body: <p>I'm working on architecting a sqlite database for a gallery application. I would like to know if using a time stamp to check if the db has been updated is good practice, or if there is a better way to do this.</p>
  
  <p>Here's what I have...three tables:</p>
  
  <pre><code>buildings
    buliding_id PK
    code
    name
    description
    timestamp
  
  building_album
   album_id PK
   building_id FK (reference to buildings-&gt;building_id)
   album_url
   timestamp
  
  building_images
   image_id PK
   album_id FK (reference to building_album-&gt;album_id)
   image
   timestamp
  </code></pre>
  
  <p>As of now I would have the application check against the server's db to see if any time stamps have changed, and if they have change those fields.</p>