SV: PostgreSQL on Windows' state

-----Oprindelig meddelelse-----
>Fra: Alessandro Dentella <sandro(dot)dentella(at)gmail(dot)com>
>Sendt: 23. september 2020 10:38
>Til: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
>Emne: PostgreSQL on Windows' state
>
>Hi,
>
>disclaimer: I've never been a Windows user and I send this email just on behalf of a friend that has problems convincing his team to use PostgreSQL.
>
>I'd like to understand if what the team replies to him is correct or not.
>
>The final project should work with Python (we know it just works) and with c#.
>The team states that:
>
> "It does not exist a native driver. You need to use ODBC, that is an old
> technology and doesn't give warranties in terms of security, reliability and
> performance."
>
>Is it any true? is it biased?

We are using Postgres 11 and 12 on Windows. No issues.

A lot of the usage comes from Python/Psycopg2 and sometimes SQLAlchemy. Which all rock.

Some usage is from C# using npgsql. Most of which also uses Entity Framework (supported by npgsql). No issues, that I have heard of.

And some usage goes through ODBC. Which works fine. Except for bulk writes, but that is not the fault of Postgres ODBC driver. That is a limitation of the ODBC architecture in general. Our ODBC usage is in environments where that is the only option.

Regards Niels