Microsoft has released the source code for a new PostgreSQL extension named pg_durable, making it publicly available for developers. The extension is designed to allow durable workflows to run natively within the PostgreSQL database environment.
This move eliminates the requirement for external orchestration systems to manage workflow execution. Durable workflows are processes that must continue running reliably even after system failures or restarts.
Background and Functionality
By integrating workflow execution directly into the database, pg_durable aims to simplify application architecture. Developers can now model and run complex business logic, such as multi-step transactions or long running processes, entirely within PostgreSQL.
The extension leverages PostgreSQL’s existing transactional guarantees. This ensures that workflow state remains consistent and recoverable in the event of crashes or network interruptions.
Technical Details
According to Microsoft’s documentation, pg_durable uses a custom scheduler and state management system that operates within the database engine. It supports common workflow patterns like retries, timeouts, and error handling without external dependencies.
The extension is written in C and integrates with PostgreSQL’s extension framework. It is compatible with PostgreSQL versions 12 and later.
Implications for Developers and Organizations
For development teams, the open sourcing of pg_durable provides a free and transparent tool to build fault tolerant applications. It reduces operational overhead by removing the need to deploy and maintain separate workflow orchestration services such as Apache Airflow or AWS Step Functions.
Organizations that rely heavily on PostgreSQL for data management may benefit from lower latency and simplified infrastructure. The extension also supports horizontal scaling through PostgreSQL’s replication features.
The release follows a broader industry trend of embedding application logic into database systems. Similar projects, such as PostgresML and pgvector, have gained traction for extending database capabilities beyond traditional data storage.
Availability and Next Steps
The source code is now available on GitHub under an open source license. Microsoft has not announced a specific release timeline for stable packages or official support channels.
Developers are encouraged to test the extension in development environments and submit feedback through the project’s repository. Community contributions for bug fixes and feature enhancements are currently open.
Future updates may include improved integration with existing PostgreSQL extensions, expanded workflow language support, and performance optimizations for high throughput workloads. Microsoft has indicated that ongoing development will be guided by community engagement and practical use cases.
