{ "_id": "6ad338102c5c76d3dd0c9f21", "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-10-17 08:46:02 UTC", "User": "root" }, "_user": "wilsonfreitas", "_type": "src", "_file": "sqliter_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/1081c5aca738222bcf96a6bbb72ca018436cce1ca5b1a5a79ef160fe7cd28b5b", "_filesize": 96641, "_sha256": "1081c5aca738222bcf96a6bbb72ca018436cce1ca5b1a5a79ef160fe7cd28b5b", "_expires": "2027-01-25T08:55:43.000Z", "_created": "2026-10-17T08:46:02.000Z", "_published": "2026-10-17T08:55:44.785Z", "_buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 117355729591, "time": 109, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "12096145935" }, { "job": 117355729599, "time": 100, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "12095941808" }, { "job": 117355729585, "time": 129, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "12096300876" }, { "job": 117355729730, "time": 98, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "12095523190" }, { "job": 117355233387, "time": 163, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12094999063" }, { "job": 117355729535, "time": 76, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12095547383" }, { "job": 117355729580, "time": 64, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "12095389551" }, { "job": 117355729660, "time": 64, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "ERROR", "artifact": "12096076066" }, { "job": 117355729538, "time": 70, "config": "windows-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "12095782862" } ], "_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": 1607, "description": "Quant and baker #rstats" }, "_downloads": { "count": 240, "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/manual.pdf", "extra/readme.html", "extra/readme.md", "extra/sqliter.html", "LICENSE" ], "_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-10-17T08:47:51.000Z", "distro": "resolute", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/9e310ac61bca7e998d4f699bad8f14417ebc2947e94f3f8aced80b1f6562ff0a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-10-17T08:47:41.000Z", "distro": "resolute", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/0c67496a3ab5cd0b68e74a674f83e9b92ed4ab4a97b3d755205bff9adc7a103a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-10-17T08:55:01.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/a0c7d364879e918d0fe16e9c71e99d549a11a3a31c062e3a29735f9e148b20ff", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-10-17T08:53:33.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/6abc6169761f498a48312993a6570f601fad3bf6f7427d5bbbed8038dd1e798e", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-10-17T08:47:34.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/8fd5359ba1f94736247d33a43578c82144e0fc0c21c1f9904d96069dd5cc0fbf", "status": "success", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-10-17T08:46:59.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/34169a833da9e5aa5c66b61ee9db0090f1a8b9ff1d73d2b72aba5d9798efe9de", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-10-17T08:46:59.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/2110485f6f24634720815a40a1d0771f2bbd67c5ab6bb21b2e9a4118851befd6", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-10-17T08:47:03.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "https://r2.ropensci.org/05011faa25c10e67780f7d573bd3992e8f415f6ccd182897e695e64dba792048", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/39018420557" } ] }