Is PostgreSQL a worthy alternative to Microsoft SQL Server?

This page summarizes the projects mentioned and recommended in the original post on dev.to

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • PostgreSQL

    Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

  • I have always been an avid Microsoft technology stack advocate, so naturally most of the time my RDBMS system of choice was Microsoft SQL Server. Now, I'm still holding my opinion that Microsoft SQL Server is a great product, which scales wonderfully from small web applications to large enterprise solutions. The fact however is that for any non-trivial applications, i.e. once the database system requirements outgrow the potential of the free SQL Server Express edition, licensing costs may start to become an issue. And that is (at least for me) exactly the point at which PostgreSQL comes into play.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • pgadmin4

    pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

  • The PostgreSQL installation process typically involves downloading the software, running the installer, and specifying a few basic configuration settings. If you also opt to install the pgAdmin GUI tool (a PostgreSQL counterpart to SQL Server Management Studio), you may start your database adventures within minutes of downloading the software.

  • Npgsql

    Npgsql is the .NET data provider for PostgreSQL.

  • And yet again, I got pleasantly surprised. Npgsql - the recommended ADO.NET and Entity Framework (Core) provider - makes the adoption of PostgreSQL an almost seamless experience. Additionally, the Npgsql provider implements those PostgreSQL language elements, which are not present in the Microsoft SQL Server world. Let me mention here at least support for the ILIKE operator, as well as a range of functions related to the PostgreSQL's LTree data type.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Amazon RDS - PostgreSQL for .NET Developers

    2 projects | dev.to | 6 Jun 2022
  • Azure PostgreSQL, Entra ID Authentication and .NET

    1 project | dev.to | 2 Jun 2024
  • Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

    1 project | dev.to | 16 May 2024
  • With .NET 8 Native AOT will we get small single binary for applications like Go/Rust?

    2 projects | /r/dotnet | 4 Jun 2023
  • ASP.Net Core database modelling without using existing ORMs?

    1 project | /r/csharp | 26 Jan 2023