title: Handling multiple tables in SQLite on Android - why so complicated?
body: <p>I'm desperately trying to set up a database with multiple tables which looks like: </p>
  
  <pre><code>nutrition.db:
  Ingredient(ID, name, kcal); 
  Meal(ID, name, ingredientId1, ingredientId2);
  MealInstance(ID, mealId, date, amountOfIngr1, amountOfIngr2) ...
  </code></pre>
  
  <p>I stumbled across miscellaneous approaches - for instance expanding a Provider class like the one from the notepad tutorial (<strong>extends</strong> ContentProvider) by using tons of switch-cases or alternatively building up an entire CRUD-interface based on .execSQL yourself. However all of this seems absurdly complex to me for such an easy (and common?) task, which is why I believe I overlooked something. For some odd reason all tutorials that I've checked only use a single DB and a single table. </p>
  
  <p>I'd really appreciate a tutorial recommendation or some hint.</p>