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.
James source
share