This experimental extension allows you to use a Preside storage provider as private storage for a database column (on a Preside object). This could be useful in situations where you have a table with a lot of rows and one large column that is read infrequently. Putting the storage of this column in an S3 bucket, for example, could have a cost benefit, keeping database storage lower and utilising more cheap storage in its place.
With this extension installed (box install preside-ext-external-dbcolumn-storage), you annotate your preside object property with a externalStorageProvider attribute
whose value is a configured storage provider in wirebox:
// a preside object
component {
property name="content" externalStorageProvider="myStorageProvider";
}// WireBox.cfc
// N.B. for illustrative purposes only - settings.mystorageprovider is fictional and would be up to you to configure
// here we are using the s3 storage provider, but could be another storage provider altogether
binder.map( "myStorageProvider" ).asSingleton().to( "app.extensions.preside-ext-s3-storage-provider.services.S3StorageProvider" ).noAutoWire().initWith(
s3bucket = settings.mystorageprovider.bucket
, s3accessKey = settings.mystorageprovider.accessKey
, s3secretKey = settings.mystorageprovider.secretKey
, s3region = settings.mystorageprovider.region
, s3subPath = "/mystorageprovier"
);
This extension is in an ALPHA state. it currently does not:
- Delete objects from the storage provider once their parent record is deleted
- Delete objects from the storage provider when the value of the column changes
This project is licensed under the GPLv2 License - see the LICENSE.txt file for details.
The project is maintained by The Pixl8 Group.
We are a small, friendly and professional community. For the eradication of doubt, we publish a simple code of conduct and expect all contributors, users and passers-by to observe it.