I will never get bored talking about curation on Hive. I think this blockchain is unique where you can earn some Hive not only by blogging but also by curating content (and many other ways to earn such as gaming, but I’m not an avid gamer so I don't know much about it).
To me, the idea of curation rewards is brilliant. Not everybody has the talent to blog quality content consistently. But since we have come to Hive, I bet all of us have the skill of consuming content. Whether it's long or short content, quality posts should be easy to spot.
I know some curators would prefer longer forms of content, with some original images. Please take a good look at the word “original.” We potentially earn rewards by posting on Hive, so posting original content should be common sense here. As for me, I don't have any particular preferences on the post length. I love to curate some cool video content. And some of the best video content won't need long text. The same goes for photography.
Some other curators may disagree. And they could just downvote a post if they feel the post is over-rewarded. It is up to them, really. They have staked some Hive Power, and they have every right to do so. It is what it is.
When I'm talking about curators here, I mean every user on Hive. Not only those who dedicate their time to curation guilds like curie, ocd, curangel, Ecency, Inleo, and so on. The fact that we can upvote a post means that we are all, in fact, curators on Hive.
Now the problem with curation on Hive really comes to how the content is displayed on Hive and its frontends. In general, if we're looking for under-rewarded content, it could be a hassle. Many of the frontends rely on the trending, hot, and recent algorithms. For trending and hot content, usually, they already got some good rewards. So our best bet to find under-rewarded content is by browsing recent content.
Why does undervalued content need to be found?
For me, it is quite simple. Those handsome rewards could encourage them to keep posting on Hive, and perhaps, they could start to spark good engagement too.
But browsing recent content could be a daunting task. You could find too many posts that might not suit your preference.
That is where my Hive Search Tool comes in handy. With this tool, you can search for Hive content, and the results will be in chronological order, sorted by the created date, descending.
I already wrote about this tool on my previous post . Long story short, I made a search tool for Hive contents, using sveltekit and hivesql. To use this tool, you need to have nodejs installed on your machine, and you need to have hivesql subscription too.
This is the looks of the web tool. By default, you will have the parameter “show only posts in payout windows” checked. My intention is for users to find good content that is still in their payout windows (a.k.a 7 days).
But the problem is, sometimes searching 7 days content without filtering any parameters could make the query so heavy and we will very likely got an timeout error. So, for now, i limit this parameter to 2 days only.
I put some optional parameters on this tool:
- Min rewards
- Max rewards
- Include tags
- Exclude tags
- Include authors
- Exclude authors
- Exclude title (comma separated)
- Search term
- Exclude apps
- Min body length (in characters, not words)
I think all those fields are self-explanatory. Except for body length, I use characters instead of word count since I use HiveSQL, and I don't know how to do the query to search body length in word count. Also, because body content might contain some HTML and markdown tags. I just don't know how to do such a query in SQL 😅
But on the frontend, I already put the results by word count. So you could easily see the word counts. I also added some image count detection.
Let's say you will be searching for photography content, the search results in this tool will give you a rough idea of how many words and how many images are in the post.
Here is an example of how to use this tool to find content:
I remember quite sometimes ago abh12345 made a useful post on how to do hivesql query to search for content. So, in this tool, i will do the same, putting 'abh12345' in included author fields, put the tag 'hivesql' in included tag field, and put 'hivesql' as search term.
and Voila, here is the result:
I added exclude apps as a parameter because I know some curators would prefer some kind of post format, and some apps’ characteristics just won't fit their preferences.
Back in 2018, the @curie team had a tool to search some content. It was more powerful than what I made here. But to me, some of the features were just not suitable for my curation preferences, so I just made myself a simpler one that suits my needs.
I will put the GitHub repo link at the end of this post so you can clone it and use it on your local machine. You will need Node.js installed on your machine, and also, you should have a HiveSQL subscription to use this search tool.
Using and testing this tool myself, with some of my favorite parameters, I already found some cool posts to curate. Some of them I curate for curie, others I couldn't, because I can just curate specific topics/communities for curie.
That is why I think I need to step up my curation game. I know for sure that I'm not a good blogger or good content creator. But I should earn good rewards with my curation. For that, I will need to power up consistently.
Wish me luck, I guess 😃
Thank you for reading!
For cloning this repo, please visit the GitHub link: https://github.com/gibic/hivelookup
For HiveSQL subscription, you can read the detailed instructions here: https://docs.hivesql.io/register-your-hivesql-acount
Have fun curating and finding those undervalued contents!