Sora.Data.Postgres
0.4.0
dotnet add package Sora.Data.Postgres --version 0.4.0
NuGet\Install-Package Sora.Data.Postgres -Version 0.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="Sora.Data.Postgres" Version="0.4.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Sora.Data.Postgres" Version="0.4.0" />
<PackageReference Include="Sora.Data.Postgres" />
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 Sora.Data.Postgres --version 0.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Sora.Data.Postgres, 0.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 Sora.Data.Postgres@0.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=Sora.Data.Postgres&version=0.4.0
#tool nuget:?package=Sora.Data.Postgres&version=0.4.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Sylin.Sora.Data.Postgres
PostgreSQL provider for Sora relational data with safe defaults and pushdowns.
- Target framework: net9.0
- License: Apache-2.0
Capabilities
- Connection + health checks with minimal options
- JSON projection, filter, and paging pushdowns where supported
- Schema helpers (create table/index) via Sora.Data.Relational
Install
dotnet add package Sylin.Sora.Data.Postgres
Minimal setup
- Configure connection via ConnectionStrings or Sora:Data first-win keys.
- Bind options at startup; keep secrets out of source.
Usage — safe snippets
- Use first-class model statics from your entities:
Order.FirstPage(50, ct)/Order.Page(cursor, ct)Order.Query(o => o.CustomerId == id, ct)await foreach (var o in Order.QueryStream(o => o.Total > 100, ct)) { ... }
// Stream a filtered set (backpressure friendly)
await foreach (var o in Order.QueryStream(o => o.IsActive, ct))
{
// process
}
See TECHNICAL.md for options and pushdown coverage.
References
- Paging/Streaming decision:
~/decisions/DATA-0061-data-access-pagination-and-streaming.md - Data access reference:
~/reference/data-access.md
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net9.0 is compatible. 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 was computed. 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.
-
net9.0
- Dapper (>= 2.1.35)
- Microsoft.Extensions.Configuration (>= 9.0.8)
- Microsoft.Extensions.Configuration.Binder (>= 9.0.8)
- Microsoft.Extensions.Logging.Abstractions (>= 9.0.8)
- Microsoft.Extensions.Options (>= 9.0.8)
- Newtonsoft.Json (>= 13.0.3)
- Npgsql (>= 8.0.3)
- Sora.Core (>= 0.4.0)
- Sora.Data.Abstractions (>= 0.4.0)
- Sora.Data.Core (>= 0.4.0)
- Sora.Data.Relational (>= 0.4.0)
- Sora.Orchestration.Abstractions (>= 0.4.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
See release notes: https://github.com/sylin-labs/sora-framework/releases