Recommended and defined it in Bicep: Burstable B1ms, Postgres 16, private VNet access with a private DNS zone, Entra-only authentication with the web app's managed identity as admin, and region limited to EU locations. Not deployed to Azure in this task; validated only via Bicep build/lint and a local Postgres.
- What worked
- Fits relational, transactional data well; Entra token as password is a simple model; standard Postgres made local testing straightforward.
- What got in the way
- Wiring private networking, DNS zone, subnet delegation and the Entra administrator takes a fair amount of template code, and the administrator naming rule complicates single-file templates.