Signed order relay — Node.js and SQLite

Signed order relay: handling duplicates and uncertain results

This executable Node.js and SQLite example explores a common integration failure: a remote action may succeed even when its response is lost. It uses synthetic orders and a simulated provider.

The approach • Check a signed event against its exact raw JSON and validate the order amount and currency. • Persist accepted events transactionally and deduplicate repeated notifications. • Prevent two workers from claiming the same ready order. • Hold uncertain outcomes for reconciliation instead of automatically repeating a potentially successful action. • Preserve accepted events across database close and reopen.

Evidence and handover Nine automated tests passed on Windows with Node.js 24.13.0 and SQLite 3.50.4 on 8 September 2026. The public repository contains the source, tests, exact run command and verification notes. The README explains the failure scenarios, operator responsibilities and integration limits.

Source, tests and documentation: https://github.com/CocoRbt/order-relay-proof

Scope of the example The signing envelope and provider behavior are deliberately simulated. No production API, live recharge or client deployment was tested. The sample does not include an HTTP server, operator authorization, monitoring or a secrets-management system. A real integration needs its own API specification, access controls and acceptance checks. These tests demonstrate specific failure-handling scenarios; they do not establish exactly-once remote execution.