ADR 004 - Database

Date: 2025-07-03
Status: Active

Context

The existing Viper solution used SQL Server, but HyperPath needed a database choice that fit AWS hosting more naturally.

Decision

Use PostgreSQL with Entity Framework Core.

Options Considered

SQL Server
PostgreSQL

Rationale

AWS RDS support, team familiarity, and the desire to stay with a relational SQL store drove the choice.