Django Binary or BLOB model field


Question

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
9
9/17/2011 5:58:53 AM

Accepted Answer

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).

1
8/18/2011 1:18:19 PM

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


Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Icon