Goal
To build an ASP.NET Core 5 MVC web app linked with a PostgreSQL.
Motivation
- SQL Server is proprietary.
- SQLite used in Microsoft’s ASP.NET Core 5 MVC tutorial isn’t made for web apps.
- MySQL doesn’t perform well with concurrent read-writes. It’s dual-licensed like GitLab.
- Some users find PostgreSQL cost-effective.
Useful tutorials
- MS’s tutorial in item 2 above.
- Wes Doyle’s YouTube video goes through the steps
- MS’s tutorial for Razor Pages with EF Core migrations
Steps
-
Create a superuser in the database.
[Read More]