Substrate and Polkadot Stack Exchange is a question and answer site for developers building blockchains with the Substrate SDK. It only takes a minute to sign up.
Sign up to join this community
How can I index the substrate storage maps of pallets and ipfs content of cids, to have filters and build custom search queries?
Is it a good idea to use subxt for querying storage through rpc from the blockchain and putting it in a database?
Not sure if I can use indexing services like hydra or subquery to do that.
Subxt is geared around interacting with the tip of a chain, and will run into issues trying to obtain and index older entries (and will need custom metadata to be provided to go back through older blocks that use V14 metadata, too).
If you want to index the storage in a chain more fully, I'd probably suggest looking into using Polkadot.js directly or a higher level interface like https://github.com/paritytech/substrate-api-sidecar offhand (which is already used for accessing and indexing older blocks and so should be up to the task.
