My Notes

  • Exclusive constraints automatically create an index, but what is the index type used an can it be changed?
    • btree- fastest for exclusion constraints (equality; other indexes are optimized for other comparisons)
  • Expose SQL interface without exposing GraphQL?
    • Configure auth per role and also make an allow list of protocols
    • Create role dedicated to SQL that only works with binary protocol
    • We are looking into it. Implement auth for GraphQL and HTTP
    • For now: Run pgbouncer in VPC
  • Warn that using GraphQL and HTTP are exposed to internet when enabled with Cloud
    • If we implement auth today, warn to make sure you enable auth
  • User is getting UnsupportedFeatureError: ‘FOR OPTIONAL’ is an internal testing feature when they try to use conditional DML via the coalesce operator in nightly_5-dev7931_cv202310110000. Is that intentional?

Meeting Notes