Viewing a response to: @arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data
This is good. Although I like something like PhpMyAdmin more. What hardware is your service running on? I'm curious about the scalability.
| author | abit |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t180712899z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 18:07:15 |
| last_update | 2016-09-14 18:10:12 |
| depth | 1 |
| children | 2 |
| 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 | 138 |
| author_reputation | 141,171,499,037,785 |
| 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,245,514 |
| net_rshares | 0 |
The server on a Intel Xeon E5-1650 v2 3.5Ghz 6 cores with 64GB memory, 8TB storage with MegaRAID 9271 Cache 1Go + CacheVault. It can be moved to a VMware HA cluster if required.
| author | arcange |
|---|---|
| permlink | re-abit-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160915t084138837z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-15 08:41:39 |
| last_update | 2016-09-15 08:41:39 |
| depth | 2 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.123 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 177 |
| author_reputation | 1,146,611,356,767,317 |
| 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,251,972 |
| net_rshares | 1,149,874,116,696 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| abit | 0 | 1,149,874,116,696 | 15% | ||
| bangol | 0 | 0 | 100% |
Sounds great.
| author | abit |
|---|---|
| permlink | re-arcange-re-abit-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160916t082154528z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-16 08:21:54 |
| last_update | 2016-09-16 08:21:54 |
| depth | 3 |
| 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 | 13 |
| author_reputation | 141,171,499,037,785 |
| 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,263,496 |
| net_rshares | 0 |
hiveblocks