Multiple sqlite *.db files for android application

Question

What is a best practice to manage different user accounts in one application? I saw the same topics here but i didn't find answer on my question. Is it a best practice to use different "userId-appName.db" for each user in application?

Or need to add userId in each table?

Sony · Accepted Answer · 2017-07-03 14:34:19Z

1

No it is not a best practice to use separate databases for each user in the application. Use a table with all the users in your application and pass the userId elsewhere. It will eliminate a lot of head ache down the road. and you don't have to track every user's database. Imagine if your app have 10 users in a mobile. How will you track each user's database? another database with all those details?

answered Jul 3, 2017 at 14:34

Sony

7,1866 gold badges49 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andrii Over a year ago

I understood. Thank you. But is it possible to open different db when user logging in? And if yes how to do this? Just provide different names into dbHepler constructor?

Sony Over a year ago

Sorry man i've never tried that. try it for yourself and tell us your experience, for the whole world to know :-)

Collectives™ on Stack Overflow

Multiple sqlite *.db files for android application

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related