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

Database storage for files would therefore improve the stability and performance of WebDSL applications.
(Issue blocks: YellowGrass/48)

Submitted by Sander Vermolen on 17 February 2010 at 10:20

On 17 February 2010 at 10:58 Lennart Kats commented:

+1

I would really like to see attachment support in YellowGrass for issues where we need to attach things like grammars and parse tables.


On 17 February 2010 at 12:04 Danny Groenewegen commented:

The File type stores files in the database. input(File) is a file upload and output(File) is a download link.


On 17 February 2010 at 12:32 Sander Vermolen commented:

Great. I did not know this. That solves the issue.

Log in to post comments