Updates to EPiCode.SqlBlobProvider

Version 1.3 of EPiCode.SqlBlobProvider is now available in the EPiServer NuGet feed.

In addition to some minor performance improvements, there are a couple of new features:

Cache blobs on disk
If you have a slow database connection or a vast amount of blobs, it would probably be faster to serve the blobs from disk rather than directly from the database. By setting loadFromDisk=”true”, you can do exactly this. This works by automatically caching files on disk when a blob has been requested for the first time. Performance wise, it should be equal to the standard FileBlobProvider. The simplicity and distributional benefits of the provider are still the same.

Files are by default stored in [appDataPath]\\sqlProviderBlobs, but can be configured:

<blob defaultProvider="sqlBlobProvider">

  <providers>

    <add loadFromDisk="true" path="c:\my_custom_location" name="sqlBlobProvider" type="EPiCode.SqlBlobProvider.SqlBlobProvider, EPiCode.SqlBlobProvider" />

  </providers>

</blob>

Export SQL blobs
A scheduled job for exporting all existing SQL blobs has been added. The files will be exported to the default (or configured) path.