The last few days [SteemSQL Wrapper](https://sql.steemhelpers.com) had some problems with displaying the delay — it just did not load and SteemSQL Wrapper always displays `Delay: loading...`, if you did use API then you were getting `504 Gateway Time-out`. It was caused because of steemd.steemit.com [was deprecated](https://steemit.com/steemitdev/@steemitdev/last-chance-to-update-steemd-steemit-com-will-be-retired-on-january-6) on 6th of January. I used steem-python to get the last block from the blockchain but it uses steemd as a default node. This problem can be easily solved by setting [a custom node](https://www.steem.center/index.php?title=Public_Websocket_Servers). But while I did search a reason for the problem, I decided full remove steem-python from the project. ![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1515507776/ndevf350elk7fbp71rsx.png) In fact, it was a bad solution — checking the time of the last block in SteemSQL and comparing it with current time is enough because Steem gets a new block every 3 seconds. A quotation from the White Paper: > Because the active witnesses are known in advance, Steem is able to schedule witnesses to produce blocks every 3 seconds. So now this part of the project is optimized and now you can get the delay info faster. [Commit](https://github.com/sihaelov/steemsql-wrapper/commit/cdd4bb409b782cc40e236c35f614fcafb6f40cd6) ![image](https://steemit-production-imageproxy-thumbnail.s3.amazonaws.com/U5dtgf6jjoQQJeK4B9jSWsNxkYFrzQo_1680x8400) <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@emptyname/steemsql-wrapper-fixed-and-optimized-the-delay-info">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>
post_id | 24,588,997 | ||||||
---|---|---|---|---|---|---|---|
author | emptyname | ||||||
permlink | steemsql-wrapper-fixed-and-optimized-the-delay-info | ||||||
category | utopian-io | ||||||
json_metadata | "{"repository": {"owner": {"login": "sihaelov"}, "id": 114453017, "full_name": "sihaelov/steemsql-wrapper", "fork": false, "name": "steemsql-wrapper", "html_url": "https://github.com/sihaelov/steemsql-wrapper"}, "moderator": {"flagged": false, "account": "vladimir-simovic", "reviewed": true, "pending": false}, "format": "markdown", "platform": "github", "tags": ["utopian-io", "steemit", "steem", "stats", "steemdev"], "community": "utopian", "type": "development", "pullRequests": [], "links": ["https://sql.steemhelpers.com", "https://steemit.com/steemitdev/@steemitdev/last-chance-to-update-steemd-steemit-com-will-be-retired-on-january-6", "https://www.steem.center/index.php?title=Public_Websocket_Servers", "https://res.cloudinary.com/hpiynhbhq/image/upload/v1515507776/ndevf350elk7fbp71rsx.png", "https://github.com/sihaelov/steemsql-wrapper/commit/cdd4bb409b782cc40e236c35f614fcafb6f40cd6", "https://steemit-production-imageproxy-thumbnail.s3.amazonaws.com/U5dtgf6jjoQQJeK4B9jSWsNxkYFrzQo_1680x8400"], "app": "utopian/1.0.0", "users": ["steemitdev", "emptyname"], "image": ["https://res.cloudinary.com/hpiynhbhq/image/upload/v1515507776/ndevf350elk7fbp71rsx.png"]}" | ||||||
created | 2018-01-09 14:19:42 | ||||||
last_update | 2018-01-11 11:35:45 | ||||||
depth | 0 | ||||||
children | 3 | ||||||
net_rshares | 11,177,461,435,565 | ||||||
last_payout | 2018-01-16 14:19:42 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 69.612 SBD | ||||||
curator_payout_value | 29.521 SBD | ||||||
pending_payout_value | 0.000 SBD | ||||||
promoted | 0.000 SBD | ||||||
body_length | 1,721 | ||||||
author_reputation | 7,007,378,164,906 | ||||||
root_title | "[SteemSQL Wrapper] Fixed and optimized the delay info" | ||||||
beneficiaries |
| ||||||
max_accepted_payout | 1,000,000.000 SBD | ||||||
percent_steem_dollars | 10,000 | ||||||
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
ausbitbank | 0 | 165,294,589,800 | 1% | ||
crimsonclad | 0 | 10,481,590,375 | 5% | ||
basriadi | 0 | 415,813,202 | 100% | ||
thinknzombie | 0 | 2,761,968,853 | 1% | ||
discordiant | 0 | 1,859,109,669 | 5% | ||
nettybot | 0 | 10,636,776,679 | 100% | ||
fabiyamada | 0 | 220,283,091,818 | 100% | ||
matrixonsteem | 0 | 380,323,658 | 100% | ||
steemliberator | 0 | 326,240,713 | 100% | ||
msp3k | 0 | 1,296,824,052 | 100% | ||
witnessstats | 0 | 380,232,733 | 100% | ||
suheri | 0 | 58,480,691 | 1% | ||
r2steem2 | 0 | 382,999,389 | 100% | ||
opaulo | 0 | 9,052,025,436 | 9% | ||
steemcreate | 0 | 397,839,854 | 100% | ||
utopian-io | 0 | 10,747,046,987,932 | 7.1% | ||
thashadowbrokers | 0 | 54,277,103 | 100% | ||
brotato | 0 | 222,055,705 | 100% | ||
pizaz | 0 | 221,881,234 | 100% | ||
triplethreat | 0 | 54,211,495 | 100% | ||
dootdoot | 0 | 50,201,672 | 100% | ||
conflaxus | 0 | 52,970,564 | 100% | ||
tittilatey | 0 | 53,023,447 | 100% | ||
cajun | 0 | 222,039,895 | 100% | ||
coonass | 0 | 221,911,006 | 100% | ||
squirrelnuts | 0 | 221,910,960 | 100% | ||
emptyname | 0 | 3,869,013,313 | 100% | ||
steemdevs | 0 | 221,878,418 | 100% | ||
jeezy | 0 | 54,188,275 | 100% | ||
test.with.dots | 0 | 54,198,345 | 100% | ||
pi-pi | 0 | 54,171,056 | 100% | ||
listentosteem | 0 | 52,937,040 | 100% | ||
gravy | 0 | 52,921,321 | 100% | ||
fonsetucker | 0 | 85,902,362 | 0.1% | ||
blervin | 0 | 586,847,500 | 100% |
Thank you for the contribution. It has been approved. You can contact us on [Discord](https://discord.gg/UCvqCsx). **[[utopian-moderator]](https://utopian.io/moderators)**
post_id | 24,977,622 |
---|---|
author | vladimir-simovic |
permlink | re-emptyname-steemsql-wrapper-fixed-and-optimized-the-delay-info-20180111t095249141z |
category | utopian-io |
json_metadata | "{"app": "utopian/1.0.0", "community": "utopian", "tags": ["utopian-io"]}" |
created | 2018-01-11 09:52:48 |
last_update | 2018-01-11 09:52:48 |
depth | 1 |
children | 1 |
net_rshares | 3,869,013,313 |
last_payout | 2018-01-18 09:52:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.024 SBD |
curator_payout_value | 0.004 SBD |
pending_payout_value | 0.000 SBD |
promoted | 0.000 SBD |
body_length | 172 |
author_reputation | 56,522,611,888,290 |
root_title | "[SteemSQL Wrapper] Fixed and optimized the delay info" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
emptyname | 0 | 3,869,013,313 | 100% |
Thanks!
post_id | 24,994,760 |
---|---|
author | emptyname |
permlink | re-vladimir-simovic-re-emptyname-steemsql-wrapper-fixed-and-optimized-the-delay-info-20180111t114229285z |
category | utopian-io |
json_metadata | "{"app": "steemit/0.1", "tags": ["utopian-io"]}" |
created | 2018-01-11 11:42:30 |
last_update | 2018-01-11 11:42:30 |
depth | 2 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-01-18 11:42:30 |
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 | 7 |
author_reputation | 7,007,378,164,906 |
root_title | "[SteemSQL Wrapper] Fixed and optimized the delay info" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |
### Hey @emptyname I am @utopian-io. I have just upvoted you! #### Achievements - You have less than 500 followers. Just gave you a gift to help you succeed! - Seems like you contribute quite often. AMAZING! #### Community-Driven Witness! I am the first and only Steem Community-Driven Witness. <a href="https://discord.gg/zTrEMqB">Participate on Discord</a>. Lets GROW TOGETHER! - <a href="https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1">Vote for my Witness With SteemConnect</a> - <a href="https://v2.steemconnect.com/sign/account-witness-proxy?proxy=utopian-io&approve=1">Proxy vote to Utopian Witness with SteemConnect</a> - Or vote/proxy on <a href="https://steemit.com/~witnesses">Steemit Witnesses</a> [![mooncryption-utopian-witness-gif](https://steemitimages.com/DQmYPUuQRptAqNBCQRwQjKWAqWU3zJkL3RXVUtEKVury8up/mooncryption-s-utopian-io-witness-gif.gif)](https://steemit.com/~witnesses) **Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x**
post_id | 25,211,901 |
---|---|
author | utopian-io |
permlink | re-emptyname-steemsql-wrapper-fixed-and-optimized-the-delay-info-20180112t113933588z |
category | utopian-io |
json_metadata | "{"app": "utopian/1.0.0", "community": "utopian", "tags": ["utopian-io"]}" |
created | 2018-01-12 11:39:33 |
last_update | 2018-01-12 11:39:33 |
depth | 1 |
children | 0 |
net_rshares | 0 |
last_payout | 2018-01-19 11:39:33 |
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 | 1,085 |
author_reputation | 152,913,012,544,965 |
root_title | "[SteemSQL Wrapper] Fixed and optimized the delay info" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 SBD |
percent_steem_dollars | 10,000 |