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

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 $database 2recins -f Name -v Chess …

Read More

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 kick.rec Select records …

Read More

Sample file 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 > insert right …

Read More

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 instantly. Search for …

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). 1Language Formats 2ar vtt 3az vtt 4bg vtt 5ca vtt 6cs vtt 7da vtt 8de vtt …

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

sudo apt-get purge -y snapd

Read More

A soft link is a file which says how to go to another file. When a program encounters a soft link, it will make a guess at whether it should ignore it, or try to get to that file. To make a soft link to a file in the current directory, linking is easy: 1fortune > $file_1 2ln -s $file_1 $link_1 Now imagine your …

Read More

Over time git repositories become bloated with old data, but never get cleaned. I can't find an official way to clean up the crud, so I did this: 1usermod -aG soft-serve $USER 2# Log out and back in for this to take effect. 3 4cd /var/lib/soft-serve/data/repos 5sudo chmod -R g+w * 6git config --global --add …

Read More