{"repo":"vibhorkum/pg_background","free":true,"listed":false,"github":"https://github.com/vibhorkum/pg_background","clone":"git clone https://github.com/vibhorkum/pg_background.git","description":"Production-grade PostgreSQL extension to execute arbitrary SQL in background worker processes — with async execution, autonomous transactions, cookie-protected handles, cancellation, progress reporting, and observability.","language":"PLpgSQL","stars":254,"topics":["async","audit-logging","autonomous","autonomous-transactions","background-worker","c","database","etl","plpgsql","postgres"],"license":null,"category":"databases-storage","readme_excerpt":"pg background: Production-Grade Background SQL for PostgreSQL Execute arbitrary SQL commands in background worker processes within PostgreSQL. Built for production workloads requiring asynchronous execution, autonomous transactions, and long-running operations without blocking client sessions. 30-second tour When you need the actual result rows, swap run for the launch → wait → result pattern shown in Quick Start or Cookbook recipe 2. Naming: 2.0 retired the v2 suffix — the unsuffixed names shown here are canonical. The v2 names (e.g. pg background run v2 ) still work as deprecated aliases through the 2.x line and are removed in 3.0. See docs/MIGRATION.md . Where to go next If you want to… Read --- --- See it in 5 minutes Quick Start Copy a working pattern Cookbook — three battle-tested templates Look up a function API Reference Understand the cancel vs detach distinction Critical Semantic Distinctions Decide whether this fits your problem When to use this — and when not to --- Table of Contents - Overview - When to use this — and when not to - Architecture (at a glance) · deep dive: docs/ARCHITECTURE.md - Key Features - PostgreSQL Version Compatibility - Installation - Quick Start - Complete API Reference - Critical Semantic Distinctions - Cancel vs Detach · V1 vs V2 (v1 removed in 2.0) · PID reuse · NOTIFY semantics - Security Model - Operational Guidance - Troubleshooting - Known Limitations - Best Practices - Cookbook — full content in docs/COOKBOOK.md - Migration Guide —","default_branch":null,"files":null,"tree":[],"storefront":"/r/vibhorkum","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/vibhorkum/pg_background/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}