Why we should choose PostgreSQL over MSSQL

Question

Can you please help me to know the answer of this question 'Why we should choose PostgreSQL over MSSQL'

Mahesh Chand · Answer

If you compare features, advancements, tooling, MS SQL Server is a better choice. But you need to pay thousands of dollars each year in licensing. If you run a large website that needs several licenses, it can cost tens of thousands of dollars or more if you want SQL Server Enterprise. PostgeSQL is 100% free. You can run as many as database instances, cost is $0. That is the key benefit. Most businesses are making this move from MS SQL to PostgreSQL because of the cost. Here is a detailed comparision feature by feature. https://learnsql.com/blog/ms-sql-vs-postgresql/

Sachin Singh · Answer

Its not like you should use one over another. You are simply saying PostgreSQL is better than MSSQL , this is incorrect. Both can be installed on any OS.MSSQL has many advanced options, such as compression, partitioning, and optimized storage. Its data management – requiring minimal troubleshooting and with data recovery support in case of data corruption – are very useful. The main difference is the licensing and support costs. For MSSQL the licensing and support costs are discouraging for the e-commerce users . The advanced features tend to be very expensive. PostgreSQL is an open-source RDBMS. There is no licensing cost for owning and upgrading it.

Muhammad Imran Ansari · Answer

There are lot of comparison on WHY question. Below are the some main comparisons: In Terms of licencing: PostgreSQL is Free and open source relational database management system, maintained by PostgreSQL. SQL Server is Commercial database management system, built and maintained by Microsoft. Supported Server Operating Systems: PostgreSQL seems to be more universal. It is widely available on multiple operating systems: FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix, Windows. SQL Server is limited to Windows, and recently Linux. For more comparisons, read the following nice article on this: https://tableplus.com/blog/2018/10/postgresql-vs-sql-server-database-comparison.html

Uttam Kumar · Answer

There are plenty of articles on the internet but I found this one very content full https://www.enterprisedb.com/blog/microsoft-sql-server-mssql-vs-postgresql-comparison-details-what-differences I hope this might help you understand as well .. Cheers!

Why we should choose PostgreSQL over MSSQL

Answers (4)