it means that I can't do it on MySQL database! should I change the DB type and if so which one should I prefer! Postgres or NoSQL?
On Tuesday, July 3, 2018 at 3:20:40 AM UTC+5:30, Melvyn Sopacua wrote: > > On maandag 2 juli 2018 21:33:35 CEST hardik dadhich wrote: > > > > > Can anyone tell me how can I make dynamic Django model fields? I mean to > > > say that I want to save excel file data in Django model using MySQL. and > > > excel column can vary. The user can upload 100 column table or he can be > > > upload 1000 column table in the database. so it is possible to add > > > dynamically in db. > > > > It makes little sense to store this in a database, because you cannot > define relations for what you don't know about. But if you must ... > > > > One way to do this is to use the EAV data model > <https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model>. > This is because at 1000 columns = 1000 fields, you will most certainly hit > MySQL's maximum row size > <https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html>. > > > > -- > > Melvyn Sopacua > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/058e3f9e-8168-4459-88f7-878b3462fd3e%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
