Let&#x27;s Keep HiveSQL Free!

getron last year

Why HiveSQL is using closed source Microsoft SQL? Why not Open Source SQL, something like MySQL, or PostgreSQL?

Microsoft doesn't belong here in open source Hive world, we don't need it here. Therefore, why we use it anyway?

detlev last year

Do something similar, run it on different redundant server, maintain all this so that as many projects could rely on this.

#HiveSQL does all this for so many different projects here on the chain.

I don't care if the DB underneath is a MySQL, MS SQL, DB2 or any other - as long as it runs all the time.

Let me know when your service is available and I will vote for it as well.

themarkymark last year

Don't need to, just use HAF like it was intended.

0.00 VYB

9 votes

dlmmqb last year

Enlighten me more about HAF?

Any links are appreciated.

0.00 VYB

themarkymark last year

HAF was a recent addition to hivemind where you can store state on a node and have it decentralized to other nodes.

So instead of a dapp being a centralized database you can put the code on a hive node to maintain it’s state. This can be done with multiple nodes to increase the decentralization.

HiveSQL like functionality is a perfect use case. Although it would take a lot of space, would be impractical on all nodes.

0.16 VYB

11 votes

dlmmqb last year

Interesting, I will look more into it.

Are there any docs available related to this?

0.00 VYB

getron last year

You have it here:
https://peakd.com/hive-139531/@mickiewicz/what-is-haf

0.10 VYB

dlmmqb last year

Thanks 👍 :)

I was looking for some frameworks to study especially these days

0.00 VYB

detlev last year

Hey @themarkymark this is indeed a very good point.

As I lost a little bit track on this, I will read myself into this.
Are there already many projects using it?

Anyway, merry Xmas and always clean and good data...

0.00 VYB

getron last year

I'm just not sure, if we use HAF, do we need HiveSQL, which is relaying on Microsoft SQL?

0.00 VYB

themarkymark last year

There currently isn't a HAF solution, one would need to be created.

0.00 VYB

7 votes

woelfchen last year

so HAF framework is there but no SQL service solution yet?

0.00 VYB

themarkymark last year

An indexer service would need to be created.

0.00 VYB

9 votes

getron last year

It sounds like you would say: "Why we need decentralized Hive cryptocurrency, we have fiat currency, and i'm happy with fiat, it works... " But, you need a bigger picture, like with fiat, you are bounded to the fed and country fiat currency, if you use it and all of the problems it comes with it. The same is with Microsoft database, one day, because, you are using it, and you (we) must accept the agreements on it (because we use it), Microsoft can change the way it works, or the way it injecting stuff on it, for example, tracing, etc. like it does with windows, and many other stuff. Windows is working too, if you just blindly use it, and have no interest on your privacy, but, you need to known how and what they do in background, and you change your mind soo quickly then, if you find out and known what you compromise from your privacy and freedom, just with use of Windows, you will sooo quick want to change to something like Linux.

The both other databases works great all the time with many projects, no problems with either.

I just don't understand @arcange why relaying on closed and bounded to Microsoft licences Microsoft SQL, and not on Open Source DB, like MySQL or Postgres, for a free and open Hive?

0.00 VYB

arcange last year

Replied here https://peakd.com/hive-167922/@arcange/re-getron-rnjzya

0.00 VYB

detlev last year

This is complex and here I don't care which database is in the middle as MS has no access to the data.

Let's think of an example.
Next week I like to go from Berlin to London.
So I choose a train (MS SQL) or a bus (DB2) or a plane (MySQL). No speed judging here....
For me, the journey is the thing I like to get done and
not the type of bus or the type of plane.

If you can build a similar system with a central database from any manufacturers, where you have all devs of Hive apps searching way faster for the content of the #Hive blockchain, please do this with the tools you love to use.

As you see, the service is what we all are looking for and not the different parts the service is built with.

I created many services for banks, insurance, and other businesses and we had this question many many times. The result depends always on your personal view, the costs, and the way you can manage the whole solution.

This said, I'm happy to support #HiveSQL as this saves so much time. I look forward to see your or other peoples HiveMySQL project and will support this as well....

0.00 VYB

getron last year

We don't need HiveMySQl, we have it, it is called HAF, here you have about it:
https://peakd.com/hive-139531/@mickiewicz/what-is-haf

I just don't have an idea, why we still need Microsoft SQL, if we have HAF, @arcange ?

And, no, you don't understand it, what i mean:

Quote As you see, the service is what we all are looking for and not the different parts the service is built with.

We are looking for free and open world here, and not just for service to work, all of these DB works great, and are almost the same in speed, so there is no big difference. And devs can create with all of these DB dApp's, there is, again no big differences.

Like you can see, HAF is done this already.

