Skip to main content

Developer Portal Service — Data Model

Version: 1.0 Status: Draft Owner: Product + Developer Relations (DevRel) Last Updated: 2026-04-20

1. Intent​

Describe the PostgreSQL schema (devportal), Redis keyspace, and S3 object layout backing the service. Includes TS interfaces, indexes, RLS policies, and ID prefix conventions.

2. ID Prefix Convention​

PrefixAggregate
dev_DeveloperAccount
key_ApiKey metadata
vrf_VerifySession
vtmpl_VerifyTemplate
sdkr_SdkRelease
doc_DocsArticle

3. Postgres Tables​

  • devportal.developer_accounts — TBD
  • devportal.api_key_metadata — TBD
  • devportal.production_key_requests — TBD
  • devportal.verify_templates — TBD
  • devportal.sdk_releases — TBD
  • devportal.docs_articles — TBD

4. Redis Keyspace​

  • devportal:verify:{verificationId} — VerifySession state, TTL = ttlSeconds — TBD
  • devportal:verify:rate:tenant:{tenantId}:{minute} — per-tenant rate counter — TBD
  • devportal:verify:rate:recipient:{hash}:{hour} — per-recipient cap — TBD
  • devportal:consumption:{keyId}:{range} — analytics cache, TTL 30 s — TBD

5. S3 / Object Store Layout​

  • s3://ghasi-devportal/sdk/{language}/{version}/... — TBD
  • s3://ghasi-devportal/openapi/{version}/openapi.{json|yaml} — TBD
  • s3://ghasi-devportal/postman/{version}/collection.json — TBD

6. RLS Policies​

  • TBD

7. Indexes​

  • TBD

8. TS Interfaces​

  • TBD