靠近余额仪表板
我只想获取仪表板,用户余额从0到100n,从100N到1000N。我坐在Macos High Sierra上,我的笔记本电脑很旧,所以我无法建立整个索引器,
我有点困惑,因为我不需要构建整个迁移或索引器。也许我可以安静地做到这一点?
I just want to get dashboard with amount of users balances from 0 to 100N and from 100N to 1000N. I’m sitting on macOS High Sierra and my laptop is old, so I cannot to build whole part of indexer
I’m little bit confused, cause I don’t need to build whole migrations or indexer stuff. Maybe I can do it quietly simple that I think about it?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
Explorer的索引器会跟踪很多信息(更多详细信息在这里)。该信息是公开的,尽管由于使用量较高,该访问可能无法可靠。如果您需要可靠性,建议运行自己的索引器实例以for Explorer,或者不需要所有这些数据,则可以运行自定义 indexer 。
数据库是
account_changes
表,可以跟踪每个块每个帐户的所有更改。如果您想获得最新的余额,则可以在更改_in_block_timestamp
&amp上进行反向顺序。index_in_block
和组通过affected_account_id
。The indexer for explorer keeps track of a lot of information (more details found here). This information is public, although the access might not be reliable due to high usage volume. If you need reliability, it is recommended to run your own instance of the indexer for explorer or if you don't need all that data, you can run a custom indexer.
One of the tables in the database is the
account_changes
table which keeps track of all the changes for each account per block. If you wanted to get the latest balance, you could do a reverse order on thechanged_in_block_timestamp
&index_in_block
and group byaffected_account_id
.