brianleect/eth-onchain-price

Retrieve and store price of ETHUSD from onchain sources into an SQLite DB for reading.

---

eth-onchain-price's Issues

[Research] Implementation for maintaining up to date data

Solution 1: Sub newHeaders()
Subscribe to connection once and simply update on every new header received.

Pros

• Close to instant updating of price once received

Cons

• Not sure how reliable WS connections are in general especially over extended periods of time.

---

Solution 2: setInterval(10000,checkAndUpdate())
Check every set interval of 10s the latest block and updates accordingly

Pros

• Relatively more stable (this only holds if WS does indeed turn out to have issues)

Cons

• Delay of up to 10s from last blocks, might be slower by a few blocks.
• However, in most use cases it's likely that a 10s delay in price update on chain would be significant considering average block time is 15s. In the case where the current block is not available, app could simply fall back to the price in previous block number?

[Framework] Helper functions for retrieval from DB

Create util_retrieve.js file to abstract retrieval of single and multiple blocks from sqlite DB using sequelize.

[Research][Benchmark] JSON vs Sqlite vs eth_call

Considering that I shifted over from using a JSON file as a store initially, it would be interesting to see whether performance improvements or degradation is observable and the required load for it to matter.

Variables

1. Storage format: JSON / Sqlite / NONE (eth_call)
2. Retrieval style: Sqlite (ALL vs Single)
3. Number of blocks: 1k / 10k/ 100k / 1mil
4. "Simultaneous" requests 1/10/100/1000

Metrics to compare

1. Size of DB choice (Storage)
2. Time taken to retrieve price of X number of blocks