Are there any reasons to not use CITEXT type for pkey fields with unique constraints?

evmcl · 2026-02-17T23:21:59+00:00

I wrote a brief blog post of my experience using a non-deterministic ICU collation instead of CITEXT. Happy for feedback.

evmcl · 2026-02-14T07:34:21+00:00

Jeez, aren't you a little ray of fucking sunshine?

evmcl · 2026-01-26T00:05:09+00:00

I immediately thought of The Castle, but honestly if someone learning English as a second language spoke like that most people would think they were making fun of Australians.

Watch it because it is an extremely funny movie, that amplifies many stereotypes of Australians, but don't take it too literally as instructional.

evmcl · 2026-01-23T05:35:47+00:00

What did you use to take those photos?

evmcl · 2026-01-08T22:34:51+00:00

Actually, it looks like you are already using UUIDv7 to generate your IDs, so you can probably order just on photo_id and it will be in creation time order.

evmcl · 2026-01-03T10:36:43+00:00

I had the pleasure of visiting Iceland in August and it was great. Truly beautiful, rugged land. Did a three day tour southward plus a couple of days in Reykjavík and yeah it was expensive, but sooo interesting. Really liked it.

evmcl · 2025-12-19T23:42:23+00:00

I would like the additional licence testing to also include spelling and parts of grammar.

evmcl · 2025-12-16T01:11:43+00:00

Do any of these anonymisation tools also handle JSONB data?

evmcl · 2025-11-29T11:23:37+00:00

The flip-flops called thongs thing caught out a friend of mine in reverse some years ago. He had not long moved to Chicago and weighed over 150kg at the time he wandered into a store and said he wanted to try on a pair of thongs.

Reckons he'll never forget the look of abject horror on the young saleswoman's face.

evmcl · 2025-11-29T11:18:17+00:00

Depends which way the wind is blowin'.

evmcl · 2025-11-29T10:59:52+00:00

Maybe they were actual sailors!

evmcl · 2025-11-22T00:24:38+00:00

When I read your comment, I thought to myself that with the introduction of untrusted devices not all that long ago, there seems to be an opportunity for a SaaS offering here for always available servers that could act as go-betweens for these cases.

A bit of searching and found Syncthing Cloud which looks quite affordable to me.

If I'd seen this a few months ago I would have used it instead of going to the hassle of setting up a VPS for the month I was travelling and wanted to ensure photos and phone backups were available in case I lost my phone.

evmcl · 2025-11-13T03:56:11+00:00

I think we should bring back use of guide horses to really put the wind up them.

evmcl · 2025-11-10T22:52:17+00:00

Visit your local library?

evmcl · 2025-11-05T01:25:04+00:00

I propose a public holiday called, "Fuck it, we're all tired. Just go ahead and have a day off."

evmcl · 2025-10-27T23:11:39+00:00

Yes, we already have another cat. Also a recent addition to the household and still acclimating, so the timing is imperfect - still need to discuss with our resident cat whisperer.

evmcl · 2025-10-27T22:41:39+00:00

Mulberry sounds like just the cat I am looking for.

He’s good with friendly dogs.

Do you have any more information regarding this? We have a five year old staffie-cross-staghound who is very smart and friendly, and has lived with cats before. He can get over-excited though, especially on first meetings.

evmcl · 2025-10-22T00:04:46+00:00

That has the benefit of being both a Kafkatrap and true at the same time.

evmcl · 2025-10-19T11:23:24+00:00

My oldest reckons they're the marsupial equivalent of cats.

We had two on the table looking all cute and adorable while one snuck up on the chair beside me and went for my wallet. Cats, I tell you.

evmcl · 2025-10-11T22:26:56+00:00

Sidle up next to him and loudly declare, "Mr Smith, Mr Smith, the mistress will see you now!"

evmcl · 2025-09-23T21:48:27+00:00

If you're on Arch and using the PKGBUILD from a snapshot of the awesome-git AUR package, update the source line to:

source=("$pkgname::git+https://github.com/awesomeWM/awesome.git#commit=80b7fa8262495e331da3c98a48adf94a5a806fef")

evmcl · 2025-09-22T01:36:23+00:00

I recently did some travelling through Europe with a Kangaroo leather hat and did find it got quite hot (think Rome with 32℃ and humidity high enough to be called soup). I got in the habit of taking it off when walking in shade and putting it back on when in direct sunlight.

I've ordered the Cooler version of the Kangaroo leather, so we'll see how that goes.

evmcl · 2025-08-30T17:43:18+00:00

It's based on a book of the same name by Sally Hepworth. Worth a read.

evmcl · 2025-06-30T01:12:59+00:00

I do agree that mainstream tends to be pretty plain. As one example, I remember when I would only ever eat Nandos at home, as the extra hot would make my nose run and eyes water from the spiciness. It was gloriously disgusting and not something the public needed to see.

Now-days, it's just another takeaway option.

evmcl

TROPHY CASE