{ "_id": "6a496c4d3c3572b93bf80aa4", "Package": "sqliter", "Type": "Package", "Title": "Connection wrapper to SQLite databases", "Version": "0.1.0", "Author": "Wilson Freitas ", "Maintainer": "Wilson Freitas ", "URL": "https://github.com/wilsonfreitas/sqliter/", "Description": "sqliter helps users, mainly data munging practioneers, to\norganize their sql calls in a clean structure. It simplifies\nthe process of extracting and transforming data into useful\nformats.", "License": "MIT + file LICENSE", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://wilsonfreitas.r-universe.dev", "Date/Publication": "2014-12-12 10:23:14 UTC", "RemoteUrl": "https://github.com/wilsonfreitas/sqliter", "RemoteRef": "HEAD", "RemoteSha": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-04 20:23:14 UTC", "User": "root" }, "_user": "wilsonfreitas", "_type": "src", "_file": "sqliter_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/3b4d2fe19f0c4e15152a29b1539ba1d5d4f1cca3d28ff2b77622433ecedd4356", "_filesize": 97027, "_sha256": "3b4d2fe19f0c4e15152a29b1539ba1d5d4f1cca3d28ff2b77622433ecedd4356", "_expires": "2026-10-12T20:25:48.000Z", "_created": "2026-07-04T20:23:14.000Z", "_published": "2026-07-04T20:25:49.888Z", "_jobs": [ { "job": 85164155529, "time": 115, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "8085139798" }, { "job": 85164155531, "time": 119, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "8085140210" }, { "job": 85164155521, "time": 80, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "8085135035" }, { "job": 85164155537, "time": 94, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "8085137106" }, { "job": 85163954319, "time": 172, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8085124685" }, { "job": 85164155518, "time": 105, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8085138514" }, { "job": 85164155514, "time": 78, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "8085135032" }, { "job": 85164155513, "time": 80, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "8085135120" }, { "job": 85164155511, "time": 68, "config": "windows-release", "r": "4.6.1", "check": "ERROR", "artifact": "8085133568" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045", "_status": "success", "_upstream": "https://github.com/wilsonfreitas/sqliter", "_commit": { "id": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "author": "wilsonfreitas ", "committer": "wilsonfreitas ", "message": "Changed asciify to handle cells with many lines\n", "time": 1418379794 }, "_maintainer": { "name": "Wilson Freitas", "email": "wilson.freitas@gmail.com", "login": "wilsonfreitas", "description": "Quant and baker #rstats", "uuid": 1583922 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "stringr", "role": "Imports" }, { "package": "functional", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" } ], "_owner": "wilsonfreitas", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 1, "_contributors": [ { "user": "wilsonfreitas", "count": 30, "uuid": 1583922 } ], "_userbio": { "uuid": 1583922, "type": "user", "name": "Wilson Freitas", "followers": 1510, "description": "Quant and baker #rstats" }, "_downloads": { "count": 300, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqliter" }, "_devurl": "https://github.com/wilsonfreitas/sqliter", "_searchresults": 6, "_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/sqliter.html", "LICENSE", "manual.pdf" ], "_homeurl": "https://github.com/wilsonfreitas/sqliter", "_realowner": "wilsonfreitas", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2014-01-26" } ], "_exports": [ "as.db", "as.dbl", "databases", "execute_in_db", "indexes", "query", "query_from_file", "rac", "send_query", "sqliter", "tables" ], "_help": [ { "page": "sqliter-package", "title": "Functions to wrap SQLite calls", "topics": [ "sqliter-package" ] }, { "page": "databases", "title": "lists databases into path", "topics": [ "databases", "databases.sqliter" ] }, { "page": "find_database", "title": "returns the paths of the given database", "topics": [ "find_database", "find_database.sqliter" ] }, { "page": "query", "title": "execute query into a given database", "topics": [ "query", "query.sqliter" ] }, { "page": "query-functions", "title": "query functions", "topics": [ "query-functions" ] }, { "page": "sqliter", "title": "Creates the sqliter a kinf of SQLite database manager, but not that far.", "topics": [ "sqliter" ] } ], "_readme": "https://github.com/wilsonfreitas/sqliter/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cachem", "cli", "cpp11", "DBI", "fastmap", "functional", "glue", "lifecycle", "lisp", "magrittr", "memoise", "pkgconfig", "rlang", "RSQLite", "stringi", "stringr", "vctrs" ], "_score": 2.6989700043360187, "_indexed": true, "_nocasepkg": "sqliter", "_universes": [ "wilsonfreitas" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-07-04T20:25:10.000Z", "distro": "resolute", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/98ce5c8cefc32f9b035c116886d781605174ed88d7a0eec8fe1fa80ba74f766b", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-07-04T20:25:12.000Z", "distro": "resolute", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/05f42e95cb75cb8e38d7afd3d94703e74b3592e4a5138179f6629f09f3a3fe94", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-07-04T20:24:39.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/849ff21a909d9967ca21f634a0a50d52b9a5c94d6fa1fc3a5165e626493bcc7d", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-07-04T20:24:53.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/642a1a964975aa742afccc47051d6174bd1a3a7031ab71bb1d243ef52fd9a1b7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-07-04T20:25:15.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/7f0a80d2f70674cd4329a57550aed65b48cf04358a3d9cbd00791e28707878f5", "status": "success", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-07-04T20:24:29.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/2f6b56f3f5ded2317f4e4c0b6d8480bbc70d66add0f9950c1f86c8ede465a487", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-07-04T20:24:18.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/29366c3200c51b4ab904e4540dd7b57cd4b9540845a24e0a8fd8c80262da73f2", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-07-04T20:24:21.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/019c8b374086f07df56b47ca4f0bda9522970c0ad85771633073f406334f65d1", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/28718490045" } ] }