RE: Introducing steemR by eroche

utopian-io · @eroche · Jun 1 '18

It depends on what data you want.

@arcange runs a service called steemsql. This is a fantastic service that packages the blockchain data in an sql database so you can easily query it. 


steemR will let you access aspects of the Steem blockchain data but will not be as comprehensive as steemsql. It also does not provide an SQL connector so you will need to use R to access it.

properties (22)

`post_id`	51,249,736
`author`	eroche
`permlink`	re-ghulammujtaba-re-eroche-introducing-steemr-20180601t153138515z
`category`	utopian-io
`json_metadata`	"{"tags": ["utopian-io"], "app": "steemit/0.1", "users": ["arcange"]}"
`created`	2018-06-01 15:31:39
`last_update`	2018-06-01 15:31:39
`depth`	2
`children`	1
`net_rshares`	0
`last_payout`	2018-06-08 15:31:39
`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`	379
`author_reputation`	59,490,065,137,068
`root_title`	"Introducing steemR"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

`post_id`	51,250,065
`author`	ghulammujtaba
`permlink`	re-eroche-re-ghulammujtaba-re-eroche-introducing-steemr-20180601t153401495z
`category`	utopian-io
`json_metadata`	"{"tags": ["utopian-io"], "app": "steemit/0.1", "users": ["eroche"]}"
`created`	2018-06-01 15:34:00
`last_update`	2018-06-01 15:34:00
`depth`	3
`children`	0
`net_rshares`	37,273,540,916
`last_payout`	2018-06-08 15:34:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.126 SBD
`curator_payout_value`	0.011 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	22
`author_reputation`	7,585,775,750,291
`root_title`	"Introducing steemR"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""