This is exactly the kind of clever little utility that it wouldn't occur to me to search for. Solves a common problem in a really neat way. And I would never know about it except being told by someone who uses it. Great show!

I should have added in the show that there are scripts available to download the db and load the sql into a sqlite file. This is probably a much easier option if you dont have experience managing mariadb.

The scripts are in the hpr_generator project:
https://repo.anhonesthost.net/HPR/hpr_generator/src/branch/main/utils

If you try the method in the show and are getting permission denied errors, try running the commands as root. Sometimes the root user has blanket permissions to the databases.

Hi norrist.

I downloaded the database and it's only 19.1 MB in size. Is that right.

I'm not able to open it in the Flatpak, 'DB Browser for SQLite Version 3.13.1'. I get an error like "Error importing data from record number 23184. Unexpected end of file. ...

I then ran the commands in this episode page with mariadb and get errors in the terminal like 'Access denied for user 'torin'@'localhost''.

Hi norrist. Thanks very much for this. I appreciate it. :-)

Hey norrist. Thanks for the guide.

Thanks Kevie,
I am tempted to have fun and try myself! And to read the steps in detail to learn what each step does.
The command Ctrl c you mentioned is indeed a very useful one.

Hi norrist. I checked the shownotes - got it. https://hackerpublicradio.org/hpr.sql
:)

Hi norrist. Do you refer to this - "hpr4378 :: SQL to get the next free slot"? Where exactly do I download the file from? How big is it about? Thanks.

Hi. In my previous comment, 'preconception' should have been 'pronunciation' -- a spellcheck mishap. Sorry.

I just recorded a show with instructions for getting a local copy of the HPR database. You can query the database to see all your previous comments.

Hi Ken.

Thank you for replying. That episode was flagged as explicit so perhaps younger folk shouldn't have been listening. Towards the end, you even used the f-word.

I'm here more for the tech [GNU/Linux & FLOSS] but it's clear that a myriad of non-tech subjects like sharing recipes, etc. are brought to HPR.

That's a fair point with the flyer example you gave.

BTW, is there a way I can easily find all of my previous comments? I'm unsure if I did or didn't make an intro post somewhere.
How do I get a link to my user name? For example, Klaatu has https://hackerpublicradio.org/correspondents/0078.html. I presume links are only for hosts - that is folk who have posted a show themselves?

About joining the Community New show -- alas, my social anxiety gets the better of me.

As for pronunciation, just give it a go - even a bad preconception is better than none. ;-)

Regards.

Hi!

Second Life was a revolution when it came out, and it's surprising too see it prospering today in the same premises. Great and open talk that brought a good knowledge about Second Life for someone who has never used (played?) it. I will not distil philosophical inquiries that it brought to me (not able to express exactly), just congratulate you two, Lee and Elsbeth, for it.

Hi Torin,

We quite often skip over difficult to read sections in the comments, as written text often doesn't translate to audio that well. I have been know to skip comments entirely when they are too long. That said all the comments are on a RSS feed, on the website, are linked in the Community News Show notes and on the episodes, so if anyone cares they are there.

In your case I didn't read it out as the descriptions you used might cause distress to younger listeners. This is allowed under our long standing policy https://hackerpublicradio.org/about.html#not_moderated
"The audio of your show will not be moderated." ... We do not vet, edit, moderate or in any way censor any of the audio you submit, we trust you to do that. ...Please note that this only relates to the audio you upload. The rest of the meta-data, are managed by the HPR Community, and may be edited.
hpr2210 :: On Freedom of Speech and Censorship describes the agreed approach to this topic. https://hackerpublicradio.org/eps/hpr2210/index.html

I felt that reading "Alas, the fate of male chicks in the egg industry is horrific" was enough to get the point across. The other words used are also in the show notes of this episode.
"[mass maceration / mass suffocation / mass gassing]"

We get a lot of people trying to push their products and opinions here on the comment section. Of your 10 comments, 30% are "pushing" a Animal Welfare agenda. I'm not disagreeing with you views, I'm trying to figure if you are here for the tech or here for the platform. That is why it's important to introduce yourself to the community. You can imagine that I will be more likely to read a flyer given to me by the person who runs the coffee corner at my hacker space, than from someone who shoves a leaflet in the door.

As for pronunciation, if you don't like it, then join the Community New show yourself. We record the Community news on the Friday before the first Monday of the month.

Ken.

Hey Ken. You read my comment [from about 25m51s in]. And I don't think it's that hard to pronounce the word 'macerated'. Also, why did you censor my comment by not even mentioning the ways male chicks are killed in the egg industry? If you don't believe me, look it up and see for yourself. Also, I've commented many times in the past. Why does it matter that I never hosted a show and that ye know nothing or little about me? I'm sure there's also other commenters that are not much known to ye. If folk go to the trouble of leaving comments, I don't think it's expecting too much to have them read out properly.

