Save uploaded files in database
Currently, uploaded files are stored outside the database. This is tricky when it comes to security (file size, number of concurrently accessed files, dangling files), it is difficult when backing up and performance-wise slower. Databases fully support storage of large blobs of data (specifically images and text files). These are generally stored in separate memory space, yet can still be indexed for performance reasons and can participate efficiently in joins.
Some additional explanation on:
http://dev.mysql.com/doc/refman/5.0/en/blob.html
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.htmlDatabase storage for files would therefore improve the stability and performance of WebDSL applications.
Submitted by Sander Vermolen on 17 February 2010 at 10:20
(Issue blocks: YellowGrass/48)
Issue Log
+1
I would really like to see attachment support in YellowGrass for issues where we need to attach things like grammars and parse tables.
The
File
type stores files in the database.input(File)
is a file upload andoutput(File)
is a download link.
Great. I did not know this. That solves the issue.
Log in to post comments