Skip to main content

Supabase

note

Content migrating from alianza-infra/docs/SUPABASE.md

Overview​

Alianza Capital uses Supabase PostgreSQL as the primary database.

Project ID: yodutvdnvvmbuaxccbex

Schemas​

SchemaPurpose
publicCore real estate, auctions, cadastral data
ridprCoquiTitle title study data

Extensions​

  • PostGIS - Geographic queries
  • pg_trgm - Full-text search
  • pg_cron - Scheduled jobs

Migrations​

Location: alianza-infra/supabase/migrations/

Migrations are automatically applied by CI/CD when pushed to main.