{
  "_id": "6aea8f19818c9e3ef6dc05c8",
  "Package": "foosball3",
  "Title": "An App to Manage and Organise Foosball Tournaments",
  "Version": "0.0.1.0008",
  "Authors@R": "c(person(\"Pepijn\", \"de Vries\", role = c(\"aut\", \"cre\", \"dtc\"),\nemail = \"pepijn.devries@outlook.com\",\ncomment = c(ORCID = \"0000-0002-7961-6646\")))",
  "Author": "Pepijn de Vries [aut, cre, dtc] (0000-0002-7961-6646)",
  "Description": "A relational SQLite database used to manage leisure\nfoosball tournaments. This package provides a features and a\ngraphical user interface to easily access the database. It also\nallows to visualise (historical) data and account player\nhistory. It can be used to facilitate a live tournament.",
  "License": "GPL (>= 3)",
  "Language": "en-GB",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "URL": "https://github.com/pepijn-devries/foosball3,\nhttps://pepijn-devries.github.io/foosball3/",
  "BugReports": "https://github.com/pepijn-devries/foosball3/issues",
  "Config/roxygen2/version": "8.1.0",
  "Config/testthat/edition": "3",
  "VignetteBuilder": "knitr",
  "Collate": "'mod_lookup.R' 'mod_record.R' 'mod_records.R'\n'mod_table_details.R' 'schema.R' 'mod_helpers.R' 'create.R'\n'mod_diagram.R' 'mod_db_manager.R' 'mod_warming_up.R'\n'suggests.R' 'foosball3.R' 'app_server.R'\n'mod_tournament_stats.R' 'mod_person_stats.R' 'mod_people.R'\n'mod_penalty.R' 'mod_table_arrangement.R'\n'mod_generator_finals.R' 'mod_generator_qualification.R'\n'mod_match_generator.R' 'mod_match_side.R' 'mod_match.R'\n'mod_phases.R' 'mod_matches.R' 'mod_plot.R'\n'mod_person_picker.R' 'mod_tournament_editor.R' 'mod_picture.R'\n'mod_tournament.R' 'app_ui.R' 'export.R' 'foosball3-package.R'\n'generate.R' 'import.R' 'meta.R' 'mod_avatar.R' 'mod_coin.R'\n'mod_news.R' 'mod_progress.R' 'mod_timer.R'",
  "Config/pak/sysreqs": "cmake make libicu-dev libuv1-dev zlib1g-dev",
  "Repository": "https://pepijn-devries.r-universe.dev",
  "Date/Publication": "2026-11-03 17:35:30 UTC",
  "RemoteUrl": "https://github.com/pepijn-devries/foosball3",
  "RemoteRef": "main",
  "RemoteSha": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-11-04 01:41:04 UTC",
    "User": "root"
  },
  "Maintainer": "Pepijn de Vries <pepijn.devries@outlook.com>",
  "_user": "pepijn-devries",
  "_type": "src",
  "_file": "foosball3_0.0.1.0008.tar.gz",
  "_fileid": "https://r2.ropensci.org/c5e565c3409f56cc2c6e225221b10730bfed12b23c564618f80f036d25b79c9a",
  "_filesize": 851837,
  "_sha256": "c5e565c3409f56cc2c6e225221b10730bfed12b23c564618f80f036d25b79c9a",
  "_expires": "2027-02-12T01:49:11.000Z",
  "_created": "2026-11-04T01:41:04.000Z",
  "_published": "2026-11-04T01:49:13.428Z",
  "_upstream": "https://github.com/pepijn-devries/foosball3",
  "_status": "success",
  "_maintainer": {
    "name": "Pepijn de Vries",
    "email": "pepijn.devries@outlook.com",
    "login": "pepijn-devries",
    "linkedin": "in/pepijn-de-vries-2509b664",
    "orcid": "0000-0002-7961-6646",
    "description": "",
    "uuid": 13707449
  },
  "_jobs": [
    {
      "job": 126331429664,
      "time": 171,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13288361743"
    },
    {
      "job": 126331429573,
      "time": 173,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13288461621"
    },
    {
      "job": 126331429602,
      "time": 142,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13288357132"
    },
    {
      "job": 126331429567,
      "time": 371,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13287973508"
    },
    {
      "job": 126330071057,
      "time": 222,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13287468352"
    },
    {
      "job": 126331429597,
      "time": 122,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "13287538571"
    },
    {
      "job": 126331429734,
      "time": 122,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "13287847856"
    },
    {
      "job": 126331429710,
      "time": 131,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "13287404088"
    },
    {
      "job": 126331429755,
      "time": 124,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "13288301732"
    }
  ],
  "_buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954",
  "_commit": {
    "id": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
    "author": "Pepijn de Vries <pepijn-devries@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #39 from pepijn-devries/work-in-progress\n\nFixes to people server",
    "time": 1793727330
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "blob",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "shiny",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "base64enc",
      "role": "Suggests"
    },
    {
      "package": "bsicons",
      "role": "Suggests"
    },
    {
      "package": "bslib",
      "role": "Suggests"
    },
    {
      "package": "DiagrammeR",
      "role": "Suggests"
    },
    {
      "package": "DiagrammeRsvg",
      "role": "Suggests"
    },
    {
      "package": "dm",
      "role": "Suggests"
    },
    {
      "package": "DT",
      "role": "Suggests"
    },
    {
      "package": "ggplot2",
      "role": "Suggests"
    },
    {
      "package": "ggiraph",
      "role": "Suggests"
    },
    {
      "package": "imager",
      "role": "Suggests"
    },
    {
      "package": "jsonlite",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "lubridate",
      "role": "Suggests"
    },
    {
      "package": "mirai",
      "role": "Suggests"
    },
    {
      "package": "promises",
      "role": "Suggests"
    },
    {
      "package": "shinybusy",
      "role": "Suggests"
    },
    {
      "package": "shinyjs",
      "role": "Suggests"
    },
    {
      "package": "shinyvalidate",
      "role": "Suggests"
    },
    {
      "package": "shinyWidgets",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    }
  ],
  "_owner": "pepijn-devries",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-34",
      "n": 6
    },
    {
      "week": "2026-35",
      "n": 4
    },
    {
      "week": "2026-36",
      "n": 13
    },
    {
      "week": "2026-37",
      "n": 10
    },
    {
      "week": "2026-38",
      "n": 1
    },
    {
      "week": "2026-40",
      "n": 3
    },
    {
      "week": "2026-42",
      "n": 4
    },
    {
      "week": "2026-43",
      "n": 6
    },
    {
      "week": "2026-44",
      "n": 1
    },
    {
      "week": "2026-45",
      "n": 2
    }
  ],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "pepijn-devries",
      "count": 135,
      "uuid": 13707449
    }
  ],
  "_userbio": {
    "uuid": 13707449,
    "type": "user",
    "name": "Pepijn de Vries",
    "followers": 25
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/foosball3"
  },
  "_devurl": "https://github.com/pepijn-devries/foosball3",
  "_pkgdown": "https://pepijn-devries.github.io/foosball3/",
  "_searchresults": 5,
  "_rbuild": "4.6.2",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/foosball3.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_cranurl": false,
  "_exports": [
    "foosball3",
    "foosball3_create_db",
    "foosball3_export_db",
    "foosball3_generate_matches",
    "foosball3_get_schema",
    "foosball3_import_db",
    "foosball3_list_suggests",
    "foosball3_meta_data",
    "foosball3_suggests_ok"
  ],
  "_help": [
    {
      "page": "foosball3",
      "title": "Start the Foosball App",
      "topics": [
        "foosball3"
      ]
    },
    {
      "page": "foosball3_create_db",
      "title": "Create a New Foosball Database",
      "topics": [
        "foosball3_create_db"
      ]
    },
    {
      "page": "foosball3_export_db",
      "title": "Export an Foosball SQLite Database to CSV Format",
      "topics": [
        "foosball3_export_db"
      ]
    },
    {
      "page": "foosball3_generate_matches",
      "title": "Generate Matches for a Tournament Phase",
      "topics": [
        "foosball3_generate_matches"
      ]
    },
    {
      "page": "foosball3_get_schema",
      "title": "Get foosball3 Schema Data",
      "topics": [
        "foosball3_get_schema"
      ]
    },
    {
      "page": "foosball3_import_db",
      "title": "Import Foosball Tournament Data from a File",
      "topics": [
        "foosball3_import_db"
      ]
    },
    {
      "page": "foosball3_list_suggests",
      "title": "List Packages Suggested by the 'foosball3' Package",
      "topics": [
        "foosball3_list_suggests"
      ]
    },
    {
      "page": "foosball3_meta_data",
      "title": "Get Meta Data for Tables in the Foosball Database Scheme",
      "topics": [
        "foosball3_meta_data"
      ]
    },
    {
      "page": "foosball3_suggests_ok",
      "title": "Check if All Suggested Packages Are Available",
      "topics": [
        "foosball3_suggests_ok"
      ]
    }
  ],
  "_pkglogo": "https://github.com/pepijn-devries/foosball3/raw/main/man/figures/logo.svg",
  "_readme": "https://github.com/pepijn-devries/foosball3/raw/main/README.md",
  "_rundeps": [
    "base64enc",
    "bit",
    "bit64",
    "blob",
    "bslib",
    "cachem",
    "cli",
    "commonmark",
    "cpp11",
    "DBI",
    "dbplyr",
    "digest",
    "dplyr",
    "fastmap",
    "fontawesome",
    "fs",
    "generics",
    "glue",
    "htmltools",
    "httpuv",
    "jquerylib",
    "jsonlite",
    "later",
    "lifecycle",
    "magrittr",
    "memoise",
    "mime",
    "otel",
    "pillar",
    "pkgconfig",
    "promises",
    "purrr",
    "R6",
    "rappdirs",
    "Rcpp",
    "rlang",
    "RSQLite",
    "sass",
    "shiny",
    "sourcetools",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr",
    "xtable"
  ],
  "_vignettes": [
    {
      "source": "foosball3-database.Rmd",
      "filename": "foosball3-database.html",
      "title": "The foosball3 Database",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Database Structure",
        "Tournaments",
        "People",
        "Disclaimer",
        "Locations, Tables and Balls",
        "And Many More",
        "Views"
      ],
      "created": "2026-10-22 21:53:18",
      "modified": "2026-10-29 23:14:06",
      "commits": 2
    },
    {
      "source": "foosball3-history.Rmd",
      "filename": "foosball3-history.html",
      "title": "The History of the foosball3 App",
      "engine": "knitr::rmarkdown",
      "headings": [],
      "created": "2026-10-21 13:37:48",
      "modified": "2026-10-21 13:37:48",
      "commits": 1
    }
  ],
  "_score": 4,
  "_indexed": true,
  "_nocasepkg": "foosball3",
  "_universes": [
    "pepijn-devries"
  ],
  "_previous": "0.0.1.0006",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:43:37.000Z",
      "distro": "resolute",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/0af8a71293420abcc87a2e4de63d4c272dd007cee3f9f0b7f269d6601720127b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:43:39.000Z",
      "distro": "resolute",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/5dff81cdc94e6bd738833b28d39036143129dad1f0c20fd33353fdd0c9989efb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:46:21.000Z",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/0a705abfc4db5e089b8b9112ceecfa16507877195836376ce16fc16f32640f84",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:47:01.000Z",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/19532ed59163506f80c120a292741aec7276b3188907a557355658fe80daf11e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:43:31.000Z",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/165d20920eb9edd677c81c21d3c46979ed98f0a8f0c2600c23c4b162552a5327",
      "status": "success",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:42:33.000Z",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/26a6526bfdf31603cb70e5faed8421c896b8e10545fc35aa0387d3225737ec10",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:42:41.000Z",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/9d2de265430901167a27bba09e9bc8630406e58a6d342119443cb3b3e599e783",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.0.1.0008",
      "date": "2026-11-04T01:42:36.000Z",
      "commit": "0f5fe06f8ffa939a89edef168988bf1b8a5c9b57",
      "fileid": "https://r2.ropensci.org/d4cf72cf3d76b5accafb77f25f362941bec319d4caf7d19af0a568d6ff978e7b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/41755319954"
    }
  ]
}