title: Mongo DB Design For Events Calendar
body: <p>We have an events calendar and here is what I am thinking for our basic mongo schema:</p>
  
  <p>users</p>
  
  <ul>
  <li>username</li>
  <li>password</li>
  <li>salt</li>
  </ul>
  
  <p>events</p>
  
  <ul>
  <li>name</li>
  <li>description</li>
  <li>tags[]</li>
  <li>category</li>
  <li>venue_id
  ...</li>
  </ul>
  
  <p>venues</p>
  
  <ul>
  <li>name </li>
  <li>address</li>
  <li>loc</li>
  </ul>
  
  <p>Queries that will be done are:</p>
  
  <ul>
  <li>Listing of distinct tags (this might be hard given current design)</li>
  <li>events in a given tag</li>
  <li>Event information along with the venue location</li>
  <li>All event and venue information for a particular event</li>
  <li>All events near me. Need to use a geo index on loc</li>
  </ul>
  
  <p>Any feedback/ideas on if we should be nesting venues inside events or use mysql instead?</p>