PostgreSQL, an open-source database with advanced performance features such as multi-version concurrency control, is a valid alternative to traditional relational databases and NoSQL databases. It also supports .NET and has a large community ensuring its relevance to .NET users. To use PostgreSQL with .NET, required NuGet packages are Npgsql and Npgsql.EntityFrameworkCore.PostgreSQL. A connection string for PostgreSQL has six required fields: server, port, user id, password, database, and pooling. Setting up a PostgreSQL instance on Amazon RDS, requires selecting Standard create and PostgreSQL, and then configuring the database as required.
