Viewing a response to: @steemreports/re-furion-upcoming-hive-db-20170918t124648155z
Yeah, it certainly will, and it already does. Several apps already use SteemData rather than steemd directly, which is much faster for many use cases and allows for powerful queries.
| post_id | 13,142,013 |
|---|---|
| author | furion |
| permlink | re-steemreports-re-furion-upcoming-hive-db-20170918t140353412z |
| category | steem |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steem"]}" |
| created | 2017-09-18 14:03:54 |
| last_update | 2017-09-18 14:04:06 |
| depth | 2 |
| children | 2 |
| net_rshares | 16,940,847,043 |
| last_payout | 2017-09-25 14:03:54 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.032 SBD |
| curator_payout_value | 0.010 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 182 |
| author_reputation | 116,591,440,117,983 |
| 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 |
|---|---|---|---|---|---|
| steemreports | 0 | 16,940,847,043 | 100% |
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% |
From what I can see it has currently just got 56% of the blocks. Will it take more than a week to be up to date? Is this because getting old blocks over RPC is really slow, and it will speed up as the blocks get more recent? I presume hive_posts_cache starts filling only once we're in the last 7 days of blocks?
| post_id | 13,384,198 |
|---|---|
| author | steemreports |
| permlink | re-furion-re-steemreports-re-furion-upcoming-hive-db-20170921t091649070z |
| category | steem |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steem"]}" |
| created | 2017-09-21 09:16:48 |
| last_update | 2017-09-21 09:16:48 |
| depth | 3 |
| children | 0 |
| net_rshares | 0 |
| last_payout | 2017-09-28 09:16:48 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 SBD |
| curator_payout_value | 0.000 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 312 |
| 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 |