I was watching a course on the online devmedia explaining about Sqlite on Android, the course example was made a basic crud, were created 1 bank and 2 tables. In the example, I was creating two classes that extended the SqliteOpenHelper, and each class handled a table, that is, the example was using the SqliteOpenHelper to manage the database and table data !!
After searching from the outside, I saw that when you create the database, sqlite generates its cache, which could be a big problem in this example case. And I saw an example of a site that used a separate class to manipulate the tables!
-
So I'm confused, does SqliteOpenHelper only serve to create the bank?
-
Do not manipulate table data by it (creating multiple SqliteOpenHelper classes, for each table)?
-
If it only serves to manage the database (without the tables), would I have to create all tables in the same SqliteOpenHelper class? In this case, if a user removes some table, how would it return?
I can not send the link from devmedia because access is for subscribers only.
Example managing tables outside the helper: link