RE: Upcoming: Hive DB by steemreports

View this thread on steempeak.com

Viewing a response to: @furion/re-steemreports-re-furion-upcoming-hive-db-20170918t140353412z

· @steemreports ·
$1.90
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.
👍  ,
properties (23)
post_id13,142,969
authorsteemreports
permlinkre-furion-re-steemreports-re-furion-upcoming-hive-db-20170918t141613474z
categorysteem
json_metadata"{"app": "steemit/0.1", "tags": ["steem"]}"
created2017-09-18 14:16:12
last_update2017-09-18 14:16:12
depth3
children0
net_rshares744,302,662,715
last_payout2017-09-25 14:16:12
cashout_time1969-12-31 23:59:59
total_payout_value1.423 SBD
curator_payout_value0.472 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length370
author_reputation26,984,297,179,214
root_title"Upcoming: Hive DB"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)