title: ContentObserver for SQLite?
body: <p>I've been looking into ways to show data from my DB in a ListView while keeping track of changes in the database.</p>
  
  <p>Let's say I have a chat app that shows a ListView of all the chatrooms I am a member of.</p>
  
  <p>the query for the adapter is <code>SELECT * FROM CHAT_ROOM ORDER BY UPTDATE_TIME</code>, meaning I want the chatrooms with recent activity to be shown first. as I am in the <code>ChatroomListActivity</code> a message is received for chatroom number 3, this means it needs to become now chatroom number one and rearrange the cell accordingly.</p>
  
  <p>I know that Loaders are capable of re-querying in the background but as commonsware answered in my <a href="https://stackoverflow.com/a/13473279/1056359">previous question here</a>, it seems like Loaders are not good enough for this.</p>
  
  <p>is there a different mechanism for observing database changes in realtime? </p>