{ "_id": "6a1d37151d7bb097a0a3d662", "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-06-01 07:26:04 UTC", "User": "root" }, "MD5sum": "0ed88efda3bfca50bb9813896f88fd83", "_user": "wilsonfreitas", "_type": "src", "_file": "sqliter_0.1.0.tar.gz", "_fileid": "03219d21eae670dea256aa3ab69ae9c4837869087353a6e206d5026c71ac54a5", "_filesize": 94177, "_sha256": "03219d21eae670dea256aa3ab69ae9c4837869087353a6e206d5026c71ac54a5", "_created": "2026-06-01T07:26:04.000Z", "_published": "2026-06-01T07:39:01.022Z", "_distro": "noble", "_jobs": [ { "job": 78805324055, "time": 120, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "7325662476" }, { "job": 78805324057, "time": 141, "config": "linux-release-x86_64", "r": "4.6.0", "check": "ERROR", "artifact": "7325668301" }, { "job": 78805324136, "time": 102, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "7325822123" }, { "job": 78805324063, "time": 119, "config": "macos-release-arm64", "r": "4.6.0", "check": "ERROR", "artifact": "7325836129" }, { "job": 78804778719, "time": 229, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7325628362" }, { "job": 78805324035, "time": 100, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7325656860" }, { "job": 78805324060, "time": 87, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "7325653180" }, { "job": 78805324109, "time": 67, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "7325648227" }, { "job": 78805324084, "time": 70, "config": "windows-release", "r": "4.6.0", "check": "ERROR", "artifact": "7325649188" } ], "_buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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", "description": "Quant and baker #rstats" }, "_downloads": { "count": 190, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqliter" }, "_devurl": "https://github.com/wilsonfreitas/sqliter", "_searchresults": 5, "_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/sqliter.html", "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", "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-06-01T07:28:02.000Z", "distro": "noble", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "d2b02fd740efc8eb31c3df7d13606015b0a6e16d4a33d37d3187c50ae87f0153", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-06-01T07:28:23.000Z", "distro": "noble", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "15255465aecff6b0387f1f46c87947c71292010ac5f587a281193dfcc75170b3", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-06-01T07:37:38.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "f4003028fb52312727c6ea0755b537b74b519afdfcd35f990a5b4a1cc0151aa0", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-06-01T07:38:26.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "b2b1ced67e24f775bd0885acba71f1fa70fa8c2b018434bf9ea5507a0632385d", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-06-01T07:28:00.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "fcf4892c22c2a94a061f635c268f964051a7d9a62553fa987c6ad517c00a1f92", "status": "success", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-06-01T07:27:24.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "bb6e0b55cbbb3ffa087fd1fc75e031747835c43a00c0dd505bed9cc5367ecaad", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-06-01T07:27:09.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "8316998931070a5916e8d7c5880883ff3f0cfbdcf532eef11b8780beb3f4e0b4", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-06-01T07:27:09.000Z", "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a", "fileid": "1296ac6e08880ba1b5e221e9196a196083e8ff895f3e5dd9717245cb35193a63", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/26740994591" } ] }