title: Store shop opening times
body: <p>This is more of an app design question so forgive me if it's not relevant.</p>
  
  <p>The app I am working on is designed to show what shops are open in the area and I am not sure what is the best way to store this information. I get the information from a database (I didn't design) that supplies an array of boolean values that determine if the shop is open during that time or not. Each boolean value represents a 15 minute slot e.g. 07:00-07:15.</p>
  
  <p>This is split down into days but not specific dates, for instance the shop could be open Mon-Fri 09:00-17:00 but Sat 09:00-20:00 so the model I keep will have to know what the day is but not necessarily the date.</p>
  
  <p>What I'm not sure about is how to store all of this for ease/speed of lookup because I want the view to be able to update in real time (shops change from open to closed without refresh). I have considered adding a table to the DB that contains opening times for any shop (using proper times and days) and then let SQLite do all the hard work allowing the Java to assume the shop is closed unless it gets a record back but that feels a little clunky because it might be better to hold the opening times in memory somehow.</p>
  
  <p>Any help you can give would be awesome.</p>