persister-supabase

The persister-supabase module of the TinyBase project lets you save and load Store data to and from a Supabase project, via the @supabase/supabase-js module.

Unlike the other PostgreSQL Persisters, this one talks to Supabase's REST API rather than to the database directly. That means it works in a browser or edge runtime, that row-level security policies apply to the data it reads and writes, and that changes can arrive over Supabase Realtime instead of polling.

It also means that only the JSON serialization mode is available, since the REST API cannot execute the arbitrary SQL that tabular mapping needs.

Most importantly, it means this Persister issues no DDL whatsoever, which is a real departure from how the other database Persisters behave. Those create their table when it is missing, add columns as new Cells appear, drop columns and tables that have become empty, and, in PostgreSQL, install the functions and event triggers they need to listen for changes and drop them again when they are destroyed. This one does none of that: it reads and writes a single row of a table you have already set up, and if that table is missing or shaped wrong, it reports the error rather than correcting the schema. Your database structure is yours, and stays exactly as your migrations left it.

If you want a Persister that manages its own schema, or you need tabular mode, connect to the database directly with the persister-pg module instead.