💰 0 USDT Bounty - "Add `cursors` table"

PomeloBounties commented 11 months ago

Bounty

Add cursors table created by @__ on Pomelo Bounties

Summary

Write a job description for creating a cursors table to monitor missed blocks from a given map module on Ethereum: We are looking for an experienced programmer to create a cursors table to monitor missed blocks from a given map module on Ethereum. The successful applicant should have experience with SQL and be comfortable writing code to create a table using ReplacingMergeTree engine and a primary key of cursor. The applicant should also be able to define the columns of the table such as cursor, module_hash, block_id, and chain. The applicant should be able to create the table and specify the primary key and order of the cursor, module_hash, and block_id.

Apply

https://bounties.pomelo.io/4aa14abd1aca

Original Issue

https://github.com/pinax-network/substreams-sink-clickhouse/issues/48

Title

Add cursors table

Body

Add cursors table to monitor:

how many missed blocks from map module dd6cc2c1bbe1516bb4bddcd9a8ca47e1861f5609 on eth?
what is the latest cursor per map module per chain?

CREATE TABLE IF NOT EXISTS cursor (
    cursor        String(),
    module_hash   FixedString(40),
    block_id      FixedString(64),
    chain         LowCardinality(String),
)
ENGINE = ReplacingMergeTree
PRIMARY KEY (cursor)
ORDER BY (cursor, module_hash, block_id);

Reward

0.0500 USDT

Note

For technical discussion use the original issue. This issue is for tracking the bounty application and implementation progress.