{ "_id": "6a46d4bec8416c4719cd615e", "Package": "virta", "Type": "Package", "Title": "Virtual tables for RSQLite", "Version": "0.9.6", "Date": "2019-06-09", "Author": "Reijo Sund ", "Maintainer": "Reijo Sund ", "Description": "This package uses SQLite's loadable extension feature to\nprovide virtual table access to SVO-files.", "License": "Artistic-2.0", "LazyLoad": "yes", "Additional_repositories": "https://survo.fi", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-07-02 21:08:46 UTC", "User": "root" }, "Repository": "https://rsund.r-universe.dev", "Date/Publication": "2026-07-02 19:34:12 UTC", "RemoteUrl": "https://github.com/rsund/survor", "RemoteRef": "HEAD", "RemoteSha": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "RemoteSubdir": "pkg/virta", "_user": "rsund", "_type": "src", "_file": "virta_0.9.6.tar.gz", "_fileid": "https://r2.ropensci.org/da406af5476ad7869e377e6f9cdcdc086a56b5def591dbc785ebd5acb00e483d", "_filesize": 260772, "_sha256": "da406af5476ad7869e377e6f9cdcdc086a56b5def591dbc785ebd5acb00e483d", "_expires": "2026-10-10T21:14:38.000Z", "_created": "2026-07-02T21:08:46.000Z", "_published": "2026-07-02T21:14:38.740Z", "_jobs": [ { "job": 84878795199, "time": 143, "config": "linux-devel-arm64", "r": "4.7.0", "check": "NOTE", "artifact": "8051706410" }, { "job": 84878795157, "time": 114, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "8051696260" }, { "job": 84878795180, "time": 122, "config": "linux-release-arm64", "r": "4.6.1", "check": "NOTE", "artifact": "8051699640" }, { "job": 84878795183, "time": 117, "config": "linux-release-x86_64", "r": "4.6.1", "check": "NOTE", "artifact": "8051697015" }, { "job": 84878795185, "time": 82, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "8051702026" }, { "job": 84878795182, "time": 197, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "8051733733" }, { "job": 84878795166, "time": 95, "config": "macos-release-arm64", "r": "4.6.1", "check": "WARNING", "artifact": "8051707786" }, { "job": 84878795209, "time": 164, "config": "macos-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "8051725508" }, { "job": 84878196639, "time": 202, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8051654935" }, { "job": 84878795139, "time": 101, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8051691302" }, { "job": 84878795196, "time": 312, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "8051763092" }, { "job": 84878795154, "time": 241, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "8051739033" }, { "job": 84878795195, "time": 88, "config": "windows-release", "r": "4.6.1", "check": "WARNING", "artifact": "8051687282" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408", "_status": "success", "_upstream": "https://github.com/rsund/survor", "_commit": { "id": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "author": "Reijo Sund ", "committer": "Reijo Sund ", "message": "NULLify pointers after muste_fclose to avoid double fclose in EPS JOIN\n", "time": 1783020852 }, "_maintainer": { "name": "Reijo Sund", "email": "reijo.sund@uef.fi", "login": "rsund", "description": "", "uuid": 7668641 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "RSQLite", "version": ">= 1.0", "role": "Depends" }, { "package": "DBI", "role": "Depends" }, { "package": "muste", "version": ">= 0.5.36", "role": "Depends" }, { "package": "muste", "role": "LinkingTo" } ], "_owner": "rsund", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-27", "n": 7 } ], "_tags": [], "_stars": 3, "_contributors": [ { "user": "rsund", "count": 377, "uuid": 7668641 } ], "_userbio": { "uuid": 7668641, "type": "user", "name": "Reijo Sund", "followers": 0 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/virta" }, "_devurl": "https://github.com/rsund/survor", "_searchresults": 0, "_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/virta.html", "manual.pdf" ], "_cranurl": false, "_exports": [ "init_virtualtables", "virta.sql" ], "_help": [ { "page": "init_virtualtables", "title": "Initialize SQLite extension virtual tables on a SQLite DB connection", "topics": [ "init_virtualtables" ] }, { "page": "virta", "title": "Virtual tables for RSQLite", "topics": [] }, { "page": "virta.sql", "title": "SQL queries from Muste (SVO)-files using virtual tables", "topics": [ "virta.sql" ] } ], "_readme": "https://github.com/rsund/survor/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cachem", "cli", "cpp11", "DBI", "fastmap", "glue", "lifecycle", "memoise", "muste", "pkgconfig", "rlang", "RSQLite", "vctrs" ], "_score": 2.1760912590556813, "_indexed": true, "_nocasepkg": "virta", "_universes": [ "rsund" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.9.6", "date": "2026-07-02T21:11:17.000Z", "distro": "resolute", "arch": "aarch64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/a540cb8e2996fe0d43df15b4ddb4107fbc9772f4a6fe4e2a82d9faab5245a6b0", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.7.0", "os": "linux", "version": "0.9.6", "date": "2026-07-02T21:10:48.000Z", "distro": "resolute", "arch": "x86_64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/4c64a2ccc9da960b8ce9f438ebe661c9387ade5cff5cc19edf6b1752ce3e1855", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.6.1", "os": "linux", "version": "0.9.6", "date": "2026-07-02T21:10:58.000Z", "distro": "resolute", "arch": "aarch64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/d3d5e3ce074c5671c28813fcbd44b3b3f2d92d77cf4eb646d146c9ae1fa12c77", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.6.1", "os": "linux", "version": "0.9.6", "date": "2026-07-02T21:10:46.000Z", "distro": "resolute", "arch": "x86_64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/0149e923c2bde310aeded6e0a795b15d45e2c44f25acc0543a315b00ffc2f6a6", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.5.3", "os": "mac", "version": "0.9.6", "date": "2026-07-02T21:11:05.000Z", "arch": "aarch64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/e1c80b21472ec64d6d2f09267112c4597190345d24bea036517d2eb0a90b8c29", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.5.3", "os": "mac", "version": "0.9.6", "date": "2026-07-02T21:12:19.000Z", "arch": "x86_64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/df5e02e7fd51eff843000d0c317f88c88fb9338f4558e069dc469b9941755fdc", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.6.1", "os": "mac", "version": "0.9.6", "date": "2026-07-02T21:11:16.000Z", "arch": "aarch64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/fb1ebead3c86cbf378726c60a333297794c4b2b5f74f752b8a62ff9b250f79be", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.6.1", "os": "mac", "version": "0.9.6", "date": "2026-07-02T21:11:59.000Z", "arch": "x86_64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/c5b14642653736c9162dfb55b8a5aaa131b6f311c00883d0b43f3d65a9c7e355", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.6.0", "os": "wasm", "version": "0.9.6", "date": "2026-07-02T21:10:45.000Z", "arch": "emscripten", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/d1b260e485851e7b6599d20156bccc9a9f1a05533b9acb88f2fbc0476f31e0ec", "status": "success", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.7.0", "os": "win", "version": "0.9.6", "date": "2026-07-02T21:13:54.000Z", "arch": "x86_64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/bcb6a9e621a2a44af780eb36c31d61eba0d2cfd0bd462c5471baca6b141eb1a4", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.5.3", "os": "win", "version": "0.9.6", "date": "2026-07-02T21:12:38.000Z", "arch": "x86_64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/5979f7a90f461e0bb3a52a64ba8d058d6b6d5d0a134d2685c98ed99770a2fcdd", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" }, { "r": "4.6.1", "os": "win", "version": "0.9.6", "date": "2026-07-02T21:10:04.000Z", "arch": "x86_64", "commit": "bbe0611c68a1e0851bd29c2ae1c960b141f37eb8", "fileid": "https://r2.ropensci.org/4aaedf908dfe449b99b5f86149a403dc656239d6d090cf6182cc08ca63e5d91d", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/28621535408" } ] }