$ the-wire · showcase
CLI fixes schema skipping bug, default cache; ETL bumps rust-postgres
By RepoJournal · Filed · About Supabase
Supabase CLI ships a correctness fix for schema resets plus an opt-out shadow cache, while ETL hardens logical replication and DuckLake ingestion.
Supabase CLI's `db reset`, `db lint`, `db diff`, and `migration down` silently skipped a user schema when its OID collided across catalogs; constraining the `pg_depend` join to `pg_catalog.pg_namespace` now makes resets drop schemas that earlier versions skipped [1]. The shadow baseline cache (`SUPABASE_SHADOW_CACHE`) flipped from opt-in to opt-out: it's ON by default to speed up `db diff`, `db pull`, and schema declarative operations, and `SUPABASE_SHADOW_CACHE=0` or `false` disables it [2]. ETL upgraded the rust-postgres logical replication client, which "contains security patches and improvements" [3], and added deferred durability to DuckLake's SYNC phase to combine small COPY batches into fewer commits and Parquet files [4]. slim-services shipped new portable Postgres 15 portable artifacts at `15.14.1.167` [5] and realtime releases `v2.130.2` and `v2.131.0` [6]. Studio fixed a Studio advisor lint that rendered blank, and will now show the correct title, icon, and remediation for `pitr_archiving_stale` [7].
Action items
- → Update your CLI and re-run db reset on affected schemas to restore dropped schemas supabase/cli [immediate]
- → Set SUPABASE_SHADOW_CACHE=0 if you need the old opt-in behavior supabase/cli [plan]
- → Adopt the new rust-postgres version in ETL pipelines for security fixes supabase/etl [plan]
- → Pull slim-services images for latest Postgres and Realtime versions supabase/slim-services [monitor]
References
- [1] fix(cli): stop skipping colliding schemas (CLI-2272) ↗ supabase/cli
- [2] feat(cli): make shadow baseline cache opt-out (default ON) (#6403) ↗ supabase/cli
- [3] feat(core): Bump to a new version of rust-postgres ↗ supabase/etl
- [4] feat(ducklake): add deferred durability to ducklake in SYNC phase ↗ supabase/etl
- [5] postgres 15.14.1.167 ↗ supabase/slim-services
- [6] realtime v2.130.2 ↗ supabase/slim-services
- [7] fix(studio): register pitr_archiving_stale in the advisor lintInfoMap (#48044) ↗ supabase/supabase