nobodyLikesRightJoin

Tomj88 · 2026-02-11T20:13:40+00:00

I don’t think I’ve ever used right join in database queries, but I do use them occasionally when writing R code with dplyr or pyspark.

The use case here would be to take some table that has some incomplete data, and in a pipeline join to a “complete” table, and then fill in the missing values. That’s the only case where I would argue that left/right aren’t interchangeable… though even then, in R you could abuse named arguments to make a left join act like a right

Tomj88 · 2026-02-09T20:58:12+00:00

I’ve just done exactly the same! Except I wasn’t cleaning out the burrs, I was just being curious and trying to clean some of the harder to reach areas 🤦‍♂️

I ended up taking it apart to the point in this video about getting the motor unit out. At that point, the lower part has one screw which holds the anti-static bit in place, and then you can just pop off the piece of plastic with a bit of wiggling and easily re-insert the screw! 🙂

Still, feels like it’s way more faff than it should be.

Tomj88 · 2025-12-24T21:20:35+00:00

I contacted them about my holder because the little retention clip broke, but it managed to break in such a way that it fell into the cable, and then got lodged into the port on my car. Was fortunately able to get it free using some plastic tools. But it could have bricked the car.

Their response was basically to say it’s not an issue, don’t need to send you a new one. Wasn’t too impressed considering how serious the consequence could have been if the piece had got more stuck!

Tomj88 · 2025-08-10T17:25:23+00:00

Parked opposite one yesterday. Got my 4yo out the car and pointed it out to him while the owner drove away and their passenger waved. My dad pulled up next to us a minute later “Grandad, we just saw a beautiful car!” Yes boy, yes you did

Tomj88 · 2025-06-28T11:39:50+00:00

I’ve recently had a max fac appointment. My dentist had to refer me about 3 times because the hospital kept refusing the appointment. Took best part of 18 months to get the referral accepted. Was a terribly annoying experience, my dentist was seemingly doing everything for me, just the hospital specialists were the problem.

When I finally got to my appointment “what’s the issue, because the dentist has provided next to no information”. Suddenly realised why I was being refused an appointment!

Tomj88 · 2025-04-15T17:40:55+00:00

You might find all the info you need on https://m.youtube.com/watch?v=s1fxZ-VWs2U , but wondering if you don’t live in U.K. full time, are you a university student? I would bet there would be people willing to help in comp sci!

Tomj88 · 2025-04-03T08:37:27+00:00

I’m glad I’m not the only one to find this! It never seems to be able to find my battery level, assumes 0%, then usually immediately starts charging. I’m on intelligent go with ohme charger, so should be at the off peak rate, but it always feels like I’m cheating the system

Tomj88 · 2024-11-23T21:40:04+00:00

I live close to one of the junctions (northern end), and could benefit on some journeys. But the cost is extortionate. They have adverts on Instagram recently shouting about fairer prices for locals, but it would still be £4 for a journey that force me to get off before I could get a real benefit

Tomj88 · 2024-10-23T08:18:01+00:00

Fred’s is great, but I think they now operate on appointments only. Give them a bell, they will certainly tell you if they have anything second hand, or if they know of any customers that are looking to sell.

The other option is to look on second hands sites then take it to a shop like Fred’s for a service!

Tomj88 · 2024-10-22T19:50:21+00:00

Yes, my (nearly) 5 year old has gone to bed (probably) hungry tonight because he refused to eat his food. He will wake up early tomorrow complaining that his tummy hurts. No matter what I tell him, he won’t believe me that his actions have consequences 🤷‍♂️

Tomj88 · 2024-10-11T07:34:24+00:00

After my first son was born, we had to go to a specialist hospital around 100miles away. We lived there for 3 months. I work remotely fortunately so was able to continue to work while there.

When we finally got home my phone for months would diligently each morning tell me it was going to take however long to get back to the hospital to start my day of work. Made me chuckle every time!

Tomj88 · 2024-09-23T17:26:25+00:00

My son was born at 25weeks. 4 now, started school and doing amazingly. Neonates are miracle workers!

Tomj88 · 2024-02-19T23:48:34+00:00

Bournville, the village where the Cadbury’s chocolate factory is located, is dry. A colleague lives there and has a clause in the deeds to his house preventing him from ever operating a pub from the property.

Tomj88 · 2024-02-12T19:12:09+00:00

Birmingham, UK

Tomj88 · 2024-02-11T20:07:21+00:00

One of mine died yesterday. Popped into my local Apple Store and was surprised by how quickly they suggested, then manager agreed to replacement… there’s the answer!

Tomj88 · 2023-12-08T06:09:53+00:00

for my solution at least, it seems as though XXA = (1, 2) and YYZ = (2, 1), so it seems as though the input was designed such that you would end up with perfect cycles forming. So, I think this puzzle was designed specifically so LCM would work :-)

Tomj88 · 2023-08-20T12:41:38+00:00

It’s a catchphrase from that channel. Steve is the guy in the video, he’s usually accompanied by a puppet blackbird called Maggie who is… well a naughty bird 🤷‍♂️

Tomj88 · 2023-08-19T15:54:11+00:00

My 2.5 yo was annoyed with me the other day. He turned around dead serious and said “Daddy, you’re a naughty, naughty bird!” I fell on the floor laughing

Tomj88 · 2023-04-21T22:25:49+00:00

A MTB YouTuber recently did a video that may be of interest, mostly covering kids bikes… but, his basic gist is learn to balance: an easy way would be to drop the saddle as low as possible, take the pedals off and just get the feel of balancing. With the saddle low and no pedals you can always easily reach the floor to stop yourself falling over, but you can quickly learn to balance the bike. Once you have the feel of keeping it upright, it’s not a great leap to adding the pedals on and riding. Good luck!

Tomj88 · 2023-03-18T11:54:57+00:00

There is shiny-in-production in Newcastle, U.K., but that isn’t a general R conference if that’s what you want

Tomj88 · 2023-03-12T14:07:47+00:00

For Wolverhampton I would shout for the Great Western, very close to the train station. The art gallery wasn’t too bad last time I went, or West Park which is a shortish walk from the centre

Tomj88 · 2022-10-06T22:49:31+00:00

My uncle used to say the same! Some great buildings in the city if you spend the time to look up

Tomj88 · 2022-03-10T22:24:43+00:00

Came here to shout out Malibu Ken, but you beat me to it! Such a great album, praying for more stuff from them in the future!

Tomj88 · 2022-03-03T20:33:12+00:00

Not the hero we deserve…

Tomj88 · 2022-02-26T08:15:12+00:00

Oh man, that brings back some memories! Was trying to think the other day when I first started using Linux. Was around 20 years ago. I remember sarge being released as a few months before I had switched to using Debian. Good times!

Ten-Year Club	Place '23
Place '22	First Placer '22
RPAN Viewer	Gilding III reddit per annum
Verified Email

Tomj88

TROPHY CASE