News

So I finally decided to watch JoJo’s Bizarre Adventure out of sheer curiosity borne from the memes, and I have to say… it totally makes sense. The show is so ridiculously over the top that it practically begs to be memed.

In the process of working on a customer migration and came up with a neat query for finding tables that don’t have a primary key:

SELECT c.oid::REGCLASS::TEXT AS table
  FROM pg_class c
  JOIN pg_namespace n ON (n.oid = c.relnamespace)
  LEFT JOIN pg_constraint p ON (p.conrelid=c.oid AND p.contype = 'p')
 WHERE c.relkind IN ('p', 'r')
   AND n.nspname NOT IN ('pglogical', 'information_schema', 'bdr')
   AND n.nspname NOT LIKE 'pg\_%'
   AND p.conrelid IS NULL;

For anyone out there that is using pglogical, this is how you figure out if there are any tables that won’t work in the default replication set.

For some reason last night, I dreamed that I was going to give a speech some time later, and as part of it, I wanted to recite the opening of the Canterbury Tales. I believe my intent was to denote that the beauty of the prose can only be truly conveyed with proper pronunciation of the Middle English that has essentially been lost to time with the evolution of the language. And that we can progress with our lives and produce works just as aesthetic which will be similarly tied to our times and regions, but no less impactful.

So, it’s nice to know that Time Magazine has essentially admitted that the election was manipulated. At least they’re being honest about it now, though using Weasel Words to obfuscate a bit for plausible deniability.

Though I don’t quite know the exact day Luna was born, I know it was some time in late August of 1999. This means a cat I adopted shortly after I graduated from college is now 21 years old.