And, don't get me wrong, we don't need closed source banks here(as a service), we built Hive and HBD as a decentralized service, and we need to build many other dApps (I agree, we just started, and there is much work to be done), to NOT need for banks, assurances, and so on.
So we fight here for this, for our free and open source world, and I don't promote the banks to save money to people, I promote Hive and HBD. The same is with DB underneath.
Like fiat, it works, but, how it works? People have ever bigger problems with it to live and to earn, in every corner of the world, just because the fact like you say, they don't care about the underneath "DB (banks)", they just continue to use it, blindly, without asking, hey what's wrong here, why i'm having trouble with fiat, how this fiat works, where are the problems... But we should don't care how the fiat works, we just should use it, in your opinion? Why then we are here, on Hive, beside making friends and collaborations, blogs and vlogs? I hope, you see now my point, it is not just about a service to work, it is about how is created and how it works.

0.00 VYB

arcange last year

Replied here https://peakd.com/hive-167922/@arcange/re-getron-rnjzya

I just don't have an idea, why we still need Microsoft SQL, if we have HAF, @arcange ?

What you don't understand is that while HAF may do the trick for some, not everyone has the skill or the will to deploy and maintain such an infrastructure.

That's where all the difference lies and that's what we call service, as @detlev so aptly described it.

We are looking for free and open world here

You seem to be confusing "we" with "I". Don't project your wishes onto everyone.

You don't like it? Don't use it.
Is it bad? Provide us with something better (according to your criteria) with the same level of quality of service.

0.52 VYB

getron last year

Hi @arcange , sorry if you get me wrong here.

It is not that i don't like it, and it is not that it doesn't work, I like the Hive and it works well - for now.

