Interesting, but what is the nature of the query?
Is this something outside of PeakD/Hive's website that you use it for?
I'm maybe not fully-aware of everything that the chain is used for.
You are viewing a single comment's thread from:
Interesting, but what is the nature of the query?
Is this something outside of PeakD/Hive's website that you use it for?
I'm maybe not fully-aware of everything that the chain is used for.
The site ought to make it clearer https://hivesql.io/
lol not really. I actually went there before I asked.
I understand what an SQL database does, but what I'm trying to understand is what the benefits of running it locally are if you're a user.
If I were developing a Hive application I assume it would be useful, but as a regular user does it improve performance of the website if you host it yourself?
Peakd(the Hive site I use) sometimes if I want to switch nodes for performance. I've never tried it, but if I had the SQL database locally would that count as a node I could switch to?
The database is not local on my PC. I just run queries against the one hosted by that service. It is kept up to date with transactions so others will use it too for their applications. I mainly use it for the #BritList and a few other queries. It is a separate thing to the nodes that host the blockchain itself.
I just had to install the Microsoft libraries to run the queries. I have not run a server myself.