Recently I came across the substrate-archive project. It does its indexing job extremely well, and I wanted to utilize it with some modifications here and there. Things I wanted to change are the following:
- In table
storage, I would like to add two varchar columns corresponding to the section and method of Substrate events. How do I decode these two out of the raw storage key?
- For every Substrate event that is in
storagetable, I need to additionally store its numeric index. Can this information be taken from the on-chain data?
- For every extrinsic, I would like to additionally store its section and method.
- For every extrinsic, I would like to store the success flag: whether the transaction was successful or not.
- For every extrinsic, I would like to store the signed flag: whether the transaction was signed or not.
Any pointers of how to achieve the above are greatly appreciated!