There's this awesome tools by @arcange called HiveSQL and if you haven't supported the proposal check out the proposal to keep HIVESQL price "Free" to use ( although you still have to pay 1 HBD) 😂 but it's worth it, I promise. Here's the link to the proposal that you can vote on :
https://peakd.com/hive-139531/@hivesql/poposal-2526
It all started from this one problem...
I don't know what got to me but recently, I got back into a problem that's been on my back burner for a while.
The problem is simple " unfollowing @lovesniper following that has rep equals and to above 60"
In the past, I am unfollowing them manually as soon as I see rep "60" but the thing is, the following list keeps growing and it was to the point that I can't keep up. I am not sure if others who's also in @lovesniper feels the same way. So, I thought about how can I sort them easily?
I tried using HIVESQL with python but somehow, I just couldn't grasp it or maybe I was a noob? So about almost a year has passed today and I finally figured it out.
The thing is, I recently tried MYSQL again and as much as the flow of the query is still the same, HiveSQL works faster with SSMS ( SQL Server Management Studio). So, after configuring my SSMS, today I learned the rope to retrieve data and write some of my first queries.
As much as perhaps python would have done it faster and automate it, this is what I find with SQL.
How did I solve that problem As a noob?
- You just have to connect to the HiveSQL (their documentation is pretty extensive)
- Learn how the database diagram works and that's where you'll most likely refer to
- Read the documentation
- Understand some basics
- Write the queries
SQL
SELECT u.username, u.reputation, u.reputation_ui
FROM Followers f
JOIN Users u ON f.following = u.username
WHERE f.follower = 'insert username' AND u.reputation > insert numerical number
The core of SQL is basically SELECT, FROM, WHERE. The interesting part happens in "WHERE" as you can includes conditionals and basically the things that you want to do.
I noticed one thing with SQL is that it doesn't accept LIMIT so I have to use TOP command to "limit" the data that I want to gather.
Thanks to documentation by hivesql and as long as you read it, nothing is impossible. You can get whatever data available that you want to know.
 | 𝘔𝘢𝘤 𝘪𝘴 𝘢 𝘴𝘦𝘭𝘧-𝘦𝘮𝘱𝘭𝘰𝘺𝘦𝘥 𝘯𝘪𝘯𝘫𝘢 & 𝘤𝘰𝘧𝘧𝘦𝘦 𝘤𝘰𝘯𝘯𝘰𝘪𝘴𝘴𝘦𝘶𝘳 . 𝘈 𝘵𝘺𝘱𝘪𝘤𝘢𝘭 𝘪𝘯𝘵𝘳𝘰𝘷𝘦𝘳𝘵 𝘪𝘯 𝘭𝘰𝘷𝘦 𝘸𝘪𝘵𝘩 𝘭𝘪𝘵𝘦𝘳𝘢𝘵𝘶𝘳𝘦, 𝘣𝘰𝘰𝘬𝘴, 𝘵𝘦𝘤𝘩𝘯𝘰𝘭𝘰𝘨𝘺 𝘢𝘯𝘥 𝘱𝘩𝘪𝘭𝘰𝘴𝘰𝘱𝘩𝘺. 𝘛𝘩𝘪𝘴 𝘪𝘴 𝘩𝘦𝘳 𝘱𝘦𝘳𝘴𝘰𝘯𝘢𝘭 𝘣𝘭𝘰𝘨, 𝘢 𝘳𝘦𝘧𝘭𝘦𝘤𝘵𝘪𝘰𝘯 𝘰𝘧 𝘩𝘦𝘳 𝘸𝘢𝘯𝘥𝘦𝘳𝘭𝘶𝘴𝘵 𝘢𝘯𝘥 𝘵𝘩𝘪𝘳𝘴𝘵 𝘧𝘰𝘳 𝘬𝘯𝘰𝘸𝘭𝘦𝘥𝘨𝘦. 𝘚𝘩𝘦 𝘰𝘧𝘵𝘦𝘯 𝘤𝘰𝘷𝘦𝘳𝘴 𝘣𝘰𝘰𝘬𝘴, 𝘮𝘰𝘷𝘪𝘦 𝘢𝘯𝘥 𝘴𝘦𝘳𝘪𝘦𝘴 𝘳𝘦𝘷𝘪𝘦𝘸𝘴, 𝘵𝘦𝘤𝘩 𝘳𝘦𝘷𝘪𝘦𝘸𝘴 𝘢𝘯𝘥 𝘵𝘳𝘦𝘯𝘥𝘴, 𝘱𝘩𝘰𝘵𝘰𝘨𝘳𝘢𝘱𝘩𝘺, 𝘢𝘯𝘥 𝘱𝘦𝘳𝘴𝘰𝘯𝘢𝘭 𝘥𝘦𝘷𝘦𝘭𝘰𝘱𝘮𝘦𝘯𝘵. 𝘖𝘯𝘤𝘦 𝘪𝘯 𝘢 𝘣𝘭𝘶𝘦 𝘮𝘰𝘰𝘯, 𝘺𝘰𝘶 𝘤𝘢𝘯 𝘧𝘪𝘯𝘥 𝘩𝘦𝘳 𝘵𝘳𝘢𝘷𝘦𝘭𝘪𝘯𝘨, 𝘪𝘮𝘮𝘦𝘳𝘴𝘪𝘯𝘨 𝘩𝘦𝘳𝘴𝘦𝘭𝘧 𝘪𝘯 𝘭𝘰𝘤𝘢𝘭 𝘤𝘶𝘭𝘵𝘶𝘳𝘦𝘴 𝘢𝘯𝘥 𝘵𝘳𝘢𝘥𝘪𝘵𝘪𝘰𝘯𝘴, 𝘢𝘯𝘥 𝘵𝘢𝘬𝘪𝘯𝘨 𝘱𝘪𝘤𝘵𝘶𝘳𝘦𝘴 𝘰𝘧 𝘵𝘩𝘦 𝘣𝘦𝘢𝘶𝘵𝘪𝘧𝘶𝘭 𝘴𝘪𝘨𝘩𝘵𝘴 𝘴𝘩𝘦 𝘦𝘯𝘤𝘰𝘶𝘯𝘵𝘦𝘳𝘴 𝘢𝘭𝘰𝘯𝘨 𝘵𝘩𝘦 𝘸𝘢𝘺. 𝘚𝘩𝘦'𝘴 𝘢𝘯 𝘰𝘤𝘤𝘢𝘴𝘪𝘰𝘯𝘢𝘭 𝘧𝘰𝘰𝘥𝘪𝘦 𝘢𝘯𝘥 𝘭𝘰𝘷𝘦𝘴 𝘵𝘰 𝘦𝘹𝘱𝘭𝘰𝘳𝘦 𝘯𝘦𝘸 𝘢𝘯𝘥 𝘥𝘦𝘭𝘪𝘤𝘪𝘰𝘶𝘴 𝘤𝘶𝘭𝘪𝘯𝘢𝘳𝘺 𝘦𝘹𝘱𝘦𝘳𝘪𝘦𝘯𝘤𝘦𝘴. 𝘍𝘰𝘭𝘭𝘰𝘸 𝘢𝘭𝘰𝘯𝘨 𝘰𝘯 𝘩𝘦𝘳 𝘢𝘥𝘷𝘦𝘯𝘵𝘶𝘳𝘦𝘴 𝘢𝘯𝘥 𝘫𝘰𝘪𝘯 𝘵𝘩𝘦 𝘤𝘰𝘯𝘷𝘦𝘳𝘴𝘢𝘵𝘪𝘰𝘯! 𝘋𝘰𝘯'𝘵 𝘩𝘦𝘴𝘪𝘵𝘢𝘵𝘦 𝘵𝘰 𝘶𝘱𝘷𝘰𝘵𝘦, 𝘭𝘦𝘢𝘷𝘦 𝘢 𝘤𝘰𝘮𝘮𝘦𝘯𝘵 𝘰𝘳 𝘢 𝘧𝘦𝘦𝘥𝘣𝘢𝘤𝘬. 𝘈 𝘳𝘦-𝘣𝘭𝘰𝘨 𝘪𝘴 𝘢𝘭𝘴𝘰 𝘢𝘱𝘱𝘳𝘦𝘤𝘪𝘢𝘵𝘦𝘥 𝘵𝘰𝘰. |
