serious contender?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
costeakai
Posts: 16
Joined: Wed 02 Aug 2017 12:16

serious contender?

Post by costeakai » Wed 28 Nov 2018 13:04

is npgsql v4.0.3 a serious contender?
I would say NO for synchronization , entityframework , asp.net , ssl , and the list goes on and on...
But, YES for simple reading / writing (including PostGIS/NetTopologySuite Type ); i have found the Binary COPY method to be the fastest thing on earth.

Shalex
Site Admin
Posts: 8474
Joined: Thu 14 Aug 2008 12:44

Re: serious contender?

Post by Shalex » Thu 29 Nov 2018 12:26

Thank you for your feedback. If you find any feature supported by a competitor and not available in dotConnect for PostgreSQL, please contact us so that we put the feature on our roadmap.

costeakai
Posts: 16
Joined: Wed 02 Aug 2017 12:16

Re: serious contender?

Post by costeakai » Mon 03 Dec 2018 10:02

Hi shalex,
thanks;

The binary copy method of npgsql is very fast , both in reading and writing.
at this moment i make BOTH devart dotconnect connections AND npgsql connections to the same postgis database,
so i am using best of both worlds.

Shalex
Site Admin
Posts: 8474
Joined: Thu 14 Aug 2008 12:44

Re: serious contender?

Post by Shalex » Mon 03 Dec 2018 18:01

JIC: dotConnect for PostgreSQL Professional includes the PgSqlLoader class, you can set PgSqlLoader.Mode=PgSqlLoaderMode.Binary.

Post Reply