IntersectMBO / cardano-db-sync

A component that follows the Cardano chain and stores blocks and transactions in PostgreSQL
Apache License 2.0
283 stars 158 forks source link

Add SPO voting power table #1720

Open kderme opened 1 month ago

kderme commented 1 month ago

After https://github.com/IntersectMBO/cardano-ledger/issues/4061 the voting power of SPOs is not directly related to their staking power, since proposal deposits count towards the stake reward account where they will be returned. This means that epoch_stake doesn't properly depict the spo voting power. A new table can be introduced, which includes pool_hash_id, lovelace ammount and epoch can be introduced. The spo voting power can be extracted as the result of the drep pulser.