So I’ve closed off the poll in the previous post, and the clear leader with three votes is (drum roll) to have some kind of rant about kubernetes, a.k.a. k8s . So here it is. I should probably say at the outset that I only occasionally have to use kubernetes in my day-to-day work, as […]
So this is going to get a bit meta, but I was browsing randomnoun.com this afternoon and noticed I haven’t updated it since December last year, which is when I last had some spare time to complain about * checks notes * attempting to rootkit a TV, running a pivot query in mysql, and a […]
A partially successful attempt to MITM the TV Right well I finally got around to getting a “smart” TV, i.e. a TV that is capable of detecting what I’m watching and then selling that information to data brokers who then sell it to advertisers . The TV I ended up getting was a LG 55QNED81SRA, […]
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 called prcPivot, because that has the word PIVOT in it, and it’s a stored procedure . Arguments prcPivot has a single […]
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, not actually to be hugely popular and successful. Here are some of […]
Well I got another NAS the other day, so I decided to reconfigure most of my kubernetes (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 want to do […]
I’ve produced some more software. This one creates diagrams of query execution 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 execution plan table from vanilla MySQL by entering EXPLAIN before the query, which looks a bit […]
Q) what is authentication A) identifying who you are Philosophical tangent on who you really are, anyway So how do you define ‘who you are’ ? Many philosopher kings would probably ascribe it to your hopes and dreams, what you do for a living, how many pyramids you have, what great works of art, music […]
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 and a fair bit of punctuation, you might find […]
So following on from ‘every piece of software eventually becomes microsoft office’ post, one day you’ll find yourself reimplementing powerpoint. You’ll be doing this in javascript and html, because everything’s the web these days, and to start you on that journey, you’ll be using drawio, because it’s open source and not as crap as the […]