The HiveSQL Proposal

avatar

With a full time job and other new hobbies taking up much of my time these days, I'm a long way from the 10 or so hours I used to spend on Steem each day. Back then I rarely missed a post of note and felt I had much more awareness of what was going on, at least on the surface.

image.png

Today though, I received a comment from (Witness) @arcange asking politely if I could review his proposal to....

Make HiveSQL Free Again!!!!!!!!!!

How did I miss this one!? It is, for me (but perhaps not for you), a hugely beneficial proposal (to the tune of 40 HBD a month), and I have obviously cast my vote on it today.

And it's so close to being funded :)

As @arcange writes in the proposal, SteemSQL started out free and with a little background knowledge in SQL (although @arcange would say differently and frequently lambastes me for writing inefficient queries), it was a great opportunity to dig into the blockchain data to see if I could find anything worth presenting.

I would guess that over 200 of my 937 (now 938) posts have used this tool, and many of them have proven quite popular over the years, even if what they present is just for shits n giggles.

And of course, the Engagement League uses HiveSQL.

For over 3 years now, this weekly post has been produced each Sunday (bar 2/3) and thanks to those taking part, is often the most commented post of the day.

image.png

When @arcange did start charging, the cost was low and as the post received good support I soaked up the cost, and the prizes for a while. In 2018-19, I was lucky to get funding from @curie for the prizes and the post continued receiving good support - it was worth my time and effort for sure to pay the 10 SBD (2018) and the 20 SBD (2019).

These past twelve months, the cost has been 40 HBD for 30 days, which was was a reasonable hike up from 10 and 20 SBD. Again though, I have been fortunate with support on the post and with prize sponsorship funds from @azircon, @justineh, and @innerhive.

This sponsorship though is unlikely to continue forever (with 2 of the above seemingly not around much any more) and the funds they donated will run out in 11 weeks time. Paying the 40 HBD a month as well as 200 odd HIVE each month in prizes has been a worry of mine. I would like to continue the league and would (if the proposal didn't appear) continue paying the subscription, but I think the prizes each week would be much lower, or 0.

If @HiveSQL was to become a free service again and post support continued, I would likely be able to fund the weekly prize pool myself.

And so, if you are a part of the Engagement League, or happen to think that it has encouraged engagement and boosted retention during this long winter, both I and @arcange would appreciate a vote on the proposal.

https://peakd.com/me/proposals/138
https://wallet.hive.blog/proposals


If this proposal is funded, the door is open for those of you who do fancy picking up a little SQL and having a look at the blockchain data. It's honestly quite easy to get started!

All you need is a tool to connect to the database: https://www.linqpad.net/Download.aspx

A look around the tables (or views), to figure out what information is stored where, and then a little googling. There are a load of SQL resources online, and if you add hive.blog or peakd (or even abh12345) to the search, you'll find some queries related to the database structure to get you started.

Want to know how many (top level) posts someone has written?

SELECT COUNT(*) FROM COMMENTS WHERE AUTHOR = 'abh12345' AND DEPTH = 0

Or comments? (any post which isn't at top level)

SELECT COUNT(*) FROM COMMENTS WHERE AUTHOR = 'abh12345' AND DEPTH <> 0

Or how much you've sent someone?

select amount_symbol, 
sum(amount) 
from txtransfers where [from] = 'abh12345' and ([to] = 'steemsql' or [to] = 'hivesql')
group by amount_symbol

Or where your votes have been going?

select author, count(*), sum(weight)/10000 -- /10000 will give equivalent of 100% votes
from txvotes 
where voter = 'abh12345'
and timestamp > '03/21/2020 15:00:00' -- Hive blockchain arrived!
group by author
order by sum(weight) desc

There is a lot to play with, and @arcange has always been helpful to me when I've got stuck with something. And, I'm sure there are other people knocking around who could help in the Hive chain Discord: https://discord.com/invite/kyEFDfT


I would love to see the EL crew push this one over the line :)

https://peakd.com/me/proposals/138
https://wallet.hive.blog/proposals

Cheers

Asher



0
0
0.000
27 comments
avatar

Well it already had my vote but hoping more get involved and give it a nudge over the line!

0
0
0.000
avatar

I'm surprised no-one dropped it on this weeks post comments, or maybe they did and my part-time ass has not seen it yet :)

Good stuff, I hope it'll be funded when I wake up!

0
0
0.000
avatar
(Edited)

Thanks to Ash’s request and lobbying. The proposal got my vote :)

0
0
0.000
avatar

Thank you!

This should mean I won't need to come to you with my cap upside down in a few months time😬

0
0
0.000
avatar

Since you are my witness proxy, that means my vote is auto given correct? Or do I need to vote myself on proposals?

0
0
0.000
avatar

I think my vote comes with your backing. I see ‘proxy’ HP on the link above so assuming we are set :)

0
0
0.000
avatar

Good, I thought it still worked that way, but wanted to be sure.

0
0
0.000
avatar

Hello dear friend @ abh12345 good night
I really appreciate this information
The vote of support has already been cast.
I take this opportunity to wish you a splendid night and a happy rest

0
0
0.000
avatar

Once i was very interested in SQL, but failed keep that passion. Still looking all programing or web desining, and feel wonder how it has stablished with very smoothly. Hope you will find a very strong point in that near project.

0
0
0.000
avatar

With a free service, if you have even a little SQL knowledge, the HiveSQL DB must be an interesting one to look at?

0
0
0.000
avatar

Wow, Asher, I don't know how to thank you for helping to fund this proposal.
Your post helped it cross the last mile and it's now funded, to the benefit of all!
I am really grateful to you. Thank you! 🙏

0
0
0.000
avatar

It’s my pleasure to help!

The SQL view of the blockchain has been hugely beneficial to me during my time here, and the possibility of it becoming free again is awesome for myself and all who wish to play.

Special thanks to @azircon for the chunky vote earlier today 😁

0
0
0.000
avatar

My view of the proposal system is very clear. Stakeholders want to support proposals if they are reasonably priced and have well defined goals and products to show. The owner of the proposal must lobby for it. It is that simple.

0
0
0.000
avatar

Indeed. Well I think arcange has shown the service to be a good product over the years, and I hope that continues with the funds to support.

0
0
0.000
avatar

Happily my support also goes to this side, Vote done.
And best wishes for this proposal.

0
0
0.000