v0.42.26.0 docs(supabase): update connection-string setup to new UI + Transaction pooler (#1848)#1875
Merged
Merged
Conversation
…n pooler Supabase moved the connection string under "Connect" in the top nav and now shows three options (Direct, Transaction pooler, Session pooler). Update the tutorial, gbrain init prompts, the setup skill, the verify runbook, and the live-sync guide to recommend the Transaction pooler (port 6543) — which gbrain is tuned for (prepared statements disabled, DDL/locks routed to a derived direct connection). Document the IPv4 footgun: the derived direct connection is IPv6-only, so on IPv4-only hosts reads work but sync silently skips pages. Tutorial 7c now leads with the free fix (GBRAIN_DIRECT_DATABASE_URL -> Session pooler, port 5432) and keeps the IPv4 add-on as the paid alternative. Removes stale "transaction mode breaks sync (.begin() is not a function)" warnings and the port-6543 "Session pooler" mislabels. Extends PR #1848 by @FilipHarald.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
uncfreak1255-code
pushed a commit
to uncfreak1255-code/gbrain
that referenced
this pull request
Jun 5, 2026
… Transaction pooler (garrytan#1848) (garrytan#1875) * docs(supabase): update connection-string setup to new UI + Transaction pooler Supabase moved the connection string under "Connect" in the top nav and now shows three options (Direct, Transaction pooler, Session pooler). Update the tutorial, gbrain init prompts, the setup skill, the verify runbook, and the live-sync guide to recommend the Transaction pooler (port 6543) — which gbrain is tuned for (prepared statements disabled, DDL/locks routed to a derived direct connection). Document the IPv4 footgun: the derived direct connection is IPv6-only, so on IPv4-only hosts reads work but sync silently skips pages. Tutorial 7c now leads with the free fix (GBRAIN_DIRECT_DATABASE_URL -> Session pooler, port 5432) and keeps the IPv4 add-on as the paid alternative. Removes stale "transaction mode breaks sync (.begin() is not a function)" warnings and the port-6543 "Session pooler" mislabels. Extends PR garrytan#1848 by @FilipHarald. * chore: bump version and changelog (v0.42.26.0) Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com> --------- Co-authored-by: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
mgunnin
added a commit
to mgunnin/gbrain
that referenced
this pull request
Jun 5, 2026
* upstream/master: v0.42.26.0 docs(supabase): update connection-string setup to new UI + Transaction pooler (garrytan#1848) (garrytan#1875) v0.42.25.0 fix(pricing): unify chat-model pricing into one canonical source; add Opus 4.8 (garrytan#1819) (garrytan#1827) v0.42.24.0 fix(minions): route lock claim/renewLock through direct session pool (garrytan#1822)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
1 participant
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
What
Updates the Supabase connection-string setup across the docs and
gbrain initto match the current Supabase dashboard and to recommend the pooler gbrain is actually tuned for. Extends community PR #1848 by @FilipHarald, who caught that the tutorial walkthrough was written for the old UI.Why
Supabase moved the connection string under Connect in the top navigation and now shows three options (Direct, Transaction pooler, Session pooler). The repo had drifted into contradiction:
.begin() is not a function), which contradicts gbrain's current dual-pool behavior.gbrain is built around the Transaction pooler (port 6543):
resolvePreparedisables prepared statements there, andconnection-managerroutes migrations, DDL, and worker locks to a derived direct connection. Verified against Supabase's live 2026 docs (Connect UI, Supavisor terminology, prepared-statement handling).The IPv4 footgun (now documented)
The direct connection gbrain derives for DDL/locks (
db.<ref>.supabase.co:5432) is IPv6-only. On an IPv4-only host (most Render plans) reads work but sync silently skips pages. Tutorial §7c now leads with the free fix — pointGBRAIN_DIRECT_DATABASE_URLat the Session pooler (port 5432, IPv4) — and keeps the IPv4 add-on as the paid alternative.Files
docs/tutorials/personal-brain.md— §7b new Connect nav + three options + Transaction pooler; §7c rewritten for the IPv4 fixsrc/commands/init.ts— prompt/warning copy → Transaction pooler + Connect navskills/setup/SKILL.md,docs/GBRAIN_VERIFY.md,docs/guides/live-sync.md— consistent labels; stale.begin()warnings reframed to the real IPv4 direct-connection gotchallms-full.txt— regeneratedFrozen per repo rules:
skills/migrations/v0.5.0.md(historical migration) and CHANGELOG history.Verification
bun run typecheckcleanbun run build:llms+bun test test/build-llms.test.ts(12 pass).begin()references🤖 Generated with Claude Code