create account

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

View this thread on: hive.blogpeakd.comecency.com

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

· @anduweb ·
That's nice of you to make this available. hopefully you won't get flooded with requests that the resources requirements will require too much of an overhead :)
👍  
properties (23)
authoranduweb
permlinkre-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t115214108z
categorysteemit
json_metadata{"tags":["steemit"]}
created2016-09-13 11:52:15
last_update2016-09-13 11:52:15
depth1
children1
last_payout2016-10-15 13:25:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length160
author_reputation11,311,191,021,706
root_title"[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,230,790
net_rshares2,767,082,391
author_curate_reward""
vote details (1)
@arcange ·
That could be, as for every service made public. But worth to experiment as it will be a good test for the infrastructure. This one is scaled for a *normal* usage.
The risk is indeed have bad response time if the load is to heavy.  Then people writing poor queries might go away as they won't get correct response time.
Anyway, I will do my best to educate users on how to perform efficient queries.
Future will tell.
👍  
properties (23)
authorarcange
permlinkre-anduweb-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160913t115835527z
categorysteemit
json_metadata{"tags":["steemit"]}
created2016-09-13 11:58:36
last_update2016-09-13 11:58:36
depth2
children0
last_payout2016-10-15 13:25:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length417
author_reputation1,146,608,602,483,196
root_title"[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id1,230,852
net_rshares0
author_curate_reward""
vote details (1)