Postgrest

Postgrest-js

postgrest-js best doc

Generated Types

pnpm generate-types

or in case of non devcontainer environment

docker compose exec -iT app bash
cd /workspaces/webstudio/packages/postgrest
pnpm generate-types

Playground

pnpm playground ./playground/{file}.ts
# OR
pnpm tsx --env-file ../../apps/builder/.env ./playground/{file}.ts

Next steps.

Use https://supabase.com/docs/reference/cli/supabase-db-start or directly https://github.com/djrobstep/migra for migrations.

Supabase can be used with --db-url flag to not reproduce "local" env

Sql testing

CREATE SCHEMA IF NOT EXISTS pgtap;
DROP EXTENSION pgtap;
CREATE EXTENSION IF NOT EXISTS pgtap WITH SCHEMA pgtap;

pnpx supabase test new latest-builds

docker run --rm --network host -v ./supabase/tests:/tests -e PGOPTIONS='--search_path=pgtap,public' supabase/pg_prove:3.36 pg_prove -d "postgresql://postgres:pass@localhost/webstudio" --ext .sql /tests
# OR
pnpm run db-test