Triggers & schedules

Run functions when rows change or on a schedule.

Database triggers

Attach a function to inserts, updates or deletes on a table. The function receives the old and new row.

functions/on-signup.ts

export default fn.onInsert(users, async ({ row }) => {  await functions.invoke("welcome-email", { userId: row.id })})

Schedules

functions/nightly-report.ts

export default fn.schedule("0 6 * * *", async ({ db }) => {  const overdue = await db.invoices.where({ status: "overdue" }).count()  await postToSlack(`${overdue} overdue invoices`)})

Beta

Triggers and schedules are in beta. Delivery is at-least-once, so make handlers idempotent.

Writing functions

Secrets

Was this helpful?

Support

Status