{
  "_id": "6aae45353d719c1f8407a766",
  "Package": "nordstatExtras",
  "Title": "Shared 'SQLite' Cache Backend for the 'nordstat' Package Family",
  "Version": "0.1.0.9004",
  "Authors@R": "person(\"Love\", \"Hansson\", , \"love.hansson@gmail.com\",\nrole = c(\"aut\", \"cre\"))",
  "Description": "Provides a SQLite-backed cell-level cache that can be used\nas a drop-in backend by the 'nordstat' family of packages\n('rKolada', 'rTrafa', and 'pixieweb'). Designed for multi-user\nweb applications where minimal fetch latency and asynchronous\nwrites are required. Individual statistical values (\"cells\")\nare stored in a gatekeeper schema with a sidecar table for\narbitrary metadata dimensions, enabling deduplication across\noverlapping queries.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "Config/testthat/edition": "3",
  "URL": "https://github.com/LCHansson/nordstatExtras",
  "BugReports": "https://github.com/LCHansson/nordstatExtras/issues",
  "Repository": "https://lchansson.r-universe.dev",
  "Date/Publication": "2026-05-19 06:16:18 UTC",
  "RemoteUrl": "https://github.com/lchansson/nordstatextras",
  "RemoteRef": "HEAD",
  "RemoteSha": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-09-19 08:14:48 UTC",
    "User": "root"
  },
  "Author": "Love Hansson [aut, cre]",
  "Maintainer": "Love Hansson <love.hansson@gmail.com>",
  "_user": "lchansson",
  "_type": "src",
  "_file": "nordstatExtras_0.1.0.9004.tar.gz",
  "_fileid": "https://r2.ropensci.org/7ae8a558df3ec60d55f376203f283a641e8e50d69ce0b7d484f18e209f9b9ce7",
  "_filesize": 157746,
  "_sha256": "7ae8a558df3ec60d55f376203f283a641e8e50d69ce0b7d484f18e209f9b9ce7",
  "_expires": "2026-12-28T08:17:55.000Z",
  "_created": "2026-09-19T08:14:48.000Z",
  "_published": "2026-09-19T08:17:57.207Z",
  "_jobs": [
    {
      "job": 105866798287,
      "time": 142,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "10580898217"
    },
    {
      "job": 105866798286,
      "time": 136,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "ERROR",
      "artifact": "10580573571"
    },
    {
      "job": 105866798263,
      "time": 90,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "10580913145"
    },
    {
      "job": 105866798266,
      "time": 74,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "ERROR",
      "artifact": "10580773303"
    },
    {
      "job": 105866485158,
      "time": 157,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10579879597"
    },
    {
      "job": 105866798323,
      "time": 95,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10581013004"
    },
    {
      "job": 105866798319,
      "time": 62,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "10580044454"
    },
    {
      "job": 105866798304,
      "time": 77,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "10581027819"
    },
    {
      "job": 105866798293,
      "time": 65,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "ERROR",
      "artifact": "10580368965"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202",
  "_status": "success",
  "_upstream": "https://github.com/lchansson/nordstatextras",
  "_commit": {
    "id": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
    "author": "LCHansson <love.hansson@gmail.com>",
    "committer": "LCHansson <love.hansson@gmail.com>",
    "message": "Update schema\n",
    "time": 1779171378
  },
  "_maintainer": {
    "name": "Love Hansson",
    "email": "love.hansson@gmail.com",
    "login": "lchansson",
    "description": "",
    "uuid": 2472298
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "digest",
      "role": "Imports"
    },
    {
      "package": "mirai",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "withr",
      "role": "Suggests"
    }
  ],
  "_owner": "lchansson",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-16",
      "n": 6
    },
    {
      "week": "2026-17",
      "n": 1
    },
    {
      "week": "2026-21",
      "n": 1
    }
  ],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "lchansson",
      "count": 8,
      "uuid": 2472298
    }
  ],
  "_userbio": {
    "uuid": 2472298,
    "type": "user",
    "name": "Love Hansson",
    "followers": 18
  },
  "_downloads": {
    "count": 287,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/nordstatExtras"
  },
  "_devurl": "https://github.com/lchansson/nordstatextras",
  "_searchresults": 2,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/nordstatExtras.html",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/lchansson/nordstatextras",
  "_realowner": "lchansson",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2026-04-21"
    }
  ],
  "_exports": [
    "nxt_cache_handler",
    "nxt_clear",
    "nxt_close",
    "nxt_expired_searches",
    "nxt_flush",
    "nxt_gc",
    "nxt_is_backend",
    "nxt_open",
    "nxt_record_search",
    "nxt_search",
    "nxt_write_async"
  ],
  "_help": [
    {
      "page": "nxt_cache_handler",
      "title": "Drop-in cache handler for the nordstat family",
      "topics": [
        "nxt_cache_handler"
      ]
    },
    {
      "page": "nxt_clear",
      "title": "Clear cached queries from the nordstatExtras backend",
      "topics": [
        "nxt_clear"
      ]
    },
    {
      "page": "nxt_close",
      "title": "Close a nordstatExtras cache handle",
      "topics": [
        "nxt_close"
      ]
    },
    {
      "page": "nxt_expired_searches",
      "title": "List recorded searches that are due for a refresh",
      "topics": [
        "nxt_expired_searches"
      ]
    },
    {
      "page": "nxt_flush",
      "title": "Flush pending async writes",
      "topics": [
        "nxt_flush"
      ]
    },
    {
      "page": "nxt_gc",
      "title": "Garbage-collect stale cache rows",
      "topics": [
        "nxt_gc"
      ]
    },
    {
      "page": "nxt_is_backend",
      "title": "Detect whether a cache location should use the nordstatExtras backend",
      "topics": [
        "nxt_is_backend"
      ]
    },
    {
      "page": "nxt_open",
      "title": "Open or create a nordstatExtras SQLite cache",
      "topics": [
        "nxt_open"
      ]
    },
    {
      "page": "nxt_record_search",
      "title": "Record a live search so the local index finds it next time",
      "topics": [
        "nxt_record_search"
      ]
    },
    {
      "page": "nxt_search",
      "title": "Full-text search across cached metadata",
      "topics": [
        "nxt_search"
      ]
    },
    {
      "page": "nxt_write_async",
      "title": "Enqueue an asynchronous cache write",
      "topics": [
        "nxt_write_async"
      ]
    }
  ],
  "_readme": "https://github.com/lchansson/nordstatextras/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "digest",
    "fastmap",
    "glue",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "memoise",
    "pillar",
    "pkgconfig",
    "rlang",
    "RSQLite",
    "tibble",
    "utf8",
    "vctrs"
  ],
  "_score": 3.1760912590556813,
  "_indexed": true,
  "_nocasepkg": "nordstatextras",
  "_universes": [
    "lchansson"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:17:11.000Z",
      "distro": "resolute",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/fd904dc0a5bd1d66e423f00db063c33bda4b78e1482da326e20518c40dfa49d7",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:17:03.000Z",
      "distro": "resolute",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/5389f151488a23fbf2480b8da4229bf81414b7278b5abe24f2e808a5455167f3",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:16:22.000Z",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/df09a487d996f366a3b91b691305284502525857b84a2bf9391fbab8d173726a",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:16:08.000Z",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/bbacf1690fdd3426918a3a38ec92e70833d75da31bbbe1c1527648d2f48b387f",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:16:37.000Z",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/704b0db952305915f36d6f1fce06bd7ecc26c30c8fba2fee71432c72b6172daf",
      "status": "success",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:15:41.000Z",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/8b4424292a4d79cdbb8f9922149b65d1de81069a4baac2d297a1606b75beec65",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:15:57.000Z",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/8f8092178ccf7bc0bece0d52cd4631285255e6bbf5db22c09f86b56716c56501",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0.9004",
      "date": "2026-09-19T08:15:45.000Z",
      "commit": "69aa1ae09eb3b205ddbe72c981f7410ae828b6c2",
      "fileid": "https://r2.ropensci.org/c0fdaff22dff8ec54559b927e938577101fc0476f1a72d01f9182b6d36326e8a",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/lchansson/actions/runs/35431356202"
    }
  ]
}