Use PostgreSQL with JSONB for the multi-tenant event service.
Chosen after comparing MySQL and PostgreSQL during the payments rewrite. JSONB and row-level security fit the tenant model better, and the team accepted the migration cost for query flexibility and long-term auditability.
Why this answer is trustworthy
- The summary is grounded in linked source artifacts.
- Confidence reflects how much direct evidence supports the record.
- The capture path and update history are part of the audit trail.
Linked evidence
- Slack: #architecture-decisions with the original discussion thread
- Jira: PAY-218 for the database selection work item
- GitHub: PR #402 for the migration spike and implementation notes