{
  "_id": "6a57ffc8ff0138dec5d72450",
  "Package": "sxpdb",
  "Title": "Store R values",
  "Version": "0.1",
  "Authors@R": "c(\nperson(given = \"Pierre\",\nfamily = \"Donat-Bouillud\",\nrole = c(\"aut\", \"cre\"),\nemail = \"pierre.donat.bouillud@gmail.com\",\ncomment = c(ORCID = \"0000-0003-4455-1130\")),\nperson(given = \"Yuan\",\nfamily = \"Cao\",\nrole = c(\"aut\"),\nemail = \"cao.yuan1@northeastern.edu\"),\nperson(given = \"Filip\",\nfamily = \"Krikava\",\nrole = c(\"ctb\"),\nemail = \"krikava@gmail.com\",\ncomment = c(ORCID = \"0000-0002-0478-6202\")))",
  "Description": "Stores R values. It stores the values in an efficient ways\nthat scales to millions of unique values and provides a rich\nquery API to find values from the database.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "SystemRequirements": "C++17",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.2.3",
  "Remotes": [
    "PRL-PRG/mutator"
  ],
  "Config/pak/sysreqs": "cmake make libuv1-dev",
  "Repository": "https://prl-prg.r-universe.dev",
  "Date/Publication": "2026-07-15 21:17:10 UTC",
  "RemoteUrl": "https://github.com/PRL-PRG/sxpdb",
  "RemoteRef": "HEAD",
  "RemoteSha": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
  "NeedsCompilation": "yes",
  "Packaged": {
    "Date": "2026-07-15 21:40:56 UTC",
    "User": "root"
  },
  "Author": "Pierre Donat-Bouillud [aut, cre] (ORCID:\n<https://orcid.org/0000-0003-4455-1130>),\nYuan Cao [aut],\nFilip Krikava [ctb] (ORCID: <https://orcid.org/0000-0002-0478-6202>)",
  "Maintainer": "Pierre Donat-Bouillud <pierre.donat.bouillud@gmail.com>",
  "_user": "prl-prg",
  "_type": "src",
  "_file": "sxpdb_0.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/3dc3b842b7a991ec584c98b2d1a4992eafbcf49aaae5a593bfb2d8db77509a32",
  "_filesize": 399573,
  "_sha256": "3dc3b842b7a991ec584c98b2d1a4992eafbcf49aaae5a593bfb2d8db77509a32",
  "_expires": "2026-10-23T21:46:46.000Z",
  "_created": "2026-07-15T21:40:56.000Z",
  "_published": "2026-07-15T21:46:48.042Z",
  "_jobs": [
    {
      "job": 87479214662,
      "time": 208,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "8358260272"
    },
    {
      "job": 87479214691,
      "time": 156,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "8358237510"
    },
    {
      "job": 87479214652,
      "time": 175,
      "config": "linux-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "8358246884"
    },
    {
      "job": 87479214649,
      "time": 169,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "8358243046"
    },
    {
      "job": 87479214645,
      "time": 122,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "8358222092"
    },
    {
      "job": 87479214666,
      "time": 263,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "8358279805"
    },
    {
      "job": 87479214651,
      "time": 86,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "8358210584"
    },
    {
      "job": 87479214639,
      "time": 276,
      "config": "macos-release-x86_64",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "8358284113"
    },
    {
      "job": 87478295404,
      "time": 289,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8358174549"
    },
    {
      "job": 87479214603,
      "time": 146,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8358233393"
    },
    {
      "job": 87479214617,
      "time": 149,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "8358234767"
    },
    {
      "job": 87479214653,
      "time": 165,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "8358242258"
    },
    {
      "job": 87479214641,
      "time": 166,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "WARNING",
      "artifact": "8358241487"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216",
  "_status": "success",
  "_upstream": "https://github.com/PRL-PRG/sxpdb",
  "_commit": {
    "id": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
    "author": "Pierre Donat-Bouillud <pierre.donat.bouillud@gmail.com>",
    "committer": "Pierre Donat-Bouillud <pierre.donat.bouillud@gmail.com>",
    "message": "Use a version of an iterator that works for wasm\n",
    "time": 1784150230
  },
  "_maintainer": {
    "name": "Pierre Donat-Bouillud",
    "email": "pierre.donat.bouillud@gmail.com",
    "login": "programlyrique",
    "mastodon": "@pierredonatbouillud@fediscience.org",
    "bluesky": "@pierredb.bsky.social",
    "orcid": "0000-0003-4455-1130",
    "twitter": "@pdonatbouillud",
    "description": "Researcher at CVUT, visiting researcher at Northeastern University,\nPhd from Sorbonne Université,\nComputer languages, computer music, R",
    "uuid": 382128
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "testthat",
      "role": "LinkingTo"
    },
    {
      "package": "pkgload",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "xml2",
      "role": "Suggests"
    },
    {
      "package": "mutator",
      "role": "Suggests"
    }
  ],
  "_owner": "prl-prg",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-29",
      "n": 12
    }
  ],
  "_tags": [],
  "_topics": [
    "database",
    "fuzzing",
    "high-performance",
    "r-values",
    "cpp"
  ],
  "_stars": 3,
  "_contributors": [
    {
      "user": "programlyrique",
      "count": 337,
      "uuid": 382128
    },
    {
      "user": "yth",
      "count": 10,
      "uuid": 4776181
    },
    {
      "user": "fikovnik",
      "count": 3,
      "uuid": 374674
    }
  ],
  "_userbio": {
    "uuid": 22217634,
    "type": "organization",
    "name": "PRL-PRG",
    "followers": 7
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sxpdb"
  },
  "_devurl": "https://github.com/prl-prg/sxpdb",
  "_searchresults": 7,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/readme.html",
    "extra/readme.md",
    "extra/sxpdb.html",
    "LICENSE",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    "add_origin",
    "add_val",
    "add_val_origin",
    "build_indexes",
    "check_all_db",
    "close_db",
    "close_query",
    "filter_index_db",
    "get_meta",
    "get_meta_idx",
    "get_origins",
    "get_origins_idx",
    "get_value_idx",
    "has_search_index",
    "have_seen",
    "is_query_empty",
    "map_db",
    "merge_all_dbs",
    "merge_db",
    "merge_into",
    "nb_values_db",
    "open_db",
    "path_db",
    "query_from_plan",
    "query_from_value",
    "relax_query",
    "sample_index",
    "sample_similar",
    "sample_val",
    "show_query",
    "size_db",
    "string_sexp_type",
    "values_from_calls",
    "values_from_origin",
    "view_call_ids",
    "view_db",
    "view_db_names",
    "view_meta_db",
    "view_origins_db",
    "write_mode"
  ],
  "_help": [
    {
      "page": "add_origin",
      "title": "Add origin to an already recorded value",
      "topics": [
        "add_origin"
      ]
    },
    {
      "page": "add_val",
      "title": "Add a value in the dabatase",
      "topics": [
        "add_val"
      ]
    },
    {
      "page": "add_val_origin",
      "title": "Add a value with origin and call id",
      "topics": [
        "add_val_origin"
      ]
    },
    {
      "page": "build_indexes",
      "title": "Build search indexes.",
      "topics": [
        "build_indexes"
      ]
    },
    {
      "page": "check_all_db",
      "title": "Checks if the db is not corrupted.",
      "topics": [
        "check_all_db"
      ]
    },
    {
      "page": "close_db",
      "title": "Closes the database",
      "topics": [
        "close_db"
      ]
    },
    {
      "page": "close_query",
      "title": "Closes a query object.",
      "topics": [
        "close_query"
      ]
    },
    {
      "page": "filter_index_db",
      "title": "Filters values from the database according to some predicate",
      "topics": [
        "filter_index_db"
      ]
    },
    {
      "page": "get_meta",
      "title": "Get the metadata associated to a value",
      "topics": [
        "get_meta"
      ]
    },
    {
      "page": "get_meta_idx",
      "title": "Get the metadata associated to an index",
      "topics": [
        "get_meta_idx"
      ]
    },
    {
      "page": "get_origins",
      "title": "Get the origins of a value",
      "topics": [
        "get_origins"
      ]
    },
    {
      "page": "get_origins_idx",
      "title": "Get the origins of a value",
      "topics": [
        "get_origins_idx"
      ]
    },
    {
      "page": "get_value_idx",
      "title": "Get the value in the db at a given index",
      "topics": [
        "get_value_idx"
      ]
    },
    {
      "page": "has_search_index",
      "title": "Checks if the database has a search index",
      "topics": [
        "has_search_index"
      ]
    },
    {
      "page": "have_seen",
      "title": "Checks if a value is in the database",
      "topics": [
        "have_seen"
      ]
    },
    {
      "page": "is_query_empty",
      "title": "Checks if a query object is empty.",
      "topics": [
        "is_query_empty"
      ]
    },
    {
      "page": "map_db",
      "title": "Map a function on the values in the database",
      "topics": [
        "map_db"
      ]
    },
    {
      "page": "merge_all_dbs",
      "title": "Merges several dbs into a new large one.",
      "topics": [
        "merge_all_dbs"
      ]
    },
    {
      "page": "merge_db",
      "title": "Merge a db into another one.",
      "topics": [
        "merge_db"
      ]
    },
    {
      "page": "merge_into",
      "title": "Merge a source db into a target db",
      "topics": [
        "merge_into"
      ]
    },
    {
      "page": "nb_values_db",
      "title": "Computes the number of values matching a given query",
      "topics": [
        "nb_values_db"
      ]
    },
    {
      "page": "open_db",
      "title": "Open a database",
      "topics": [
        "open_db"
      ]
    },
    {
      "page": "path_db",
      "title": "Path to the database directory",
      "topics": [
        "path_db"
      ]
    },
    {
      "page": "query_from_plan",
      "title": "Creates a query from a plan.",
      "topics": [
        "query_from_plan"
      ]
    },
    {
      "page": "query_from_value",
      "title": "Creates a query from an example value.",
      "topics": [
        "query_from_value"
      ]
    },
    {
      "page": "relax_query",
      "title": "Relaxes on some parameters of a query.",
      "topics": [
        "relax_query"
      ]
    },
    {
      "page": "sample_index",
      "title": "Sample randomly a value from the database",
      "topics": [
        "sample_index"
      ]
    },
    {
      "page": "sample_similar",
      "title": "Sample randomly a value similar to a given from the database",
      "topics": [
        "sample_similar"
      ]
    },
    {
      "page": "sample_val",
      "title": "Sample randomly a value from the database",
      "topics": [
        "sample_val"
      ]
    },
    {
      "page": "show_query",
      "title": "Displays a query",
      "topics": [
        "show_query"
      ]
    },
    {
      "page": "size_db",
      "title": "Number of elements in the database",
      "topics": [
        "size_db"
      ]
    },
    {
      "page": "string_sexp_type",
      "title": "Get a textual repreentation of an R type",
      "topics": [
        "string_sexp_type"
      ]
    },
    {
      "page": "values_from_calls",
      "title": "Fetches all the calls corresponding to one origin",
      "topics": [
        "values_from_calls"
      ]
    },
    {
      "page": "values_from_origin",
      "title": "Fetches all the values corresponding to one origin",
      "topics": [
        "values_from_origin"
      ]
    },
    {
      "page": "view_call_ids",
      "title": "Fetches call ids from the database.",
      "topics": [
        "view_call_ids"
      ]
    },
    {
      "page": "view_db",
      "title": "Fetch values from the database.",
      "topics": [
        "view_db"
      ]
    },
    {
      "page": "view_db_names",
      "title": "Fetches the origin databases",
      "topics": [
        "view_db_names"
      ]
    },
    {
      "page": "view_meta_db",
      "title": "Fetches metadata from the database.",
      "topics": [
        "view_meta_db"
      ]
    },
    {
      "page": "view_origins_db",
      "title": "Fetches origins from the database",
      "topics": [
        "view_origins_db"
      ]
    },
    {
      "page": "write_mode",
      "title": "Checks if the database is in write mode",
      "topics": [
        "write_mode"
      ]
    }
  ],
  "_readme": "https://github.com/PRL-PRG/sxpdb/raw/HEAD/README.md",
  "_rundeps": [
    "brio",
    "callr",
    "cli",
    "crayon",
    "desc",
    "diffobj",
    "evaluate",
    "fs",
    "glue",
    "jsonlite",
    "lifecycle",
    "magrittr",
    "otel",
    "pkgbuild",
    "pkgload",
    "praise",
    "processx",
    "ps",
    "R6",
    "rlang",
    "rprojroot",
    "testthat",
    "waldo",
    "withr"
  ],
  "_sysdeps": [
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "16-20260322-1ubuntu1",
      "name": "c++",
      "homepage": "http://gcc.gnu.org/",
      "description": "GNU Standard C++ Library v3"
    }
  ],
  "_score": 2.4771212547196626,
  "_indexed": true,
  "_nocasepkg": "sxpdb",
  "_universes": [
    "prl-prg",
    "programlyrique"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1",
      "date": "2026-07-15T21:44:39.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/ee78bb294442e6e345f5be366bd0432f307ba89dada4ae90b40ee8fda2f519ab",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1",
      "date": "2026-07-15T21:43:42.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/22eb1c6a068866316cdd95fd99e8fb8e30d902bc7c26a27c546b81ad50dc2470",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1",
      "date": "2026-07-15T21:44:10.000Z",
      "distro": "resolute",
      "arch": "aarch64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/9f7af5ea07b54b880461312174e78bd06a990ad0dd56c9f4e72f872177e541d9",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1",
      "date": "2026-07-15T21:43:49.000Z",
      "distro": "resolute",
      "arch": "x86_64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/8c92c2e2e29504fb71aa8aedbaa797c6c4b5bf511ff4b97e9baa891c45012524",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1",
      "date": "2026-07-15T21:43:02.000Z",
      "arch": "aarch64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/af2f0e3290eb5802fe6c46c3a5d9414bf017ad30cdbdd39226c5d575cb53b121",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1",
      "date": "2026-07-15T21:44:40.000Z",
      "arch": "x86_64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/4c4c81e93293acd7aa48dfd008a8273b0657a60fa3727c755e773e27b156beeb",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1",
      "date": "2026-07-15T21:42:47.000Z",
      "arch": "aarch64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/4bbcaf3698ccc7e999131a7085426608ccbff5c6ecb51b592736ab1ce7bf5867",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1",
      "date": "2026-07-15T21:44:38.000Z",
      "arch": "x86_64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/ee92e5fd8108dbe67d2decf15127d1e50c8f2a2b69e52123700d424fecfba69f",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1",
      "date": "2026-07-15T21:43:46.000Z",
      "arch": "emscripten",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/7624236a58f76f6a474470c0f60e393b667cc2ae476db165a4a2511923660aa1",
      "status": "success",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1",
      "date": "2026-07-15T21:42:46.000Z",
      "arch": "x86_64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/1dee944de6c9a7d81be1569c8bb4715c7011334fb92c11165f1603a90a5f8873",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1",
      "date": "2026-07-15T21:42:47.000Z",
      "arch": "x86_64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/d970ed40e914c07c2470105a5f2f6de658dadf1e54790208fe4a09dce43548ad",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1",
      "date": "2026-07-15T21:43:01.000Z",
      "arch": "x86_64",
      "commit": "eacdf11be92bb7dbb636fadd6de641e6ffe9c0bc",
      "fileid": "https://r2.ropensci.org/968124d1453d06272d916f89e497f367a7aa30aff861ef97817036c41a7d7e87",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/prl-prg/actions/runs/29452540216"
    }
  ]
}