{ "_id": "6a11764cacfb0bcc41cf9238", "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-05-23 09:36:12 UTC", "User": "root" }, "Repository": "https://rsund.r-universe.dev", "Date/Publication": "2025-06-01 19:09:16 UTC", "RemoteUrl": "https://github.com/rsund/survor", "RemoteRef": "HEAD", "RemoteSha": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "RemoteSubdir": "pkg/virta", "MD5sum": "cc427b6985b712d7128f3c98a272b9bf", "_user": "rsund", "_type": "src", "_file": "virta_0.9.6.tar.gz", "_fileid": "aa48ffa9829b3d2cacfb906fcce4e54162a555603d2a63ff0e1ca0fc3c82546a", "_filesize": 260186, "_sha256": "aa48ffa9829b3d2cacfb906fcce4e54162a555603d2a63ff0e1ca0fc3c82546a", "_created": "2026-05-23T09:36:12.000Z", "_published": "2026-05-23T09:41:32.558Z", "_distro": "noble", "_jobs": [ { "job": 77512763586, "time": 123, "config": "linux-devel-arm64", "r": "4.7.0", "check": "NOTE", "artifact": "7176004022" }, { "job": 77512763569, "time": 94, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7176001586" }, { "job": 77512763583, "time": 126, "config": "linux-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7176004364" }, { "job": 77512763578, "time": 110, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7176002887" }, { "job": 77512763591, "time": 123, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "7176003963" }, { "job": 77512763598, "time": 239, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "7176014755" }, { "job": 77512763596, "time": 128, "config": "macos-release-arm64", "r": "4.6.0", "check": "WARNING", "artifact": "7176004424" }, { "job": 77512763594, "time": 289, "config": "macos-release-x86_64", "r": "4.6.0", "check": "WARNING", "artifact": "7176019428" }, { "job": 77512632768, "time": 152, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7175992391" }, { "job": 77512763555, "time": 90, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7176001221" }, { "job": 77512763574, "time": 253, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "7176016017" }, { "job": 77512763575, "time": 194, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "7176010501" }, { "job": 77512763617, "time": 223, "config": "windows-release", "r": "4.6.0", "check": "WARNING", "artifact": "7176013087" } ], "_buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/rsund/survor", "_commit": { "id": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "author": "Reijo Sund ", "committer": "Reijo Sund ", "message": "update old-style function definitions\n", "time": 1748804956 }, "_maintainer": { "name": "Reijo Sund", "email": "reijo.sund@uef.fi", "login": "rsund", "description": "", "uuid": 7668641 }, "_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": "2025-22", "n": 49 } ], "_tags": [], "_stars": 3, "_contributors": [ { "user": "rsund", "count": 370, "uuid": 7668641 } ], "_userbio": { "uuid": 7668641, "type": "user", "name": "Reijo Sund" }, "_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.0", "_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-05-23T09:38:14.000Z", "distro": "noble", "arch": "aarch64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "acae9c2aeaa9a0ecc2ea7d3db6ad472c24165c7d232a5307e5582c91d72bcb43", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.7.0", "os": "linux", "version": "0.9.6", "date": "2026-05-23T09:37:46.000Z", "distro": "noble", "arch": "x86_64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "f91d0e745fb3a1ed4b18f96d352655e8c782c3718cc580da9ef517228fa948d5", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.6.0", "os": "linux", "version": "0.9.6", "date": "2026-05-23T09:38:20.000Z", "distro": "noble", "arch": "aarch64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "ac177d990b196195bceb299fe829a33ca8dd1c2c437dd805cd2d3bee9b8e8d3e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.6.0", "os": "linux", "version": "0.9.6", "date": "2026-05-23T09:38:01.000Z", "distro": "noble", "arch": "x86_64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "bc6e7f901ef3b257f8b487b63a6a017b101a8fcacd8f6caa1bd93901a75625a2", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.5.3", "os": "mac", "version": "0.9.6", "date": "2026-05-23T09:38:17.000Z", "arch": "aarch64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "936adb4ac9b3b9d6380a7dca09109627f4a4d85163a129bb5b8521d70330874e", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.5.3", "os": "mac", "version": "0.9.6", "date": "2026-05-23T09:40:00.000Z", "arch": "x86_64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "acbec235adc7d789fdc5772047c5f9b429a7ff278b964e9e70ec704e082fc4e7", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.6.0", "os": "mac", "version": "0.9.6", "date": "2026-05-23T09:38:20.000Z", "arch": "aarch64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "c6db3809d3937a13b3821d3a4902ca6daad0d1a2c876eccc51900ecac82f5a4f", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.6.0", "os": "mac", "version": "0.9.6", "date": "2026-05-23T09:40:43.000Z", "arch": "x86_64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "d7d86e172b45a8ce5232fdba9befd0d45bf03a53b91abc418d0e6abbc5c2b026", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.6.0", "os": "wasm", "version": "0.9.6", "date": "2026-05-23T09:37:58.000Z", "arch": "emscripten", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "59c7b92c608694ff52e736e709d44af1ff9249cc3ed57c7e7181f8008db3438e", "status": "success", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.7.0", "os": "win", "version": "0.9.6", "date": "2026-05-23T09:40:20.000Z", "arch": "x86_64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "995f546942867105d6b5594cb6e21d2794e61420482bdf18949892219726c0da", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.5.3", "os": "win", "version": "0.9.6", "date": "2026-05-23T09:39:18.000Z", "arch": "x86_64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "57939a89d51e74962636f42afcd6da5ec9557505b2b5462cbda4214aa130278f", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" }, { "r": "4.6.0", "os": "win", "version": "0.9.6", "date": "2026-05-23T09:39:44.000Z", "arch": "x86_64", "commit": "9e0aa03caca7de9dfcdabe1b7aa218df9da062fa", "fileid": "58fc28d152e8dce8cdbdca622a8571ed2b0dc9b54e1e1fd700d065a0a65016bf", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/rsund/actions/runs/26329358794" } ] }