Install PostgreSQL as the main database

[loid345]

Mssql is not an open source database and it cannot be said that the platform is based on open source components. But EF also supports postgres. I suggest adding postgres support and installing PostgreSQL as the main database

[efonsecab]

Hello @loid345 , thanks for creating the task, the item has been moved to under consideration, in order to support additional database engine providers, it will however not be the default.
The system purposely uses Microsoft SQL Server to avoid using Entity Framework migrations, and instead have an SQL Database Project, as a means to facilitate learning for students and junior developers.

[loid345]

thanks for the answer.
The pgsql provider looks and feels just like any other Entity Framework Core provider.
No special changes will be required
https://www.nuget.org/packages/Npgsql.EntityFrameworkCore.PostgreSQL
https://learn.microsoft.com/en-us/ef/core/providers/?source=recommendations&tabs=dotnet-core-cli
But for example eShopOnAbp abandoned mssql in favor of postgres
https://github.com/abpframework/eShopOnAbp

[efonsecab]

Research issue created #149