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 :
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.
 | ๐๐ข๐ค ๐ช๐ด ๐ข ๐ด๐ฆ๐ญ๐ง-๐ฆ๐ฎ๐ฑ๐ญ๐ฐ๐บ๐ฆ๐ฅ ๐ฏ๐ช๐ฏ๐ซ๐ข & ๐ค๐ฐ๐ง๐ง๐ฆ๐ฆ ๐ค๐ฐ๐ฏ๐ฏ๐ฐ๐ช๐ด๐ด๐ฆ๐ถ๐ณ . ๐ ๐ต๐บ๐ฑ๐ช๐ค๐ข๐ญ ๐ช๐ฏ๐ต๐ณ๐ฐ๐ท๐ฆ๐ณ๐ต ๐ช๐ฏ ๐ญ๐ฐ๐ท๐ฆ ๐ธ๐ช๐ต๐ฉ ๐ญ๐ช๐ต๐ฆ๐ณ๐ข๐ต๐ถ๐ณ๐ฆ, ๐ฃ๐ฐ๐ฐ๐ฌ๐ด, ๐ต๐ฆ๐ค๐ฉ๐ฏ๐ฐ๐ญ๐ฐ๐จ๐บ ๐ข๐ฏ๐ฅ ๐ฑ๐ฉ๐ช๐ญ๐ฐ๐ด๐ฐ๐ฑ๐ฉ๐บ. ๐๐ฉ๐ช๐ด ๐ช๐ด ๐ฉ๐ฆ๐ณ ๐ฑ๐ฆ๐ณ๐ด๐ฐ๐ฏ๐ข๐ญ ๐ฃ๐ญ๐ฐ๐จ, ๐ข ๐ณ๐ฆ๐ง๐ญ๐ฆ๐ค๐ต๐ช๐ฐ๐ฏ ๐ฐ๐ง ๐ฉ๐ฆ๐ณ ๐ธ๐ข๐ฏ๐ฅ๐ฆ๐ณ๐ญ๐ถ๐ด๐ต ๐ข๐ฏ๐ฅ ๐ต๐ฉ๐ช๐ณ๐ด๐ต ๐ง๐ฐ๐ณ ๐ฌ๐ฏ๐ฐ๐ธ๐ญ๐ฆ๐ฅ๐จ๐ฆ. ๐๐ฉ๐ฆ ๐ฐ๐ง๐ต๐ฆ๐ฏ ๐ค๐ฐ๐ท๐ฆ๐ณ๐ด ๐ฃ๐ฐ๐ฐ๐ฌ๐ด, ๐ฎ๐ฐ๐ท๐ช๐ฆ ๐ข๐ฏ๐ฅ ๐ด๐ฆ๐ณ๐ช๐ฆ๐ด ๐ณ๐ฆ๐ท๐ช๐ฆ๐ธ๐ด, ๐ต๐ฆ๐ค๐ฉ ๐ณ๐ฆ๐ท๐ช๐ฆ๐ธ๐ด ๐ข๐ฏ๐ฅ ๐ต๐ณ๐ฆ๐ฏ๐ฅ๐ด, ๐ฑ๐ฉ๐ฐ๐ต๐ฐ๐จ๐ณ๐ข๐ฑ๐ฉ๐บ, ๐ข๐ฏ๐ฅ ๐ฑ๐ฆ๐ณ๐ด๐ฐ๐ฏ๐ข๐ญ ๐ฅ๐ฆ๐ท๐ฆ๐ญ๐ฐ๐ฑ๐ฎ๐ฆ๐ฏ๐ต. ๐๐ฏ๐ค๐ฆ ๐ช๐ฏ ๐ข ๐ฃ๐ญ๐ถ๐ฆ ๐ฎ๐ฐ๐ฐ๐ฏ, ๐บ๐ฐ๐ถ ๐ค๐ข๐ฏ ๐ง๐ช๐ฏ๐ฅ ๐ฉ๐ฆ๐ณ ๐ต๐ณ๐ข๐ท๐ฆ๐ญ๐ช๐ฏ๐จ, ๐ช๐ฎ๐ฎ๐ฆ๐ณ๐ด๐ช๐ฏ๐จ ๐ฉ๐ฆ๐ณ๐ด๐ฆ๐ญ๐ง ๐ช๐ฏ ๐ญ๐ฐ๐ค๐ข๐ญ ๐ค๐ถ๐ญ๐ต๐ถ๐ณ๐ฆ๐ด ๐ข๐ฏ๐ฅ ๐ต๐ณ๐ข๐ฅ๐ช๐ต๐ช๐ฐ๐ฏ๐ด, ๐ข๐ฏ๐ฅ ๐ต๐ข๐ฌ๐ช๐ฏ๐จ ๐ฑ๐ช๐ค๐ต๐ถ๐ณ๐ฆ๐ด ๐ฐ๐ง ๐ต๐ฉ๐ฆ ๐ฃ๐ฆ๐ข๐ถ๐ต๐ช๐ง๐ถ๐ญ ๐ด๐ช๐จ๐ฉ๐ต๐ด ๐ด๐ฉ๐ฆ ๐ฆ๐ฏ๐ค๐ฐ๐ถ๐ฏ๐ต๐ฆ๐ณ๐ด ๐ข๐ญ๐ฐ๐ฏ๐จ ๐ต๐ฉ๐ฆ ๐ธ๐ข๐บ. ๐๐ฉ๐ฆ'๐ด ๐ข๐ฏ ๐ฐ๐ค๐ค๐ข๐ด๐ช๐ฐ๐ฏ๐ข๐ญ ๐ง๐ฐ๐ฐ๐ฅ๐ช๐ฆ ๐ข๐ฏ๐ฅ ๐ญ๐ฐ๐ท๐ฆ๐ด ๐ต๐ฐ ๐ฆ๐น๐ฑ๐ญ๐ฐ๐ณ๐ฆ ๐ฏ๐ฆ๐ธ ๐ข๐ฏ๐ฅ ๐ฅ๐ฆ๐ญ๐ช๐ค๐ช๐ฐ๐ถ๐ด ๐ค๐ถ๐ญ๐ช๐ฏ๐ข๐ณ๐บ ๐ฆ๐น๐ฑ๐ฆ๐ณ๐ช๐ฆ๐ฏ๐ค๐ฆ๐ด. ๐๐ฐ๐ญ๐ญ๐ฐ๐ธ ๐ข๐ญ๐ฐ๐ฏ๐จ ๐ฐ๐ฏ ๐ฉ๐ฆ๐ณ ๐ข๐ฅ๐ท๐ฆ๐ฏ๐ต๐ถ๐ณ๐ฆ๐ด ๐ข๐ฏ๐ฅ ๐ซ๐ฐ๐ช๐ฏ ๐ต๐ฉ๐ฆ ๐ค๐ฐ๐ฏ๐ท๐ฆ๐ณ๐ด๐ข๐ต๐ช๐ฐ๐ฏ! ๐๐ฐ๐ฏ'๐ต ๐ฉ๐ฆ๐ด๐ช๐ต๐ข๐ต๐ฆ ๐ต๐ฐ ๐ถ๐ฑ๐ท๐ฐ๐ต๐ฆ, ๐ญ๐ฆ๐ข๐ท๐ฆ ๐ข ๐ค๐ฐ๐ฎ๐ฎ๐ฆ๐ฏ๐ต ๐ฐ๐ณ ๐ข ๐ง๐ฆ๐ฆ๐ฅ๐ฃ๐ข๐ค๐ฌ. ๐ ๐ณ๐ฆ-๐ฃ๐ญ๐ฐ๐จ ๐ช๐ด ๐ข๐ญ๐ด๐ฐ ๐ข๐ฑ๐ฑ๐ณ๐ฆ๐ค๐ช๐ข๐ต๐ฆ๐ฅ ๐ต๐ฐ๐ฐ. |