• Recfile Bugs and Gotchas

    2 min read · data recfiles bugs

    Requirements Recfiles Only One Join You can't make more than one join, so you can take the record of a book and join it with a publisher, or with an author, but not both. This will not work: 1recsel Book.rec -t Book -j Publisher -j Author -p "Title,Publisher_City,Author_City" Formatting Demands Singular Fields You …


    Read More

  • Recfiles

    1 min read · data database

    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

  • Recfiles Extended Example

    2 min read · data database recfiles

    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

  • Recfixes

    1 min read · data recfiles

    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

  • Review: git-secret

    1 min read · data git review

    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

  • Rundown: git

    1 min read · size git email pr comfy maintenance data git

    Automatically select commits from the current branch during a merge git checkout "${master}" git merge "${branch}" git checkout --ours "${master}" These flags can be counterintuitive in other contexts. https://nitaym.github.io/ourstheirs/ Read the minimal size of a git repo 1git count-objects -vH | grep -Po 'size-pack: …


    Read More

  • Rundown: ijq

    1 min read · data json TUI ijq

    Analyse json easier with ijq column -J -ts: -H PW,GID,shell -N User,PW,UID,GID,Description,Home,shell /etc/passwd > host.json ijq !$ If you get stuck, try adding .[].


    Read More

  • Rundown: jless

    1 min read · data json pager TUI jless

    Read json with a pager jless "${file}".json


    Read More

  • Rundown: mlr

    1 min read · csv markdown data mlr

    Convert markdown table to csv 1mlr --m2c cat ${file}.md


    Read More

  • Rundown: sed

    1 min read · tip shell maintenance csv substitute replace writing data recfiles database text sed

    Remove long lines from bash history 1sed -i -r '/([^ ]{100,})\s?$/d' $HISTFILE Convert a csv file to markdown 1column -o '|' -ts, "$1" + | sed -r '0,/./p ; 0,/./s/[a-zA-Z ]/-/g; 0,/^|/s/|-/|:/g' Change a CSV header 1from=number 2to=quantity 3sed -i "1 s///" "".csv Replace first instance of word 1sed …


    Read More