 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 : <div class="text-justify"> 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? <center>  </center> 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. <center>  </center> ### 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. </div> <center>  </center> <center> Don't hesitate to upvote for more content like this ! You can also support me below! </center> <center> <a href='https://buymeberri.es/@macchiata' target='_blank'><img src='https://buymeberries.com/assets/bmb-4-s.png'/></a></center> ||| |-|- || <div class="text-justify">๐๐ข๐ค ๐ช๐ด ๐ข ๐ด๐ฆ๐ญ๐ง-๐ฆ๐ฎ๐ฑ๐ญ๐ฐ๐บ๐ฆ๐ฅ ๐ฏ๐ช๐ฏ๐ซ๐ข & ๐ค๐ฐ๐ง๐ง๐ฆ๐ฆ ๐ค๐ฐ๐ฏ๐ฏ๐ฐ๐ช๐ด๐ด๐ฆ๐ถ๐ณ . ๐ ๐ต๐บ๐ฑ๐ช๐ค๐ข๐ญ ๐ช๐ฏ๐ต๐ณ๐ฐ๐ท๐ฆ๐ณ๐ต ๐ช๐ฏ ๐ญ๐ฐ๐ท๐ฆ ๐ธ๐ช๐ต๐ฉ ๐ญ๐ช๐ต๐ฆ๐ณ๐ข๐ต๐ถ๐ณ๐ฆ, ๐ฃ๐ฐ๐ฐ๐ฌ๐ด, ๐ต๐ฆ๐ค๐ฉ๐ฏ๐ฐ๐ญ๐ฐ๐จ๐บ ๐ข๐ฏ๐ฅ ๐ฑ๐ฉ๐ช๐ญ๐ฐ๐ด๐ฐ๐ฑ๐ฉ๐บ. ๐๐ฉ๐ช๐ด ๐ช๐ด ๐ฉ๐ฆ๐ณ ๐ฑ๐ฆ๐ณ๐ด๐ฐ๐ฏ๐ข๐ญ ๐ฃ๐ญ๐ฐ๐จ, ๐ข ๐ณ๐ฆ๐ง๐ญ๐ฆ๐ค๐ต๐ช๐ฐ๐ฏ ๐ฐ๐ง ๐ฉ๐ฆ๐ณ ๐ธ๐ข๐ฏ๐ฅ๐ฆ๐ณ๐ญ๐ถ๐ด๐ต ๐ข๐ฏ๐ฅ ๐ต๐ฉ๐ช๐ณ๐ด๐ต ๐ง๐ฐ๐ณ ๐ฌ๐ฏ๐ฐ๐ธ๐ญ๐ฆ๐ฅ๐จ๐ฆ. ๐๐ฉ๐ฆ ๐ฐ๐ง๐ต๐ฆ๐ฏ ๐ค๐ฐ๐ท๐ฆ๐ณ๐ด **๐ฃ๐ฐ๐ฐ๐ฌ๐ด, ๐ฎ๐ฐ๐ท๐ช๐ฆ ๐ข๐ฏ๐ฅ ๐ด๐ฆ๐ณ๐ช๐ฆ๐ด ๐ณ๐ฆ๐ท๐ช๐ฆ๐ธ๐ด, ๐ต๐ฆ๐ค๐ฉ ๐ณ๐ฆ๐ท๐ช๐ฆ๐ธ๐ด ๐ข๐ฏ๐ฅ ๐ต๐ณ๐ฆ๐ฏ๐ฅ๐ด, ๐ฑ๐ฉ๐ฐ๐ต๐ฐ๐จ๐ณ๐ข๐ฑ๐ฉ๐บ, ๐ข๐ฏ๐ฅ ๐ฑ๐ฆ๐ณ๐ด๐ฐ๐ฏ๐ข๐ญ ๐ฅ๐ฆ๐ท๐ฆ๐ญ๐ฐ๐ฑ๐ฎ๐ฆ๐ฏ๐ต**. ๐๐ฏ๐ค๐ฆ ๐ช๐ฏ ๐ข ๐ฃ๐ญ๐ถ๐ฆ ๐ฎ๐ฐ๐ฐ๐ฏ, ๐บ๐ฐ๐ถ ๐ค๐ข๐ฏ ๐ง๐ช๐ฏ๐ฅ ๐ฉ๐ฆ๐ณ ๐ต๐ณ๐ข๐ท๐ฆ๐ญ๐ช๐ฏ๐จ, ๐ช๐ฎ๐ฎ๐ฆ๐ณ๐ด๐ช๐ฏ๐จ ๐ฉ๐ฆ๐ณ๐ด๐ฆ๐ญ๐ง ๐ช๐ฏ ๐ญ๐ฐ๐ค๐ข๐ญ ๐ค๐ถ๐ญ๐ต๐ถ๐ณ๐ฆ๐ด ๐ข๐ฏ๐ฅ ๐ต๐ณ๐ข๐ฅ๐ช๐ต๐ช๐ฐ๐ฏ๐ด, ๐ข๐ฏ๐ฅ ๐ต๐ข๐ฌ๐ช๐ฏ๐จ ๐ฑ๐ช๐ค๐ต๐ถ๐ณ๐ฆ๐ด ๐ฐ๐ง ๐ต๐ฉ๐ฆ ๐ฃ๐ฆ๐ข๐ถ๐ต๐ช๐ง๐ถ๐ญ ๐ด๐ช๐จ๐ฉ๐ต๐ด ๐ด๐ฉ๐ฆ ๐ฆ๐ฏ๐ค๐ฐ๐ถ๐ฏ๐ต๐ฆ๐ณ๐ด ๐ข๐ญ๐ฐ๐ฏ๐จ ๐ต๐ฉ๐ฆ ๐ธ๐ข๐บ. ๐๐ฉ๐ฆ'๐ด ๐ข๐ฏ ๐ฐ๐ค๐ค๐ข๐ด๐ช๐ฐ๐ฏ๐ข๐ญ ๐ง๐ฐ๐ฐ๐ฅ๐ช๐ฆ ๐ข๐ฏ๐ฅ ๐ญ๐ฐ๐ท๐ฆ๐ด ๐ต๐ฐ ๐ฆ๐น๐ฑ๐ญ๐ฐ๐ณ๐ฆ ๐ฏ๐ฆ๐ธ ๐ข๐ฏ๐ฅ ๐ฅ๐ฆ๐ญ๐ช๐ค๐ช๐ฐ๐ถ๐ด ๐ค๐ถ๐ญ๐ช๐ฏ๐ข๐ณ๐บ ๐ฆ๐น๐ฑ๐ฆ๐ณ๐ช๐ฆ๐ฏ๐ค๐ฆ๐ด. ๐๐ฐ๐ญ๐ญ๐ฐ๐ธ ๐ข๐ญ๐ฐ๐ฏ๐จ ๐ฐ๐ฏ ๐ฉ๐ฆ๐ณ ๐ข๐ฅ๐ท๐ฆ๐ฏ๐ต๐ถ๐ณ๐ฆ๐ด ๐ข๐ฏ๐ฅ ๐ซ๐ฐ๐ช๐ฏ ๐ต๐ฉ๐ฆ ๐ค๐ฐ๐ฏ๐ท๐ฆ๐ณ๐ด๐ข๐ต๐ช๐ฐ๐ฏ! ๐๐ฐ๐ฏ'๐ต ๐ฉ๐ฆ๐ด๐ช๐ต๐ข๐ต๐ฆ ๐ต๐ฐ ๐ถ๐ฑ๐ท๐ฐ๐ต๐ฆ, ๐ญ๐ฆ๐ข๐ท๐ฆ ๐ข ๐ค๐ฐ๐ฎ๐ฎ๐ฆ๐ฏ๐ต ๐ฐ๐ณ ๐ข ๐ง๐ฆ๐ฆ๐ฅ๐ฃ๐ข๐ค๐ฌ. ๐ ๐ณ๐ฆ-๐ฃ๐ญ๐ฐ๐จ ๐ช๐ด ๐ข๐ญ๐ด๐ฐ ๐ข๐ฑ๐ฑ๐ณ๐ฆ๐ค๐ช๐ข๐ต๐ฆ๐ฅ ๐ต๐ฐ๐ฐ.</div> |</center>
