sync onchain data node to timeseries store

[imotai]

Motivations

sync onchain data node to timeseries store

Solution

# start rtstore
docker run -p 9292:9292 -dt ghcr.io/rtstore/rtstore:0.1.0
#  use cli to connect to rtstore
mysql -h localhost -P 9292 -u root
# create tables
>create tables WITH ("blocknode_urls"="ws://xxxx","contract"="0x0a267cF51EF038fC00E71801F5a524aec06e4f07", "blockchain"="eth","auto_gen"="true");
# analysis the data 
> select * from xxx_event limit1;

Alternatives

Additional context

Sub Tasks

• streaming etl research