James Ramsay

Finished reading: Less is More: How Degrowth Will Save The World by Jason Hickel 📚

Finished reading: How to Take Smart Notes by Sönke Ahrens 📚

Finished reading: On Immunity: An Inoculation by Eula Biss 📚

Finished reading: Surprised by Hope by N. T. Wright 📚

Finished reading: Drawing for Architecture by Léon Krier 📚

Finished reading: Exponential by Azeem Azhar 📚

Finished reading: The Great Mental Models Volume 1: General Thinking Concepts by Farnam Street 📚

Finished reading: The Tyranny of Merit: What’s Become of the Common Good by Michael J. Sandel 📚

There seems to be an increasing number of services that require a specific app for two-factor authentication. In the last week I needed to install both Authy and Symantec VIP Access.

I’d prefer, however, to keep all my Time-based One-Time Passwords (TOTP) in one place. Having secret keys scattered over multiple apps makes them hard to backup. Thankfully I found solutions for both:

• Authy secret keys can be extracted from the desktop app using following these instructions.
• Symantec VIP Access can be avoided by generating a secret key with the python-vipaccess tool. I found I needed to set the token model to SYMC in most cases (vipaccess provision -p --token-model SYMC).

A clever dynamic solution to the unpivot problem from Thomas Kellerer:

WITH data_percentiles AS (
  SELECT
    month,
    percentile_disc(0.50) within group (order by count) "50p",
    percentile_disc(0.80) within group (order by count) "80p",
    percentile_disc(0.99) within group (order by count) "99p"
  FROM data
  GROUP BY 1
)

SELECT
  p.month,
  d.series,
  d.amount::numeric
FROM data_percentiles p
CROSS JOIN LATERAL jsonb_each_text(to_jsonb(p) - 'month') as d(series, amount)
ORDER BY 1, 2