Airline Sign Generator

Media

I remembered this old sign generator site from years back, and saw they have a slew of new ones. This is my latest creation!

Airways Airlines

Well, that was less inspired than I expected. I’ll try again.

Aeroline du Plane

That doesn’t even make sense. Sleep probably would have been more productive an activity for this time of night.

As for the plane itself—the Aeroline du Plane as it were—you can tell it’s a Boeing 757 on account of the fuselage looking like a 757.


Today on Punwatch: Oil

Media

I haven’t done a Punwatch in six years. This cannot stand. Or sit, or whatever.

Speaking of locations I mispronounce, Angela Monaghan reported for The Guardian:

Oil giant Aramco’s $2tn flotation is still on, says Saudi Arabia. Energy minister in Riyadh denies reports that world’s largest ever IPO has been cancelled

Coal companies are reportedly on solid footing. Glaven.


PostgreSQL NOT IN with NULL

Software

Earlier this week my colleague clued me into a potential Postgres pitfall I’d yet to be bitten by, but it could happen.

Say you’re doing a once-off query like this. Yes, it’s a contrived, simplified example.

SELECT book, isbn 
FROM inventory 
WHERE isbn NOT IN (
    SELECT isbn FROM orders
)

This superficially works, but Postgres will not match NULL values in this subquery when using NOT IN. Ouch!

So the only way to be safe is to check the field is also NOT NULL:

SELECT book, isbn 
FROM inventory 
WHERE isbn NOT IN (
    SELECT isbn FROM orders 
    WHERE isbn IS NOT NULL
)

Or the more robust alternative, short of doing a proper join, is to strategically deploy NOT EXISTS:

SELECT book, isbn 
FROM inventory 
WHERE NOT EXISTS (
    SELECT isbn FROM orders 
    WHERE inventory.isbn = orders.isbn
)

I did some digging, and also found this interesting article on Explain Extended on the performance implicaitons of using these different queries.


Places I read but still mispronounce

Travel

The photo above is from some night Shinjuku wanderings back in March. It’s not in any of below places, so therefore its inclusion is entirely pointless.

Chesapeake Bay
Cheapskate Bay

Arkansas
Are-kansas

Riyadh
Riddya

Sydenham
Syd-en-em-en-ememem

Worcester
Worcestershire

Llanfair­pwllgwyngyll­gogery­chwyrn­drobwll­llan­tysilio­gogo­goch
Llama-frasm-keysmash-gogo-gogog-gogogoch

Argument mnemonics

Software

I like argument and option mnemonics. I can see why standard usage documentation prefers to sort arguments l15y, but this way makes them much easier to remember.

For example, my standard directory listings:

$ ls -cola

From the FreeBSD ls(1) manpage:

  • Use time when file status was last changed for sorting or printing
  • Include the file flags in a long (-l) output
  • List files in the long format
  • List all; include directory entries whose names begin with a dot

Or for sorting by ascending time modified, using the name of those Singaporean and Malaysian train systems:

$ ls -lrt

From that same manpage:

  • List files in the long format
  • Reverse the order of the sort
  • Sort by descending time modified (most recently modified first)

And the classic, audio-sounding aux:

$ ps aux

From the FreeBSD ps(1) manpage:

  • Display information about other users’ processes as well
  • Display information associated with the following keywords: user, pid, %cpu, %mem, vsz, rss, tt, state, start, time, and command.
  • When displaying processes matched by other options, include processes which do not have a controlling terminal

And finally, a somewhat lowbrow insult to give to a folder that may be using way too much of your drive space:

$ du -sh

From the FreeBSD du(1) manpage:

  • Display an entry for each specified file
  • “Human-readable” output. Use unit suffixes.

Unfortunately, tar and related tools will never have mnemonic arguments, unless cjvf becomes an overpriced clothing line or something.


Communicating isn’t just stating facts

Thoughts

This answer on by Upper_Case appeared in the Hot Network Questions sidebar on StackExchange:

Communicating well is not a matter of stating true facts (though that is important). It is about expressing things that are accurate in a way that the other party will understand. It is common, in my personal experience, for technically-minded people (like engineers) to only focus on the accuracy of their statements.

I call this the not seeing the forest for the trees problem, and is one of the reasons I originally disabled blog comments.


My new Kindle

Hardware

Clara and I each got Kindle Paperwhites, on recommendation from @sashin9000. How artful and fabulous does it look with the fake plant? Don’t answer that.

Compared to reading on a phone

Camera aside, the main reason I bought a dinner-tray iPhone 7+ was for reading books and manga. I always have my phone with me, so it seemed to make sense. I’d resigned myself to the fact we’ll all be using fuzzy OLEDs eventually, but in the meantime what its LCD lacks in saturation it makes up for with crisp lines.

