RE: [STEEMSQL.COM] A public SQL server database with all Steemit blockchain data by l0k1

View this thread on: hive.blog | peakd.com | ecency.com

Viewing a response to: @arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data

steemit · @l0k1 · Sep 14 '16

the differences between the graph database and the monolithinc, intransient relational database takes some compilation of data, and new blocks alter records, in ways that can be difficult to adapt, such as if a poster makes a really big edit, and suddenly the datatype has been overflowed.

But I think this is a cool idea. It might make a model for moving from a memory heavy graphene database to a storage heavy sql, maybe some sort of hybrid to cache data for faster retrieval or so.

👍 kewpiedoll

`author`	l0k1
`permlink`	re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t145620337z
`category`	steemit
`json_metadata`	{"tags":["steemit"]}
`created`	2016-09-14 14:56:21
`last_update`	2016-09-14 14:56:21
`depth`	1
`children`	7
`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`	486
`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,243,842
`net_rshares`	10,219,302,734
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
kewpiedoll	0 B		10,219,302,734	100%

@arcange · Sep 14 '16

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.

👍 khuziyad

`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,615,920,099,066
`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`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
khuziyad	0 B		0	100%

@khuziyad · Jul 29 '17

Seriously, Doesn't this defeat the purpose of decentralization?

properties (22)

`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

@orine · Jan 17 '18

Why  its defeat decentralization?

properties (22)

`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

@steemiest · Feb 9 '18

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.

👍 dzungmrf, pexea12

`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`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
pexea12	0 B		0	100%
dzungmrf	0 B		0	100%

@l0k1 · Sep 14 '16

Ah. So it's just another implementation of the graph database protocol, layered on top of a relational database.

properties (22)

`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

@faddat · Sep 24 '16

This isn't a graph database at all, unless I am somehow mistaken.

properties (22)

`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

1 reply