__________     __ __     __  _______    ________
  / ____/ __ \   / // /    / / / /  _/ |  / / ____/
 / / __/ / / /  / // /_   / /_/ // / | | / / __/
/ /_/ / /_/ /  /__  __/  / __  // /  | |/ / /___
\____/\____/     /_/    /_/ /_/___/  |___/_____/

 --- A GOPHER-LIKE INTERFACE FOR HIVE BLOCKCHAIN ---

Automating Upvotes using HiveVote and The Idea of Self Vote

BY: @maakue | CREATED: June 7, 2022, 12:09 p.m. | VOTES: 16 | PAYOUT: $2.44 | [ VOTE ]

HiveVote

Found out about HiveVote from this Rising Star post. How this works is you follow a curator using the curator trail menu and you automatically upvote the post they just upvoted. It is like a copy service for upvotes. You just need to set the parameter and let it do the rest. The link from above has some nice explanation about the settings. Please also make sure the curator you're following does not upvote low quality posts.

This can also work for someone you follow, upvote their post as soon at it is published. I like this service compared to delegation as the Hive Power is still on your account so replenishment of resource credit is never an issue for me. HiveVote have other things it can do but I think these two are the most useful. Thank you @mahdiyari, you made my life easier.

Self Vote

While looking through HiveVote's dashboard, I noticed the SelfVote option and it is set to true as default. I am not familiar if this is an oversight or what since there are a few unwritten rules on Hive. Found this post by @bozz where he asks for the unwritten rules and collated it. From this, it looks like self voting is an accepted practice as long as you don't upvote your own comment.

Self Vote Statistics

My curiousity piqued, I used HiveSQL to find out how many authors upvoted their own post.

Below is the number of authors who self voted their own post at least once. Based on this, it looks like less and less author are self voting their own post.

No of Authors Year 11,676 2022 18,915 2021 22,207 2020 59,229 2019 259,513 2018

[IMAGE: https://images.ecency.com/DQmRbCyFKdC7niUTdXU8d9uuuGPCG3KFw92W376w9bcxtVr/image.png]

How about you? What's your take on self voting on own post? Let me know in the comments.

Thank you for reading.

Image screenshot from MS SQL SMS.

TAGS: [ #Ecency ] [ #leofinance ] [ #hive-engine ] [ #cent ] [ #gems ]

Replies

@gangstalking | June 7, 2022, 12:09 p.m. | Votes: 1 | [ VOTE ]

They literally have attempeted my murder and are trying to kill me with V2K and RNM. Five years this has been happening to me, it started here, around people that are still here. Homeland security has done nothing at all, they are not here to protect us. Dont we pay them to stop shit like this? The NSA, CIA, FBI, Police and our Government has done nothing. Just like they did with the Havana Syndrome, nothing. Patriot Act my ass. The American government is completely incompetent. The NSA should be taken over by the military and contained Immediately for investigation. I bet we can get to the sources of V2K and RNM then. https://ecency.com/fyrstikken/@fairandbalanced/i-am-the-only-motherfucker-on-the-internet-pointing-to-a-direct-source-for-voice-to-skull-electronic-terrorism ..... https://ecency.com/gangstalking/@acousticpulses/electronic-terrorism-and-gaslighting--if-you-downvote-this-post-you-are-part-of-the-problem

@hivebuzz | June 7, 2022, 12:37 p.m. | Votes: 1 | [ VOTE ]

Congratulations @maakue! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s):

You got more than 700 replies.Your next target is to reach 800 replies.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Check out the last post from @hivebuzz:

Our Hive Power Delegations to the May Power Up Month WinnersHive Power Up Month Challenge 2022-05 - Winners ListFeedback from the June 1st Hive Power Up Day

@ecency | June 7, 2022, 5:20 p.m. | Votes: 0 | [ VOTE ]

Yay! 🤗Your content has been boosted with Ecency Points, by @maakue. Use Ecency daily to boost your growth on platform! Support EcencyVote for new ProposalDelegate HP and earn more

@arcange | June 9, 2022, 8:24 a.m. | Votes: 0 | [ VOTE ]

FYI, the NOLOCK hint is no more required on HiveSQL queries ;)

The TxVotes table is quite big.
For better performances and to lower load on the server , it's better to use a time range in your WHERE clause (ex: timestamp >= '2018-01-01' AND timestamp < '2019-01-01') instead of YEAR(timestamp) = 2018.
This will allow the server to use the timestamp index and avoid it to execute the YEAR() function on every row.

Finally, you may take into account the weight of the vote. If it is negative, it's a downvote, not a self-[up]vote.
That being said, I doubt anyone has ever downvoted themselves 😂[IMAGE: https://i.imgur.com/XsrNmcl.png]

@maakue | June 9, 2022, 10:35 a.m. | Votes: 0 | [ VOTE ]

Thanks for the tips.

@arcange | June 9, 2022, 8:23 p.m. | Votes: 0 | [ VOTE ]

You're welcome.

BTW, as you use it, may I ask you to support the HiveSQL proposal? That would be much appreciated.
You can do it on Peakd, ecency, Hive.blog or using HiveSigner

Thank you![IMAGE: https://i.imgur.com/XsrNmcl.png]

@maakue | June 9, 2022, 9:43 p.m. | Votes: 0 | [ VOTE ]

Done. Sorry I missed that.

@arcange | June 10, 2022, 5:37 a.m. | Votes: 0 | [ VOTE ]

Thank you for your support, really appreciate it! 👍[IMAGE: https://i.imgur.com/XsrNmcl.png]

[ BACK TO TRENDING ] [ BACK TO MENU ]
CMD>