Lyo.PackageMetadata.Postgres 2.0.1

Lyo.PackageMetadata.Postgres

EF Core store behind Lyo.PackageMetadata.IPackageMetadataStore.

What problem this solves

Stripped namespaces and assembly-qualified tokens show up in stack traces. Lyo.PackageMetadata resolves which NuGet or Git package owns a prefix for diagnostics overlays. PostgresPackageMetadataStore implements the store against normalized tables (PackageStackPrefix rows ordered by NormalizedPrefix length) so resolution is O(sorted prefixes) in-process after each DB read. The bulk API loads all prefixes once per call when caching allows.

How storage is modeled (conceptual)

• PackageMetadataEntity holds catalog metadata (id, package name, version range, SPDX/license expression blobs). See EF configurations for the rest.
• PackageStackPrefixEntity maps NormalizedPrefix to the owning package. Longest prefix wins.

Bulk resolution (TryGetManyForStrippedMethodPrefixesAsync)

• Input: distinct stripped prefixes (typically one per decoded stack frame subtree).
• Output: a dictionary with one entry per input key; the value is null when nothing matches contract rules.
• Requested keys are never dropped silently. That invariant keeps Lyo.Diagnostic bulk decode paths deterministic.

Caching the prefix catalog (PostgresPrefixCatalogCachingMode)

Repeated DB chatter is gated by PostgresPackageMetadataOptions.PrefixCatalogCaching:

When caching is disabled, ClearPrefixCatalogCache() is a no-op on the cache. It only bumps the generation.

Cross-process writes do not invalidate. Disable the snapshot or bust the cache after CLI imports.

DI registration (Extensions)

• AddPackageMetadataDbContextFactory (and FromConfiguration). Binds PostgresPackageMetadataOptions, registers the PackageMetadataDbContext factory, attaches AddPostgresMigrations bootstrap.
• AddPostgresPackageMetadataStore. Factory plus IPackageMetadataStore as PostgresPackageMetadataStore singleton resolving options and IDbContextFactory.

Schema and migrations

Migrations live under Migrations/. Table names and schema follow PostgresPackageMetadataOptions.Schema. Inspect the snapshot for authoritative DDL.

Related reading

• Stack decode and breadcrumb tooling that optionally consumes IPackageMetadataStore: Lyo.Diagnostic.

Dependencies

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

• Lyo.Exceptions (direct, lyo)
• Lyo.PackageMetadata (direct, lyo)
• Lyo.Postgres (direct, lyo)
• Microsoft.EntityFrameworkCore 10.0.5 (direct, microsoft)
• Microsoft.EntityFrameworkCore.Design 10.0.5 (direct, microsoft)
• Microsoft.Extensions.Options 10.0.5 (direct, microsoft)
• Lyo.Common.Core (transitive, lyo)
• Lyo.Common.Metadata (transitive, lyo)
• Lyo.Hashing (transitive, lyo)
• Lyo.Health (transitive, lyo)
• Microsoft.Bcl.AsyncInterfaces 10.0.5 (transitive, microsoft, netstandard2.0)
• 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)
• Npgsql.EntityFrameworkCore.PostgreSQL 10.0.3 (transitive, third-party)
• System.IO.Hashing 10.0.5 (transitive, microsoft, net10.0)
• System.Memory 4.6.3 (transitive, microsoft, netstandard2.0)
• System.Text.Json 10.0.5 (transitive, microsoft, netstandard2.0)
• System.Threading.Tasks.Extensions 4.6.3 (transitive, microsoft)