author | macchiata |
---|---|
permlink | i-just-learned-how-to-sort-following-list-by-reputation-with-hivesqlfeels-silly-but-exciting |
category | hive-155735 |
json_metadata | {"app":"peakd/2025.2.3","format":"markdown","tags":["sql","learn2code","howto","mysql","hivesql","tech"],"users":["arcange","hivesql","lovesniper","macchiata"],"image":["https://files.peakd.com/file/peakd-hive/macchiata/246b2fmdczE1sraVi2tMyeMxbJJWaK3mSUgBcoXYpUCMgTQrx9hcbzjpT7j8V4kRFZUUg.png","https://files.peakd.com/file/peakd-hive/macchiata/23sweD6vycN7cwFdHaLE8Ze8ayocMSDoWEAgUZqFJJ9kCXshFpN3tDPaDhXgZr3fLV5ZQ.png","https://buymeberries.com/assets/bmb-4-s.png","https://files.peakd.com/file/peakd-hive/macchiata/AKqch2qeXxDgtt6gewBnVB28roLauVcnbF5T9dypQyjYTV1DhG9mmkdEo7HYkMv.jpg"]} |
created | 2025-02-15 16:41:48 |
last_update | 2025-02-15 16:41:48 |
depth | 0 |
children | 15 |
last_payout | 2025-02-22 16:41:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 3.383 HBD |
curator_payout_value | 3.360 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 4,246 |
author_reputation | 1,384,980,362,611,795 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,810,991 |
net_rshares | 15,593,331,323,434 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
kenny-crane | 0 | 803,022,751,697 | 50% | ||
someguy123 | 0 | 199,923,400,188 | 49% | ||
freebornsociety | 0 | 2,474,733,913 | 4.88% | ||
thatsweeneyguy | 0 | 456,713,656 | 100% | ||
jznsamuel | 0 | 177,229,358,509 | 100% | ||
joeyarnoldvn | 0 | 528,138,888 | 1.68% | ||
grocko | 0 | 47,043,781,364 | 50% | ||
livinguktaiwan | 0 | 1,811,783,979,034 | 50% | ||
ksteem | 0 | 494,474,324,655 | 30% | ||
bambukah | 0 | 17,768,653,841 | 20% | ||
moeknows | 0 | 166,017,556,066 | 100% | ||
martibis | 0 | 17,038,151,742 | 50% | ||
simplifylife | 0 | 66,972,575,254 | 100% | ||
deathwing | 0 | 1,847,756,583,595 | 49% | ||
diosarich | 0 | 3,597,251,719 | 50% | ||
afterglow | 0 | 1,127,505,080 | 20% | ||
emrebeyler | 0 | 2,018,414,662,328 | 34.3% | ||
katerinaramm | 0 | 139,876,251,584 | 89% | ||
mytechtrail | 0 | 45,088,701,999 | 35% | ||
nathen007 | 0 | 274,696,419,354 | 100% | ||
drunksamurai | 0 | 520,167,057 | 30% | ||
danielwong | 0 | 45,041,677,611 | 100% | ||
dedicatedguy | 0 | 1,417,874,712 | 100% | ||
jude.villarta | 0 | 3,935,531,732 | 50% | ||
sinochip | 0 | 458,614,591 | 100% | ||
m1alsan | 0 | 31,083,642,156 | 24.5% | ||
jazzhero | 0 | 31,601,379,549 | 37.5% | ||
sudefteri | 0 | 43,290,512,709 | 49% | ||
fireguardian | 0 | 576,910,120 | 20% | ||
akifane | 0 | 1,574,813,320 | 49% | ||
russellstockley | 0 | 45,369,386,630 | 35% | ||
jglake | 0 | 5,386,020,380 | 20% | ||
dumnebari | 0 | 1,065,235,589 | 50% | ||
ravenmus1c | 0 | 92,517,361,119 | 5% | ||
adamada | 0 | 59,264,147,782 | 50% | ||
kendallron | 0 | 949,281,545 | 50% | ||
cesaramos | 0 | 54,767,641,191 | 100% | ||
littledrummerboy | 0 | 543,858,754 | 100% | ||
pinas | 0 | 564,024,616 | 50% | ||
sgbonus | 0 | 11,041,850,149 | 16% | ||
cmplxty | 0 | 209,081,752,459 | 14% | ||
jauregui98 | 0 | 1,202,746,588 | 100% | ||
bestofph | 0 | 4,467,467,247 | 50% | ||
teamvn | 0 | 8,840,112,779 | 6.73% | ||
luciannagy | 0 | 525,493,113 | 50% | ||
smartvote | 0 | 78,147,353,277 | 3.6% | ||
zuerich | 0 | 1,012,046,544,036 | 20% | ||
slothlydoesit | 0 | 15,870,347,827 | 10% | ||
aksurevm89 | 0 | 680,988,606,260 | 100% | ||
helgalubevi | 0 | 10,687,390,704 | 25% | ||
nooblogger | 0 | 4,822,788,582 | 50% | ||
aboutheraklion | 0 | 836,116,478 | 44.5% | ||
lut-studio | 0 | 889,222,658 | 50% | ||
ph1102 | 0 | 326,115,045,368 | 10% | ||
ssiena | 0 | 6,939,115,518 | 14% | ||
maddogmike | 0 | 60,078,233,256 | 35% | ||
successchar | 0 | 7,884,908,257 | 35% | ||
whangster79 | 0 | 12,911,840,906 | 50% | ||
vault.tokens | 0 | 986,174,533 | 50% | ||
theisacoin | 0 | 3,380,867,830 | 100% | ||
wesp05 | 0 | 32,750,565,242 | 100% | ||
hivetrending | 0 | 289,073,645,069 | 100% | ||
thepeakstudio | 0 | 1,062,268,914 | 35% | ||
kyleana | 0 | 2,981,683,131 | 50% | ||
kingneptune | 0 | 4,556,183,340 | 50% | ||
hivehustlers | 0 | 14,644,566,529 | 70% | ||
improbableliason | 0 | 1,555,456,388 | 35% | ||
aaalviarez | 0 | 13,919,670,682 | 100% | ||
trcommunity | 0 | 0 | 49% | ||
birdbeaksd | 0 | 832,922,644 | 100% | ||
rondonshneezy | 0 | 10,519,938,835 | 50% | ||
dadspardan | 0 | 42,293,530,371 | 50% | ||
hykss.leo | 0 | 101,907,888,242 | 9.8% | ||
eldritchspig | 0 | 1,193,417,607 | 50% | ||
ausbit.dev | 0 | 11,485,155,329 | 49% | ||
huzzah | 0 | 37,597,026,802 | 100% | ||
cooperclub | 0 | 31,932,010,144 | 50% | ||
draygyn | 0 | 7,070,976,459 | 100% | ||
princeofbeyhive | 0 | 1,374,350,807 | 49% | ||
creodas | 0 | 2,859,544,429 | 75% | ||
iviaxpow3r | 0 | 14,419,108,930 | 100% | ||
hive.pizza | 0 | 2,485,351,918,728 | 100% | ||
dajokawild | 0 | 75,944,148,780 | 50% | ||
john9inch | 0 | 1,806,327,379 | 50% | ||
szmobacsi | 0 | 2,301,854,995 | 90% | ||
onthemountain | 0 | 5,471,043,896 | 50% | ||
mooontivated | 0 | 1,756,957,923 | 59% | ||
bilgin70 | 0 | 26,693,532,492 | 24.5% | ||
andriko | 0 | 1,174,054,502 | 100% | ||
avidez | 0 | 826,349,376 | 50% | ||
banzafahra | 0 | 8,808,112,687 | 50% | ||
mcgilli | 0 | 958,192,555 | 100% | ||
cogie88 | 0 | 2,587,849,736 | 50% | ||
thercek | 0 | 834,702,345 | 50% | ||
h3m4n7 | 0 | 32,782,145,281 | 90% | ||
thedoc07 | 0 | 7,284,179,672 | 50% | ||
tillmea | 0 | 659,175,306 | 100% | ||
relf87 | 0 | 46,787,028,266 | 50% | ||
promete0sz | 0 | 23,018,564,729 | 100% | ||
lothbrox | 0 | 883,662,055 | 100% | ||
highfist | 0 | 4,737,383,659 | 50% | ||
arveno | 0 | 34,448,654,137 | 100% | ||
blocktunes | 0 | 1,321,223,460 | 10% | ||
gunu1 | 0 | 1,036,644,383 | 100% | ||
thorlock | 0 | 124,591,049,958 | 100% | ||
dusunenkalpp | 0 | 20,942,203,999 | 49% | ||
ipexito | 0 | 847,036,223 | 39.2% | ||
mighty-thor | 0 | 7,612,513,748 | 100% | ||
olujay | 0 | 160,261,773,781 | 80% | ||
sabajfa | 0 | 7,480,717,698 | 50% | ||
enclassecu | 0 | 25,474,498,678 | 100% | ||
nurfay | 0 | 64,130,053,847 | 100% | ||
dutchchemist | 0 | 542,303,043 | 100% | ||
mukadder | 0 | 48,566,759,821 | 34.3% | ||
incublus | 0 | 139,303,473,382 | 24.5% | ||
ezgicop | 0 | 3,675,015,894 | 50% | ||
thoth442 | 0 | 16,273,895,907 | 50% | ||
splinterwhale | 0 | 4,623,848,626 | 100% | ||
masterfarmer | 0 | 1,570,488,226 | 100% | ||
amiegeoffrey | 0 | 63,292,614,875 | 75% | ||
duskobgd | 0 | 76,736,780,937 | 50% | ||
hive-195880 | 0 | 2,220,847,432 | 50% | ||
kalibudz23 | 0 | 387,421,136 | 100% | ||
dangab | 0 | 3,079,860,236 | 50% | ||
dragonmemories | 0 | 989,265,610 | 25% | ||
emviagem | 0 | 469,255,264 | 25% | ||
mita3 | 0 | 6,400,260,975 | 100% | ||
hivedrip | 0 | 262,466,107,976 | 100% | ||
kathrynkw | 0 | 22,162,976,106 | 50% | ||
silvercrown1 | 0 | 2,514,304,698 | 100% | ||
hive-188753 | 0 | 1,248,396,872 | 49% | ||
youhive | 0 | 17,935,034,909 | 100% | ||
apis.hive | 0 | 103,065,393,887 | 50% | ||
endhivewatchers | 0 | 0 | 0.5% |
I'll have to check this out, it's always good seeing dev tools for programmers like myself
author | gunu1 |
---|---|
permlink | re-macchiata-2025219t84748256z |
category | hive-155735 |
json_metadata | {"type":"comment","tags":["hive-155735","sql","learn2code","howto","mysql","hivesql","tech"],"app":"ecency/3.2.1-mobile","format":"markdown+html"} |
created | 2025-02-19 08:47:48 |
last_update | 2025-02-19 08:47:48 |
depth | 1 |
children | 1 |
last_payout | 2025-02-26 08:47:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 91 |
author_reputation | 10,604,089,175,916 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,895,772 |
net_rshares | 0 |
Check it out, you can learn quite a bit from them.
author | macchiata |
---|---|
permlink | re-gunu1-srzccg |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3"} |
created | 2025-02-20 11:38:42 |
last_update | 2025-02-20 11:38:42 |
depth | 2 |
children | 0 |
last_payout | 2025-02-27 11:38:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 50 |
author_reputation | 1,384,980,362,611,795 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,922,364 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
endhivewatchers | 0 | 0 | 0.5% |
>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 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 ๐
author | livinguktaiwan |
---|---|
permlink | re-macchiata-srqrps |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]} |
created | 2025-02-15 20:32:15 |
last_update | 2025-02-15 20:32:15 |
depth | 1 |
children | 1 |
last_payout | 2025-02-22 20:32:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.012 HBD |
curator_payout_value | 0.012 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 357 |
author_reputation | 1,676,739,286,318,667 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,815,396 |
net_rshares | 57,559,895,885 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
macchiata | 0 | 57,559,895,885 | 100% | ||
bpcvoter4 | 0 | 0 | 100% |
๐ 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 ๐
author | macchiata |
---|---|
permlink | re-livinguktaiwan-srrqk1 |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3"} |
created | 2025-02-16 09:04:54 |
last_update | 2025-02-16 09:04:54 |
depth | 2 |
children | 0 |
last_payout | 2025-02-23 09:04:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 282 |
author_reputation | 1,384,980,362,611,795 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,824,616 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
endhivewatchers | 0 | 0 | 0.5% |
Cool! Maybe next thing we'll see is you automating the unfollow process with Python. I'd like to learn that.
author | olujay |
---|---|
permlink | re-macchiata-srrx8o |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]} |
created | 2025-02-16 11:29:15 |
last_update | 2025-02-16 11:29:15 |
depth | 1 |
children | 1 |
last_payout | 2025-02-23 11:29:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 108 |
author_reputation | 530,536,449,085,412 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,826,304 |
net_rshares | 0 |
hahahaha I'd like to learn that too but maybe in a million years before I can even do that
author | macchiata |
---|---|
permlink | re-olujay-srs5r6 |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3"} |
created | 2025-02-16 14:33:15 |
last_update | 2025-02-16 14:33:15 |
depth | 2 |
children | 0 |
last_payout | 2025-02-23 14:33:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 90 |
author_reputation | 1,384,980,362,611,795 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,829,156 |
net_rshares | 0 |
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 ๐ >Muchachona no sabรญa tienes tus conocimientos en programacion o al menos eso voy entendiendo, en mi caso no he tenido el problema o inconveniente que mencionas, de hecho tuve que leer varias veces para poder entender el problema que te aqueja desde hace buen tiempo jaja >Con gusto voto por la propuesta que me parece algo positivo por donde se vea, eso si que lo capte inmediatamente por las soluciones y ventajas que ofrece ademรกs de poder llegar gratis a todos si la propuesta se aprueba para que puedan solucionar asรญ sus inconvenientes >A lo que pude concluir es que tengo que leer la documentacion hivesql para adaptarlo a mis necesidades usando como base los elementos que haz mencionado. Llamativo lo de WHERE TOP SELECT etc jaja, llegue a ver algo de programaciรณn en la universidad y siempre son llamativas las maneras en que los programas colocan los terminos para uno poder adaptar las condiciones y fluya el programa. Es lo que pude entender ๐ .... pienso tomaste muchos cafes mientras resolvias todo este conflicto ๐
author | promete0sz |
---|---|
permlink | re-macchiata-srqjr4 |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]} |
created | 2025-02-15 17:40:21 |
last_update | 2025-02-15 17:40:21 |
depth | 1 |
children | 3 |
last_payout | 2025-02-22 17:40:21 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.231 HBD |
curator_payout_value | 0.231 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 2,054 |
author_reputation | 255,147,079,390,263 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,812,201 |
net_rshares | 1,070,597,714,921 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
freebornsociety | 0 | 1,363,721,868 | 2.75% | ||
macchiata | 0 | 62,339,695,494 | 100% | ||
justclickindiva | 0 | 413,883,602,952 | 50% | ||
happywhalex | 0 | 62,184,761,343 | 100% | ||
commentrewarder | 0 | 174,420,008,555 | 100% | ||
topcomment | 0 | 356,405,924,709 | 100% |
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.
author | macchiata |
---|---|
permlink | srqk67 |
category | hive-155735 |
json_metadata | {"users":["lovesniper"],"app":"hiveblog/0.1"} |
created | 2025-02-15 17:49:33 |
last_update | 2025-02-15 17:49:33 |
depth | 2 |
children | 0 |
last_payout | 2025-02-22 17:49:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 914 |
author_reputation | 1,384,980,362,611,795 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,812,410 |
net_rshares | 22,781,941,711 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
promete0sz | 0 | 22,781,941,711 | 100% | ||
endhivewatchers | 0 | 0 | 0.5% |
<center> **Your comment is upvoted by [@topcomment](https://peakd.com/@topcomment)** <center> **[Info](https://peakd.com/hive-148441/@topcomment/rewarding-meaningful-comments-with-topcomment) - [Support](https://peakd.com/hive/@topcomment/support-topcomment-a-delegation-and-earn-80percent-curation-rewards) - [Discord](https://discord.gg/u7ebA2QKCd)** </center> [](https://peakd.com/@topcomment)
author | topcomment |
---|---|
permlink | re-promete0sz-1739654832 |
category | hive-155735 |
json_metadata | "{"tags": ["hive-155735"], "app": "HiveDiscoMod"}" |
created | 2025-02-15 21:27:12 |
last_update | 2025-02-15 21:27:12 |
depth | 2 |
children | 1 |
last_payout | 2025-02-22 21:27:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 533 |
author_reputation | 7,519,979,968,003 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,816,276 |
net_rshares | 23,224,608,886 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
promete0sz | 0 | 23,224,608,886 | 100% |
Success to continue for more genuineness and good contribution to high quality content on the platform, this motivates to continue for Success ๐ >El Exito a seguir por mas genuinidad y buen aporte a los contenidos de gran calidad en la plataforma, esto motiva a seguir por el Exito ๐
author | promete0sz |
---|---|
permlink | re-topcomment-srrb71 |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]} |
created | 2025-02-16 03:32:51 |
last_update | 2025-02-16 03:32:51 |
depth | 3 |
children | 0 |
last_payout | 2025-02-23 03:32:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 284 |
author_reputation | 255,147,079,390,263 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,821,183 |
net_rshares | 0 |
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?๐
author | seki1 |
---|---|
permlink | re-macchiata-srrix9 |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]} |
created | 2025-02-16 06:20:00 |
last_update | 2025-02-16 06:20:00 |
depth | 1 |
children | 4 |
last_payout | 2025-02-23 06:20:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.012 HBD |
curator_payout_value | 0.012 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 258 |
author_reputation | 152,465,402,379,985 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,822,900 |
net_rshares | 56,408,273,672 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
macchiata | 0 | 56,408,273,672 | 100% |
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 ๐
author | macchiata |
---|---|
permlink | re-seki1-srrqju |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3"} |
created | 2025-02-16 09:04:48 |
last_update | 2025-02-16 09:04:48 |
depth | 2 |
children | 3 |
last_payout | 2025-02-23 09:04:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 221 |
author_reputation | 1,384,980,362,611,795 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,824,615 |
net_rshares | 0 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
endhivewatchers | 0 | 0 | 0.5% |
Hmmm Okay๐๐ So you're unfollowing them because you're not part of the curation team again or,?..
author | seki1 |
---|---|
permlink | re-macchiata-srrr8s |
category | hive-155735 |
json_metadata | {"tags":["hive-155735"],"app":"peakd/2025.2.3","image":[],"users":[]} |
created | 2025-02-16 09:19:42 |
last_update | 2025-02-16 09:19:42 |
depth | 3 |
children | 2 |
last_payout | 2025-02-23 09:19:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 98 |
author_reputation | 152,465,402,379,985 |
root_title | "I Just Learned How to Sort Following List by Reputation With HiveSQLโFeels Silly but Exciting!" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 140,824,781 |
net_rshares | 0 |