I
I
Ivan Petrov2018-11-22 13:40:45
MySQL
Ivan Petrov, 2018-11-22 13:40:45

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

2 answer(s)
M
Melkij, 2018-11-22
@melkij

It is necessary that each user has a separate database.

There is no connection between the proposals, much less a causal one.
To begin with, answer for what reasons you decided to discard the usual normal form (this is a technical term) with the addition of fields with reference to the owner to the entities.

S
stratosmi, 2018-11-22
@stratosmi

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 question

Ask a Question

731 491 924 answers to any question