android SQLite - manage a single database with multiple users

Question

I'm creating an app which allows a user to login and retrieve some information about his account from a server. These information are inserted in a SQLite database, and then the user can set other preferences on them (I use sharedpreferences for this).

Now i want to expand the app allowing more users to login. The problem is that i don't know exactly how to manage the database with multiple users, infact:

• if I keep db after logout, and login with another account, I find the information related to the previous user;
• if I don't keep the db, and erase it after logout, I miss all the preferences set by the user;

How can I solve this problem? Thanks..

Answer 1

This can be done in multiple ways 1. Have user id table created and link that to other tables using foreign key. another way is 2. create new DB for each of the users. so your database name will have username. If user name changes then database changes.

with second way your code changes will be minimal.