Viewing a response to: @furion/re-steemreports-re-furion-upcoming-hive-db-20170918t140353412z
I've just investigated the schema and installed mysqlclient for Python. I'm currently maintaining a sqlite db for our stuff, but you're already doing the consolidation so edits etc. are merged into hive_posts_cache (if I'm not mistaken?), which I'm not so sure how to do easily. I look forward to investigating further once it has synced! Thanks very much for this work.
post_id | 13,142,969 |
---|---|
author | steemreports |
permlink | re-furion-re-steemreports-re-furion-upcoming-hive-db-20170918t141613474z |
category | steem |
json_metadata | "{"app": "steemit/0.1", "tags": ["steem"]}" |
created | 2017-09-18 14:16:12 |
last_update | 2017-09-18 14:16:12 |
depth | 3 |
children | 0 |
net_rshares | 744,302,662,715 |
last_payout | 2017-09-25 14:16:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 1.423 SBD |
curator_payout_value | 0.472 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 370 |
author_reputation | 26,984,297,179,214 |
root_title | "Upcoming: Hive DB" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
furion | 0 | 744,031,533,023 | 100% | ||
rsrb | 0 | 271,129,692 | 100% |