Skip to content

PostgreSQL ADO.NET outbox store #30

Closed as not planned
1 of 1 issue completed
Closed as not planned

Description

@thomhurst

Implement the ADO.NET store for PostgreSQL (design §6.2).

Scope

  • outbox.BeginTransactionAsync(connection) returns a DbTransaction subclass, so normal usage is correct usage.
  • Supports NpgsqlDataSource.
  • Optional LISTEN/NOTIFY to wake the sweeper.

Acceptance criteria

  • Tests for commit, rollback and Dapper usage.

Depends on: #28

See docs/design.md and docs/decisions.md.

Activity

  1. thomhurst commented on Nov 1, 2026

    @thomhurst
    OwnerAuthor

    Triage against origin/main bf3191f: this issue's implementation remains outstanding; the outbox packages still contain options only. Added native blocked-by dependencies on #28, matching the prerequisites already documented in the issue. Existing scope and acceptance criteria remain current.

  2. thomhurst commented on Nov 1, 2026

    @thomhurst
    OwnerAuthor

    Split the remaining PostgreSQL implementation into native children #117 (durable read/claim store and shared header storage codec) and #118 (transactional enqueue, native transaction compatibility and Dapper integration). #118 depends on #117's storage representation. These are independent deliverables; #30 remains open until both ship. Implementing #117 first.

  3. thomhurst commented on Nov 1, 2026

    @thomhurst
    OwnerAuthor

    Consolidated the remaining acceptance criteria into #118 and detached its native child link. #117 and #28 are closed; their stale blocked_by links were removed. #118 now carries the original transaction subclass, NpgsqlDataSource and commit/rollback/Dapper requirements, and explicitly preserves LISTEN/NOTIFY as optional worker integration under #33. Closing this one-child parent as superseded avoids duplicate implementation and wait-only tracking.

    The implementation already exists in #134, which closes #118 and is currently locked by another worker. Its real blocker #136 is implemented by reviewed, ready, auto-merge-armed #137; CI run 41332386816 is queued. No condition has met that would permit removing #118's remaining #136 dependency. Continue the existing PR after the blocker lands rather than create a competing implementation.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions