{ "_id": "6a17f192acfb0bcc41da7412", "Package": "sqliteutils", "Title": "Utility Functions for 'SQLite'", "Version": "0.1.0", "Authors@R": "person(given = \"Bruno\",\nfamily = \"Crotman\",\nrole = c(\"aut\", \"cre\"),\nemail = \"crotman@gmail.com\")", "Description": "A tool for working with 'SQLite' databases. 'SQLite' has\nsome idiosyncrasies and limitations that impose some hurdles to\nthe R developer who is using this database as a repository. For\ninstance, 'SQLite' doesn't have a date type and 'sqliteutils'\nhas some functions to deal with that.", "License": "MIT + file LICENSE", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.1.2", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://crotman.r-universe.dev", "Date/Publication": "2021-09-20 16:29:27 UTC", "RemoteUrl": "https://github.com/crotman/sqliteutils", "RemoteRef": "HEAD", "RemoteSha": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-28 07:37:49 UTC", "User": "root" }, "Author": "Bruno Crotman [aut, cre]", "Maintainer": "Bruno Crotman ", "MD5sum": "8b9222410db2caf88ecaa77706ae4009", "_user": "crotman", "_type": "src", "_file": "sqliteutils_0.1.0.tar.gz", "_fileid": "1da65e1d3d5efa18bcfefb49006c861df6a83dcf5d5edc10c1d3bca35de8ce9c", "_filesize": 78989, "_sha256": "1da65e1d3d5efa18bcfefb49006c861df6a83dcf5d5edc10c1d3bca35de8ce9c", "_created": "2026-05-28T07:37:49.000Z", "_published": "2026-05-28T07:41:06.172Z", "_distro": "noble", "_jobs": [ { "job": 78245226092, "time": 114, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7260290622" }, { "job": 78245226047, "time": 113, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7260290360" }, { "job": 78245226061, "time": 170, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7260296964" }, { "job": 78245226066, "time": 153, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7260288462" }, { "job": 78244798030, "time": 177, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7260253744" }, { "job": 78245226033, "time": 108, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7260288057" }, { "job": 78245226034, "time": 65, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7260274581" }, { "job": 78245226096, "time": 57, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7260272144" }, { "job": 78245226053, "time": 66, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7260275016" } ], "_buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/crotman/sqliteutils", "_commit": { "id": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "author": "crotman ", "committer": "crotman ", "message": "resubmission due to some problems in description\n", "time": 1632155367 }, "_maintainer": { "name": "Bruno Crotman", "email": "crotman@gmail.com", "login": "crotman", "description": "", "uuid": 26494490 }, "_registered": true, "_dependencies": [ { "package": "RSQLite", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "crotman", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "database", "sqlite" ], "_stars": 5, "_contributors": [ { "user": "crotman", "count": 4, "uuid": 26494490 } ], "_userbio": { "uuid": 26494490, "type": "user", "name": "Bruno Crotman" }, "_downloads": { "count": 175, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqliteutils" }, "_devurl": "https://github.com/crotman/sqliteutils", "_searchresults": 4, "_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/sqliteutils.html", "manual.pdf" ], "_homeurl": "https://github.com/crotman/sqliteutils", "_realowner": "crotman", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2021-09-21" } ], "_exports": [ "%>%", "slu_date_to_r", "slu_date_to_sqlite" ], "_help": [ { "page": "slu_date_to_r", "title": "Converts dates stored on 'SQLite' to their original values", "topics": [ "slu_date_to_r" ] }, { "page": "slu_date_to_sqlite", "title": "Converts dates to the numeric values as which they would be stored on SQLite", "topics": [ "slu_date_to_sqlite" ] } ], "_readme": "https://github.com/crotman/sqliteutils/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cachem", "cli", "cpp11", "DBI", "dbplyr", "dplyr", "fastmap", "generics", "glue", "lifecycle", "magrittr", "memoise", "pillar", "pkgconfig", "purrr", "R6", "rlang", "RSQLite", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr" ], "_score": 3.3979400086720375, "_indexed": true, "_nocasepkg": "sqliteutils", "_universes": [ "crotman" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-05-28T07:39:46.000Z", "distro": "noble", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "83596d575e9a94fd06328a5aaad270469649bf2d5f6d16dbcbd785e247d919a5", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-28T07:39:46.000Z", "distro": "noble", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "e70ede88d43be237303a741f0efb76b742139160940831b0ab0da63905aafc89", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-05-28T07:40:07.000Z", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "72a242ff97409a3dcd80cf8001d541305348db41b784837022b233c07f45e8ac", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-05-28T07:39:38.000Z", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "ca0f7d1b225f099e9299877ef0b91e2dda2a6239cd9374d0fb0aed08cbfa2650", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-05-28T07:39:48.000Z", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "984526b9ee40f9e3e4d7fdda41c909a44d54039bab1b350f80377f93f3c6aed9", "status": "success", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-05-28T07:38:54.000Z", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "a96ae70d898d7e36bbc9beefbf9181dfbb1ecd6552b7e8c90a6ef6199552d737", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-05-28T07:38:47.000Z", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "4fa1fadb944c219caaa7d687fef92f104df04a3522c0b468cea8bf4836da8527", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-05-28T07:38:55.000Z", "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9", "fileid": "00d25a09f30d45f8fdefa7e86ec6a8d4410e756b057b97003e03f5063adde9da", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/crotman/actions/runs/26561304359" } ] }