Yeah I think a lot of those tech instructional channels use it to get around the language barriers.
The hardest part of making my videos is talking into the camera, hands down.
It's the part I dread the most too, but that's partially because I do it on the 2nd computer in the studio and every time I do it there's a whole process.
It also matters which camera I use.
But second hardest is simply recording the dialogue itself because it can come across too flat or like reading which I often am doing.
There's a long-running joke that having a British accent is a major positive for doing dialogue because so many Brits have major gaming channels etc.
And the sound of your voice is definitely a factor in the appeal of content like mine.
In the video I'm working on right now I used a website that lets you generate Keanu Reeves voice, but just so he can say "SystemD". Because I've edited in some humor based around the movie A Scanner Darkly which revolves around a drug called Substance D.
But doing it all these times, and realizing when it's not good enough is how I've gotten better. And everything else has improved with effort too. My thumbnails, my graphics etc. But I can edit and design more on a whim when I feel like it vs recording where I'm stopping everything to record.
What is HiveSQL for exactly?
I've done web dev before, and so I've managed MySQL or MariaDB and other SQL databases. Do you host your own Hive blockchain node? Is there a reward or payout of some kind for doing it?
And you mentioned figuring out Microsoft packages so does that mean you're needing to use Wine to run it on Linux? I'd think anything SQL-like would have a native Linux package.
HiveSQL is a SQL Server instance
that is kept up to date with the blockchain data so it's easy to query. @arcange runs the one I use and I'm not sure if there are others. There is also HAF that in don't fully understand, but it may also allow queries. I have also used a library for direct blockchain access, but that was slower.
I needed the MS library for the Python queries to work. They provide it for Linux.
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.
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.