Delta Support for EfCore with PostgreSQL?

Hi, I want to congratulate you on the good work that you have done with this package.

Any further milestone to be able to use it with Postgresql database?

As I saw from you documentation, you only support EF with SqlServer.

Thank you!

Nov 27 '24 12:11 zewa1999

looks like pg_last_committed_xact would work as an etag https://stackoverflow.com/a/65340830/53158

Nov 28 '24 11:11 SimonCropp

Or maybe xmin (when going for the rowversion only approach) https://www.npgsql.org/efcore/modeling/concurrency.html?tabs=data-annotations?

Dec 03 '24 18:12 mwo-dk

Postgres does not support "Change tracking "

Dec 04 '24 09:12 Neo-vortex

Couldn't this be solved with Triggers?

Dec 04 '24 10:12 Kurpanik

postrgres support has been added

Dec 09 '24 10:12 SimonCropp

Thanks for adding this support.

Dec 09 '24 11:12 edcsu

has anyone tried this? any issues/problems to report?

Dec 10 '24 11:12 SimonCropp

Not yet. But since support for Postgres has been added, I plan to integrate it into one of my projects soon.

Dec 10 '24 12:12 Kurpanik

has anyone tried this? any issues/problems to report?

Yes I have and I am getting the super fast query responses

Apr 07 '25 12:04 edcsu

@edcsu can u share some before and after numbers?

Apr 07 '25 23:04 SimonCropp

@edcsu can u share some before and after numbers?

I reproduced the effect locally. I am querying for 1000 products.

Before using delta

Using delta initial request

Subsequent request 1

next request

another

Apr 08 '25 11:04 edcsu

@edcsu that is a great outcome.

Apr 08 '25 11:04 SimonCropp

@edcsu that is a great outcome.

Indeed it is because we are dealing with millions of records. 🚀 Just wanted to say thanks for both Delta and replicant. They are both incredibly fast and optimised. Really appreciate the attention to performance. Great work!

Apr 08 '25 11:04 edcsu