Community.Microsoft.Extensions.Caching.PostgreSql 4.0.4

dotnet add package Community.Microsoft.Extensions.Caching.PostgreSql --version 4.0.4
NuGet\Install-Package Community.Microsoft.Extensions.Caching.PostgreSql -Version 4.0.4
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Community.Microsoft.Extensions.Caching.PostgreSql" Version="4.0.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Community.Microsoft.Extensions.Caching.PostgreSql --version 4.0.4
#r "nuget: Community.Microsoft.Extensions.Caching.PostgreSql, 4.0.4"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Community.Microsoft.Extensions.Caching.PostgreSql as a Cake Addin
#addin nuget:?package=Community.Microsoft.Extensions.Caching.PostgreSql&version=4.0.4

// Install Community.Microsoft.Extensions.Caching.PostgreSql as a Cake Tool
#tool nuget:?package=Community.Microsoft.Extensions.Caching.PostgreSql&version=4.0.4

Community.Microsoft.Extensions.Caching.PostgreSQL Nuget

Description

This implemantation uses PostgreSQL 11+ as distributed cache. Version 4 and up.

For PostgreSQL ⇐ 10

Use older versions of this packages (<= 3.1.2)

Getting Started

  1. Install the package into your project
dotnet add package Community.Microsoft.Extensions.Caching.PostgreSql
  1. Add the following line to the Startup Configure method.
services.AddDistributedPostgreSqlCache(setup =>
{
    setup.ConnectionString = configuration["ConnectionString"];
    setup.SchemaName = configuration["SchemaName"];
    setup.TableName = configuration["TableName"];
    setup.DisableRemoveExpired = configuration["DisableRemoveExpired"];
    // Optional - DisableRemoveExpired default is FALSE
    setup.CreateInfrastructure = configuration["CreateInfrastructure"];
    // CreateInfrastructure is optional, default is TRUE
    // This means que every time starts the application the
    // creation of table and database functions will be verified.
    setup.ExpiredItemsDeletionInterval = TimeSpan.FromMinutes(30)
    // ExpiredItemsDeletionInterval is optional
    // This is the periodic interval to scan and delete expired items in the cache. Default is 30 minutes.
    // Minimum allowed is 5 minutes. - If you need less than this please share your use case 😁, just for curiosity...
})

Configuring with IServiceProvider access

services.AddDistributedPostgreSqlCache((serviceProvider, setup) =>
{
    // IConfiguration is used as an example here
    var configuration = serviceProvider.GetRequiredService<IConfiguration>();
    setup.ConnectionString = configuration["ConnectionString"];
    ...
})

Configuring via IConfigureOptions<PostgreSqlCacheOptions>

use

services.AddDistributedPostgreSqlCache();

and implement and register

IConfigureOptions<PostgreSqlCacheOptions>

DisableRemoveExpired = True use case:

When you have 2 or more instances/microservices/processes and you just to leave one of them removing expired items.

  • Note 1: This is not mandatory, see if it fits in you cenario.
  • Note 2: If you have only one instance and set to True, all the expired items will not be auto-removed, when you call GetItem those expired items are filtred out. In that case you are responsable to manually remove the expired key or update it
  1. Then pull from DI like any other service
    /// this is extracted from the React+WebApi WebSample

    private readonly IDistributedCache _cache;

    public WeatherForecastController(IDistributedCache cache)
    {
        _cache = cache;
    }

UpdateOnGetCacheItem = false use case:

For read-only databases or if the database user does not have write permission you can set UpdateOnGetCacheItem = false

  • Note 1: This will cancel the sliding expiration and only absolute experation will work
  • Note 2: This can be used to improve performance
services.AddDistributedPostgreSqlCache((serviceProvider, setup) =>
{
    ...
    setup.UpdateOnGetCacheItem = false;
    // Or
    var configuration = serviceProvider.GetRequiredService<IConfiguration>();
    setup.UpdateOnGetCacheItem = configuration["UpdateOnGetCacheItem"];
    ...
})

What it does to my database 🐘:

It creates a table & schema for storing cache (names are configurable)

Runing the console sample

You will need a local postgresql server with this configuration:

  1. Server listening to port 5432 at localhost
  2. The password of your postgres account, if not attached already to your user.
  3. Clone this repo.
  4. Run the following commands inside PostgreSqlCacheSample:
dotnet restore
prepare-database.cmd -create
dotnet run

S

Runing the React+WebApi WebSample project

You will need a local postgresql server with this configuration:

  1. Server listening to port 5432 at localhost
  2. The password of your postgres account, if not attached already to your user.
  3. You also need npm and node installed on your dev machine
  4. Clone this repo.
  5. Run the following commands inside WebSample:
dotnet restore
prepare-database.cmd -create
dotnet run

It takes some time to npm retore the packages, grab a ☕ while waiting...

Then you can delete the database with:

prepare-database.cmd -erase

Change Log

  1. v4.0.1 - Add suport to .net 7
    1. [BREAKING CHANGE] - Drop suport to .net 5
    2. [BREAKING CHANGE] - Make use of procedures (won't work with PostgreSQL ⇐ 10, use version 3)
  2. v3.1.2 - removed dependency for IHostApplicationLifetime if not supported on the platform: AWS for instance - issue #28
  3. v3.1.0 - Added log messages on Debug Level, multitarget .net5 and .net6, dropped support to netstandard2.0, fix sample to match multitarget and sample database.
  4. v3.0.2 - CreateInfrastructure also creates the schema issue #8
  5. v3.0.1 - DisableRemoveExpired configuration added; If TRUE the cache instance won`t delete expired items.
  6. v3.0
    1. [BREAKING CHANGE] - Direct instantiation not preferred
    2. Single thread loop remover
  7. v2.0.x - Update everything to net5.0, more detailed sample project.
  8. v1.0.8 - Update to latest dependencies -

License

  • MIT

This is a fork from repo

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (4)

Showing the top 4 NuGet packages that depend on Community.Microsoft.Extensions.Caching.PostgreSql:

Package Downloads
BIA.Net.Core.Presentation.Common

Presentation features layer classes for BIA.Net Core Framework

BIA.Net.Core.Presentation.Api

Presentation api layer classes for BIA.Net Core Framework

BIA.Net.Core.WorkerService

WorkerService layer classes for BIA.Net Core Framework

Pipoburgos.SharedKernel.Infrastructure.EntityFrameworkCore.PostgreSQL

EntityFrameworkCore.PostgreSQL infrastructure implementations

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Community.Microsoft.Extensions.Caching.PostgreSql:

Repository Stars
simpleidserver/SimpleIdServer
OpenID, OAuth 2.0, SCIM2.0, UMA2.0, FAPI, CIBA & OPENBANKING Framework for ASP.NET Core
Version Downloads Last updated
4.0.4 36,916 10/2/2023
4.0.2 55,491 12/27/2022
4.0.1 3,089 12/6/2022
3.1.2 77,540 5/25/2022
3.1.1 24,899 2/22/2022
3.1.0 11,339 12/20/2021
3.0.3.2 42,627 5/14/2021
3.0.2 1,098 4/4/2021
3.0.1 18,958 1/17/2021
3.0.0 774 1/9/2021
2.0.7 2,279 11/27/2020
1.0.30 68,090 4/20/2019
1.0.7 2,824 3/24/2018
1.0.5 833 3/22/2018
1.0.0 950 3/22/2018