Surprising nobody, the big issues reading on a phone like this were:

  • eye fatigue, especially on planes
  • the screen is still too small for long-form reading
  • harder to read in broad daylight; though improved from the old days
  • too many work, internet, and mobile game distractions
  • I couldn’t commit to a store

Expanding on that last point, I had half a dozen apps on my home screen for reading from disparate places. This is the sad reality of DRM of which Kindle’s are a part, but I’ve also resigned myself to it if I want to buy digital books from authors and manga artists I want to support.

So the end result was I read fewer books, less often. Or would that be fewer books, more often? I read less, is what I mean. Not consciously, but it slipped from my daily routine. Which concurrently sucks and blows.

Comparing to reading physical books

I can’t comment, I haven’t done in a while. And even if I were to comment, I feel it’s enough of a minefield littered with those who like the smell of glue and the feeling of physical paper — and aren’t afraid to tell you so — to be worth defending!

What I can say from recent experience is that it’s wonderful, wonderful, to have all the books I care about in one discrete unit I can carry around. It’s like my own portable library, that also dovetails nicely with my desire to live with less physical stuff.

Choosing the Kindle

There are many different readers on the market. Likely the best ones are in the Kobo line; they have more storage, bigger screens, and are lighter to boot. Or glove, because you hold them with your hands. Glaven.

But for once in my life I thought I’d get the most popular device and make things simpler. Amazon’s book store has everything I’ve searched for so far, and my Humble Bundles have mobi format files.

Books look great on the 300 DPI E-Ink display, and I love the feel of the official case. My last Kindle from 2011 was destroyed by an impact to its screen, so having a flippy protector is a good idea. It also turns the device on/off when you open/close, and makes it feel like a book to hold.

I watched and read reviews saying reading manga on it is so-so, but I’ve found pages crisp and perfectly legible, if marginally on the small side.

It’s been a week, but I’m already halfway through a Steven Pinker, and the second volume of Kenta Shinohara’s Astra Lost in Space. It’s fun to read this stuff again!


Scalars greater than 2

Thoughts

Happy Monday! My grandfather delighted in regaling facts to add to your vast store of useless information. I endeavour to continue this fine tradition.

The following scalars are greater than 210:

  • 1010 10102
  • 0o52
  • Some bad fish pun, expressed in your encoding of choice (glaven)
  • 0x2A

Sincerely,
Ruben


Aretha Franklin and Matt “Guitar” Murphy ♡

Media

Matt Guitar Murphy and Aretha Franklin in The Blues Brothers

A decade ago I wrote:

As if the original Blues Brothers wasn’t the best movie of all time, and as if Aretha Franklin doesn’t rock!

I’ve spent most of my time here talking about jazz, but with my sister as my witness, I was obsessed with the blues as a teenager. And Aretha and Matt played a huge part in that.

People will likely remember Aretha best for commanding R.E.S.P.E.C.T! But for me it’ll always be that legendary scene in that Blues Brothers soul food restaurant when she’s musically sparring with Matt “Guitar” Murphy to the tune of THINK!

I legit shed a tear this weekend. What lives and talent. Thank you ♡


Anime we’re watching, Q3 2018

Anime

Clara and I are watching three series this season; a first for us in a while on account of work and other commitments. But there’s some quality right now, despite what the sniveling hipsters may say :).

① Holmes of Kyoto

Cover for the above series

A young artefact appraiser and his new assistant engage in adventures and investigations that sometimes even have something to do with appraisals! I know deductive reasoning doesn’t work in the real world, but that doesn’t detract from the Hyouka-esque stories and likeable characters.

Kyoto is my new favourite place, so naturally with that in the title we had no choice!

② Kakuriyo: Bed & Breakfast for Spritis

Cover for the above series

What happens when your superficially sweet and carefree grandfather secretly set you up as collateral for a loan? Do you marry the ogre as you’re contractually obligated, or do you run your own business to pay the loan back on your terms? I admire Aoi’s fierce independence and cuteness cough.

The universe reminds me a little of Rinne, though with a male protagonist who’s confusing but somewhat less irritating! The art, colour, and settings are breathtaking.

③ Isekai Izakaya: Japanese Food From Another World

Cover for the above series

I feel Clara and I only just finished watching a series based around a restaurant with a door to a parallel universe! But it was one of our favourites, so we’re happy to see the premise get used elsewhere. It’s the ultimate chill show.

But the other reason you watch this is for the followup Nobu Plus with real people! Each episode alternates between an unreasonably cute chef who shows us how he cooks food from that episode, and a delightful folk musician and food critic wandering around Japan trying various restaurants.

Time for another whatsontap!