• Board Games with Recfiles

    1 min read · data recfiles games

    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 …


    Read More

  • IP Addresses with Recfiles

    1 min read · data recfiles games

    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

  • Recfile Bibliography for TeX

    2 min read · data database recfiles tex

    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 …

    Read More

  • Recfiles Extended Example

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

    Read More

  • Recfixes

    1 min read · data 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: …


    Read More