About a year ago, our hive friend @balaz started doing something, you can have a look here:
The site is still live but it looks like it wasn't developed further, it could be a start.
I had a play this morning with HiveSQL, I'm not a programmer or dev at all, but I managed to come up with a python script that, for my testing, it shows my December posts and how many votes each has, if I give it enough time I guess I could come up with a site where you input your filters and get the stats you need, but it'll take a bit of time, at least for me because I'll be learning both python or javascript and SQL commands.
Maybe @arcange has something easy already made and not published or could guide us on the right path to achieve this faster...
This is what "my" script currently shoots out, title posts and votes count, I know, not much, but I'll work on it! :))
And this is part of the script:
SQLCommand = '''
SELECT title, net_votes, created
FROM "DBHive"."dbo"."Comments"
WHERE author = 'drlobes' AND YEAR(created) = 2022 AND MONTH(created) = 12
GROUP BY title, net_votes, created
ORDER BY created
'''
cursor.execute(SQLCommand)
results = cursor.fetchall()
for result in results:
if result[0]:
print(f'title: {result[0]}, Net votes: {result[1]}')
Thank you both @arcange and
@balaz and
@geekgirl who did some work in the past to inspire others!
RE: Can we add the ability to filter our Hive posts?