Infrastructure
spinschool‑postgres‑syd1 · Sydney (SYD1) · 170.64.170.84
-
01
Caddy
Reverse proxy, auto HTTPS via Let's Encrypt
-
02
ASP.NET Core on Kestrel
Docker container, 127.0.0.1:8085
-
03
PostgreSQL 16
postgres:16-alpine, not exposed publicly
-
04
Brevo
Password-reset email via HTTP API (SMTP blocked)
Load capacity
p95 latency by peak concurrent users · k6, 21 Aug 2026
550100200400600
peak virtual users
Comfortable to ~200 VUs (~60 req/s), flat latency. Degrades sharply by 400–600 VUs (~120–150 req/s) — queues rather than errors, 0% hard failures throughout.
Deployment
Migration & Deployment
SQL Server → PostgreSQL, Docker, DigitalOcean, HTTPS, backups
Load testing
k6 Results
Install, integration, six-run capacity study
Finance
Cost Breakdown
Editable template, dev through hosting through testing
Operations
Credentials Guide
Local & production retrieval, PowerShell commands
Tooling
VS → PostgreSQL
Server Explorer setup for local development