The Wire · Showcase
SUPABASE SHIPS POSTGRES MIDDLEWARE PAIR AND FAST SHADOW BASELINE
By RepoJournal · Filed · About Supabase
The supabase/server package just delivered the RLS-scoped Postgres middleware you've been waiting for, and db diff just got 4x faster.
Supabase's server package now ships withPostgresClient and withPostgresAdminClient as a hardened pair, giving you RLS-enforced direct database access from middleware with a service-role companion [1]. The withOAuthProtectedResource helper moved to defineMiddleware, unblocking Edge Functions support [2]. Meanwhile, the CLI's shadow database baseline cache cuts warm provisioning from ~15.5s to ~3.3s on PG17 [3], and the pg-delta upgrade to alpha.46 brings parameter-ACL filtering plus OWNED BY handling to db diff [4]. The evals team promoted build-rls-003-org-roles-permissions to the benchmark suite, doubling down on RLS coverage [5], and the pg_net docs finally clarify the net schema permission model [6]. New runtime artifacts dropped for storage v1.71.0 and pooler v2.9.11 [7][8].
One email a day. Unsubscribe in one click.
Keep up with Supabase in about 3 minutes a day: what actually shipped — the commits, pull requests, releases, and security advisories that matter.
One email a day. Unsubscribe in one click. Read a past issue →
Action items
- → Upgrade @supabase/server to 1.5.0-rc.108 to adopt the withPostgresClient/Admin middleware pair supabase/server [plan]
- → Set SUPABASE_SHADOW_CACHE=1 to test the shadow baseline cache in db diff supabase/cli [immediate]
- → Migrate any withOAuthProtectedResource usage to the defineMiddleware signature supabase/server [plan]
- → Pin storage to v1.71.0 in your Docker images supabase/slim-services [monitor]
References
- [1] feat(middleware): ship withPostgresClient and withPostgresAdminClient (#115) supabase/server
- [2] fix: migrate `withOAuthProtectedResource` to `defineMiddleware` ↗ supabase/server
- [3] feat(cli): cache the shadow database baseline as a PGDATA snapshot (CLI-2191) (#6184) supabase/cli
- [4] feat(cli): upgrade pg-delta next to alpha.46 (#6300) supabase/cli
- [5] feat: promote build-rls-003-org-roles-permissions to benchmark suite (#162) supabase/evals
- [6] Clarify pg_net net schema grants (#49472) supabase/supabase
- [7] storage v1.71.0 ↗ supabase/slim-services
- [8] pooler v2.9.11 ↗ supabase/slim-services