{
  "_id": "6afaf1148c54a69a6a55bc6b",
  "Package": "sqliter",
  "Type": "Package",
  "Title": "Connection wrapper to SQLite databases",
  "Version": "0.1.0",
  "Author": "Wilson Freitas <wilson.freitas@gmail.com>",
  "Maintainer": "Wilson Freitas <wilson.freitas@gmail.com>",
  "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-11-16 11:07:44 UTC",
    "User": "root"
  },
  "_user": "wilsonfreitas",
  "_type": "src",
  "_file": "sqliter_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/c1732ebff04645797556b83b030956723869806ca1ecbd534ad2e7706b46d630",
  "_filesize": 96629,
  "_sha256": "c1732ebff04645797556b83b030956723869806ca1ecbd534ad2e7706b46d630",
  "_expires": "2027-02-24T12:03:31.000Z",
  "_created": "2026-11-16T11:07:44.000Z",
  "_published": "2026-11-16T12:03:32.700Z",
  "_upstream": "https://github.com/wilsonfreitas/sqliter",
  "_status": "success",
  "_maintainer": {
    "name": "Wilson Freitas",
    "email": "wilson.freitas@gmail.com",
    "login": "wilsonfreitas",
    "description": "Quant and baker #rstats",
    "uuid": 1583922
  },
  "_jobs": [
    {
      "job": 133256973386,
      "time": 100,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "14220477155"
    },
    {
      "job": 133256973460,
      "time": 94,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "ERROR",
      "artifact": "14219698164"
    },
    {
      "job": 133256973556,
      "time": 93,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "14223842907"
    },
    {
      "job": 133256973243,
      "time": 96,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "ERROR",
      "artifact": "14223072475"
    },
    {
      "job": 133255110719,
      "time": 212,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14220681716"
    },
    {
      "job": 133256973232,
      "time": 82,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "14220627092"
    },
    {
      "job": 133256973643,
      "time": 61,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "14220542033"
    },
    {
      "job": 133256973426,
      "time": 71,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "14220756931"
    },
    {
      "job": 133256973420,
      "time": 61,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "ERROR",
      "artifact": "14220971371"
    }
  ],
  "_buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052",
  "_commit": {
    "id": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
    "author": "wilsonfreitas <wilson.freitas@gmail.com>",
    "committer": "wilsonfreitas <wilson.freitas@gmail.com>",
    "message": "Changed asciify to handle cells with many lines\n",
    "time": 1418379794
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_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": 1632,
    "description": "Quant and baker #rstats"
  },
  "_downloads": {
    "count": 317,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqliter"
  },
  "_devurl": "https://github.com/wilsonfreitas/sqliter",
  "_rbuild": "4.6.2",
  "_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-11-16T11:09:28.000Z",
      "distro": "resolute",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/c9a8728f346a6f2e0815da5eaf21b0ae0373301493ed8970084b9012e391803b",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-11-16T11:09:25.000Z",
      "distro": "resolute",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/7638b3733a944b729b47475b8e72500534e9036b7707482836113ff87cb62496",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-11-16T12:02:53.000Z",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/a5332cd80a285b785d999791b5981940dff8531ffab7aa2959a41bd36b511bde",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-11-16T11:49:23.000Z",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/b8eb621249dc4ec73d390b42f9b936b7dae1274a2263dcd4af5193212d92bd81",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-11-16T11:09:26.000Z",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/325148c9ee1c9ca3df20dcd5c160c139b96d8ecd707f24f78d3ab7e3553b5794",
      "status": "success",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-11-16T11:08:44.000Z",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/27876b9e63ba6d928db71dcafc78068f12a920322ae98c83997ce11d252dfdf7",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-11-16T11:08:52.000Z",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/3e7f15e8b19d9817f1fd88d2a4c517d4a2d1e4469a98b93d90d8b15f48dc0006",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-11-16T11:08:47.000Z",
      "commit": "704fb49acd725fb89e7808a82ea8fb0fdc2d1e2a",
      "fileid": "https://r2.ropensci.org/f8d4582e6594cfa8ea55fa72e07dcd501028f0c1ce04c4208dacc5980cf4823a",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/wilsonfreitas/actions/runs/43854433052"
    }
  ]
}