Django Binary or BLOB model field

2019-04-23 07:06发布

问题:

I have a C# program that inserts a pdf inside a MySQL database. Now I want to retrieve that pdf via django but django's models.FileField needs an "Upload To" parameter which means behind the scenes it actually stores the File on the file system rather than in the database. Is there any way I can set up a django model so that I can store the pdf directly inside MySQL?

Regards

回答1:

I have been dealing with this same issue, writing a pdf to a mediumblob field in mysql and retrieving via django. I have set the mysql field type to a mediumblob and the django field type to textfield. I have used a queryset and httpresponse to view the PDF objects in a browser (but not directly in django).



回答2:

Just as an update to this, as of Django 1.6, there's now a BinaryField option that will store files up to 4 GB in size. https://docs.djangoproject.com/en/dev/ref/models/fields/#django.db.models.BinaryField