Putting a hold on Engagement Project because of HiveSQL

avatar

Good morning to everyone . Not a happy announcement from my side today .

HiveSQL subscription mode

Yesterday I received a transfer from @hivesql with this memo

image.png

My engagement project depends on HiveSQL completely to retrieve the data and calculate . Since as you can see in the memo I need to pay to use this from now on , I have decided to put a hold on the Engagement project till I can figure out what to do .

Can I afford it?

If you follow me or my engagement project you may have already seen that I don't take my cut in these projects . Every single curation rewards + the curation account author rewards are paid to other delegators .

I haven't taken out anything from it so yeah I can't afford it . 4 HBD per day is too much for me as well as 40 HBD per month .

Is this the end of Engagement Project ?

Absolutely not . I always like to think positive and solve problems . I see two ways of solving this -

  1. Try to write a whole new script which doesn't depend on HiveSQL .
  2. Wait for HiveSQL to go back to free mode .

Unfortunately , I can't guarantee the 1st one yet because I am bombarded with so many issues in my real life right now .

If you haven't yet voted for the HiveSQL proposal , I request you to do it - it is created by @arcange

https://peakd.com/me/proposals/138

My request to delegators

We would most likely see less dividends this Sunday due to this so I would like to request you to not come to a conclusion that this is the end of the project . By sunday I will try to see what other ways are there to continue with our project and if I find , I will update you on it .

If I fail to find an alternative , I will inform you to take back your delegations .

HLS tool update

Right now , I have disabled some features which were dependent on HiveSQL but some other features are as it is . I will make a detailed post regarding this soon .

Regards,
MR

Posted Using LeoFinance Beta

proofofbrain ctp palnet neoxian archon mancave leofinance
0
0
0.000
55 comments
avatar

Congratulations @amr008! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You distributed more than 14000 upvotes.
Your next target is to reach 15000 upvotes.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Support the HiveBuzz project. Vote for our proposal!
0
0
0.000
Reply
avatar

Thanks for running the project up until now. I hope it gets resolved soon enough. I don't know what to make of the HBD situation since its getting plenty of funds right now and it seems to be failing to get pegged. I think we may have to wait for the hard fork to see any substantial progress.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

That was going through my mind too. I don't understand the HBD stuff despite reading a number of posts about it.

!ENGAGE 10

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar
(Edited)

HBD stuff as if you were 5

HBD price is no more pegged to USD and is above $1, let's say $2.

  • Issue 1
    Proposal asking for 100 HBD (equivalent to $100) now receives 100 HBD but worth $200
    Stakeholder consider the proposal is overpaid
    Stakeholder remove its vote from the proposal
    Proposal go down in the ranking below the Return Proposal
    Proposal is no more funded

