HiveSQL Proposal Renewal - Keep It Free To Use For The Community

avatar

TLDR;

  • The active HiveSQL proposal will expire at the end of this month.
  • This new proposal aims to continue to provide free access to HiveSQL Services to the community
  • You can support the proposal here.

What is HiveSQL

HiveSQL is a publicly available Microsoft SQL database containing all the Hive blockchain data.

It allows apps and users to access structured data efficiently, perform analysis, or find valuable information quickly.

By eliminating the need for local blockchain copies or extensive data downloads, HiveSQL provides fast query results, often in seconds, to complex blockchain questions.

HiveSQL history

Launched in 2016 at the very beginning of the blockchain's life, HiveSQL has been central to many apps building on top of the Hive blockchain from the start.

Initially free, growing costs necessitated the implementation of a funding proposal to maintain its services. Over the years, HiveSQL has undergone several infrastructure and code upgrades to ensure peak performance.

Over time, with more and more users and applications relying on HiveSQL for their proper functioning, operating costs started to climb.

HiveSQL has regularly undergone several code reviews [1][2][3][4][5][6][7].
It was also necessary to carry out several infrastructure upgrades [1][2][3] to be able to keep performances at their best level.

HiveSQL provides extensive documentation, which now serves as a reference for many developers. It is available at https://docs.hivesql.io

Well-known Hive applications that rely on HiveSQL to operate include Peakd, Hive Keychain, 3Speak, Worldmappin, Travelfeed, ... as well as websites like DappRadar, Staking Rewards, HiveTools by @primersion, HiveAlive by @ura-soul. The list is of course not exhaustive.

Technical Insights and Metrics

HiveSQL has been operational for 8 years, and its database has grown to over 5TB, with certain tables nearing 4 billion records. Annually, the database expands by nearly 1TB, highlighting the significant volume of data generated daily by our blockchain.

Every day, HiveSQL processes around 16K requests per minute (with peaks up to ~28K requests/min) (graph), 5K table scans per minute (with peaks up to ~15K scans/min) (graph) daily servicing an average up to 71 Hive applications (graph) which generate between 50K and 200K lock requests each second! (graph).

At times, HiveSQL processes several million index scans per minute, demonstrating how intensively Hive applications use it, but more importantly its capacity to manage extensive data operations efficiently.

Regarding availability, HiveSQL's SLA is close to 100%. Despite a major attack at the beginning of the year which required rebuilding the infrastructure, HiveSQL has been 100% available as usual since then (graph).

Why a proposal?

The goal of this proposal is to keep HiveSQL free to use and allow the greatest number of developers and users to benefit from this tool to develop their applications and services for our ecosystem.

1. Infrastructure and maintenance costs

Delivering top performance requires robust infrastructure and services and is a costly endeavor. This proposal aims to keep HiveSQL free to maximize its utility across the Hive ecosystem by supporting a wide range of developers and users.

Since its inception, HiveSQL has proven to be reliable, responsive and highly available.

Providing such high-quality services is not free. Setting up, monitoring and maintaining such an infrastructure requires a lot of attention. Maintaining and monitoring the processes that inject data from the blockchain into the database also requires its share of the work.

2. Empower less fortunate developers and users

While HAF (Hive Application Framework) offers users the flexibility to deploy an SQL infrastructure on their own setups, it comes with the burden of management, security, backups, and regular updates, all of which can add significant operational overheads and costs.

In contrast, HiveSQL is a fully managed and shared infrastructure that relieves users from these technical burdens. It is instantly available and capable of delivering enterprise-class performance without the need for management and maintenance efforts. This allows developers and users to focus on what truly matters: building and enhancing applications without worrying about infrastructure-related challenges.

HiveSQL serves as a robust, cost-effective solution, especially for those who wish to access blockchain data without incurring additional logistical hassles.

It's important that everyone can take advantage of the huge potential that HiveSQL offers to Hive in terms of supporting applications, analytics, or any other use case.

3. Grow the hive ecosystem

HiveSQL is a powerful, fast, and efficient tool.

By making HiveSQL accessible to as many people as possible, within the Hive community and beyond, it can help Hive grow.

If we give users and application developers free and easy access to our blockchain data, we provide them with the perfect tool to develop their business and services, thereby facilitating the onboarding of more users.

4. Infrastructure Update

While there have been no major changes to the HiveSQL database due to relatively stable data structures, the existing infrastructure is slowly nearing its performance limits.

In the coming year, plans are in place to upgrade HiveSQL with expanded storage, more powerful processors, and potentially additional memory to maintain its high service levels as demand grows.

Request for Funding

This proposal request is to cover current and future costs in terms of infrastructure and human resources so that HiveSQL can continue to run and enable developers and users to use it for free.

The operational budget is based on the following elements:

1. Infrastructure and services

  • SQL Server (including license)
  • Dedicated Hive private API node
  • Firewall + IPS
  • Security management and monitoring tools
  • Performances monitoring tools
  • Backup services
  • Language identification services

