SteemIt Bot Update: Showing Your Payout in Last 7 Days
Motivation How many of you sometimes want to know how much you have been paid by writing good contents? Especially for those regular writers or even full time steemians, …
Category: sql
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 …
SteemSQL Tutorial – I have spent 800 SBD (7000+ USD) buying votes!
I spent around 800 SBD (7000 USD) in buying votes. The following queries the table TxTransfers thanks to @arcange’s STEEMSQL. select "from", "to", "memo", (amount) from TxTransfers (NOLOCK) where …
SteemSQL Tutorial: How to Avoid SQL Injection?
My SteemSQL scripts suddenly stopped working a few hours ago and I thought at first it was the connectivity issues until I found out the same queries run just …
SteemSQL Tutorial: How to Get the Most Payout Authors in History?
@nationalpark has published quite a few posts on the most payout authors in history, and here is how it was done in SteemSQL just in case you want to …