First sketch of signers table

kadena-io / chainweb-data

Data ingestion for Chainweb.

BSD 3-Clause "New" or "Revised" License

14 stars 8 forks source link

First sketch of signers table #58

Closed mightybyte closed 3 years ago

mightybyte commented 3 years ago

@sirlensalot I don't believe request key does captures everything because transactions can be reintroduced. @emmanueldenloye and I ran into this issue when we were debugging the DB filling code.

sirlensalot commented 3 years ago

I guess since our Transaction is actually an executed transaction, that's correct, since the outputs depend on the block.

sirlensalot commented 3 years ago

Truly denormalized would be:

transaction INPUT keyed by just req key
transaction OUTPUT keyed by req key + block hash

mightybyte commented 3 years ago

Ahh yeah. I think this is a good compromise for now because it avoids a join when you want to query on tx success/failure, etc.