pg_durable

Discover how the pg_durable worker coordinates with user sessions using the _worker_ready table. Learn about the sentinel record and is_worker_ready() function for ensuring active and schema-compatible worker execution.

Discover how the df.seq() function and the ~> operator in pg_durable implement sequencing, ensuring left-to-right workflow order with THEN execution nodes.

Understand deterministic replay in Duroxide and why pg_durable orchestrations need deterministic code for crash recovery and exact-once guarantees.

Discover how pg_durable leverages Row-Level Security RLS to isolate user's durable function instances and variables, ensuring secure and private data handling within PostgreSQL.

Secure your pg_durable deployments by understanding df.http() security. Learn how http-allow-azure-domains prevents SSRF by validating Azure domains.

Learn how pg_durable persists state across PostgreSQL crashes using runtime state tables. It stores metadata in WAL-protected tables for exact replay after restarts.

Discover how pg_durable detects extension drop/recreate events and restarts its worker using catalog polling and a UUID sentinel for seamless background process management.

Understand the df.cancel() interaction with Duroxide runtime in pg_durable. Learn the cancellation flow from PL/pgSQL to Rust and Tokio for graceful worker shutdowns. Explore the repository now.

Learn how the epoch sentinel mechanism in pg_durable detects extension drop-and-recreate races with a UUID heartbeat, ensuring the background worker restarts its runtime before operating on stale data.

Understand the difference between df.if() and df.if_rows() in pg_durable. Learn how to optimize conditional branching and eliminate extra database queries for better performance.

Discover how pg_durable initializes the Duroxide runtime at startup. This PostgreSQL extension utilizes a background worker to spin up Tokio and start the Duroxide state-machine engine.