Skip to content

Instantly share code, notes, and snippets.

View mempirate's full-sized avatar
🏃
Sprinting

Jonas Bostoen mempirate

🏃
Sprinting
  • Chainbound
  • Antwerp, Belgium
  • 22:04 (UTC +02:00)
  • X @mempirate
View GitHub Profile
Symbol Number of Deposits
bathUSDC 400
bathOP 246
bathETH 175
bathDAI 38
bathUSDT 38
bathSNX 30
nukenke 5
bathWBTC 4
@mempirate
mempirate / explorer-schema.md
Created January 30, 2025 15:50
Bolt Explorer Schema

Context

We need to redesign the data indexer with the following in mind:

  • Correct indexing for measuring network health
  • Correct indexing for attributing faults (liveness, safety, timeliness)
  • Correct indexing for finding bugs (local & remote error responses, tracking confirmations)
  • Enough metadata for all of the above

With this in mind, this is what the Clickhouse tables will look like:

raw_transaction_requests