1/3 Look. “Bacon Numbers” is a set-piece assignment for CS students. Solutions are usually sought in an “if-then-else” language. Amazingly, a correct pure SQL solution fits in a single tweet. See 2/3. But it fails to finish on real data 🙁 3/3 fixes this.

@UHaul_Cares @UHaul_Cares 4/4 Then, when I typed my facts perfectly, it said that I’d failed too many times and told me to try later. I left it a couple of days and tried again. Same “failed too many times” error. What RUBBISH! Look:

@UHaul_Cares @UHaul_Cares 3/3 I tried 1415nnnnnnn ’cos this format usually works on such screens. But this needs eleven digits. I typed my number that way, and when I entered the last digit, the “1” country code vanished. Fair enough. I must’ve fumbled a few times, getting “Computer says no”.

@UHaul_Cares 2/2 I read it on “ on my macOS 14.6.1 laptop. When I clicked the link, it forced me to install an app. Sigh… When I’d done that, I tried to register. The stupid screen gave no hint about the phone number format. Sigh again….

UHaul_Cares 1/2 I booked an appointment, by phone, at a nearby U-Haul facility to have a trailer hitch mounted on my car. I soon got an SMS confirmation: « Your reservation # nnnnnnnn can be viewed/edited on the U-Haul App here » . .

@Photoshop 2/2 I get no error message but it takes me back to the same “Sign in required” screen. I tried resetting my password but I get the same behavior. I have a note of my licence key. But I don’t reach a screen where I can enter it.

I’ve just become a happy retiree. My last day at Yugabyte, Inc was 18-Aug-2023.

It's official: "premise" (in the singular) has lost its original meaning—and now I live at a premise. CC @PGE4Me

Look: “Kroger exploits microservices to deliver more business value faster with YugabyteDB”.

Thanks for the mention! My abstract is here:.

Nice!.

Non-dummies should read this too.

Look: Yugabyte Inc's very own @fritshoogland is the current PostgreSQL Person of the Week.

Look:. “Evolution of Transactional Databases”. My current colleague (also former colleague from our Oracle days) is presenting. I've signed up. And so should you.

Exciting news!.

Sad news. Another reminder that time and tide wait for no man.

Full disclosure: using PostgreSQL Version 11, « select 5 ! » gets 120—the right answer for "factorial(5)". But on the current PostgreSQL Version 11, the "select" gets a syntax error. So maybe my initial indignation was fair, after all.

Look—in PostgreSQL & therefore in YugabyteDB's YSQL:. select. (select (1 != 2)::text) as "what I intended",. (select (1 ! = 2)::text) as "fat-fingered typo",. (select (1 !)::text) as "factorial of one";. I s'pose that I shouldn't feel too indignant….

I’m looking forward to this session. Please join me. And do fee free to challenge opinions.

I've watched it again a couple of times. (But, then, I do like the sound of my own voice.) I was convinced by what I said. .

Thx @pdevisser. Appreciated your ætherial participation in my talk. You asked me and partner-in-crime @ToonKoppelaars to generalize our polemic to #postgres ~4 years ago. Patience is a virtue. Yours is now rewarded. I’m writing external doc for the code kit. I’ll post it soon.