How to configure silverstripe 4 to use a BLOB field instead of the file system

Question

In the Silverstripe 4 docs the possiblity to use a BLOB or s3 storage is mentioned (https://www.silverstripe.org/learn/lessons/v4/working-with-files-and-images-1)

But I cannot find any documention how to handle a BLOB storage. Is this only about configuration or is some implementation required? Are there examples?

Answer 1

You can create a custom DBField class for BLOB.

Here is the example DBBlobField class works in SS 4.2 with MariaDB.

use SilverStripe\ORM\DB;
use SilverStripe\ORM\FieldType\DBField;

class DBBlobField extends DBField
{
    function requireField()
    {
        DB::require_field($this->tableName, $this->name, "mediumblob");
    }
}

mediumblob is the BLOB type supported by your database.

Define the $db field in DataObject.

private static $db = [
    "Data" => DBBlobField::class
];

Save file content into Data field.

$dataObject->Data = file_get_contents($filePath);
$dataObject->write();