 Retrieving information about Hive Power delegations can be a bit tricky. While the Hive API makes it easy to know to whom an account is delegating using `condenser_api.get_vesting_delegations`, the opposite is more difficult. As far as I know, there is no API call to know who has delegated to an account. ### HiveSQL to the rescue - Episode 1 Fortunately, HiveSQL allows you to easily retrieve this information thanks to the `TxDelegateVestingShares` table which includes all creation, modification or removal of delegation operations carried out by users. However, the main difficulty comes from the fact that you have to check the last `delegate_vesting_share` operation involving two accounts to get the state of the delegation between these accounts. In addition, there is a very particular event that must also be taken into account: the hardfork 23 that happened when the Hive blockchain split from Steem. Indeed, at this time, several accounts have not been airdropped with HIVE tokens, so their existing delegations were instantly removed. However, there were no operations of type `delegate_vesting_share` relating to this. This was recorded in the blockchain with `hardfork_hive` virtual operations, stored in the `VOHardforkHives` table in HiveSQL ### HiveSQL to the rescue - Episode 2 Due to all the technical reasons mentioned above, retrieving an accurate list of delegators or delegatees has become much more complex and resources consuming. That's why I added a new non-consensus state table named `Delegations` to the HiveSQL database in order to allow its users to retrieve delegations data quickly and easily. It contains the list of all active delegations with the following info: |Column|Description| |-|-| |delegator|The account delegating Hive Power| |delegating|The account receiving Hive Power delegation| |vests|The amount of Vesting Shares delegated| ## Support If you have any questions or remarks, support is provided on the [HiveSQL Discord Channel](https://discord.gg/kyEFDfT). Thank you. --- <center> ### Check out my apps and services <a href="/hive/@hive.engage/stay-connected-with-your-hive-audience-and-catch-attention"><img src="https://i.imgur.com/GiNJqlm.png"></a><a href="/@hivebuzz"><img src="https://i.imgur.com/B4UTun2.png"></a><a href="/@hivesql"><img src="https://i.imgur.com/EPN8RW6.png"></a><a href="/hive/@arcange/introducing-hive-account-recovery"><img src="https://i.imgur.com/6TWeW7V.png"></a><a href="/@hive.autoclaim"><img src="https://i.imgur.com/ih2pEOw.png"></a></center> <center> ### [Vote for me as a witness ](https://hivesigner.com/sign/account-witness-vote?witness=arcange&approve=1)
