pgreflex

pgreflex (v0.0.19) is a reactive Postgres library that integrates with tRPC and Drizzle ORM to automatically reflect database changes in the frontend. It uses PostgreSQL logical replication via the pg_output plugin to listen to WAL changes and sends invalidations to tRPC procedures. Inspired by Convex, it provides granular, automatic invalidation without manual cache management. Requires REPLICA IDENTITY FULL for correct updates. Currently in early development with rapid releases; performance overhead is sub-1ms in same datacenter. Differentiators: works with any Postgres + tRPC + Drizzle stack, and aims for Neon DB compatibility.