search

OpenFn / wcs-wildmeat

Wildlife Conservation Society ConSocSci Project
1 stars 0 forks source link

Consider upserting for idempotency #2

Closed taylordowns2000 closed 3 years ago

taylordowns2000 commented 4 years ago

This would allow us to replay transactions without fear of failure or duplication: https://www.postgresqltutorial.com/postgresql-upsert/

It's standard practice for OpenFn jobs, but has been omitted given the timeline for this initial demo.

taylordowns2000 commented 4 years ago

Jobs are now (as of last commit) idempotent, but don't upsert. they on conflict do nothing;

taylordowns2000 commented 3 years ago

This is handled in the new job changes.