| author | arcange |
|---|---|
| permlink | hivesql-new-feature-delegation-state-table-availaible |
| category | hive-139531 |
| json_metadata | "{"app":"peakd/2020.10.9","format":"markdown","description":"Retrieving information about Hive Power delegations can be a bit tricky. Thanks to HiveSQL, it's now easier than ever.","tags":["hivesql","hive","sql","database","hive-139531"],"users":["hive.engage","hivebuzz","hivesql","arcange","hive.autoclaim"],"links":["https://discord.gg/kyEFDfT","/hive/@hive.engage/stay-connected-with-your-hive-audience-and-catch-attention","/@hivebuzz","/@hivesql","/hive/@arcange/introducing-hive-account-recovery","/@hive.autoclaim","https://hivesigner.com/sign/account-witness-vote?witness=arcange&approve=1"],"image":["https://i.imgur.com/FE9D32t.png","https://i.imgur.com/GiNJqlm.png","https://i.imgur.com/B4UTun2.png","https://i.imgur.com/EPN8RW6.png","https://i.imgur.com/6TWeW7V.png","https://i.imgur.com/ih2pEOw.png","https://i.imgur.com/2bi4SnT.png"]}" |
| created | 2020-11-03 14:32:42 |
| last_update | 2020-11-03 17:08:27 |
| depth | 0 |
| children | 6 |
| last_payout | 2020-11-10 14:32:42 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 3.548 HBD |
| curator_payout_value | 3.212 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 2,738 |
| author_reputation | 1,146,633,668,945,473 |
| root_title | "HiveSQL new feature - Delegation state table available" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,374,709 |
| net_rshares | 32,663,335,430,877 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| pfunk | 0 | 7,578,191,222,090 | 100% | ||
| pnc | 0 | 104,294,577,698 | 100% | ||
| kenny-crane | 0 | 337,278,223,083 | 50% | ||
| mammasitta | 0 | 92,225,539,075 | 15% | ||
| gerber | 0 | 34,830,420,797 | 2% | ||
| ezzy | 0 | 132,655,931,545 | 2% | ||
| livingfree | 0 | 276,944,292,908 | 4% | ||
| inertia | 0 | 1,414,601,147,009 | 100% | ||
| exyle | 0 | 79,610,736,497 | 2% | ||
| ace108 | 0 | 183,729,953,674 | 5% | ||
| timcliff | 0 | 1,336,018,953,094 | 100% | ||
| alinalazareva | 0 | 10,932,366,838 | 100% | ||
| bert0 | 0 | 2,091,295,944 | 0.4% | ||
| jsantana | 0 | 826,033,538 | 30% | ||
| someguy123 | 0 | 41,647,774,997 | 2% | ||
| anarcho-andrei | 0 | 708,708,146 | 2.4% | ||
| phusionphil | 0 | 20,484,500,895 | 19% | ||
| abh12345 | 0 | 1,195,168,780,793 | 50% | ||
| jang | 0 | 249,255,455,007 | 100% | ||
| vannour | 0 | 52,779,032,022 | 50% | ||
| steemcultures | 0 | 653,805,631 | 50% | ||
| steemworld | 0 | 2,035,662,334 | 50% | ||
| created | 0 | 671,268,442,559 | 4% | ||
| creat | 0 | 707,534,280 | 50% | ||
| mapesa | 0 | 970,590,456 | 25% | ||
| funnel | 0 | 34,858,112,009 | 100% | ||
| cisah | 0 | 698,122,347 | 50% | ||
| ixindamix | 0 | 121,835,096,559 | 60% | ||
| cardboard | 0 | 19,448,494,656 | 100% | ||
| pedir-museum | 0 | 1,336,325,194 | 50% | ||
| distantsignal | 0 | 735,570,372,197 | 100% | ||
| aceh | 0 | 772,423,807 | 50% | ||
| tarazkp | 0 | 1,154,239,850,365 | 20% | ||
| borislavzlatanov | 0 | 142,055,402,784 | 100% | ||
| miniature-tiger | 0 | 98,058,506,080 | 50% | ||
| lizanomadsoul | 0 | 246,750,533,291 | 100% | ||
| munzir | 0 | 798,455,334 | 50% | ||
| dune69 | 0 | 15,036,241,348 | 2% | ||
| iansart | 0 | 2,187,953,952 | 1.24% | ||
| valued-customer | 0 | 22,895,030,448 | 25% | ||
| alphacore | 0 | 38,621,903,653 | 1.8% | ||
| drakos | 0 | 1,614,402,476,783 | 100% | ||
| derosnec | 0 | 884,199,279 | 4% | ||
| paulag | 0 | 125,600,142,777 | 10% | ||
| guchtere | 0 | 850,595,904 | 4% | ||
| slickhustler007 | 0 | 3,544,266,529 | 100% | ||
| eturnerx | 0 | 3,523,362,971,107 | 100% | ||
| shitsignals | 0 | 841,674,055 | 2% | ||
| pixelfan | 0 | 32,984,354,858 | 6% | ||
| gamesjoyce | 0 | 13,633,263,315 | 50% | ||
| warjar | 0 | 11,809,087,214 | 100% | ||
| zyx066 | 0 | 11,563,201,741 | 4% | ||
| foreveraverage | 0 | 2,043,084,782 | 50% | ||
| felander | 0 | 9,801,197,375 | 2% | ||
| tipu | 0 | 384,409,686,324 | 1% | ||
| niallon11 | 0 | 3,493,756,815 | 0.4% | ||
| onartbali | 0 | 10,845,812,960 | 50% | ||
| accelerator | 0 | 48,213,594,022 | 5% | ||
| cconn | 0 | 701,802,688 | 19% | ||
| yogacoach | 0 | 1,761,116,908 | 2% | ||
| tomiscurious | 0 | 6,757,228,919 | 2.83% | ||
| circleoffriends | 0 | 1,050,877,673 | 100% | ||
| pixresteemer | 0 | 56,436,221,758 | 17% | ||
| revisesociology | 0 | 70,191,710,761 | 5% | ||
| thatterrioguy | 0 | 1,979,435,838 | 100% | ||
| calimeatwagon | 0 | 1,173,827,502 | 35% | ||
| jlsplatts | 0 | 8,714,814,127 | 1% | ||
| meno | 0 | 82,122,556,269 | 4% | ||
| craigcryptoking | 0 | 76,812,256,377 | 100% | ||
| ankapolo | 0 | 904,848,279 | 1.6% | ||
| liverpool-fan | 0 | 741,522,940 | 20% | ||
| florian-glechner | 0 | 478,664,749,749 | 100% | ||
| traciyork | 0 | 704,109,594,122 | 100% | ||
| caladan | 0 | 3,538,438,165 | 1.9% | ||
| socent | 0 | 1,471,077,484 | 15% | ||
| emrebeyler | 0 | 48,927,199,888 | 2% | ||
| bluefinstudios | 0 | 15,391,261,864 | 25% | ||
| pechichemena | 0 | 1,005,598,533 | 1.6% | ||
| kernelillo | 0 | 702,946,847 | 31% | ||
| helpie | 0 | 19,552,799,566 | 8% | ||
| markaustin | 0 | 792,614,402 | 5% | ||
| fherdz | 0 | 5,796,324,273 | 100% | ||
| jrungi | 0 | 1,890,862,519 | 50% | ||
| lethsrock | 0 | 590,379,340 | 50% | ||
| fourfourfun | 0 | 1,267,783,909 | 4.37% | ||
| kaerpediem | 0 | 175,047,033,354 | 100% | ||
| nerdtopiade | 0 | 14,810,065,615 | 36.58% | ||
| dudeontheweb | 0 | 1,091,712,534 | 10% | ||
| payger | 0 | 5,700,749,410 | 50% | ||
| bennettitalia | 0 | 1,865,973,091 | 2% | ||
| nealmcspadden | 0 | 11,852,502,028 | 2% | ||
| tryskele | 0 | 9,641,448,556 | 10% | ||
| manncpt | 0 | 69,441,265,986 | 100% | ||
| purefood | 0 | 2,498,814,487 | 2% | ||
| jnmarteau | 0 | 22,348,218,303 | 100% | ||
| philnewton | 0 | 1,881,032,993 | 25% | ||
| cfminer | 0 | 543,924,874 | 100% | ||
| jakeeyexe | 0 | 938,618,875 | 50% | ||
| tricki | 0 | 881,806,453 | 10% | ||
| icuz | 0 | 270,394,821 | 100% | ||
| holger80 | 0 | 2,278,498,653,052 | 50% | ||
| shmoogleosukami | 0 | 65,320,587,965 | 50% | ||
| warpedpoetic | 0 | 3,613,718,153 | 8% | ||
| hazem91 | 0 | 904,270,011 | 1.2% | ||
| overmedia | 0 | 994,268,098 | 50% | ||
| thisbejake | 0 | 2,919,132,082 | 50% | ||
| ajaxalot | 0 | 4,029,910,962 | 5% | ||
| zipporah | 0 | 4,052,156,731 | 1.6% | ||
| watchlist | 0 | 172,719,622,799 | 100% | ||
| doomsdaychassis | 0 | 5,314,999,546 | 8% | ||
| bestboom | 0 | 854,546,778 | 2% | ||
| nebuladream | 0 | 1,754,216,532 | 50% | ||
| manniman | 0 | 79,311,669,522 | 33% | ||
| kanrat | 0 | 16,358,640,516 | 31% | ||
| jan23com | 0 | 5,918,864,394 | 90% | ||
| jkramer | 0 | 1,130,981,205,929 | 100% | ||
| big-m | 0 | 713,459,460 | 31% | ||
| orkin420 | 0 | 6,334,063,085 | 100% | ||
| freddio | 0 | 23,406,104,603 | 15% | ||
| choco11oreo11 | 0 | 3,622,553,021 | 90% | ||
| naruitchi | 0 | 6,081,864,736 | 50% | ||
| tresor | 0 | 85,423,236,165 | 29.77% | ||
| josebenavente | 0 | 7,915,551,053 | 100% | ||
| globalschool | 0 | 44,825,952,130 | 50% | ||
| promobot | 0 | 14,824,050,244 | 17.5% | ||
| youraverageguy | 0 | 621,019,424 | 50% | ||
| bembelmaniac | 0 | 3,338,408,247 | 75% | ||
| dunite | 0 | 17,753,075,238 | 100% | ||
| opt2o | 0 | 3,055,165,657 | 50% | ||
| jancharlest | 0 | 404,387,761 | 1% | ||
| aceaeterna | 0 | 4,927,947,686 | 50% | ||
| justasperm | 0 | 1,867,368,250 | 50% | ||
| sk1920 | 0 | 7,733,071,678 | 100% | ||
| free-reign | 0 | 1,418,543,239 | 1.2% | ||
| solarwarrior | 0 | 1,309,679,491,577 | 100% | ||
| somegaming | 0 | 2,221,628,361 | 50% | ||
| swisswitness | 0 | 1,120,781,993 | 2% | ||
| roger5120 | 0 | 92,749,409,325 | 10% | ||
| blewitt | 0 | 14,074,987,870 | 0.56% | ||
| bflanagin | 0 | 4,136,281,861 | 4% | ||
| melor9 | 0 | 645,718,576 | 4% | ||
| lillywilton | 0 | 3,569,651,528 | 20% | ||
| adonisr | 0 | 22,114,279,425 | 100% | ||
| digi-me | 0 | 50,118,299,912 | 100% | ||
| thehive | 0 | 117,161,294,028 | 70% | ||
| dalz | 0 | 3,497,495,308 | 1% | ||
| zuerich | 0 | 407,674,535,772 | 10% | ||
| kepslok | 0 | 1,402,826,078 | 50% | ||
| littleshadow | 0 | 5,474,196,069 | 90% | ||
| luppers | 0 | 130,218,752,675 | 10% | ||
| dlike | 0 | 23,282,549,496 | 2% | ||
| voxmortis | 0 | 901,200,821 | 0.5% | ||
| joseph6232 | 0 | 1,863,354,984 | 90% | ||
| emaillisahere | 0 | 3,273,287,804 | 75% | ||
| buzzbee | 0 | 627,658,005 | 50% | ||
| fullnodeupdate | 0 | 16,632,851,664 | 50% | ||
| caoimhin | 0 | 4,375,010,346 | 100% | ||
| djtrucker | 0 | 1,473,417,611 | 75% | ||
| voter003 | 0 | 3,381,080,152 | 3.25% | ||
| vimm | 0 | 557,833,028,741 | 100% | ||
| marshalmugi | 0 | 77,845,979,533 | 85% | ||
| podg3 | 0 | 1,770,457,877 | 90% | ||
| misstaken | 0 | 6,682,171,690 | 90% | ||
| deepsouthpiddlin | 0 | 3,875,360,123 | 20% | ||
| followjohngalt | 0 | 14,753,607,453 | 2% | ||
| eonwarp | 0 | 2,418,950,701 | 100% | ||
| jussbren | 0 | 2,073,112,193 | 90% | ||
| vibesforlife | 0 | 2,370,297,183 | 10% | ||
| thehealthylife | 0 | 3,729,148,127 | 100% | ||
| kaldewei | 0 | 8,737,668,683 | 31% | ||
| bilderkiste | 0 | 932,222,684 | 100% | ||
| tomsmaid | 0 | 66,259,497,030 | 50% | ||
| helpiecake | 0 | 41,677,256,539 | 100% | ||
| permaculturedude | 0 | 731,476,828 | 2% | ||
| princessamber | 0 | 1,130,153,778 | 50% | ||
| helpie-caster | 0 | 33,003,188,619 | 62% | ||
| ghostdylan | 0 | 1,134,705,060 | 50% | ||
| goodcontentbot | 0 | 806,699,182 | 15% | ||
| dopal | 0 | 1,744,275,881 | 100% | ||
| kryptogames | 0 | 4,665,023,838 | 1% | ||
| mfblack | 0 | 1,882,625,374 | 1.9% | ||
| bigmoneyman | 0 | 905,753,939 | 50% | ||
| dtrade | 0 | 563,633,425 | 20% | ||
| scholaris | 0 | 113,389,562,720 | 40% | ||
| threejay | 0 | 903,067,471 | 1% | ||
| likwid | 0 | 126,442,447,434 | 17.5% | ||
| iamjohn | 0 | 608,437,488 | 10% | ||
| suigener1s | 0 | 556,027,010 | 100% | ||
| vxc | 0 | 126,941,500 | 5.5% | ||
| milu-the-dog | 0 | 804,314,733 | 2% | ||
| yeswecan | 0 | 18,220,207,786 | 90% | ||
| lrekt01 | 0 | 2,945,835,936 | 100% | ||
| triplea.bot | 0 | 668,598,505 | 2% | ||
| steem.leo | 0 | 19,865,273,460 | 2% | ||
| babytarazkp | 0 | 3,124,175,790 | 50% | ||
| asteroids | 0 | 2,169,702,335 | 1.8% | ||
| prolinuxua | 0 | 7,027,340,744 | 100% | ||
| logiczombie | 0 | 41,404,373,130 | 6.94% | ||
| acta | 0 | 29,641,733,266 | 100% | ||
| the-table | 0 | 22,061,349,312 | 100% | ||
| cardtrader | 0 | 2,431,467,596 | 100% | ||
| maxuvd | 0 | 30,817,649,484 | 7% | ||
| thehouse | 0 | 1,929,981,756 | 90% | ||
| urtrailer | 0 | 1,119,352,754 | 0.25% | ||
| spinvest-leo | 0 | 5,264,811,241 | 5% | ||
| joshmania | 0 | 2,240,933,672 | 2% | ||
| silverquest | 0 | 143,962,793,213 | 90% | ||
| gerbo | 0 | 0 | 2% | ||
| honeychip | 0 | 10,245,508,666 | 85% | ||
| tariqul.bibm | 0 | 4,056,891,195 | 10% | ||
| elsan.artes | 0 | 35,464,867,927 | 100% | ||
| ribary | 0 | 623,630,911 | 1% | ||
| mice-k | 0 | 11,933,426,792 | 2% | ||
| drew0 | 0 | 720,115,386 | 5% | ||
| tommys.shop | 0 | 1,768,992,508 | 90% | ||
| hivewaves | 0 | 571,157,781 | 75% | ||
| hivesql | 0 | 733,350,892 | 100% | ||
| hivebuzz | 0 | 283,816,100,980 | 100% | ||
| hiveyoda | 0 | 150,011,351 | 4% | ||
| timhorton | 0 | 15,217,345,395 | 100% | ||
| dagamers | 0 | 1,619,101,603 | 100% | ||
| dcityrewards | 0 | 56,645,042,939 | 2% | ||
| ciderjunkie | 0 | 12,156,726,405 | 31% | ||
| paulman | 0 | 1,497,259,996 | 75% | ||
| ninnu | 0 | 11,376,536,502 | 2.5% | ||
| localgrower | 0 | 2,171,999,355 | 4% | ||
| hivecur | 0 | 8,228,269,361 | 2% | ||
| patronpass | 0 | 527,644,931 | 19% | ||
| jelly13 | 0 | 247,149,447,231 | 17% | ||
| viviana28 | 0 | 14,769,434,450 | 60% | ||
| hivecur2 | 0 | 31,217,140,819 | 5% | ||
| vokus | 0 | 960,524,530 | 31% | ||
| kraken99 | 0 | 2,841,351,189 | 100% | ||
| leone.bianco | 0 | 39,846,559,480 | 80% | ||
| betterdev | 0 | 57,071,410,643 | 100% |
Nice!
| author | abh12345 |
|---|---|
| permlink | re-arcange-qj8ed7 |
| category | hive-139531 |
| json_metadata | {"tags":["hive-139531"],"app":"peakd/2020.10.9"} |
| created | 2020-11-03 17:39:09 |
| last_update | 2020-11-03 17:39:09 |
| depth | 1 |
| children | 1 |
| last_payout | 2020-11-10 17:39:09 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 5 |
| author_reputation | 1,408,615,966,842,648 |
| root_title | "HiveSQL new feature - Delegation state table available" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,376,858 |
| net_rshares | 53,212,303,529 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 53,212,303,529 | 1% |
Hehe, I knew you would like it 😉<div class="pull-right"><a href="/@hive.engage"></a></div>
| author | arcange |
|---|---|
| permlink | re-re-arcange-qj8ed7 |
| category | hive-139531 |
| json_metadata | {"app":"engage"} |
| created | 2020-11-03 19:48:12 |
| last_update | 2020-11-03 19:48:12 |
| depth | 2 |
| children | 0 |
| last_payout | 2020-11-10 19:48:12 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 126 |
| author_reputation | 1,146,633,668,945,473 |
| root_title | "HiveSQL new feature - Delegation state table available" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,378,288 |
| net_rshares | 0 |
Congratulations @arcange! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) : <table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@arcange/upvoted.png?202011031437"></td><td>You received more than 350000 upvotes. Your next target is to reach 360000 upvotes.</td></tr> </table> <sub>_You can view your badges on [your board](https://hivebuzz.me/@arcange) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> **Do not miss the last post from @hivebuzz:** <table><tr><td><a href="/hivebuzz/@hivebuzz/pud-202011-feedback"><img src="https://images.hive.blog/64x128/https://i.imgur.com/lZQYVmN.png"></a></td><td><a href="/hivebuzz/@hivebuzz/pud-202011-feedback">Feedback from the November 1st Hive Power Up Day</a></td></tr></table>
| author | hivebuzz |
|---|---|
| permlink | hivebuzz-notify-arcange-20201103t145135000z |
| category | hive-139531 |
| json_metadata | {"image":["http://hivebuzz.me/notify.t6.png"]} |
| created | 2020-11-03 14:51:33 |
| last_update | 2020-11-03 14:51:33 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-11-10 14:51:33 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.016 HBD |
| curator_payout_value | 0.016 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 948 |
| author_reputation | 369,406,463,435,726 |
| root_title | "HiveSQL new feature - Delegation state table available" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,374,959 |
| net_rshares | 259,520,683,486 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 259,520,683,486 | 5% |
<center></center><center>Bang, I did it again... I just rehived your post!</center><center>Week 30 of my [contest](/hive-179017/@pixresteemer/the-re-hive-contest-results-week-29-and-start-week-30) just started...you can now check the winners of the previous week!</center><center><sub>9</sub></center>
| author | pixresteemer |
|---|---|
| permlink | 20201103t144842011z |
| category | hive-139531 |
| json_metadata | {"tags":["pixresteemer"],"app":"pixresteemer"} |
| created | 2020-11-03 14:48:42 |
| last_update | 2020-11-03 14:48:42 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-11-10 14:48:42 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 442 |
| author_reputation | 121,314,585,119,707 |
| root_title | "HiveSQL new feature - Delegation state table available" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,374,926 |
| net_rshares | 0 |
Beautiful! This should simplify things a bit.
| author | vimm |
|---|---|
| permlink | re-arcange-qj88eg |
| category | hive-139531 |
| json_metadata | {"tags":["hive-139531"],"app":"peakd/2020.10.9"} |
| created | 2020-11-03 15:30:15 |
| last_update | 2020-11-03 15:30:15 |
| depth | 1 |
| children | 1 |
| last_payout | 2020-11-10 15:30:15 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 45 |
| author_reputation | 142,339,878,687,537 |
| root_title | "HiveSQL new feature - Delegation state table available" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,375,407 |
| net_rshares | 0 |
That's the goal 😉<div class="pull-right"><a href="/@hive.engage"></a></div>
| author | arcange |
|---|---|
| permlink | re-re-arcange-qj88eg |
| category | hive-139531 |
| json_metadata | {"app":"engage"} |
| created | 2020-11-03 16:25:00 |
| last_update | 2020-11-03 16:25:00 |
| depth | 2 |
| children | 0 |
| last_payout | 2020-11-10 16:25:00 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 111 |
| author_reputation | 1,146,633,668,945,473 |
| root_title | "HiveSQL new feature - Delegation state table available" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,376,052 |
| net_rshares | 0 |
hiveblocks