-> Solution: the proposal needs votes from the (other) stakeholders

  • Issue 2 (cf. my reply here to @finguru)
    @hdbstabilizer proposal is created to try to peg HBD back to $1

    DHF daily budget is HBD 10000 per day.
    Proposal ranked #1 ask for HBD 100, is funded and receive HBD 100
    Proposal ranked #2 ask for HBD 19200, is funded and receive HBD 9900
    Proposal ranked #3 ask for HBD 100 is "approved" but receive HBD 0 (i.e. it is unfunded)
    -- Return Proposal (ranked #4)
    Proposal ranked #5 ask for HBD 100 is "unfunded" and receive HBD 0

-> Solution: the proposal needs more votes from the stakeholders

0
0
0.000
Reply
avatar

Thank you for your engagement on this post, you have recieved ENGAGE tokens.

0
0
0.000
Reply
avatar

I am working on it . Will try to fix it tonight by writing a new script . Will update tomorrow.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

This is a shame but not unexpected. The cost will price out many accounts from being able to use the service.

0
0
0.000
Reply
avatar

I agree . Right now I am writing another script which uses Beem Api but it takes a lot of time but I guess it is okay as long as the project continues .

What are you planning to do for hive engagement league / leofinance engagement league if it doesn't get resolved by then?

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

That's bad. I see that the proposal is being funded (Support level is 100%) so why did they go back to the subscription model? Any particular reason?

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

While being above the Return Proposal (#0), the hdbstabilizer proposal (#169) is "eating" all the DHF daily budget, meaning HiveSQL is effectively NOT funded.

image.png

0
0
0.000
Reply
avatar

I asked the very same question to arcange on discord in the morning and he replied the same which he replied to you here .

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Let's hope they get funded soon and you start this project again. Cuz I was thinking to invest bro. 👻

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

That's a shame but I understand your decision. There seem to be a number of projects that will no longer run due to this. I don't understand the bigger picture of the HBD problem but I hope it gets sorted out soon.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

I agree . I wish I had written a backup script though . Right now I am trying to write one , hopefully I will finish it tonight.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Sorry to hear this, i hope you kickstart the project but what would be the status of those who delegated to engagement project?

Posted via proofofbrain.io

0
0
0.000
Reply
avatar

I am trying to write a new one right now . Hopefully it works in the same way .

Regarding delegation , I suggest not to take it out right now and wait till Friday or saturday .

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar
(Edited)

This is a good project and instead of looking only towards the APR i am also looking forward for the sustainability of this project as this is the only project which will help the communities or as we call hive based tribes to keep engaged. I will not pull out from the project and will wait till next updates

Posted via proofofbrain.io

0
0
0.000
Reply
avatar

HiveSQL is a really handy tool. I will vote for their proposal (for what my tiny vote is worth), and would be interested in looking into other ways to query the chain.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

I think the best solution, if you have the skills (which it sounds like you have) is to make a program that accesses the blockchain directly.
If you think this will take time you could consider paying for one month or two for a subscription until you have your own program up and running.
This way you keep the project alive while making the program.

You're doing a great job which encourages interaction and commenting.

0
0
0.000
Reply
avatar

That's a solid solution I think, don't might a lower return either if it's temporary so the costs can be compensated

Posted via proofofbrain.io

0
0
0.000
Reply
avatar

Yeah that is true but storage will become a problem to be honest . I can run a bot which stores all data into a MySQL but it just keeps getting bigger and bigger .

Since HiveSQL does the same and it was free , there was no need for me to do this .

Right now I am exploring other options and will keep in mind what you have said . Thank you.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

You'll have to evaluate how much history you need.
I don't think you have to save the whole history of the blockchain.
You could make something that purged the database of outdated history.
That way your database would not get to big.

If you set a hard timelimit on the comments that would be counted like maybe only comments within 7 or 14 days.
This would reduce the amount of data you would have to keep stored at any given time.

0
0
0.000
Reply
avatar

I voted in favour of the proposal. I think a paid HiveSQL could make sense, but this high flat rate seems rather unreasonable, given that usage can fluctuate dramatically?

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Yeah that is true . Since 1 HBD isn't equal to 1 USD too , it will be difficult for me to afford it . I am writing a new script right now , hopefully it works .

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Sad to hear but thanks for the quick update, will keep the delegations for now and await further news. Any chance you could actually take a cut and pay the costs with that or won't that be sustainable?

Posted via proofofbrain.io

0
0
0.000
Reply
avatar

I haven't ever thought of this to be honest but I think it is time I take my cut ( atleast 50% ) . I will see for 2 weeks how much my cut is worth so that I can use it for subscription.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

I'm sure we'll hear about it in an update, hope it works out

0
0
0.000
Reply
avatar

That sucks. I don't have a solution to the issue right now but I would be willing to donate a couple HBD a month to keeping you active on this. I also think you should do a Hive post strictly as a "raise" for this purpose. Take the payout and use it for paying for your subscription. At least do it for the first month. That would buy a month of time to for you to figure out a more permanent solution. Maybe that would BE the permanent solution. One post a month for "subscription" purposes and then take a little from the delegations if needed via votes.

Personally, I think what you do is too valuable to the platform to let it end.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Thank you for volunteering to donate , I really appreciate it . I am currently writing a script which doesn't use HiveSQL but I am not sure how long it will take and if it works in same way . If I can't figure this out ,then I have to go for the methods which you have mentioned here .

Personally, I think what you do is too valuable to the platform to let it end.

Thank you very much :)

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Dang, that seems like a lot of money for a service. You are talking like $80 per month at the current prices. I'd offer to send you some HDB to cover it, but I honestly feel like they are taking advantage of you. It seems a though writing your own stuff might be the better option.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Yeah and since HBD isn't stable right now , I can be paying more than 80$ too which I don't think is worth it .

I am trying to write a new script , will update tomorrow.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Looking forward to it. I agree with you and I think you are making the better choice.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

I'm not taking advantage of anyone. I invite you to read the HiveSQL proposal that describes in great detail why subscriptions are so expensive, and why I put so much effort into making HiveSQL free again thanks to DHF.

Unfortunately, some see it as a niche service that does not deserve support. It is regrettable. It is a short-term view which is a pity.

Going towards an alternative solution is of course possible, but I am not sure that it will be less expensive.

0
0
0.000
Reply
avatar

$80 a month just seems like a lot. I don't even pay that for my Cable bill and they are the worst at screwing you over. Maybe taking advantage wasn't the best term. Does the cost adjust based on the price of HBD or is it always 40 HBD? I haven't messed around with SQL since college so I will just take your word for it.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

I know it's a lot. The main problem is HBD is not fully pegged to $1 and too volatile now.
And adjusting the subscription fee according to HBD price variation would be too cumbersome: updating processes, updating the website, updating communication, ... 😓

0
0
0.000
Reply
avatar

Yeah, the HBD price moving so much doesn't help. I voted on the proposal. I hope it pushes through for you.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Thank you for your vote.
Maybe this was the boost we needed because the proposal is now back funded!
Woohoo, HiveSQL is free again! 🎉

0
0
0.000
Reply
avatar

I understand the need for that amount of funding , I really do . I appreciate everything you have worked on to be honest . It is a great tool for an analyst like myself . I hope we all can work together in making it free again .

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Sad news indeed. I have voted for proposal #138.

I for one would be willing to take lower returns for a period of time for you to renew the subscription and keep the project running. Or a way for us to donate to you to keep the subscription might work also.

Thanks for all you do. :)

Posted via proofofbrain.io

0
0
0.000
Reply
avatar

Thank you very much @oldmans . I really appreciate you volunteering to donate . Right now I am working on a new script , hopefully I finish it tonight .

Will update tomorrow on how it went so that we can decide how to move forward.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Sorry to hear that, my friend :(

Thanks for all your dedication so far and I hope you are able to resume this great project as soon as possible. I have voted for the proposal.

Let me know if there is any other way to help.

Posted Using LeoFinance Beta

0
0
0.000
Reply