The backend for African apps.

import { createClient } from "@affineq/js";
const affineq = createClient("aq_pub_…");

// a code by SMS to a number, not an email
await affineq.auth.signInWithOtp({
  phone: "+254712345678",
});

const { data } = await affineq.auth.verifyOtp({
  phone: "+254712345678",
  token: "482913", type: "sms",
});

// your Postgres, as an API.
// row-level security decides who sees what
const { data } = await affineq
  .from("orders")
  .select("id, total, customer(name)")
  .eq("status", "paid")
  .order("created_at", { ascending: false })
  .limit(20);

// the shop's screen updates when an order is
// paid; after a dropped connection it catches up
affineq.channel("orders")
  .on("postgres_changes", {
    event: "UPDATE",
    table: "orders",
    filter: "status=eq.paid",
  }, (change) => notifyShop(change))
  .subscribe();

// functions/on-order-paid/index.ts
export default async function (req, ctx) {
  // a table change fired us
  const row = ctx.event?.record;
  if (row?.status !== "paid") {
    return Response.json({ skipped: true });
  }
  // the secret key skips row-level security,
  // so the receipt is written here
  return Response.json({ ok: true });
}