2. DevOps

  • Infrastructure maintenance and updates
  • Code maintenance
  • Support to users and developers

3. WebOps

  • HiveSQL.io website maintenance and update
  • Documentation maintenance
  • Tutorial creation and maintenance

Based on our past experience, we are requesting a budget of 135 HBD per day for the next two years, maintaining the same level of funding as in the previous proposal.

Interesting links

Main website: https://hivesql.io
Documentation: https://docs.hivesql.io
Service status: https://hivesql.io/status
Support is provided on Discord

Let's keep HiveSQL free to use!

Support This Proposal:

Thank you for your support!

hive-139531 hivesql proposal hive sql database
0
0
0.000
30 comments
avatar

Got my vote ! I've been looking at Hive Dapps recently, just to get a picture of what's out there, and it's made me realise how many of them need HiveSQL to function.

0
0
0.000
Reply
avatar

I don't understand anything about this geek stuff but I get it's pretty important. You have my vote ✌🏻

0
0
0.000
Reply
avatar

Unfortunately, the DHF is being mined by substantial stakeholders, demonstrably involving criminal fraud. Until stakeholders rein in the DHF proposal exuberance I can only recommend voting the return proposal. While I would happily support your work, until and unless you and other OG stakeholders establish critical accounting procedures necessary to prevent financial fraud mining the DHF, I will continue to refrain from supporting any DHF proposal other than the return proposal.

Sorry, but I have no other recourse to end the theft by fraud ongoing via DHF proposals. No apps, no onboarding, no services will be beneficial to Hive when it is stripped of it's principal development assets through theft by fraud using the DHF proposal mechanism. This ongoing theft is an existential threat to Hive.

I urge you to withdraw your proposal, to unvote all DHF proposals except the return proposal, and add your voice to the call for standard accounting procedures to rein in criminal theft by fraud of the DHF that is ongoing.

Thanks!

0
0
0.000
Reply
avatar

Thanks for speaking out on this problem. I'm glad I'm not the only one who sees what's going on behind people's backs.

0
0
0.000
Reply
avatar

How can I educate myself to understand and recognize this "fraud via DHF proposals" in the future ??

0
0
0.000
Reply
avatar
(Edited)

Read the testimony of eyewitnesses that allege fraud to have occurred, as has been stated regarding Valueplan. @blanchy's posts regarding Valueplan expenditures and the lack of accounting provide a solid background, and the refusals of Valueplan principals to provide proof of specific expenditures fail to refute the allegations of fraud and possible kickbacks that have been made.

Below are a few posts that provide details referenced above. I hope you agree that the DHF requiring recipients of DHF funds to use generally accepted accounting practices to demonstrate that theft by fraud of DHF funds is not occurring is the least we should do to prevent the unacceptable theft of the Hive community's development fund. I also hope I have provided information that answers your question, and you feel free to ask any more questions you many have.

Thanks!

https://peakd.com/hive-167922/@blanchy/valueplan-the-numbers-october-part-ii-ytd-totals

https://peakd.com/hive-145796/@hecatonquirox/tskysnkj

https://peakd.com/hive-167922/@hecatonquirox/minecraft-shows-you-how-value-plan-is-throwing-hive-money-down-the-drain-93n

https://peakd.com/hive-181335/@atlashv96/crywyiwp

https://peakd.com/life/@valued-customer/valueplan-strategy

https://peakd.com/life/@valued-customer/fixing-valueplan

0
0
0.000
Reply
avatar

Can you show us your expenses?
I used to run up to 25 websites, including up to 15 SQL databases, all for $6 per MONTH and you want $135 per DAY!??? Why such a discrepancy?
And your own records show you haven't updated your work in 2 years, so manpower has been ZERO.

0
0
0.000
Reply
avatar

HiveSQL handles a significantly larger volume of data and requests than typical website databases.
I doubt you can run and maintain an infrastructure like HiveSQL for $6, but if you're up to it, I invite you to do so.

0
0
0.000
Reply
avatar

Nice try at giving an obfuscating answer. SHOW us exactly what it costs. Of course it will cost more, but THAT much more?

0
0
0.000
Reply
avatar

Hello hivesql!

It's nice to let you know that your article will take 13th place.
Your post is among 15 Best articles voted 7 days ago by the @hive-lu | King Lucoin Curator by szejq

You receive 🎖 0.2 unique LUBEST tokens as a reward. You can support Lu world and your curator, then he and you will receive 10x more of the winning token. There is a buyout offer waiting for him on the stock exchange. All you need to do is reblog Daily Report 513 with your winnings.

2.png

Invest in the Lu token (Lucoin) and get paid. With 50 Lu in your wallet, you also become the curator of the @hive-lu which follows your upvote.
Buy Lu on the Hive-Engine exchange | World of Lu created by szejq

If you no longer want to receive notifications, reply to this comment with the word STOP or to resume write a word START

0
0
0.000
Reply