How to Check If SteemSQL is Synchronized with Steem Blockchain?

SteemSQL is a great service (MSSQL) developed and maintained by @arcange despite the fact that it moved to a monthly subscription model.

The most important thing for a BlockChain Centralized Data Service is the on-time synchronization. If data cannot be synchronized quickly, the data service is not useful at all. Currently, SteemSQL synchronizes the data from blockchain every few minutes e.g. 8 minute if I recall correctly.

Still, there were a few times that SteemSQL is out of sync. If your application relies heavily on the data completeness, SteemSQL may not be a good choice. However, if your just need to run a few queries to do some analysis on the past data, SteemSQL is perfect as it is always faster to fetch data from the centralized database than in the blockchain.

I have made an easy-to-use API that returns the latest synchronized block number from SteemSQL so that you know how much the SteemSQL is behind the Steem Blockchain.

Where to know the lastest block number?
You can go to steemdb.com and it should show you quite straightforward on the page:

steemdb

API to return the SteemSQL latest block number
API Endpoint: /api/steemit/blocknumber/steemsql/
API Parameters: None

API Servers of SteemSQL Block Number

https://helloacm.com (New York, USA)
https://steakovercooked.com (Fremont, USA)
https://uploadbeta.com (London, UK)
https://happyukgo.com (Tokyo, Japan)

For example, typing https://helloacm.com/api/steemit/blocknumber/steemsql/ in the browser should give you JSON data:

{"timestamp": "2018-01-31 17:05:45 (UTC)", "block_num": 19465269}

You are given the time stamp so that you know how much SteemSQL is behind!

You may also like: 怎么样查看 STEEMSQL 是否数据同步完全？

STEEM SQL Tutorial

• SteemSQL Tutorial: How to Get Random Posts on SteemIt?
• SteemSQL Tutorial: How to Get Authors Order By Potential Payout in Last 7 days?
• SteemSQL Tutorial: How to Get Historic Posts of Today on SteemIt?
• SteemSQL Tutorial: How to Calculate Monthly Income on STEEMIT?
• SteemSQL Tutorial: Can we Really Recover Deleted Comments/Posts on STEEMIT?
• SteemSQL Tutorial: What are the Outgoing Votes for Big Whales?
• SteemSQL Tutorial: Count Total Interests Sent
• SteemSQL Tutorial: Finding Inactive Steemians that You Follow
• SteemSQL Tutorial: How to Fix “JSON text is not properly formated. Unexpected character ‘.’ is found at position 0.”?
• SteemSQL Tutorial: How to Get the Most Payout Authors in History?
• SteemSQL Tutorial: Get Most Single Payout Authors
• SteemSQL Tutorial: How to Avoid SQL Injection?
• SteemSQL Tutorial: I have spent 800 SBD (7000+ USD) buying votes!
• SteemSQL Tutorial: How to Check If SteemSQL is Synchronized with Steem Blockchain?

–EOF (The Ultimate Computing & Technology Blog) —