eQuantic.Core.CQS.PostgreSql
2.4.0
dotnet add package eQuantic.Core.CQS.PostgreSql --version 2.4.0
NuGet\Install-Package eQuantic.Core.CQS.PostgreSql -Version 2.4.0
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="eQuantic.Core.CQS.PostgreSql" Version="2.4.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="eQuantic.Core.CQS.PostgreSql" Version="2.4.0" />
<PackageReference Include="eQuantic.Core.CQS.PostgreSql" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add eQuantic.Core.CQS.PostgreSql --version 2.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: eQuantic.Core.CQS.PostgreSql, 2.4.0"
#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.
#:package eQuantic.Core.CQS.PostgreSql@2.4.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=eQuantic.Core.CQS.PostgreSql&version=2.4.0
#tool nuget:?package=eQuantic.Core.CQS.PostgreSql&version=2.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
eQuantic.Core.CQS.PostgreSql
PostgreSQL provider for eQuantic.Core.CQS - Saga Repository, Outbox, and Job Scheduler using Dapper.
Installation
dotnet add package eQuantic.Core.CQS.PostgreSql
Configuration
services.AddCQS(options => options
.FromAssemblyContaining<Program>()
.UsePostgreSql<MySagaData>(pg =>
{
pg.ConnectionString = "Host=localhost;Database=myapp;Username=user;Password=pass";
pg.Schema = "cqs";
pg.SagasTable = "sagas";
pg.OutboxTable = "outbox";
pg.JobsTable = "jobs";
}));
Database Setup
Create the required tables:
CREATE SCHEMA IF NOT EXISTS cqs;
CREATE TABLE cqs.sagas (
id UUID PRIMARY KEY,
type VARCHAR(500) NOT NULL,
data JSONB NOT NULL,
state INT NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW(),
updated_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE cqs.outbox (
id UUID PRIMARY KEY,
type VARCHAR(500) NOT NULL,
payload JSONB NOT NULL,
state INT NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW(),
processed_at TIMESTAMPTZ NULL
);
CREATE TABLE cqs.jobs (
id UUID PRIMARY KEY,
command_type VARCHAR(500) NOT NULL,
command_data JSONB NOT NULL,
scheduled_at TIMESTAMPTZ NOT NULL,
executed_at TIMESTAMPTZ NULL
);
Features
- Saga Repository: JSONB storage with efficient querying
- Outbox Repository: Transactional outbox pattern support
- Job Scheduler: Scheduled command execution
License
MIT License
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net6.0 is compatible. 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 is compatible. 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. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net10.0
- Dapper (>= 2.1.66)
- eQuantic.Core.CQS.Abstractions (>= 2.4.0)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 10.0.3)
- Npgsql (>= 10.0.1)
-
net6.0
- Dapper (>= 2.1.66)
- eQuantic.Core.CQS.Abstractions (>= 2.4.0)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 6.0.0)
- Npgsql (>= 6.0.13)
-
net8.0
- Dapper (>= 2.1.66)
- eQuantic.Core.CQS.Abstractions (>= 2.4.0)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 8.0.2)
- Npgsql (>= 8.0.8)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.