Database Blob File

This plugin is in a very early stage and should not be used for production environment.

Store your uploads from CakePHP form helper directly in the database as binary object.

If you still consider that all uploaded files have to be stored in the filesystem you can ignore this plugin.

Install

Enable Plugin

Enable to plugin in your bootstrap.php file. Routes are required for serving uploaded files via http.

CakePlugin::load('DatabaseBlobFile', array(
	'routes'    => true,
	'bootstrap' => true,
));

Create a BLOB column

Change or add an column in your database as MEDIUMBLOB (max. 16MB file size).

Add the behavior to your Model

Tell the Model to load the behavior for saving files directly.

public $actsAs = array(
	'DatabaseBlobFile.BlobFile' => array(
		'imageMaxWidth' => 1000,
	)
);

You can set addional parameters like:

imageMaxWidth Resize uploaded images to have a maximum width.

Form

And make sure your form created with a correct type to allow file uploads at all.

<?php echo $this->Form->create('Object',array('type'=>'file')); ?>

Add your form field with the form helper

<?php echo $this->Form->input('column_name'); ?>

Using the plugin

Because it is not necessary to transfer all files with every database select every time the model returns only the uploaded file size in byte. This can be usefull to decide if something has been uploaded at all.

You will have a new virtual field containing a base path to the file (will be replaced with a View helper function) in your database result.

<?php echo $this->Html->image($model['Table']['columnname_basepath'].'size.jpg')

Caching

Every file which has been served once will be stored inside the webroot for caching with a timestamp. This is supposed to work with a deployment processes which resets the app folder to its correct state with every deployment.

Roadmap

• Support for more file types than just images
• More config options for caching and serving files (use subdomain, path and cdn)