flndrn cf639bce5b Merge remote-tracking branch 'origin/briven-doltgres-readiness-s0-s1'		1 bulan lalu
..
src	cf639bce5b Merge remote-tracking branch 'origin/briven-doltgres-readiness-s0-s1'	1 bulan lalu
Dockerfile	95e80eb459 fix(deploy): switch service Dockerfiles from alpine to debian-slim	3 bulan lalu
README.md	ad4dcdc04f feat(observability): finish realtime LISTEN/NOTIFY + /metrics on api+realtime	3 bulan lalu
package.json	1eba7e2b1e feat: converge platform on DoltGres (Postgres-wire git-for-data)	2 bulan lalu
tsconfig.json	ab84003a38 chore: initial commit	3 bulan lalu
turbo.json	8f5baeeac0 chore(repo): cross-cutting cleanup — turbo outputs, AppEnv extract, shared additions	3 bulan lalu

@briven/realtime — reactive query WebSocket service

per CLAUDE.md §7.4:

client calls useQuery("getPosts", { userId })
SDK sends query name + args to realtime over WebSocket
realtime computes a query hash, checks cache
on miss: invokes query via runtime, caches, returns
realtime subscribes to Postgres LISTEN channels for every table touched
on NOTIFY (auto-generated triggers), recompute and push deltas to subscribed clients
subscriptions expire when client disconnects

status: Phase 1 complete (2026-05-09). wire protocol, refcounted LISTEN/UNLISTEN, NOTIFY → re-invoke fan-out, channel diffing on touchedTables, postgres.js v3 auto-reattach on reconnect. Caller auth is the runtime shared secret; SDK-direct connection (per-project JWT) is a Phase 2 follow-up.

year-one scale target: 10,000 concurrent subscriptions. migrate to logical replication + WAL streaming if this becomes a bottleneck.

README.md

@briven/realtime — reactive query WebSocket service