suhlig

SELECT
  CAST(SUM(ZMEDIADURATION) / 60 / 60 AS INT) AS listened_hours,
  ZPODCAST.ZTITLE as podcast,
  ZURL as url
FROM
  ZPODCAST,
  ZPODCASTEPISODE
WHERE
  ZPODCASTEPISODE.ZPODCASTFOREPISODE == ZPODCAST.Z_PK
  AND 

suhlig

suhlig

$ arp -na | grep -e "b8:27:eb" -e "dc:a6:32" -e "e4:5f:01"

from https://smallstep.com/blog/build-a-tiny-ca-with-raspberry-pi-yubikey/

suhlig

-- start sqlite monitor with _histdb_query

-- most-often used commands; top ones at the bottom
SELECT 
  commands.argv, count(*) as invocation_count
FROM 
  history 
LEFT JOIN 
    commands 
  ON 

suhlig

steampipe query --output json "
  select 
    title, url, 'https://news.ycombinator.com/item?id=' || id as comments_url 
  from 
    hackernews_top 
  where 
    time > current_date - interval '24 hour' 
  order by 
    score desc 
  limit 

suhlig

$x("//a[@title='Click to re-crawl this link']").forEach(element => element.click());

suhlig

from git-duet:

Rebasing (resets the committer to the committer of the current pair):

$ git rebase -i --exec 'git duet-commit --amend'

suhlig

# Insert an event into InfluxDB
use e5573;
INSERT events title="Disabled unattended-upgrades",description="We should see reduced bandwidth usage from here on",tags="apt,debug,bandwidth";

# Configure the annotation in Grafana
# https://grafana.com/docs/grafana/latest/features/datasources/influxdb/#annotations
SELECT title, description from events WHERE $timeFilter ORDER BY time ASC;

suhlig

#!/bin/bash

set -euo pipefail
IFS=$'\n\t'

# This is an updated version of https://lebkowski.name/docker-volumes

main() {
  remove-exited-containers
  remove-unused-images

suhlig

I work with a lot of different Concourse servers that have a variety of versions. fly rejects working with servers that are off to much. Therefore I have fly-3.14.1, fly-4.2.3 etc. on my machine.

But many set-pipeline scripts assume that a single fly command exists and that it magically is of the right version. So I need to switch; preferably per directory or per shell.

Did not work

• Shell aliases are never exported, so that a set-pipeline script does not know about the alias.
• I use ZSH, where functions cannot be exported.

Works