A five-checkpoint workflow for spinning up a database branch that behaves like production: clone config, replay migrations, deploy code, pull fresh data, then verify before you trust it.
A database branch is an independent project, not a mirror: it needs its own settings, schema, code, and data before anyone can test against it. This explainer walks the order that works — copy the main project's Postgres, Auth, and Realtime config in one restart, replay migrations from the repo or the main history with one transaction per file, deploy functions (only changed ones on each push), then stream real-time source data so the branch never decides on stale rows. It ends on the verification habits that separate a usable branch from a broken one, including the difference between a DEAD step that halts dependents and a PAUSED warning that does not.
When a branch is created, main project settings for Postgres, Auth, and Realtime are copied and applied with a single Postgres restart, but Auth secrets are not included. You have to supply branch-specific secrets before testing auth flows. Also keep key types straight: publishable and anon keys are for client apps, while secret and service keys bypass Row Level Security.
DEAD means a step failed, and it stops the steps that depend on it, so the branch is left incomplete and needs attention before use. PAUSED is only a warning: it does not block subsequent steps, so setup continues and you can review the warning alongside the finished environment.
Do not rely on a scheduled copy or a separate replicated store, because sync lag turns into wrong answers fast, especially for automated agents. Prefer streaming source records into the branch in real time so it reads current rows, and keep multi-step writes atomic so partial updates never linger.
The posts behind it
Supabase · · TutorialThe Supabase .NET SDK provides a single C# client for Auth, Database, Storage, Realtime, and Edge Functions; version 8.0.0 moves serialization to System.Text.Json and adds injectable HttpClient with retry. It also ships a dependency injection package for ASP.NET Core that registers the client as scoped via IHttpClientFactory to pool connections. Models derive from BaseModel with table and column attributes; queries use From () with Where filters, and updates require explicit calls without a change tracker, supporting both model-based and query-builder approaches. Authentication covers email/password, OAuth, magic links, phone, and SSO, with auto-refresh tokens attaching to subsequent requests for Row-Level Security. Setup for ASP.NET Core uses AddSupabase, while other apps construct the client manually and call InitializeAsync; the post also distinguishes publishable and anon keys for client apps from secret and service keys that bypass Row-Level Security.
Databricks · · ExplainerAI agents cannot compensate for stale data like humans, turning sync lags into machine-speed errors such as approving fraud. Traditional operational data stores (ODS) rely on CDC pipelines and separate copies, which add latency, break on schema changes, and remain ungoverned. LTAP (Lakehouse Transactional Analytical Processing) unifies storage so operational writes land directly in a single governed foundation, eliminating replication entirely. It uses two independent engines—a row-oriented engine for operational reads and a columnar engine for analytical scans—both accessing the same copy without duplication. This removes the sync step, reduces infrastructure complexity, and ensures agents always query current data without degrading transactional performance.
Clickhouse · · AnnouncementQuery Insights for ClickHouse Managed Postgres now includes wait event metrics that show what active sessions are waiting on, such as disk I/O, locks, or CPU. The Active sessions by wait type chart groups activity by wait_event_type, with categories like IO, Lock, and CPU, where CPU means a session is active with no reported wait event. A Waits table breaks down individual wait_event values, showing their average active sessions and share of total load; in the example, lock waits account for about 42% of load. Two additional charts, Blocked sessions and Lock wait time, display the number of sessions waiting on locks and the p50, p95, and maximum wait durations, with maximum lock waits repeatedly above 100 seconds. Wait event metrics are also available through the Managed Postgres Prometheus endpoint for custom Grafana dashboards and alerting, and ClickHouse Agents can help investigate wait events alongside slow queries.
Databricks · · AnnouncementDatabricks made multi-statement transactions generally available on Delta Lake and Apache Iceberg tables, providing atomic guarantees for complex, multi-step workflows directly on the lakehouse. Previously, organizations had to rely on separate warehouse systems for these transactional guarantees, adding expensive data movement, duplicate copies, fragmented governance, and custom consistency workarounds. Row-level concurrency enables concurrent transactions to write to the same table as long as they do not update the same row, delivering significantly stronger performance than traditional cloud and legacy warehouses. The transactions are composable with stored procedures, temporary tables, and streaming tables, and they respect Unity Catalog attribute-based access controls including row-level security and column masking on both reads and writes. Fivetran used transactions to remove consistency-repair code for its slowly changing dimension updates using SCD Type 2, and Accolade processes roughly 1,700 transactions daily for claims and liabilities on the governed lakehouse.
Databricks · · AnnouncementStripe Data Pipeline now supports real-time sync to Postgres, with Databricks Lakebase as a supported destination. Stripe streams real-time API data into Lakebase and manages the sync end to end, eliminating the need for custom integrations with APIs or webhooks that require handlers, retry logic, and reconciliation processes for missed or out-of-order events. One Stripe account can feed two Databricks destinations: Unity Catalog for analytics and AI workloads, and Lakebase for applications. With real-time sync, payment, customer, subscription, refund, and payout data updates arrive in Lakebase within seconds, enabling applications to control product and feature access based on subscription status, keep billing and account details up to date without calling the Stripe API on every page load, and provide real-time financial visibility with dashboards showing daily sales volume, refunds, and payouts as they happen. The feature is available in public preview and free to get started.
Supabase · · ExplainerSupabase branches are independent projects that require settings, schema, and edge functions to be set up before use. When a branch is created, configuration copies main project settings including Postgres, Auth, and Realtime config, then applies them with a single Postgres restart via walg_enable; Auth secrets do not carry over. Migrations come from the git repo for GitHub-connected branches or from the main project’s migration history for gitless branches; each file runs as one transaction in pipeline mode. Edge functions are copied from the main project at creation in parallel with configuration, and on each push only changed functions are redeployed using Brotli compression and SHA-256 checksums. If a step fails, it shows as DEAD and stops dependent steps, while PAUSED indicates a warning that does not block subsequent steps.
More like this
A practical how-to for engineers who need to turn brand from a style guide into a governed signal pipeline: anchor on jobs, model brand roles, unify signals, tokenize meaning, and close the loop with measurement.
A five-step path from fragmented payment silos to a canonical, governed record that AI agents can act on: model the payment, unify the copy, stream events, wrap writes in transactions, and scope agent authority.
A five-step loop for treating bots as accountable actors: verify identity, honor opt-out preferences, measure sustained behavior, band trust, and bound blast radius.
The Good Stuff
Paid picks we use ourselves. Links carry a referral code — a subscription through one earns us a commission at no extra cost to you.
One useful email. Unsubscribe anytime.
