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 colons, which will …

Read More

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 country_asn.csv | csv2rec | recsel …

Read More

Store your bibliography in a recfile database, then extract any part with make. For example, you could store books like this in bibliography.rec: 1%rec: book 2%key: slug 3 4slug: thinkingexperience 5author: H. H. Price 6title: Thinking and Experience 7year: 1953 8publisher: Harvard University Press, Cambridge 9 10slug: …

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