SmartDBStorage is a File Storage for Django that stores files in the database using Django Models.
When the attachments or images are as important as the other data, you may want to store them in the database for better integrity and consistency.
For example, this is specially useful to store original pictures which are displayed using sorl thumbnail.
Advantages : everything at the same place, no more broken links, better flexibility. Disadvantages : performance, overall data usage.
Minimal configuration : just a pluggable Django app.
Django model based : No database to create and setup manually. Uses South.
Files are saved in chunks in order to limit memory usage.
Original file names are preserved : no more logo_1.jpg, logo_2.jpg, logo_3.jpg "behind the scene" renames. Files a renamed to /some_unique_id/original_file_name.ext.
Files can be extracted to another File Storage when accessed from the web or be served directly from the database. (not recommended, but useful for debugging purposes)
Basic admin for inspection purposes.
'south' (if you don't use it already)
'smartdbstorage' to your
INSTALLED_APPS = ( ... 'south', 'smartdbstorage' )
From the command line:
./manage.py syncdb ./manage.py migrate smartdbstorage
settings.py, it's a good idea to set global defaults:
SMARTDBSTORAGE_SERVE_DIRECTLY = False # when accessed from the web files are either served directly or extracted to another file storage SMARTDBSTORAGE_EXTRACTION_STORAGE = DEFAULT_FILE_STORAGE
urls.py, add the following:
(r'^some_prefix/', include('smartdbstorage.urls', namespace='smart_db_storage')),
This allows to serve files directly from the database if needed.
Simply specify a SmartDBStorage instance where you want to use it:
class Article(models.Model): text = models.TextField() image = ImageField(upload_to='articles_images', storage=SmartDBStorage())
You can override defaults like this:
class Article(models.Model): text = models.TextField() image = ImageField(upload_to='articles_images', storage=SmartDBStorage(option=dict(extraction_storage=FileSystemStorage())))