Connect to databases dynamically in Django

Question

I'm new to Django.

My project database architecture is like

Having 'Auth_DB' contains all the users login details.

Once user logged in, then in need to fetch the details from the other DB. Here i have databases for each user individually, like:

user_0001
user_0002
user_0003
user_0004
user_0005

Can any one please help how can i achieve this.

Thanks in Advance.

A database per user? Really? How are your models defined? I am wondering if you do not make a confusion. — keepAlive, Aug 14 '18 at 10:53
One question, does this mean that with each new user, you create a new database dynamically and migrate a predefined schema to this database? — Ahmed Hosny, Aug 14 '18 at 10:55
@Kanak same model can be used, as the tables, columns would be same. — MadhuP, Aug 14 '18 at 11:08
@AhmedHosny yes. Currently my system contains few set of databases. I would like to provide API's. — MadhuP, Aug 14 '18 at 11:10
@MadhuP Please check https://stackoverflow.com/a/11292526/7890592 — Muthuraj S, Aug 14 '18 at 11:18
@MuthurajS Thanks. I Have gone through the solution earlier, but haven't tried. Now i tried and get implemented it works. — MadhuP, Aug 14 '18 at 13:07
@MuthurajS can we follow the same procedure for setting throttling limit? — MadhuP, Aug 22 '18 at 06:35
Does this answer your question? [Django multiple and dynamic databases](https://stackoverflow.com/questions/6585373/django-multiple-and-dynamic-databases) — Abdul Aziz Barkat, Jun 10 '22 at 15:23

score 0 · Accepted Answer · answered Oct 30 '19 at 11:38

In summary, this is the process:

Add the new database to settings (at runtime)
Create a file to store these settings for reloading when the server is restarted (at runtime)
Run a script which loads the saved settings files (whenever the server is restarted)

1 Answers1