Creating/updating and deleting models at runtime

Using Django Using the ORM
1

Hi everyone,

Here is a request I had last friday. Currently, my client use monday.com for scheduling/tasking because when he launched his startup in 2022, it was fulfilling his requirements.

But over the years, the cost just ramp up and limitations appeared.

My question is the following :

Is it possible to create/update/delete models schema at runtime.

For example, I’ve a client model :

class Client(models.Model):
    nom = models.CharField(max_length=255, blank=False, unique=True)
    contact_name = models.CharField(max_length=255, blank=False)
    contact_number = models.CharField(max_length=10,blank = False)

and like in monday, the client need to add/remove fields just in monday :

image
image1920×1080 276 KB

I am almost sure it can be done but I understand the way django behave with the ORM and the way he’s making the database with makemigrations and migrate can be problematic.

My first though would be to save the models schema into a database table which will be a dynamic version of models.py.

But before getting too deep into that, I’m probably not the first to address this situation.

2

Short answer: No.

Slightly longer answer: Yes, but with a lot of caveats, limitations, and potential pitfalls. And it does require restarting all server instances using those models.

You can search the forums here for threads on this topic.

See:

among others.

2 Likes
3

As always, Thank you Ken