Salsuki
2024 – Current
Salsuki is a community management platform built for a non-profit salsa school. The system combines a React 19 and TypeScript frontend hosted on Vercel with a Supabase backend providing Postgres, Row-Level Security, Auth, Edge Functions, and Storage. The product supports bookings, credits, waitlists, and a learning resource library.
Technical decisions worth discussing
- Ledger-based credits: balances are computed with a live SUM over an append-only transactions table to guarantee an audit trail and avoid lost-update races.
- Authorization enforced in Postgres via Row-Level Security policies rather than scattered app checks, making it harder to bypass data rules accidentally.
- Atomic multi-table writes implemented as `SECURITY DEFINER` Postgres functions so multi-step financial operations are consistent and atomic.
The codebase is developed as a solo-maintained project with mandatory PR review. CI runs a local Supabase stack to apply and lint migrations before changes land in shared environments. For more technical details, see the repository or the live site when available.