Regulated filings

The filings preset is for an app that prepares documents, gets them signed and approved, sends them, and has to prove afterwards what happened and when: notices, filings, certified mailings and the claims that follow.

ConfigCopy Anchor Link

import { defineConfig } from "better-supabase/config";

export default defineConfig({ preset: "filings" });

npx better-supabase init --preset filings starts a new project from it, and npx better-supabase add --preset filings adds it to one you have (CLI).

BlocksCopy Anchor Link

The preset is saas plus these blocks, and whatever they require:

An evidence trailCopy Anchor Link

Facts that matter live in a table of your own tagged for evidence:

create table public.filing_facts (
  id bigint generated always as identity primary key,
  organization_id uuid not null,
  filing_id uuid not null,
  kind text not null,
  payload jsonb not null,
  recorded_at timestamptz not null default now(),
  chain_seq bigint,
  prev_hash bytea,
  row_hash bytea
);

comment on table public.filing_facts is '@bsb append-only function-writes chain';

better-supabase table filing_facts enable chain adds the statements the tags need. The table then refuses edits, takes no direct writes from the Data API and links each row to the one before it (tables).

One command appends the fact, records the audit event and writes any block rows in a single transaction. If a step returns an error, nothing is kept (transactions):

const result = await server.transaction(
  userId,
  async (db) => {
    await db.$client.queryRaw("select public.append_filing_fact($1, $2, $3)", [
      filingId,
      "notice_prepared",
      JSON.stringify(payload),
    ]);

    return db.audit.record({
      eventType: "filing.notice_prepared",
      organizationId,
      record: filingId,
    });
  },
  { tenant: organizationId },
);

append_filing_fact is a security definer function you write; it is the only way a row arrives. A scheduled job signs the chain heads with createChain(...).checkpoint(), and chain.proof with evidenceBundle produce a document an outside party checks without your database (audit).

With ReUICopy Anchor Link

• A DataGrid of facts per filing, with a Badge for each kind.
• A Dialog that shows the verification result for a bundle before it is exported.