pg_durable
Run fault-tolerant background workflows directly inside PostgreSQL
All Skills in This Repository (1)
Pure Emerald Level IndicatorsFrequently Asked Questions
FAQPage SchemaHow to install pg_durable?โผ
Run `npx skills add microsoft/pg_durable --all -g -y` in your terminal to install the skill globally. The extension itself is added to PostgreSQL via a Debian package, Docker image, or `CREATE EXTENSION pg_durable;`.
What problem does pg_durable solve?โผ
It makes long-running database jobs survive crashes and restarts by checkpointing each step, so you never rerun completed work or rebuild state by hand.
Can pg_durable replace Airflow or Temporal?โผ
For workflows that live mostly in Postgres, yes. It removes the need for external orchestrators, queues, and worker infrastructure by running durable execution as a PostgreSQL extension.
How do I write a durable workflow in SQL?โผ
Compose steps with operators like `~>` for sequence, `&` for parallel, and `?>` for conditions, then launch the graph with `df.start()` to get an instance ID you can monitor.
Does pg_durable need extra infrastructure?โผ
No. It runs entirely as a PostgreSQL extension with a background worker, so there is no Redis, message queue, or separate orchestration service to manage.
Related Repositories in Software Engineering
View All in Software Engineeringโopenclaw
Run a personal AI assistant across your devices and chat apps
superpowers
Gives coding agents a disciplined workflow from idea to merged code
react
AI agent skills for building, testing, and porting React core