[Documentation]: Query event: how can I query events about all validator staking

[Dmdv]

Summary

I need to query all events about all stakings from the node.
Like in ethereum where we can get all events from smart contracts using events, the same way I want to get about all stakings to validators.

I couldn't find any relevant information in docs, everywhere, and discord channel in not working too.

[tac0turtle]

We dont recommend querying all events in this fashion instead we would recommend putting the data into a database like postgres and then querying from there. If you have a node that has all the events then you will need to construct a query that loops through the tx_index.db from comet to get the data

[Dmdv]

We dont recommend querying all events in this fashion instead we would recommend putting the data into a database like postgres and then querying from there. If you have a node that has all the events then you will need to construct a query that loops through the tx_index.db from comet to get the data

Would be scanning transactions in each block a good solution anyway, provided that it's possible?

[tac0turtle]

scanning the txs will not get you the events. the best case is to send all the events to an external database or stream them directly to the integrated database

closing this as answered but happy to continue answering