Guide to swapping SQLite for PostgreSQL or SQL Server #98

"Swap SQLite for something real" tells people to reimplement the repositories. For PostgreSQL or SQL Server the real job is smaller: change the provider package and UseSqlite, deal with the NOCASE collation and the keep-alive connection, regenerate the migrations, and point the tests somewhere sensible.

Phase 1: The guide

• guides/database.mdx gets a step-by-step section (or its own page) for PostgreSQL and SQL Server, per template
• Say what changes for the in-memory test databases

Checks: the site builds, and the steps work on a freshly generated solution against a local PostgreSQL container. Related to the --database option in #55.