Stephan Sokolow @ssokolow@qoto.org

Tip: I haven't finished minimizing the reproducer yet but, if you're using rusqlite concurrently through something like `Arc<Mutex<Connection>>` and you're getting `Foreign key constraint failed` errors that go away if you force only one thread, check if you're using `INSERT OR ...` on a table referenced by a foreign key. There's some kind of bug and manually reimplementing `OR IGNORE` client-side by `SELECT`ing first worked around it for me. #rust #sqlite

Did I really forget to show the "XP pretending to be 98SE" side of my server's icon set? I can't find one in my timeline... oh well.

I've been on other things this week, but here's the complete overview.

As you can see, 10.4 isn't beyond proof-of-concept for the same "small sizes for older OS, bigger sizes in a different style for newer OS" trick I used for XP vs. Win7 and I'm currently just reusing my Win7 icons for Linux.
#retro #retrocomputing #windows #icons

@pink_arcana ...speaking of which, I should probably make sure my licensing guide covers all the common mistakes I've noticed.

(eg. Creative Commons explicitly says that it's a violation of their trademark policy to add new restrictions like "you can't re-upload this elsewhere as-is" to CC licenses.)

https://creativecommons.org/policies/#trademark

@pink_arcana The more public links, the merrier. My stance on that sort of thing is "If I hadn't wanted it to be shared far and wide, I wouldn't have put it on a public site where anyone can find it."

As for the explanation, I'm glad you liked it. I put it up because, over the last couple of decades, I ran into a worrying number of people whose understanding of licensing didn't even reach my IANAL level.

@pink_arcana I just wish things weren't so messy right now. I haven't had time to look for more stuff to add in months.

I've started to polish up the classic Mac OS versions of my retro fileshare icons. #retro #retrocomputing #windows #icons

...if anyone wants it, the tool is a shareware thing Icon Archiver in "Large Family" view mode.

...though the actual editing work mainly involves ex-shareware-now-freeware named Iconographer and Graphic Converter 5.x pending me discovering how to edit icons in Netatalk-flavoured AppleDouble resource forks directly on Linux so I can use GIMP for layers and select-by-color.

...and the .ico files for my retro fileshare now have higher-resolution versions for Windows 7... with the sizes carefully chosen so that XP will pick the dithered 98SE-originated 48px and below while Windows 7 will switch to the smooth ones at any size above that.

I wound up having to slice, dice, and redraw Windows 7's Libraries icon to get the kind of folder art I wanted to use for a base.

#retro #retrocomputing #windows #icons

Sorry for anyone who saw me pull the previous version. I accidentally uploaded an old screenshot from before I'd done the tricky to fix the scale of the DOS icon.

...and now some retro fileshare icons for the OSX 10.13 side of my Intel macs... or really any mac that prefers SMB.

Most were just done by making a silhouette in Inkscape & feeding it to folderify-v2, but Mac_PPC and Win7 were hand-done, OSX_PPC required hand-tracing to get that gloss, and DOS required some trickery because folderify-v2 strips padding. Win9x is probably going to need to be redone by hand for the same reason. #retro #retrocomputing #macos #osx #icons

I've continued to work on the icons for my retrocomputing fileshare. Here's the current state of the icons for the Samba side of things.

#retro #retrocomputing #windows #icons

The urge hit me and I decided to create some nicer icons for what my /srv/retro looks like when viewed from my Power Mac G4 through Netatalk.

I'm a perfectionist, so I'm sure I'll go back to fine-tune things like that win16 icon later. I have an SVG source for the logo, so I can tweak the size to fix it hanging a little too low.

(`serials.zip` is password protected keys for stuff I paid for. `UNSORTED` is temporary.)
#retro #retrocomputing #macos #icons

The fun thing is, once I knew the song's name, I could then search it on Korean Wikipedia, feed the page into Google Translate, and see that the links in the opposite direction are in good health.
https://ko-m-wikipedia-org.translate.goog/wiki/중화반점?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en-US&_x_tr_pto=wapp

I was finally clearing out a bunch of old "What was this?" TODO items and I had a brainstorm for how to identify the music from an old ebaumsworld video named `annoyingasians.mpg` with no other context... search the filename on YouTube and see who the royalties are going to for any crossposts that show up. Sure enough, I found my answer → https://www.youtube.com/watch?v=2TqoacPsq_8

pseudoscience (n.): A process of inquiry superficially similar to science, but characterized by seeking evidence for explanations instead of explanations for evidence.

Networking Tip: If your client says "No route to host" on some ports but not others, double-check your server's firewall configuration... for example, if you're trying to use UFW and something also installed firewalld behind your back, you're going to get very confusing symptoms that won't be fixed by asking UFW to flush your iptables and re-create them.

#linux #ubuntu #kubuntu #debootstrap #network #networking

KDE Tip: If the Display Settings snapping is preventing you from getting the alignment you want (eg. top-aligned 1280x1024,1920x1080,1280x1024), try changing (but not applying) resolutions, then snapping, then changing them back.

(eg. To work around the forced centerline snapping, I changed the 1920x1080 to 1280x1024, snapped them together as a uniform row of 1280x1024, changed it back, and then hit apply).

#kde #linux #plasma

Tip: The YD-RP2040 isn't 100% compatible with name-brand Raspberry Pi Pico boards. If you need to build something that has it acting as a USB host, prepare for the slightly fiddly job of tacking a piece of resistor leg between the two legs of a BAT54C barrier diode facing the USB C connector to allow current from Vin to flow to the USB connector... also, the (VBUS) and (VSYS) silkscreens on the bottom are wrong. Vout is *not* VBUS. Follow https://github.com/initdc/YD-RP2040/blob/master/YD-2040-2022-V1.1-SCH.pdf #electronics

@soller @emeric Is it OK if it's a CPU from 2016 that FEELS like it's 25 years old? :P

For perf testing my creations, I have a hand-me-down mini PC built around a Celeron J3160 and I can confirm that its twice-as-fast brother (Celeron J3455) with half the RAM (4GB instead of 8GB) is still only 2/3rds the speed of the Athlon II X2 270 from 2011 that I recently upgraded off of. (The J3160 is apparently 1.1x as fast as a RasPi 4.)