Skip to content

EFF-749 Backport sql-pg dedicated listen connection#6140

Merged
tim-smart merged 1 commit intomainfrom
lalph/EFF-749
Mar 22, 2026
Merged

EFF-749 Backport sql-pg dedicated listen connection#6140
tim-smart merged 1 commit intomainfrom
lalph/EFF-749

Conversation

@tim-smart
Copy link
Contributor

Summary

  • backported sql-pg LISTEN handling to use a dedicated pg.Client connection instead of reserving a pooled connection
  • kept LISTEN connection lifecycle scoped via RcRef + Effect.acquireRelease (attach/detach error handler, timeout on close)
  • added a single-connection integration test to verify listening does not block normal queries from the pool
  • added a changeset for @effect/sql-pg

Validation

  • pnpm lint-fix
  • pnpm test run packages/sql-pg/test/Client.test.ts
  • pnpm check
  • pnpm build
  • pnpm docgen

@github-project-automation github-project-automation bot moved this to Discussion Ongoing in PR Backlog Mar 22, 2026
@changeset-bot
Copy link

changeset-bot bot commented Mar 22, 2026

🦋 Changeset detected

Latest commit: f1141f1

The changes in this PR will be included in the next version bump.

This PR includes changesets to release 1 package
Name Type
@effect/sql-pg Patch

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR

@tim-smart tim-smart enabled auto-merge (squash) March 22, 2026 21:55
@tim-smart tim-smart merged commit 4767f86 into main Mar 22, 2026
11 checks passed
@tim-smart tim-smart deleted the lalph/EFF-749 branch March 22, 2026 21:55
@github-project-automation github-project-automation bot moved this from Discussion Ongoing to Done in PR Backlog Mar 22, 2026
@github-actions github-actions bot mentioned this pull request Mar 22, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

Status: Done

Development

Successfully merging this pull request may close these issues.

@effect/sql-pg: Add dedicated connection option for PostgreSQL LISTEN/NOTIFY operations

1 participant