redb.Postgres.Pro 3.0.0

RedBase Pro

Data Platform for .NET — Pro edition with compiled queries, parallel materialization, and advanced analytics.

RedBase Pro extends the open-source RedBase core with performance-critical features for production workloads.

What Pro Adds

Free vs Pro — Query Pipeline

Free:  LINQ → plpgsql function → JSON → Deserialize → Props
Pro:   LINQ → ExpressionToSqlCompiler → native SQL + PVT CTE → Parallel.ForEach → Props

Pro compiles your LINQ expression into raw SQL at runtime. No intermediate JSON, no plpgsql interpreter. The query hits the database as a native SELECT with JOINs and WHERE clauses — same as hand-written SQL, but generated from C#.

Packages

Package	NuGet	Description
redb.Core.Pro		Pro abstractions, compiled query engine, change tracking
redb.Postgres.Pro		PostgreSQL Pro provider
redb.MSSql.Pro		SQL Server Pro provider

Installation

# PostgreSQL
dotnet add package redb.Postgres.Pro

# SQL Server
dotnet add package redb.MSSql.Pro

Both provider packages include redb.Core.Pro as a transitive dependency.

Quick Start

using redb.Core;
using redb.Core.Extensions;
using redb.Core.Models.Configuration;
using redb.Core.Pro.Extensions;
using redb.Postgres.Pro.Extensions;  // or redb.MSSql.Pro.Extensions

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddRedbPro(options => options
    .UsePostgres("Host=localhost;Database=mydb;Username=postgres;Password=pass")
    // .UseMsSql("Server=localhost;Database=mydb;User Id=sa;Password=pass;TrustServerCertificate=true")
    .WithLicense("YOUR-LICENSE-KEY")     // optional — trial works without it
    .Configure(c =>
    {
        c.PropsSaveStrategy = PropsSaveStrategy.ChangeTracking;
        c.EnableLazyLoadingForProps = false;
        c.EnablePropsCache = true;
    }));

var app = builder.Build();
var redb = app.Services.GetRequiredService<IRedbService>();
await redb.InitializeAsync();

// Pro: compiled queries, parallel materialization
var results = await redb.Query<EmployeeProps>()
    .Where(e => e.Salary > 75000m)
    .Take(100)
    .ToListAsync();

// Pro: window functions — from E132_WindowRowNumber.cs
var ranked = await redb.Query<EmployeeProps>()
    .WithWindow(w => w
        .PartitionBy(x => x.Department)
        .OrderByDesc(x => x.Salary))
    .SelectAsync(x => new
    {
        Name = x.Props.FirstName,
        Department = x.Props.Department,
        Salary = x.Props.Salary,
        Rank = Win.RowNumber()
    });

Trial

No license key required to start. All Pro features are fully functional with a limit of 1,024 requests per application launch. The counter resets on every restart — during active development this means no practical restriction.

Build your project, run tests, evaluate performance. Purchase a license when you move to production or need sustained long-running workloads.

redbase.app/pricing

Supported Databases

Target Frameworks

• .NET 8.0 (LTS)
• .NET 9.0
• .NET 10.0

Documentation

License

RedBase Pro is distributed under a commercial license. See LICENSE-PRO.txt for terms.