Get the latest tech news

Declarative Schemas for simpler database management

Simplify managing and maintaining complex database schemas

Declarative schemas store the final desired state of the database in.sql files that can be saved and versioned alongside a project. Since Postgres views are not updatable by default, we have defined trigger functions to cascade writes to the underlying table when a Supabase user creates a new project. This makes development easier because the projects view can be inserted with regular PostgREST calls while invoking the appropriate RLS policies on the underlying table.

Get the Android app