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.