Randomnoun

08/12/2023

I found this one absolutely pivotting.

So you want to run a PIVOT query in MySQL knoxg | December 8, 2023 | Programming | No Comments Here’s a stored procedure which generates PIVOT (or crosstab) queries in MySQL, sort of like what you used to be able to do in Microsoft Access, before everything moved to The Cloud. prcPivot It’s call...

08/12/2023

Another poste on the bloge

Master of his domain (name) knoxg | November 12, 2023 | Meta | No Comments So as a nerd I need to have a website, and as a nerd who’s been on the net for a while, I’ve had a few fantastic ideas which were definitely going to be hugely popular and successful, but have turned out, surprisingly, no...

02/01/2023

Yet another home kubernetes setup project, but this one uses a Something for Kate pun in the title.

Something for K8s knoxg | January 1, 2023 | Devices | No Comments Well I got another NAS the other day, so I decided to move most of my k8s stuff to use that, and hell, why not upgrade it at the same time. The was about 4 months ago and I just finished last weekend, so here are the steps in case you...

14/10/2022

Who wants query ex*****on plan diagrams ?

Make a new plan, Stan knoxg | October 9, 2022 | Programming | No Comments I’ve produced some more software. This one creates diagrams of query ex*****on plans for MySQL. ^ There's tooltips on the things that have tooltips. Explain that to me like I know what SQL is You can get a query ex*****on pl...

25/12/2021

Who wants control flow diagrams ?

Flowcharts-R-Us knoxg | December 11, 2021 | Programming | No Comments Joining the dots So it turns out that a lot of people are incapable of reading, or if they can read, to actually absorb the information in that text in any meaningful way. So in order to explain a bit of code that is mostly words....

20/07/2021

This one's about tabstops

Tabstop me if you think that you’ve heard this one before knoxg | July 24, 2021 | Internet, Programming | No Comments Some guy who spouts aphorisms and the occasional web browser once said that “all software expands until it is capable of sending emails”. And a not insignificant number of othe...

09/07/2021

Have posted a few more articles to the wordpress site, which still exists. Here they are in increasing order of whimsy.

swagger-combine knoxg | June 29, 2021 | Programming | No Comments This post has been written in two parts, The first part, slagging off about YAML, and YAML in swagger in particular (“the problem”), and The second part, presenting a way of pre-processing your YAML in ways swagger doesn’t suppo...

02/01/2021

Here's a new post. This one's about history tables.

http://www.randomnoun.com/wp/2020/12/19/the-complete-history-of-everything/

10/08/2014

I spent over six hours yesterday installing cyanogenmod on my Android phone. And then I wrote a story about it.

http://www.randomnoun.com/wp/2014/08/10/removing-the-crapware-from-your-smartphone/

Continuing the tradition of blogging about anything that requires even the slightest amount of effort, here's what's involved in installing cyanogenmod on a Samsung II (GT i900). Because that's jus...

31/03/2014

The other day I was trying to remember the name of that open-source software that was a bit like Amazon Workspaces/VMware View that allows people to log in to remote desktops without having to pay AUD$3,683.61 to do it. I initially thought it was Aardvark or Avocado, but turns out it was Guacamole.

Ha. Avocado. As if you'd avocado into a server.

07/03/2014

Hello world. Here's another post, this time on DMX and dmx-web.

If you are vaguely interested in taking a look at this thing, why not check out the still not completed website at www.dmx-web.com and put your details in there.

28/02/2014

Here's a story about a small storage cube running FreeNAS.

Here's a story about a small storage cube running FreeNAS.