Oracle improvements

[sergiimk]

An idea dump for oracle improvements:

• [x] Scan limited range of blocks on startup (e.g. last N days), not from the very beginning
• [x] Debug info for lines in release build
• [ ] Oracle is killed by liveness checks when Infura goes down before logging anything
• [ ] Single request that results in API 500 error can DOS the oracle (retry death loop)
• [ ] Upgradeability proxy
  • Consider foundry upgrades [1] [2]
  • Consider eternal storage pattern
• [ ] Add emergency stop
• [ ] Add simple payments
  • fallback function?
  • treasury / transfer-all-ETH-to admin function
  • emergency withdraw
• [ ] Arbitrary metadata with request (e.g. to associate request with contract data)
• [ ] Support SQL parametrization $var
• [ ] Ability to self-deliver signed responses (reconcile with commitment RFC)
• [ ] Handle limits
• [ ] Pagination support
• [ ] Streaming internal architecture
• [ ] Websocket subscriptions instead of polling
• [ ] Use latest/safe/finalized aliases?
• [ ] Handle reorgs