Welcome to my personal website!

Shield:

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Supabase schema workflow

This project uses declarative Supabase schemas, one Postgres schema per app and one table or function per file:

supabase/schemas/portfolio/ — tables for the personal site (post_views, ratings, bgms, hobby_*).
supabase/schemas/laundro_cafe/ — tables and functions for laundro.cafe.

Both schemas are listed in [api] schemas in supabase/config.toml and must also be in Settings → Data API → Exposed schemas on the hosted project. Add a schema there only after the migration that creates it is applied: exposing a schema that does not exist yet stops the whole Data API.

When schema changes are made:

Edit the SQL files under supabase/schemas/<schema>/, and list any new file in schema_paths in…