RE: [STEEMSQL] A public SQL database with all blockchain data – UPDATE 1 by faddat

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

Viewing a response to: @arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-1

steemit · @faddat · Sep 21 '16

Do you sync at every block?  If not, Happy to help you adapt STEEMJSON to do this for you :).  I'm interested in using your DB for many things but I'd like to know how much abuse is too much abuse for the machines you have it hosted on?

👍 ausbitbank

`author`	faddat
`permlink`	re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160921t203854705z
`category`	steemit
`json_metadata`	{"tags":["steemit"]}
`created`	2016-09-21 20:38:54
`last_update`	2016-09-21 20:38:54
`depth`	1
`children`	3
`last_payout`	2016-10-23 12:04:33
`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`	236
`author_reputation`	36,581,868,473,026
`root_title`	"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	1,320,691
`net_rshares`	17,621,506,996
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
ausbitbank	0 B		17,621,506,996	100%

@arcange · Sep 22 '16

Every block and every transaction are synced every 10 seconds.
You can freely use the DB for any development you have. I made it public and it has been designed to support heavy load. Infrastructure may be even scaled up  if required. Go on ;)

properties (22)

`author`	arcange
`permlink`	re-faddat-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160922t071039606z
`category`	steemit
`json_metadata`	{"tags":["steemit"]}
`created`	2016-09-22 07:10:39
`last_update`	2016-09-22 07:10:39
`depth`	2
`children`	2
`last_payout`	2016-10-23 12:04:33
`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`	243
`author_reputation`	1,146,606,926,313,931
`root_title`	"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	1,324,933
`net_rshares`	0

@faddat · Sep 24 '16

I absolutely would, if the source code was released.  Without the source in the public domain you could (die, disappear, become disinterested, etc) and the services relying on this would *poof.*

If the source code were public, I'd use your server in a heartbeat.  till them I'll have to continue to schlep through this problem my own way :(.

properties (22)

`author`	faddat
`permlink`	re-arcange-re-faddat-re-arcange-steemsql-a-public-sql-database-with-all-blockchain-data-update-1-20160924t203635524z
`category`	steemit
`json_metadata`	{"tags":["steemit"]}
`created`	2016-09-24 20:36:36
`last_update`	2016-09-24 20:36:36
`depth`	3
`children`	1
`last_payout`	2016-10-23 12:04:33
`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`	342
`author_reputation`	36,581,868,473,026
`root_title`	"[STEEMSQL] A public SQL database with all blockchain data – UPDATE 1"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	1,349,904
`net_rshares`	0

@arcange · Sep 25 '16

I can't opensource steemsql right now because I used some non-opensource libs.
I'm working on replacing them. As soon it's done, I will make code public.

properties (22)