RE: Disclosure: Ai, Open-Source, and Linux | Separating Ourselves From The Clanker-Lovers
You are viewing a single comment's thread:
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.
0
0
0.000
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.
When are your stupid friends going to stop killing Hive 😂
I just read your BritList to understand more, and I think I get it.
You can figure out who is British or even British ex-pat by querying the database? If so, that's kind of wild honestly. And this is what I meant when I said I don't fully understand everything about Hive and what it can do.
Just out of curiosity. Do you recall what the Microsoft libraries are? Maybe something related to .NET if I had to guess.
I have a script that looks at account profiles in HiveSQL to see if they contain UK locations. There is some manual work to check those. I put those names in a file that the other script processes to create the post by checking recent activity.
I installed msodbcsql from here. Just had to find a version that worked as there were issues with the keys.