Schema cache reload (run after ALTER TABLE)

NOTIFY pgrst, 'reload schema';

Check ledger balance

SELECT SUM(debit) dr, SUM(credit) cr
FROM journal_lines;

Beta + Founding signups

SELECT * FROM beta_applications
ORDER BY submitted_at DESC;

SELECT * FROM founding_members
ORDER BY submitted_at DESC;

OSS Q1 2026 breakdown

SELECT vat_code, COUNT(*) n,
SUM(jl.credit) vat
FROM journal_entries je
JOIN journal_lines jl ON ...
WHERE je.vat_code='3c'
GROUP BY 1;