Tech componentsShared across all subject areas

PostgreSQL

Stack choice components7
  • Python services with matching implemented as SQL against Postgres
  • PostgreSQL via Supabase
  • Aurora PostgreSQL with declarative partitioning and read replicas
  • NUMERIC(19,4) in Postgres, Python decimal.Decimal, strings across the API boundary
  • pg-boss on the same Postgres instance
  • Postgres row-level security enabled on transactional tables
  • timestamptz in Postgres, UTC throughout, converted at render time