sqlite - How to handle multi-user data storage in Android?

Question

The current implementation is that one User corresponds to one database. But I think it is also possible to add a User table and use foreign key association. Don't know which implementation is better? Are there any other ways to achieve this?

Answer 1

From the perspective of easy upgrade, it is better to use 一个数据库+外键关联, especially when using a third-party ORM.

Answer 2

Same as the website backend, use User+foreign keys, as mentioned above, if you upgrade the table structure one by one, you will be exhausted.

Answer 3

One User corresponds to one database, and data search is fast

Answer 4

What effect do you want to achieve?
Or what data is stored?

Answer 5

You can create tables by user (table name + user ID)