Viewing a response to: @l0k1/re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t145620337z
SteemSQL database is a **replica** of the whole blockchain, not a compilation! This mean if a user edit a post, you will find 2 or more transactions in TxComments with the same author/permlink but with different bodies/titles. Compilation of data is made at query time.
| author | arcange |
|---|---|
| permlink | re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t151754258z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 15:17:54 |
| last_update | 2016-09-14 15:17:54 |
| depth | 2 |
| children | 6 |
| 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 | 269 |
| 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,244,031 |
| net_rshares | 0 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| khuziyad | 0 | 0 | 100% |
Seriously, Doesn't this defeat the purpose of decentralization?
| author | khuziyad |
|---|---|
| permlink | re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20170729t202522789z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2017-07-29 20:25:24 |
| last_update | 2017-07-29 20:25:24 |
| depth | 3 |
| children | 2 |
| last_payout | 2017-08-05 20:25:24 |
| 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 | 63 |
| author_reputation | 27,573,572,663 |
| 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 | 10,150,596 |
| net_rshares | 0 |
Why its defeat decentralization?
| author | orine |
|---|---|
| permlink | re-khuziyad-re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20180117t075757264z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2018-01-17 07:58:00 |
| last_update | 2018-01-17 07:58:00 |
| depth | 4 |
| children | 0 |
| last_payout | 2018-01-24 07:58:00 |
| 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 | 33 |
| author_reputation | 29,111,480,335 |
| 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 | 30,119,478 |
| net_rshares | 0 |
No. The essence of data analysis is collecting (aggregating ) data and making meaningful insights from it, which requires centralization by rule. The decentralized nature of the data isn't in jeopardy here because there are still unlimited copies of the Steemit blockchain out there ensuring that there is no vulnerable, mutable, single-source of the truth. This particular copy just happens to facilitate reporting.
| author | steemiest |
|---|---|
| permlink | re-khuziyad-re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20180209t015610572z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
| created | 2018-02-09 01:56:09 |
| last_update | 2018-02-09 01:56:09 |
| depth | 4 |
| children | 0 |
| last_payout | 2018-02-16 01:56:09 |
| 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 | 418 |
| author_reputation | 1,904,412,504 |
| 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 | 36,049,662 |
| net_rshares | 0 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| pexea12 | 0 | 0 | 100% | ||
| dzungmrf | 0 | 0 | 100% |
Ah. So it's just another implementation of the graph database protocol, layered on top of a relational database.
| author | l0k1 |
|---|---|
| permlink | re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t152912223z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 15:29:12 |
| last_update | 2016-09-14 15:29:12 |
| depth | 3 |
| 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 | 112 |
| author_reputation | 94,800,257,230,993 |
| 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,244,140 |
| net_rshares | 0 |
This isn't a graph database at all, unless I am somehow mistaken.
| author | faddat |
|---|---|
| permlink | re-l0k1-re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160924t205610928z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-24 20:56:12 |
| last_update | 2016-09-24 20:56:12 |
| depth | 4 |
| 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 | 65 |
| author_reputation | 36,581,868,473,026 |
| 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,350,099 |
| net_rshares | 0 |
No, it however has to implement one to allow the diff-updates that the platform allows, which essentially is a graph database (like CVS or Git). It just gives you the ability to search using SQL queries which are very concise and neat and easy to write, and with that pull all kinds of higher level data out of it. I think that was the purpose of building it - to allow more people to tinker with analytics.
| author | l0k1 |
|---|---|
| permlink | re-faddat-re-l0k1-re-arcange-re-l0k1-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160925t053656597z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-25 05:36:57 |
| last_update | 2016-09-25 05:36:57 |
| depth | 5 |
| 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 | 407 |
| author_reputation | 94,800,257,230,993 |
| 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,353,225 |
| net_rshares | 0 |
hiveblocks