But my concerns are, what if, in couple of years, the Microsoft decide to change their policies and certificates (and trust me, they can this, because, we see, in the world, what of power they have to change and influences the peoples lives in the plandemic...), for example, to unsupport, or not accept our decentralized Hive, just some one centralized crypto (done by Microsoft) what their will make, centralized, etc. (it can be, because of the control they don't have here in Hive, or decentralized world). What will be then? Where is going the Hive then? Because, the main engine Hive is working with, or on, is the Microsoft closed DB?

These are my main concerns, and not that it doesn't work ok. Yes, it works great this DB, for now. But, one change in the policies or certificate, and we are somehow destroyed, because of this change.

Therefore, I just want to appeal on devs like you and other, to think about this for a second, and prepare for the future. And yes, i known it is hard to do it. I don't think Hive it was not hard to do, but, we have it, and maybe in couple of years, we don't need fiat anymore, because of great devs have done excellent work with Hive and crypto.

Hope you don't get me wrong, and understand what i mean. Maybe is time to think about future, and not relaying on any of these corporate things. That's what I meant.

0.00 VYB

arcange last year

I don't get you wrong but, sorry to say, with such a FUD mindset, we should no longer trust and use any private or centralized entities' products or services such as car manufacturers, public transport, connected washing machine manufacturers, ...

I have been working with Microsoft products for years and I do not see why or how they could "unsupport, or not accept our decentralized Hive". I'm pretty sure they don't even know what Hive is or they don't give a damn. Should something happen anyway, I have already analyzed alternatives, which currently do not satisfy me (for many reasons which I will not elaborate in detail here). So I'm not that unprepared.

0.00 VYB

detlev last year

I love open source and we produce and use it in many ways.

Our discussion drifted a bit away from the core question about HiveSQL to Fiat and other things.

But we should don't care how the fiat works, we just should use it, in your opinion?
Naa, here you mixed something up - I love and supported hive and crypto for many years.

HAF is an interesting concept and based on our discussion, I will have a deeper look into this and will write a little report about my own results of comparing all this.

Anyway, I enjoy this kind of discussion as we all learn something new. Thanks for your time and efforts. You got a new follower!

0.00 VYB

arcange last year

Because my choice was not ideologically driven and when I created HiveSQL it was MS-SQL which was my area of expertise.

What I provide with HiveSQL is a service and my goal is that the service provided is reliable, available and efficient. HiveSQL is a complex infrastructure with Hive nodes, a backup system, a firewall, performance monitoring, etc... it's not just a database choice.

When I did, many told me I was crazy to publicly open access to a database server to potentially thousands of users. Several other similar open-source initiatives have also emerged. I'll let you guess the rest of the story.

Do you consider it bad because it's not decentralized? Set up your own "decentralized" infrastructure and prove that you are a reliable player over time as I did for years.

0.01 VYB

detlev last year

Yeah - HiveSQL is a service that works well for years

There is nothing "bad" to use MS SQL instead of an open source product.

0.00 VYB

getron last year

My friend, no, you don't understand what i mean.

It is not about rivaling us mutually, and is not about that i think is wrong what you are doing - the job you are providing is excellent, therefore i support your proposal, i voted your proposal for HiveSQL.

But, just to slowly start to rethinking for the future, to not relaying on some of big tech company, because, we see, they can from one day to another change their policies, and we are screwed then.

And no, I have not such expertise in DB like you have, and I don't have better infrastructure as yours, this is not what i meant with this.

Hope you understand, again, what i meant.

0.00 VYB

ijelady last year

Thou i dont know much about HiveSQL and how it works, i love points you made clear here why it should be free. It is a useful tool on hive which helps not just users but developers. I am going to read more now to learn.

cocacolaron last year

I don't have much Hp but I hope my vote helps in some way, merry christmas

detlev last year

VOTED

since many weeks this has my full support - https://peakd.com/me/proposals/247

1.01 VYB

ijelady last year

Though i don't know much about

0.00 VYB

abdul01 last year

This is a great one. Well this is the first time of me chancing on it. I will do well to add my vote to make it stand.

Thanks for sharing 😊

0.19 VYB

arcange last year

Dear @geekgirl, thank you for the shout-out about my work and for promoting the HiveSQL proposal. I appreciate it a lot and I hope this will allow you and the whole community to continue to use it for free.

1.00 VYB

getron last year

Hi @arcange , can you give us a reason, why we need closed and with Microsoft bounded certificate Microsoft SQL, when we have now HAF (HIVE Application Framework)?

What is the main reason to keep this anymore?

I support your proposal, because you are great dev, but, I don't get it, why we need this anymore? Maybe you should switch to something more excited and open source project, like HAF, and go there with some amazing projects and proposals further?

0.00 VYB

arcange last year

Replied here https://peakd.com/hive-167922/@arcange/re-getron-rnjzya

PS: next time you have a question for me, avoid spreading it over and over again in all your comments!

0.00 VYB

djbravo last year

Yes

0.00 VYB

hivegestapo last year

Your comments are coming off as too generic, it makes you look too much like you are just fishing for votes.
This is the game we are playing, but it is best to not look to thirsty, eh?

It takes time to become known in the hive and becoming known for insincere comments is not a winning tactic, imo.

I don't know what to tell you to do differently, but I can tell you that you are getting attention in places you don't want it.
Too much of that attention and things go south real quick.

0.07 VYB

dlmmqb last year

Irrelevant comment.

0.00 VYB

chinito last year

I hope hiveSQL stays free..

0.00 VYB

lee1938 last year

I don't know much about this. Because I'm new but after reading that. I feel you sharing a really informative information. Thanks for sharing your experience.

olympicdragon last year

It's useful project. I shall voted for it just now !

treasuree last year

I didn't know about this HiveSQL , It must have been quiet difficult to keep running for so many years? I will try to vote for it , if my cote counts that is.

Merry Christmas and happy new year in advance.

0.00 VYB

d-zero last year

Already supporting it 😇

Posted Using LeoFinance ^Beta

0.00 VYB

videoaddiction last year

I will support it as an user who accumulates HBD and is paid interest rate.

india-leo last year

This post has been manually curated by @bhattg from Indiaunited community. Join us on our Discord Server.

Do you know that you can earn a passive income by delegating your Leo power to @india-leo account? We share 100 % of the curation rewards with the delegators.

_{Please contribute to the community by upvoting this comment and posts made by @indiaunited.}

0.00 VYB

olujay last year

It's interesting how many of us have no idea what is done in the background to keep Hive running as well as it does.

I am not too knowledgeable about HiveSQL concepts, but I do have that idea that it must be pretty challenging keeping it up for 6 years and still counting.

I never really thought much about all these proposals, but I am learning now how super important they are for the smooth running of Hive.

0.47 VYB

3 votes

dlmmqb last year

It's interesting how many of us have no idea what is done in the background to keep Hive running as well as it does.

My bounty offer is still available! :)

I am not too knowledgeable about HiveSQL concepts

It's a database which would be much expensive for developers to use and build stuff on hive. Thanks to HIVESQL proposal funding, I can develop my project without worrying about the high costs.

Gave u a basic summary.

olujay last year

My bounty offer is still available! :)

I'm lost.

Thanks for the basic summary, by the way.

Happy New Year in advance, DLM Santa.

0.00 VYB

jacuzzi last year

YES!! VOTED! Its a good service and one that we need to support.

korver last year

Voted for @arcange and Hive SQL proposal. I may have around almost 1k right now, supporting quality projects like this.

arcange last year

Thank you for your support @korver, really appreciate it! 👍

0.00 VYB

korver last year

You always have my support! :)

0.00 VYB

zaibkang last year

Is that Mean hive is using third party services to store all data

Is it not possible to stored all the data on chain? I knew a blockchain which which claimed they stored everything on chain, the name of this blockchain is a deso blockchain

I don't think it's a good idea to use a centerlized database to store decentralized blockchain data, we should have over own decentralized solution, I mean if it's possible we should store all data on chain

geekgirl last year

All network data is stored in Hive blockchain. HiveSQL keeps a copy of all the data, so data can be retrieved faster.

0.02 VYB

zaibkang last year

Thanks for clarification

0.00 VYB