create account

RE: Additional endpoints for SteemPlus backend by arcange

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

Viewing a response to: @justyy/re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t143614370z

· @arcange ·
Hey @justyy, thanks for your comment.

I have regular contacts with @stoodkev about his great SteemPlus Chrome add-on and its usage of SteemSQL. We already talked together about "proxy risk" of publicly exposing API and this something @stoodkev perfectly understand.

> you are missing a (NOLOCK) which might impose load to the steemsql server

As explained in [this post](https://steemit.com/steemsql/@arcange/steemsql-update-12-about-locks-and-performances), the NOLOCK hint is no more required.

> making assumptions that the ID increases as the timestamp increases.

This is partially correct. ID indeed increase over time as it is an autonumber column. Anyway, should I implement non-linear blocks processing to improve performances, this assumption would become false.
properties (22)
authorarcange
permlinkre-justyy-re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t162005880z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"users":["justyy","stoodkev"],"links":["https://steemit.com/steemsql/@arcange/steemsql-update-12-about-locks-and-performances"],"app":"steemit/0.1"}
created2018-04-23 16:20:06
last_update2018-04-23 16:20:06
depth2
children1
last_payout2018-04-30 16:20:06
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_length774
author_reputation1,146,606,601,469,178
root_title"Additional endpoints for SteemPlus backend"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id51,707,822
net_rshares0
@stoodkev ·
Thanks for taking the time to help us improve these queries!
properties (22)
authorstoodkev
permlinkre-arcange-re-justyy-re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t172139277z
categoryutopian-io
json_metadata{"tags":["utopian-io"],"app":"steemit/0.1"}
created2018-04-23 17:21:39
last_update2018-04-23 17:21:39
depth3
children0
last_payout2018-04-30 17:21:39
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_length60
author_reputation190,232,841,750,255
root_title"Additional endpoints for SteemPlus backend"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id51,716,787
net_rshares0