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?
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?
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.
Yeah - HiveSQL is a service that works well for years
There is nothing "bad" to use MS SQL instead of an open source product.
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.
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.
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?
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....
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:
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.
Replied here https://peakd.com/hive-167922/@arcange/re-getron-rnjzya
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.
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.
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.
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.
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.
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!
Replied here https://peakd.com/hive-167922/@arcange/re-getron-rnjzya
Don't need to, just use HAF like it was intended.
Enlighten me more about HAF?
Any links are appreciated.
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.
Interesting, I will look more into it.
Are there any docs available related to this?
You have it here:
https://peakd.com/hive-139531/@mickiewicz/what-is-haf
Thanks 👍 :)
I was looking for some frameworks to study especially these days
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...
I'm just not sure, if we use HAF, do we need HiveSQL, which is relaying on Microsoft SQL?
There currently isn't a HAF solution, one would need to be created.
so HAF framework is there but no SQL service solution yet?
An indexer service would need to be created.