Requirements Recfiles You can play with a board games database from boardgamegeek.com. Download the Database 1mkdir board_games 2cd board_games 3curl -Lo bg.zip 'https://www.kaggle.com/api/v1/datasets/download/threnjen/board-games-database-from-boardgamegeek' 4unzip bg.zip The header line shows fields with a bunch of …

Read More

Requirements Recfiles Download the Database Download the csv data, and separate the ipv4 data from the ipv6. 1curl -Lo ips.zip 'https://www.kaggle.com/api/v1/datasets/download/ipinfo/ipinfo-country-asn' 2unzip -p ips.zip country_asn.csv | csv2rec | recsel -e "start_ip ~ '.'" > ipv4.rec 3unzip -p ips.zip …

Read More

Requirements Recfiles nginx The standard nginx log format has such a lack of consistency or meaning that you might squint your face into a whirlpool making sense of them: 18.97.14.85 - - [16/Nov/2025:00:52:12 +0100] "GET /posts/learning_without_experts/content.html HTTP/1.1" 200 1704 "-" "CCBot/2.0 …

Read More

Requirements Recfiles Makefiles Store your bibliography in a recfile database, then extract any part with make. For example, you could store books like this in bibliography.rec: %rec: book %key: slug slug: thinkingexperience author: H. H. Price title: Thinking and Experience year: 1953 publisher: Harvard University …

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

Combine many recfiles of different types into one 1sed '1i\ ' *.rec > all.rec Combine many recfiles of the same type into one 1recinf -d -t ${type} ${one}.rec > ${all}.rec 2sed '/^%/d' ${one}.rec ${two}.rec > all.rec The strange syntax used by sed only makes sense after using ed

Read More