python - Django database router

Question

I'd like to route (change) the database based on the authenticated user. I've looked at the docs but I don't know how to do this upon user login...

I was thinking of adding a field with database_name to my custom UserProfile and then I'd like to pass this info to the database router which would make the switch...

I don't have any code to show because I simply don't know how to implement this.

This post somehow relates to my previous post.

So the schema would be like:

- Users (containing only the `UserProfile`)
 - user1 (containing the app database)
 - user2 (containing the app database)
 - ...

Could you point me to the right direction?

Thank you! BR

Answer 1

Multitenancy in general is a little bit hard to do without twisting django a bit, even though it is a typical request in SaaS applications. Here is a link describing one approach, the one developed at a company I worked with was a little bit different, hacking the contrib.sites, but the database part is pretty similar.

In short, if you want database multitenancy you are going to have to hack Django ConnectionHandler to do what you want.