Answer the question
In order to leave comments, you need to log in
What are examples of database architecture in which each user has a separate database?
I'm going to start working on a service for learning foreign languages.
Each user will have their own dictionary and some other data.
Each user has a separate small database, with a maximum of 200,000 entries.
How can this be implemented? Is it ok to create thousands of databases in mysql or should I use something else?
Answer the question
In order to leave comments, you need to log in
It is necessary that each user has a separate database.
There are no such architectures. Because NOT WANTED.
Except perhaps for considerations of top-secrecy of each user's data, when the security service of your enterprise will fundamentally insist on the separation of databases.
Regularly, this is done simply by an additional field - the user ID - all data is filtered by it when issued to the user from tables common to all. It is impossible to get foreign data.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question