Muchachona did not know you have your knowledge in programming or at least that I understand, in my case I have not had the problem or inconvenience you mention, in fact I had to read several times to understand the problem that afflicts you for a long time haha.
With pleasure I vote for the proposal that seems to me something positive by where it is seen, that if I grasped it immediately by the solutions and advantages that it offers besides being able to arrive free to all if the proposal is approved so that they can solve this way their inconveniences.
To what I could conclude is that I have to read the hivesql documentation to adapt it to my needs using as base the elements that you have mentioned. It is striking the WHERE TOP SELECT etc haha, I got to see some programming in college and it is always striking the ways in which the programs place the terms to adapt the conditions and the program flows. That's what I could understand 😅.... I think you drank many coffees while solving all this conflict 😃
Your comment is upvoted by @topcomment
Info - Support - Discord
Success to continue for more genuineness and good contribution to high quality content on the platform, this motivates to continue for Success 😎
It's basically we run a requirement in @lovesniper that account must be unfollowed after they get to rep 60 since that also indicates that they already familiarize themselves with the ecosystem. So, for a long time, a lot of us did it manually and it gets tedious. We have to go through pages of pages while with that simple script, we can simply have list of name within mere seconds haha. The problem is definitely unique but again if you want to know a lot of data and wants to solve problems around HiveSQL is the start.
I know we have some tools around like hive-now but it's alway good to learn something new and now I can know things that I really want to know rather than going to multiple websites to find certain things.So, I hope it gets funded hehe 😃
You're definitely right, I had quite a bit of coffee hahaha and that's why I got this AHA moment to solve this problem that's been a while for me.
You make it sound do easy ! Great work for sussing it out.
I would have taken the lazy route and beg others to help me out 😂
😂 I just happen to start learning data science and this was the problem that actually got to me. So, I am glad to learn something new and partially solve the problem. Asking other helps would have been faster and I tried but I don't like it when I don't understand the whole thing 😄
Love sniper hasn't been active for some time though.
I literally forgot about that app till now😂😂✨
Really don't remember it curating my works back then when I was a newbie nor did I follow it.
Or maybe it didn't curate my work because I didn't follow it?😂
It's not because you don't follow it rather we through @lovesniper should follow the new user. We curate our feed and has certain rules as well. I am sure you've been curated by us, I've seen your name a couple of time 😊
Hmmm
Okay😂😂
So you're unfollowing them because you're not part of the curation team again or,?..
I am the one that manages it. I unfollow the users we're following.
Ohhh
Okay...
Cool! Maybe next thing we'll see is you automating the unfollow process with Python. I'd like to learn that.
hahahaha I'd like to learn that too but maybe in a million years before I can even do that
I'll have to check this out, it's always good seeing dev tools for programmers like myself
Check it out, you can learn quite a bit from them.