Kind notes

 Note

Something cool newer #git versions are doing - you'll now see Reapply instead of Revert Revert ... in commit messages, if you're reverting a revert.

In an older version of Git (i.e. with 2.34.x) you would see:

Revert "Revert "Commit title here""
Revert "Commit title here"
Commit title here

However, in newer versions (i.e. with 2.43.x) you now see:

Reapply "Commit title here"
Revert "Commit title here"
Commit title here

Which makes it a little bit cleaner in your Git log

 Note

Anyone know a good place to ask #sqlite or #sql questions?

I'm trying to convert rows (produced by a big query that then uses a GROUP BY advisory_type) that produces data like:

-- the `advisory_type` can be one of multiple values, i.e. SECURITY, DEPRECATED, UNSUPPORTED
repo    advisory_type  total_advisories
------  -------------  ----------------
jvt.me  SECURITY       10               
jvt.me  DEPRECATED     5               

And I'm trying to convert this to:

repo    total_security total_deprecated total_unmaintained
------  -------------  ---------------- ----------------
jvt.me  10             5                0               

Any clue how I'd go about doing so? Happy to provide more details / some data for you to query too, but been playing around with it on and off and not really having any luck.

 Note

I've just found in my notes app that I wanted to write A plea to SCA vendors but I've not written down what that plea is so now I'm annoyed at past me assuming future me would know πŸ˜…

 Note

Love to get an email from #Vercel: You’re off the waitlist for Next.js Conf 2023 and are officially registered. despite never registering for the event. I also can't unsubscribe because (allegedly) This email contains important information about an event you registered for and cannot be unsubscribed from.

Regretting signing up for their prize giveaway at #LeadDev London, especially as this isn't the only thing I've been emailed about but can't unsubscribe from of theirs 🫠

 Note

Bit gutted to have received my official rejection from speaking at GitHub Universe, after being on the "alternate" (backup) list of speakers, but still chuffed to have made it that far! 1600+ talks proposed this year apparently πŸ™€

 Note

Following on from a successful conversation that was had at #DevOpsDays Chicago, there was an Open Space yesterday all about #compensation and #salary at #DevOpsDays London, which of course I was super interested in, and happy to share my own salary history as well as some of the things that companies have done over the year.

Based on one of the questions I'll (soon ℒ️) be adding how much on-call is compensated, if not part of the salary

 Note

TIL that I can use my fingerprint to log in with i3lock-colorπŸ•΅οΈ I thought it'd not worked before last time I looked, but similar to logging in on a TTY, I just need to enter an empty password, then I can auth via my fingerprint πŸ‘

 Note

Has anyone else noticed that the #reddit mobile web app is useless? Often get white screens if I try to load it, often have to choose a subreddit to go to first, then I can go back home. Wouldn't get that with excellent third party apps πŸ˜₯

 Note

New release of deepmap/oapi-codegen πŸš€ v1.15.0 comes to downgrade the version of Go in use by a couple of dependencies, which was leading to build issues for folks running Go 1.21 πŸ”§

 Note

Two years ago, I posted my salary history - in an impulsive move - and I absolutely do not regret it. I know directly of some the great impact having this data has had (including leading to others sharing their own), and I'm so glad to be able to use my privilege to help others

 Note

New release of deepmap/oapi-codegen πŸš€ v1.14.0 comes with Iris Support, a requirement of a minimum of Go 1.20, reduction of runtime dependencies, and various other features and fixes πŸ‘