5

This might be a bit cheeky but I would like some advice. I'm new to Android and have started to create my first app. I'm coming to the section where I need to create an SQLite DB with multiple tables and have been looking for best practices but have been unable to find my answer, this helped a little but not a lot What are the best practices for SQLite on Android?. I need about 6 tables in total.

  1. Should I use one "constants" class to keep all of my table names, field names and database name in?

  2. Should I create one "DBHelper" class to run all my SQL SELECT, UPDATE, DELETE in or create one per table?

  3. Any other advice around best practices around maintaining the data or any other classes I need?

  4. Bonus question :) If any one has any good examples they could point me towards as the Android documentation example is not in depth enough.

It's appreciated, I'm thinking about creating a blog with some simple examples for newbies to use as some of what I have read is a bit complex for small brains like mine.

Community
  • 1
  • 1
James
  • 474
  • 4
  • 9
  • 22
  • You can try this [simple approach](http://pastebin.com/3pfzXMgv) at beginning and this is a [sample project](http://www.mediafire.com/?569on9rvb4qoa7w) based on the simple approach :) – Imran Rana May 29 '12 at 10:14
  • @James, you should visit this [answer](http://stackoverflow.com/a/9141116/996493) as well – Lucifer May 29 '12 at 10:16
  • @Lucifer thanks that will be good to know, internal for me I think as it will hold only a few hundred entries before being cleared and r-filled with fresh data :) – James May 29 '12 at 10:19

1 Answers1

2

I found this which answers what I'm looking for. Not sure how I didn't find this before with all the searching! Thanks for all your help guys/girls!

Multiple Table SQLite DB Adapter(s) in Android?

Community
  • 1
  • 1
James
  • 474
  • 4
  • 9
  • 22