SV: PostgreSQL on Windows' state - Mailing list pgsql-general

From Niels Jespersen
Subject SV: PostgreSQL on Windows' state
Date
Msg-id f291292bc5ee4064994f6fe2f3a44eea@dst.dk
Whole thread Raw
In response to PostgreSQL on Windows' state  (Alessandro Dentella <sandro.dentella@gmail.com>)
List pgsql-general
-----Oprindelig meddelelse-----
>Fra: Alessandro Dentella <sandro.dentella@gmail.com>
>Sendt: 23. september 2020 10:38
>Til: pgsql-general <pgsql-general@lists.postgresql.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
convincinghis 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
haveheard 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
onlyoption.  

Regards Niels




pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL on Windows' state
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: PG 13 trusted extensions and pg_available_extensions