Viewing a response to: @arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data
Thankyou heaps for doing this! I have a heap of ideas for queries but I've been trying to avoid the overhead of running my own full node - this is a far more efficient way to do it :) I'll be following, great work
| author | ausbitbank |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t120702586z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 12:07:03 |
| last_update | 2016-09-13 12:07:03 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 213 |
| author_reputation | 287,009,709,424,827 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,922 |
| net_rshares | 4,947,371,102 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| arcange | 0 | 2,180,288,711 | 100% | ||
| bitcoiner | 0 | 2,767,082,391 | 50% |
That's exactly the purpose of it: having an efficient alternative to local nodes. Thanks!
| author | arcange |
|---|---|
| permlink | re-ausbitbank-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t121534054z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-13 12:15:33 |
| last_update | 2016-09-13 12:15:33 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 89 |
| author_reputation | 1,146,608,602,483,196 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,230,972 |
| net_rshares | 0 |
hiveblocks