David Boucha UtahDave

In a zoom?

xdotool search --name "Zoom Meeting ID:"

This will exit non-zero if no meeting matching this name is found. "Zoom Meeting ID:"

This window exists regardless of sharing or not sharing, in my tests.

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Launch a one-off git server from any local repository.

I [tweeted this already][1] but I thought it could use some expansion:

Enable decentralized git workflow: git config alias.serve "daemon --verbose --export-all --base-path=.git --reuseaddr --strict-paths .git/"

Say you use a git workflow that involves working with a core "official" repository that you pull and push your changes from and into. I'm sure many companies do this, as do many users of git hosting services like Github.

Say that server, or Github, goes down for a bit.

	---
	created: <% tp.file.creation_date() %>
	---
	tags:: [[+Daily Notes]]

	# <% moment(tp.file.title,'YYYY-MM-DD').format("dddd, MMMM DD, YYYY") %>

	<< [[<% fileDate = moment(tp.file.title, 'YYYY-MM-DD-dddd').subtract(1, 'd').format('YYYY-MM-DD-dddd') %>\|Yesterday]] \| [[<% fileDate = moment(tp.file.title, 'YYYY-MM-DD-dddd').add(1, 'd').format('YYYY-MM-DD-dddd') %>\|Tomorrow]] >>

	---

	---
	company:
	location:
	title:
	email:
	website:
	aliases:
	---
	tags:: [[People MOC]]

	##
	# CONFIRMED WITH
	# - Host OS: Pop!_OS 20.04 LTS
	# - Vagrant v2.2.18
	# - Box: generic/rhel7 v3.4.0
	# - RHEL 7.9
	# - Salt v3003.2
	# - Virtualbox v6.1.18
	#
	# Last tested: 08/27/2021

	# Fetch latest configuration:
	/5 * * * cd /home/ubuntu/dogsheep-config && python3 git_pull_and_run_scripts.py . && sudo python3 ensure_symlinks.py files-to-symlink

	# Goodreads
	46 * * * * cd /home/ubuntu && /home/ubuntu/datasette-venv/bin/goodreads-to-sqlite books goodreads.db -a auth.json

	# Twitter
	1,11,21,31,41,51 * * * * /home/ubuntu/datasette-venv/bin/twitter-to-sqlite user-timeline /home/ubuntu/twitter.db -a /home/ubuntu/auth.json --since
	2,7,12,17,22,27,32,37,42,47,52,57 * * * * run-one /home/ubuntu/datasette-venv/bin/twitter-to-sqlite home-timeline /home/ubuntu/timeline.db -a /home/ubuntu/auth.json --since
	4,14,24,34,44,54 * * * * run-one /home/ubuntu/datasette-venv/bin/twitter-to-sqlite mentions-timeline /home/ubuntu/twitter.db -a /home/ubuntu/auth.json --since

	#!/bin/bash

	#
	# Run command in all running containers
	# Usage: $ ./lxc-exec-all.sh apt update && apt upgrade
	#

	for container in $(lxc list volatile.last_state.power=RUNNING -c n --format csv); do
	lxc exec "$container" "$@"
	done

	# How to sign your custom RPM package with GPG key

	# Step: 1
	# Generate gpg key pair (public key and private key)
	#
	# You will be prompted with a series of questions about encryption.
	# Simply select the default values presented. You will also be asked
	# to create a Real Name, Email Address and Comment (comment optional).
	#
	# If you get the following response:

	#!/bin/bash
	curl -sSk http://192.168.11.10:8000 \
	-b ./cookies.txt \
	-H "Accept: application/json" \
	-H "Content-type: application/json" \
	-d '[{
	"client": "local_async",
	"tgt":"overlord",
	"fun":"state.sls",
	"kwarg": { "mods": "test.s_test-state1" }