Create: 1database=games.rec 2touch $database 3for g in Vojvodina Saboter Carcassonne Chess; do 4 recins -r "Name: $g" -r "Played: yes" $database 5done Read: 1recsel $database 2query=Carc 3recsel --quick=$query $database 4 5game=Vojvodina 6recsel --expression="Name = '${game}'" $database Update: 1recset …

Read More

Requirements Recfiles Create Make a database for your boardgames, specifying only one field and value: 1database=games.rec 2n=Name 3g=Vojvodina 4touch ${database} 5recins -f ${n} --value ${g} ${database} 6recsel ${database} Insert a few more, with the estimated playtime: 1recins -f Name -v Saboter -f Playtime -v 30 …

Read More

Requirements Recfiles Sometimes recsel chokes on a large query, and you need to break the query into chunks with a pipe. This Kickstarter file has 374,853 records. Here's the chonky query: 1recsel kick.rec -e "Category = 'Games'" -p "Subcategory,Avg(Goal)" -G Subcategory It breaks down like this: Chunk Meaning recsel …

Read More

This utility is largely useless, as it can only identify people by their email. So if someone has multiple GPG keys associated with one email, the tool will not work. A broken tool is better than a tool which will break soon.

Read More

Convert markdown table to csv 1mlr --imarkdown --ocsv cat ${file}.md Convert a csv file to markdown 1mlr --icsv --omd cat ${file}.csv

Read More

Requirements vim basics Basic Commands See Cells Cells are hard to see. Change this with :set autowrap. Make sc-im always autowrap: 1mkdir .config/sc-im/bash 2echo 'set autowrap' >> .config/sc-im/scimrc Movement Command Key highest part H lowest part L top gg most right. g$ most left. g0 insert middle \ insert left > …

Read More

Requirements cron You can search every file on the computer instantly by installing plocate. Once installed, run sudo updatedb to create the database of (nearly) every file on the computer. Check how big the database is: 1du -h /var/lib/plocate/plocate.db Once you have the database, you can find nearly any file …

Read More

Check subtitles available: 1url='https://videos.domainepublic.net/videos/watch/d9567d5b-1add-477c-bce3-a58cef84c28c' 2yt-dlp --list-subs "$url" | grep --max-count=1 '^en' The original language often displays with -orig, e.g. en-orig (Original). Language Formats ar vtt az vtt bg vtt ca vtt cs vtt da vtt de vtt el vtt en …

Read More

1git config --global user.email "${email}" 1git config --global user.name "${name}" Decide on algorithm: If you're scared of insecure hash-sums, go with hash=sha256. If you don't know what a hash sum is, go with hash=sha1. Init the Git Start a git in directory ${DIR}: 1git init --object-format=${hash} ${DIR} 2cd …

Read More

You can share parts of a secret with multiple people, so only some of them need to agree to see the secret. Install ssss, then decide on the total number of secrets (N), and the threshold of people who must share their shard of the secret in order to reveal the secret. 1N=5 2T=3 3FILE=secret.txt 4fortune | ssss-split …

Read More