what we would like to do is build a custom query (or set of queries) to "update" supporting records as in-place as possible
if we take Listing -> Listing Events as our example:
we want to build a custom extension such that:
if its a new listing event it gets created in the db
if its a listing event that is being removed from the db it gets deleted from the db
if its a listing event that is getting updated then update it in place
if its a listing event that has no changes, do nothing to it
the way it currently works is we delete all listing events and then re-create them. PCE might be able to reduce that churn and hopefully make the process easier, or at least more legible
We want to investigate Prisma Client Extensions (PCE): https://www.prisma.io/docs/orm/prisma-client/client-extensions
what we would like to do is build a custom query (or set of queries) to "update" supporting records as in-place as possible
if we take Listing -> Listing Events as our example: we want to build a custom extension such that:
the way it currently works is we delete all listing events and then re-create them. PCE might be able to reduce that churn and hopefully make the process easier, or at least more legible