Every edit is accounted for. Conflicts are quarantined, failures are logged, and a reconcile sweep catches anything missed.
conflict_log, validation_issues, sync_run_log, reconcile_audit()) are designed and stubbed in v0.1.0; the worker that populates them is in active development.
agol_fdw is built so an edit can never just disappear:
dead for review — never silently discarded.conflict_log; they are never auto-resolved — a human decides.validation_issues.sync_run_log with counts and outcomes.reconcile_audit() sweep compares AGOL and PostGIS to catch edits that slipped past the webhook path.For a system of record, "it synced" isn't good enough — you need proof. The logs and queues make sync observable and auditable, and they make failures recoverable instead of invisible.
-- review anything that failed to sync after retries
SELECT * FROM agol_fdw.outbox WHERE status = 'dead';
-- human review of concurrency conflicts
SELECT * FROM agol_fdw.conflict_log ORDER BY detected_at DESC;
-- run the periodic reconcile audit
SELECT agol_fdw.reconcile_audit();