Constructive Jobs

Background job infrastructure for the Constructive platform. Declaratively attach triggers to tables that enqueue jobs when rows change, processed by the Knative worker stack.

When to Apply

• Adding a background job that fires on row INSERT/UPDATE/DELETE
• Wiring a table to a Knative cloud function (e.g., send email on invite creation)
• Syncing data to external systems on change (e.g., Stripe sync on invoice update)
• Generating embeddings, sending notifications, auditing changes
• Scheduling recurring jobs (cron-style)

Architecture

Table row change (INSERT/UPDATE/DELETE)
  --> PostgreSQL AFTER trigger (created by DataJobTrigger node)
    --> app_jobs.add_job(task_identifier, payload)
      --> knative-job-worker polls app_jobs.jobs