Does anyone provide a public facing SQL database of the steemit blockchain by woz.software

steemdev · @woz.software · Jul 26 '17

$3.18

Does anyone provide a public facing SQL database of the steemit blockchain

![](http://i.imgur.com/nLeqZYj.jpg)

I am interested in running some analytics on steemit and wondered if anyone maintains its blockchain in an SQL DB? Far easier to query that way :)

Thanks

Woz

👍 julianita, steewrit, qed, woz.software, weg
👎 transisto

`post_id`	8,331,749
`author`	woz.software
`permlink`	does-anyone-provide-a-public-facing-sql-database-of-the-steemit-blockchain
`category`	steemdev
`json_metadata`	"{"app": "steemit/0.1", "format": "markdown", "image": ["http://i.imgur.com/nLeqZYj.jpg"], "tags": ["steemdev"]}"
`created`	2017-07-26 09:07:30
`last_update`	2017-07-26 09:07:30
`depth`	0
`children`	4
`net_rshares`	875,124,692,506
`last_payout`	2017-08-02 09:07:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	2.428 SBD
`curator_payout_value`	0.755 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	196
`author_reputation`	2,320,360,990,397
`root_title`	"Does anyone provide a public facing SQL database of the steemit blockchain"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (6)

voter	rshares	pct
transisto	-249,078,420,357	-2%
julianita	1,116,834,299,758	28%
steewrit	3,094,827,495	100%
qed	2,488,255,431	100%
woz.software	1,042,908,034	100%
weg	742,822,145	100%

@sarasate · Jul 26 '17

$1.01

[SteemSQL](http://www.steemsql.com) by @arcange

👍 transisto, steewrit, woz.software

properties (23)vote details (3)

voter	rshares	pct
transisto	311,348,025,446	3%
steewrit	3,029,328,500	100%
woz.software	2,968,985,333	100%

@woz.software · Jul 27 '17

Cool, thanks. Exactly what I was looking for. Big thanks to @arcange by the looks of it

properties (22)

`post_id`	8,428,645
`author`	woz.software
`permlink`	re-sarasate-re-wozsoftware-does-anyone-provide-a-public-facing-sql-database-of-the-steemit-blockchain-2017726t2100287z-20170727t071104515z
`category`	steemdev
`json_metadata`	"{"app": "steemit/0.1", "users": ["arcange"], "tags": ["steemdev"]}"
`created`	2017-07-27 07:11:06
`last_update`	2017-07-27 07:11:06
`depth`	2
`children`	2
`net_rshares`	0
`last_payout`	2017-08-03 07:11:06
`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`	87
`author_reputation`	2,320,360,990,397
`root_title`	"Does anyone provide a public facing SQL database of the steemit blockchain"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@transisto · Jul 30 '17 (edited)

you should have upped the answer.

👍 woz.software, randomwhale

`post_id`	8,710,602
`author`	transisto
`permlink`	re-wozsoftware-re-sarasate-re-wozsoftware-does-anyone-provide-a-public-facing-sql-database-of-the-steemit-blockchain-2017726t2100287z-20170730t091945292z
`category`	steemdev
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemdev"]}"
`created`	2017-07-30 09:19:45
`last_update`	2017-07-30 09:19:51
`depth`	3
`children`	1
`net_rshares`	3,828,247,863
`last_payout`	2017-08-06 09:19:45
`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`	33
`author_reputation`	331,131,121,482,590
`root_title`	"Does anyone provide a public facing SQL database of the steemit blockchain"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
randomwhale	0 B		903,797,310	100%
woz.software	0 B		2,924,450,553	100%

1 reply