You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Foundations of the outbox (design §6.3, decision D12).
Scope
Store abstraction used by the dispatcher.
Tables: outbox, outbox_dead, inbox, leases, with the indexes in design §6.3 (filtered or partial where the database supports it).
Configurable schema and table prefix.
Ship SQL scripts per database and a dotnet relayer db script --provider <name> command.
Acceptance criteria
Scripts are idempotent and tested against real databases.
Foundation shipped:#5 in #70 provides scoped send execution and IOutboxEnlistment hooks. This issue still implements the durable store abstraction, schemas, idempotent database scripts and script command; EF Core transaction enlistment remains in #29.
Triage against origin/main 66f3349: #5 shipped in #70 with send execution and IOutboxEnlistment hooks. Updated the body to distinguish that foundation from the remaining durable store/schema/script work. No open prerequisite remains; EF Core transaction enlistment stays in #29.
Split the remaining foundation into native sub-issues #108 (durable dispatch contracts and optional keyed health adapter) and #109 (PostgreSQL schema, idempotent scripts, CLI and real database threshold fixtures). #109 is blocked by #108. The other database providers remain in #41. I am implementing #108 first; #28 stays open until both deliverables ship.
Verified the remaining parent acceptance criteria against freshly fetched origin/main at 541c460. Both native sub-issues are closed and their implementations are merged:
DatabaseSchemaTests.Scripts_are_idempotent_and_shared_with_EF_and_health_queries runs creation repeatedly against real PostgreSQL, verifies default/custom/edge-case identifiers, catalog definitions, constraints and data preservation, and checks health counts at 9/10/19/20 while excluding future schedules, parked/dead rows and live claims. PR Ship PostgreSQL schema scripts, database CLI and EF migration path #114 records 595 passing tests, tool installation/output verification and Native AOT validation.
The site documents the implemented contracts, schema, CLI and migration path in website/docs/reference/outbox-stores.md and website/docs/reference/postgres-schema.md.
This completes the parent scope established in the split comment. SQL Server/MySQL remain #41; EF Core transaction enlistment remains #29 and the PostgreSQL store implementation remains #30. No additional implementation is required for #28.
Activity
thomhurst commentedon Nov 1, 2026
Triage against origin/main 66f3349: #5 shipped in #70 with send execution and IOutboxEnlistment hooks. Updated the body to distinguish that foundation from the remaining durable store/schema/script work. No open prerequisite remains; EF Core transaction enlistment stays in #29.
thomhurst commentedon Nov 1, 2026
Split the remaining foundation into native sub-issues #108 (durable dispatch contracts and optional keyed health adapter) and #109 (PostgreSQL schema, idempotent scripts, CLI and real database threshold fixtures). #109 is blocked by #108. The other database providers remain in #41. I am implementing #108 first; #28 stays open until both deliverables ship.
thomhurst commentedon Nov 1, 2026
Verified the remaining parent acceptance criteria against freshly fetched origin/main at 541c460. Both native sub-issues are closed and their implementations are merged:
IOutboxStoredefines bounded reads, fenced expiring claims, completion/failure persistence and eligible pending counts. The optional keyed health adapter uses explicit store names and supports scoped registrations. Tests cover inclusive thresholds, time/cancellation forwarding, unavailable counts and original errors.dotnet-relayertool exposesdotnet relayer db script --provider postgres; the EF Core migration extension uses the same SQL.DatabaseSchemaTests.Scripts_are_idempotent_and_shared_with_EF_and_health_queriesruns creation repeatedly against real PostgreSQL, verifies default/custom/edge-case identifiers, catalog definitions, constraints and data preservation, and checks health counts at 9/10/19/20 while excluding future schedules, parked/dead rows and live claims. PR Ship PostgreSQL schema scripts, database CLI and EF migration path #114 records 595 passing tests, tool installation/output verification and Native AOT validation.website/docs/reference/outbox-stores.mdandwebsite/docs/reference/postgres-schema.md.This completes the parent scope established in the split comment. SQL Server/MySQL remain #41; EF Core transaction enlistment remains #29 and the PostgreSQL store implementation remains #30. No additional implementation is required for #28.