RE: Additional endpoints for SteemPlus backend by justyy

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

Viewing a response to: @stoodkev/additional-endpoints-for-steemplus-backend

utopian-io · @justyy · Apr 23 '18

$0.05

Thank you for your contribution. @steemsql  is not free anymore and thus we should be very careful in this as this potentially will make the API server a proxy between users and steemsql.  

However, as I understand this, it is useful to separate logics from the presentation, as you are using the APIs in Chrome extension, thus intelligent users may view-source and get the API directly.

On [here](https://github.com/stoodkev/steemplus-api/blob/master/routes/routes.js), line 86, you are missing a *(NOLOCK)* which might impose load to the steemsql server. And I am not sure this is the 'correct' way to get incoming delegation as you are making assumptions that the ID increases as the timestamp increases. You might want to look at alternative solution such as [here](https://stackoverflow.com/questions/43895890/sql-selecting-the-rows-with-max-timestamp-by-group?rq=1)


----------------------------------------------------------------------
Need help? Write a ticket on https://support.utopian.io.
Chat with us on [Discord](https://discord.gg/uTyJkNm).

**[[utopian-moderator]](https://utopian.io/moderators)**

👍 dailystats, dailychina, superbing, dailyfortune, happyukgo

properties (23)vote details (5)

voter	rshares	pct
happyukgo	344,288,463	20%
superbing	2,064,838,909	20%
dailyfortune	1,372,955,561	20%
dailystats	3,403,242,264	20%
dailychina	2,327,886,932	20%

@arcange · Apr 23 '18

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)

`author`	arcange
`permlink`	re-justyy-re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t162005880z
`category`	utopian-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"}
`created`	2018-04-23 16:20:06
`last_update`	2018-04-23 16:20:06
`depth`	2
`children`	1
`last_payout`	2018-04-30 16:20:06
`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`	774
`author_reputation`	1,146,633,779,972,293
`root_title`	"Additional endpoints for SteemPlus backend"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	51,707,822
`net_rshares`	0

@stoodkev · Apr 23 '18

Thanks for taking the time to help us improve these queries!

properties (22)

`author`	stoodkev
`permlink`	re-arcange-re-justyy-re-stoodkev-additional-endpoints-for-steemplus-backend-20180423t172139277z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-23 17:21:39
`last_update`	2018-04-23 17:21:39
`depth`	3
`children`	0
`last_payout`	2018-04-30 17:21:39
`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`	60
`author_reputation`	190,283,772,273,558
`root_title`	"Additional endpoints for SteemPlus backend"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	51,716,787
`net_rshares`	0