@Bob

Re: Comment #2

That would be much better but unless operat0r states that then I doubt it. It's more likely those eggs come from factory farm hell.

Interesting topic of which I didn't knew anything about. Until after I listened to your show. Steganography will be on my someday list, to dive deeper into. Thank you mightbemike!

I enjoyed this episode! It is an interesting topic. I would like to hear about case studies.

Somewhat related. At least I heard that some persons writing some technical documents, hide their "kilroy" in eg a drawing, like maybe tiny black text on a black line. Somewhat similar is hidden code, like I recall a Tektronix oscilloscope that if you entered a specific order of commands, a figure would play on the screen - I didn't find it out but I remember a colleague did. And some software has hidden games in the code.

https://www.openbsd.org/faq/pf/example1.html

After installing OpenBSD on a machine with 2 network adapters, you can follow the FAQ page for setting up a home router

It was interesting to learn some about BSD and notes to be aware of if trying BSD and entering from Linux background. I can think of at least two reasons why I today use Linux as my daily driver, both work related: First of all that I for several years had a SUN UNIX work station as my daily driver at work, and secondly when I was on UNIX a work mate at coffe break talked about Linux, it was at the time when Linux was something very new.
BSD is on my thoughts to try one day, as an ordinary driver or eventually as a NAS driver, we'll see if it happens. Furthermore I also think of that I was on macOS for some years, still have it, and macOS is to my knowledge based on BSD. This show gave me more knowledge of BSD, thanks.

Hi Dave,
I will see if I can make a show about my media server and how I get stuff uploaded. Although I do have some "imposter syndrome" about it, because sometimes I feel that if it went wrong, I would be stumped! On the positive side, I have all my physical media, so if I did lose the digital content, it wouldn't be the end of the world (but it would be a lot of work to re-scan it).
Regarding "--delete" - I agree with your comment about the potential dangers with it. Needless to say, I took some time carefully checking it was doing what I expected, then put it in a script so I could avoid typing it incorrectly in the future!

Thanks for the interesting show Elspeth. I have been flying model aircraft (predominantly gliders) since my teenage years, and also fly full size gliders for several years in my 40's. Gliding is a great way to enjoy flying, and in my humble opinion everyone wanting to fly should start with gliders! Anyway, I have too much to say on the matter, so I think I will have to add the topic to my "HPR Shows to create" list.

Looking forward to your next show!
-- Paulj

Thank you very much for this show. I am BSD curious, and currently have FreeBSD installed on a Thinkpad X270, but haven't done much with it. I have Proxmox on a server, and have TrueNas Scale installed in a VM with disk passthrough for the data drives. It's OK, but complex, and I really have an urge to set up a server with BSD, and provide all of the NAS services and VM services (Jails, I guess) running any services I want to use.
I also have a Wyse 5750 mini tower with Guix Linux installed, but again not being used. I might use this as a test bed to learn about the details of server setup, then reconfigure the main server.
Thanks for the comprehensive overview and show notes. Now I have some homework!

I have long had a pilot license on my bucket list, ever since a friend took me for a ride in a '39 Piper Cub. Your episode reminded me that this type of flying, while expensive, is within reach. Thank you!

I have run many Linux distributions as daily drivers, but I'm interested in learning more for bespoke appliances. Loved this episode -- I have long wondered what BSD was all about.

Thanks y'all! :D

Hi Rho`n,

This was great. I had some similar thoughts to you and made a comment on show 4373. You win more HPR points by making a show about it though ;-)

I have a "to do" note to myself to prepare a show on 'find', but have never got round to it. It's a very powerful and useful tool, and someone should talk about it!

Similarly with 'xargs', as you said.

Cheers, Dave

I have never used any modern BSD variants, though at my work I used various BSD versions like SunOS, HP-UX and Ultrix. I had a MIPS DECstation running Ultrix on my desk for many years (as part of a network called DECAthena).

I'm tempted to install one of the BSDs on a spare machine, just to see what it's like now!

Great show, I loved hearing about your flying experiences with your family.

Hi Rho`n,

Very interesting episode. I did a quick search and learnt that besides xargs, grep, sort and wc can receive null-terminated input via the '-z' option. Also it seems that tar can handle null-terminated filenames by the use of '--null'. Certainly more to explore for me :)

Regards oxo

@sgoti
Yes... good observation. Thanks for sharing.

Also, the other part was not directed to me, but anyway I read it. Moving story, sad outgoings but with a powerful outcome by Aleysha and her suporters. Grateful,