{
  "_id": "6acf6339e2d863f662951840",
  "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-10-14 11:06:56 UTC",
    "User": "root"
  },
  "Author": "Bruno Crotman [aut, cre]",
  "Maintainer": "Bruno Crotman <crotman@gmail.com>",
  "_user": "crotman",
  "_type": "src",
  "_file": "sqliteutils_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/c6aabcf5cc9d72dfd7bdc1347b769a3b1e505e111d1ed1cf20efe0626d61c388",
  "_filesize": 80888,
  "_sha256": "c6aabcf5cc9d72dfd7bdc1347b769a3b1e505e111d1ed1cf20efe0626d61c388",
  "_expires": "2027-01-22T11:10:47.000Z",
  "_created": "2026-10-14T11:06:56.000Z",
  "_published": "2026-10-14T11:10:49.474Z",
  "_buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 115819620746,
      "time": 113,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11887699181"
    },
    {
      "job": 115819620624,
      "time": 96,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11889220835"
    },
    {
      "job": 115819620613,
      "time": 186,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11887823366"
    },
    {
      "job": 115819620735,
      "time": 148,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11889345785"
    },
    {
      "job": 115818464212,
      "time": 175,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11888615412"
    },
    {
      "job": 115819620476,
      "time": 99,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11889320788"
    },
    {
      "job": 115819620591,
      "time": 56,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11887753708"
    },
    {
      "job": 115819620739,
      "time": 50,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11887842838"
    },
    {
      "job": 115819620598,
      "time": 56,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11887738559"
    }
  ],
  "_upstream": "https://github.com/crotman/sqliteutils",
  "_commit": {
    "id": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
    "author": "crotman <crotman@gmail.com>",
    "committer": "crotman <crotman@gmail.com>",
    "message": "resubmission due to some problems in description\n",
    "time": 1632155367
  },
  "_maintainer": {
    "name": "Bruno Crotman",
    "email": "crotman@gmail.com",
    "login": "crotman",
    "description": "",
    "uuid": 26494490
  },
  "_distro": "resolute",
  "_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",
    "followers": 17
  },
  "_downloads": {
    "count": 249,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqliteutils"
  },
  "_devurl": "https://github.com/crotman/sqliteutils",
  "_searchresults": 2,
  "_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/sqliteutils.html",
    "LICENSE"
  ],
  "_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-10-14T11:08:59.000Z",
      "distro": "resolute",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/a2cff8bd029e1d19b7fe293e7910d6ae31820339f18dc9f8269ad1a31004a3d0",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-14T11:08:38.000Z",
      "distro": "resolute",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/a61889f3bce1ad9366cd71314a815028e06f009ae81771f00da26f21c91e5879",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-14T11:09:37.000Z",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/5214d276cc36aa7e30ffaaf0769699e288e488bd4d42eacfcca00e32d7080422",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-14T11:09:02.000Z",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/6880974dc9611a47cfa733f558c7a347d283ddfbff3b81d4a3ddc0ba867889b5",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-10-14T11:08:50.000Z",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/88d6531c95002f9a880e12368870c86aa2750e1f80f069bb0c27441c4290be33",
      "status": "success",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-14T11:07:54.000Z",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/d59fbc96a143e9992523359cade69060f8f3154b1729e0c307f6edc1763e3eec",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-14T11:07:51.000Z",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/c7e23925afa433bb31e4b6ab355e191011834d3c4872ba75723c29fd4828a85c",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-14T11:07:57.000Z",
      "commit": "97f2589927f627ab23abf70e5a53a590aa4cd2f9",
      "fileid": "https://r2.ropensci.org/5ce353bcc64291eeec73305281424ad04cbdeca01cd3784113ed368f8aabbd00",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/crotman/actions/runs/38553924795"
    }
  ]
}