Lyo.Audit.Postgres 1.0.1

Lyo.Audit.Postgres

PostgreSQL implementation of Lyo.Audit using Entity Framework Core. Persists AuditChange and AuditEvent records to PostgreSQL with JSONB columns for dictionary data.

Features

• PostgresAuditRecorder – Implements IAuditRecorder and Lyo.Health.IHealth with PostgreSQL persistence
• Migrations – EF Core migrations in the audit schema (PostgresAuditOptions.Schema) with audit_changes and audit_events tables
• Auto migrations – Optional automatic migration on startup via EnableAutoMigrations

Examples

Quick Start

services.AddPostgresAuditRecorder(new PostgresAuditOptions {
    ConnectionString = configuration.GetConnectionString("Audit")!,
    EnableAutoMigrations = true
});

services.AddPostgresAuditRecorderFromConfiguration(configuration);

Quick Start (2)

services.AddAuditDbContextFactory(configuration.GetSection("PostgresAudit").Get<PostgresAuditOptions>()!);

Migrations

export AUDIT_CONNECTION_STRING="Host=localhost;Database=audit;Username=postgres;Password=postgres"
dotnet ef migrations add MigrationName --project Core/Audit/Lyo.Audit.Postgres

Registration

Quick Start

Need just the factory (e.g. to share with downstream services or run migrations explicitly)?

Health

PostgresAuditRecorder implements Lyo.Health.IHealth with HealthCheckName = "audit-postgres". The probe opens an AuditDbContext and runs Database.CanConnectAsync, surfacing connection failures through HealthResult.Unhealthy so the recorder contributes to host health endpoints that resolve IEnumerable<IHealth>.

Schema

• audit.audit_changes – id (uuid), timestamp, for_entity_type, for_entity_id (varchar), from_entity_type?, from_entity_id? (varchar), tenant_id? (uuid), old_values_json (jsonb), changed_properties_json (jsonb), created_timestamp, updated_timestamp?
• audit.audit_events – id (uuid), event_type, timestamp, for_entity_type, for_entity_id (varchar), from_entity_type?, from_entity_id? (varchar), tenant_id? ( uuid), message?, metadata_json? (jsonb), created_timestamp, updated_timestamp?

Tenancy

AuditChange and AuditEvent records carry an optional TenantId (mapped to the tenant_id column). PostgresAuditRecorder runs every record through TenancyResolver.Resolve using the policy configured in PostgresAuditOptions.Tenancy (inheriting from EntityRefOptions.Mode when unset) before persisting:

• SystemOnly — caller TenantId is ignored and the row stores null (system-level audit).
• SingleTenantDefault (default) — caller value, falling back to Tenancy.DefaultTenantId then EntityRefOptions.DefaultTenantId.
• MultiTenantStrict — caller must supply a non-empty TenantId or persistence throws.

Each table has an ix_<table>_tenant index for filtered scans. Use WhereTenant(tenantId) to scope queries to a single tenant (or null for system rows) and WhereTenantOrSystem(tenantId) to include both. See Lyo.EntityReference.Postgres for the policy matrix.

{
  "PostgresAudit": {
    "ConnectionString": "Host=localhost;Database=audit;...",
    "Tenancy": { "Mode": "MultiTenantStrict" }
  }
}

Dependencies

Generated from ProjectReference / PackageReference (same model as docs/Lyo.ProjectGraph.html).

• Lyo.Audit — (direct, lyo)
• Lyo.EntityReference.Postgres — (direct, lyo)
• Lyo.Exceptions — (direct, lyo)
• Lyo.Health — (direct, lyo)
• Lyo.Postgres — (direct, lyo)
• Microsoft.Extensions.Configuration.Binder 10.0.5 — (direct, microsoft)
• Lyo.Common — (transitive, lyo)
• Lyo.EntityReference.Models — (transitive, lyo)
• Microsoft.EntityFrameworkCore 10.0.5 — (transitive, microsoft)
• Microsoft.EntityFrameworkCore.Design 10.0.5 — (transitive, microsoft)
• Microsoft.EntityFrameworkCore.Relational 10.0.5 — (transitive, microsoft)
• Microsoft.Extensions.DependencyInjection.Abstractions 10.0.5 — (transitive, microsoft)
• Microsoft.Extensions.Hosting.Abstractions 10.0.5 — (transitive, microsoft)
• Microsoft.Extensions.Logging.Abstractions 10.0.5 — (transitive, microsoft)
• Microsoft.Extensions.Options 10.0.5 — (transitive, microsoft)
• Microsoft.Extensions.Options.ConfigurationExtensions 10.0.5 — (transitive, microsoft)
• Npgsql.EntityFrameworkCore.PostgreSQL 10.0.3 — (transitive, third-party)
• System.Memory 4.6.3 — (transitive, microsoft, netstandard2.0)
• System.Text.Json 10.0.5 — (transitive, microsoft, netstandard2.0)