Weeknotes 70

After having a drifting left Joy-Con for over a year, I finally sent it to Nintendo for repair.

With the Switch out of action, I signed up for a free trial of Apple Arcade and have so far downloaded “What the Golf?, “A Monster’s Expedition (Through Puzzling Exhibitions)” and “Sayonara Wild Hearts”.

I’ve only played “What the Golf?” so far and it is wonderful.

My mum and I took C to a nearby park to feed the ducks (oats, to avoid controversy) and saw a raft of glorious Mandarin ducks.

Along with the red kites we’ve seen in the garden, they certainly make a change from London’s feral parakeets.

I had to parse a CSV file sent as a Data URL this week and converting a Request for Comments into a regular expression is a great joy in life:

REGEXP = %r{
  data:
  (?<mediatype>
    (?<mimetype> .+? / .+? )?
    (?<parameters> ( ; .+? = .+? )* )
  )?
  (?<extension>;base64)?
  ,
  (?<data>.*)
}x.freeze

You can find a full Ruby implementation on GitHub.

I learnt about Active Record’s ability to rollback migrations using the revert method which came in very handy when amending a unique index:

require_relative '20210211104247_add_unique_index_to_product_links'

class ChangeUniqueIndexOnProductLinks < ActiveRecord::Migration[6.1]
  def change
    revert AddUniqueIndexToProductLinks

    add_index(:product_links, [:product_id, :reseller_id, :country_id], unique: true, name: 'by_product_reseller_country')
  end
end

An overgrown bush had begun to crowd the patio so my mum and I decided to cut it back. She disappeared into the garage and returned with a truly horrifying but brilliantly effective single-purpose tool: a telescopic branch cutter.

In the footsteps of other power couples, E and I went for our first run together yesterday. My legs now ache and, about 5 minutes into the run, my shorts nearly fell off.