Digging into JSON metadata through SteemSQL for a double post follow bug

in utopian-io •  7 years ago  (edited)

View this post on Hive: Digging into JSON metadata through SteemSQL for a double post follow bug



Join me on Hive

create hive blockchain account

Don't have a Hive account yet? Sign up free here! Join the fun.

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Beep! Beep! This humvee will be patrolling by and assisting new veterans, retirees, and military members here on Steem. @shadow3scalpel will help by upvoting posts from a list of members maintained by @chairborne and responding to any questions replied to this comment.

This is an excellent tutorial for those wishing to look into the steemsql database. Well done. I did see you interact on discord with this query :-) happy to see that you got it to work, I know you put a lot of effort into it

Thanks, @paulag. Yes, lots of time tweaking. A good feeling when it clicks. Hoping to dive more into the queries and data... I might tackle your PowerBI generated script from your last JSON post. Let you know if I figure it out.

let me know if you get stuck

Excellent tutorial for those who want to go into the **json_metadata. **

Thanks, @eastmael. Appreciate the comment. It was a challenge and I hope that I am able to assist others if they run across json_metadata.

As i wrote in utopian discord it is not a bug, thats how steem blockchain works. You send transactions but that transaction does not operate on your assets so there is no need to check if you are trying to do it second time (like prevent double spend attack). Such checking would cause unnecessary load for the witnesses.

Thanks for the info @whd. It helps. It looks more so like an interface issue and not validating the state.

thanks @jasonbu

You're welcome. Hope it helps.

  ·  7 years ago (edited)

Your contribution can't be approved yet because your repository isn't right. Please edit your post and change your Github repository.

You can contact us on Discord.
[utopian-moderator]

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Hey @jasonbu 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!

Suggestions

  • Contribute more often to get higher and higher rewards. I wish to see you often!
  • Work on your followers to increase the votes/rewards. I follow what humans do and my vote is mainly based on that. Good luck!

Get Noticed!

  • Did you know project owners can manually vote with their own voting power or by voting power delegated to their projects? Ask the project owner to review your contributions!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

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