psycopg3

Critical lessons from implementing a highly complex workflow system

- Transaction Boundaries are Sacred: When spawning child tasks, the parent MUST commit its transaction before children become visible to workers.