Best Practices for Android SQLite

It may be a little cheeky, but I would like some advice. I am new to Android and started building my first app. I come to the section where I need to create SQLite DB with several tables and look for best practices, but could not find the answer, it helped a little, but not much What are the best practices for SQLite on Android? . I only have about 6 tables.

  • Should I use one class of “constants” to keep all the names of my tables, field names and database name in?

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

  • Any other tips on best practices for maintaining data or any other classes I need?

  • Bonus question :) If someone has good examples, they could point out to me that the example documentation for Android is not deeper enough.

It’s clear that I’m thinking of creating a blog with some simple examples for beginners to use, since some of what I read is a little complicated for small brains like mine.

+5
source share
1 answer

I found this that responds to what I'm looking for. Not sure how I did not find this before with all the searches! Thanks for your help guys / girls!

DB adapter for multiple SQLite tables on Android?

+1
source

All Articles