README

Plinth.Storage.PgSql

Storage Index driver for PostgreSQL

Enables storing the blob index used by Plinth.Storage in PostgreSQL

:point_right: In the package Schema folder, find the Procedures.sql and Tables.sql files. Include those in your database scripts. It is required by the framework that the procedures and tables be available.

This package adds this extension method to Plinth.Storage.StorageFactory to utilize PostgreSQL for the index.

var blobStorage = storageFactory.Get(connection, callingUser);

If you want to read blob data from the database, include this line when constructing the factory in Startup

storageFactory.AddDatabaseProvider()

If you want to write blob data to the database (only recommended for testing), include this line

storageFactory.SetDefaultWriteProviderAsDatabase()