{
  "_id": "6a248c074b233be198383823",
  "Package": "RSQLite.toolkit",
  "Type": "Package",
  "Title": "Load Data in SQLite from Tabular Files",
  "Version": "0.1.2.9030",
  "Authors@R": "person(\"Ludovico G.\", \"Beretta\", , \"ludovicogiovanni.beretta@gmail.com\", role = c(\"aut\", \"cre\", \"cph\"))",
  "Description": "A lightweight wrapper around the 'RSQLite' package for\nstreamlined loading of data from tabular files (i,e. text\ndelimited files like Comma Separated Values and Tab Separated\nValues, Microsoft Excel, and Arrow Inter-process Communication\nfiles) in 'SQLite' databases. Includes helper functions for\ninspecting the structure of the input files, and some functions\nto simplify activities on the 'SQLite' tables.",
  "License": "GPL (>= 3)",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "URL": "https://github.com/fab-algo/RSQLite.toolkit,\nhttps://fab-algo.github.io/RSQLite.toolkit/",
  "BugReports": "https://github.com/fab-algo/RSQLite.toolkit/issues",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "cmake libicu-dev libssl-dev",
  "Repository": "https://fab-algo.r-universe.dev",
  "Date/Publication": "2026-06-06 19:09:53 UTC",
  "RemoteUrl": "https://github.com/fab-algo/rsqlite.toolkit",
  "RemoteRef": "HEAD",
  "RemoteSha": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-06 21:04:18 UTC",
    "User": "root"
  },
  "Author": "Ludovico G. Beretta [aut, cre, cph]",
  "Maintainer": "Ludovico G. Beretta <ludovicogiovanni.beretta@gmail.com>",
  "MD5sum": "796047e839e3190e008cba1feb2ff0be",
  "_user": "fab-algo",
  "_type": "src",
  "_file": "RSQLite.toolkit_0.1.2.9030.tar.gz",
  "_fileid": "ed48adeb1e0e766c27e1dfa9a4da0666a6dcae2df11a3c7ea8b66de42b07c745",
  "_filesize": 798632,
  "_sha256": "ed48adeb1e0e766c27e1dfa9a4da0666a6dcae2df11a3c7ea8b66de42b07c745",
  "_created": "2026-06-06T21:04:18.000Z",
  "_published": "2026-06-06T21:07:19.550Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79907712714,
      "time": 143,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7457920422"
    },
    {
      "job": 79907712695,
      "time": 142,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7457920426"
    },
    {
      "job": 79907712706,
      "time": 92,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7457914337"
    },
    {
      "job": 79907712712,
      "time": 94,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7457914582"
    },
    {
      "job": 79907528129,
      "time": 188,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7457903205"
    },
    {
      "job": 79907712702,
      "time": 112,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7457916861"
    },
    {
      "job": 79907712705,
      "time": 107,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7457916098"
    },
    {
      "job": 79907712740,
      "time": 100,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7457915253"
    },
    {
      "job": 79907712735,
      "time": 81,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7457913077"
    }
  ],
  "_buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/fab-algo/rsqlite.toolkit",
  "_commit": {
    "id": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
    "author": "Ludovico G. Beretta <ludovicogiovanni.beretta@gmail.com>",
    "committer": "Ludovico G. Beretta <ludovicogiovanni.beretta@gmail.com>",
    "message": "dbTableFromDSV: fixed bug when skip>0, added possibility to combine nlines and chunck_size\n",
    "time": 1780772993
  },
  "_maintainer": {
    "name": "Ludovico G. Beretta",
    "email": "ludovicogiovanni.beretta@gmail.com",
    "login": "fab-algo",
    "description": "",
    "uuid": 70130185
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.2.0",
      "role": "Depends"
    },
    {
      "package": "RSQLite",
      "version": ">= 2.3.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "openxlsx2",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "piggyback",
      "role": "Suggests"
    }
  ],
  "_owner": "fab-algo",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-23",
      "n": 1
    },
    {
      "week": "2025-24",
      "n": 1
    },
    {
      "week": "2025-26",
      "n": 1
    },
    {
      "week": "2025-48",
      "n": 1
    },
    {
      "week": "2025-49",
      "n": 2
    },
    {
      "week": "2026-01",
      "n": 1
    },
    {
      "week": "2026-02",
      "n": 2
    },
    {
      "week": "2026-03",
      "n": 2
    },
    {
      "week": "2026-04",
      "n": 1
    },
    {
      "week": "2026-05",
      "n": 3
    },
    {
      "week": "2026-07",
      "n": 1
    },
    {
      "week": "2026-08",
      "n": 7
    },
    {
      "week": "2026-09",
      "n": 8
    },
    {
      "week": "2026-10",
      "n": 2
    },
    {
      "week": "2026-12",
      "n": 1
    },
    {
      "week": "2026-14",
      "n": 1
    },
    {
      "week": "2026-15",
      "n": 1
    },
    {
      "week": "2026-23",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v0.1.1",
      "date": "2026-02-28"
    },
    {
      "name": "v0.1.2",
      "date": "2026-02-28"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "fab-algo",
      "count": 69,
      "uuid": 70130185
    }
  ],
  "_userbio": {
    "uuid": 70130185,
    "type": "user",
    "name": "Fabrica Algorithmica"
  },
  "_downloads": {
    "count": 467,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RSQLite.toolkit"
  },
  "_mentions": 27,
  "_devurl": "https://github.com/fab-algo/rsqlite.toolkit",
  "_pkgdown": "https://fab-algo.github.io/RSQLite.toolkit/",
  "_searchresults": 18,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/RSQLite.toolkit.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/fab-algo/rsqlite.toolkit",
  "_realowner": "fab-algo",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.1",
      "date": "2026-03-05"
    },
    {
      "version": "0.1.2",
      "date": "2026-04-04"
    }
  ],
  "_exports": [
    "dbCopyTable",
    "dbCreatePK",
    "dbExecFile",
    "dbTableFromDataFrame",
    "dbTableFromDSV",
    "dbTableFromFeather",
    "dbTableFromView",
    "dbTableFromXlsx",
    "file_schema_dsv",
    "file_schema_feather",
    "file_schema_xlsx",
    "format_column_names",
    "R2SQL_types"
  ],
  "_help": [
    {
      "page": "dbCopyTable",
      "title": "Copy a table from one SQLite database to another",
      "topics": [
        "dbCopyTable"
      ]
    },
    {
      "page": "dbCreatePK",
      "title": "Creates a unique index on a table in a SQLite database",
      "topics": [
        "dbCreatePK"
      ]
    },
    {
      "page": "dbExecFile",
      "title": "Execute SQL statements from a text file",
      "topics": [
        "dbExecFile"
      ]
    },
    {
      "page": "dbTableFromDataFrame",
      "title": "Create a table in a SQLite database from a data frame",
      "topics": [
        "dbTableFromDataFrame"
      ]
    },
    {
      "page": "dbTableFromDSV",
      "title": "Create a table from a delimiter separated values (DSV) text file",
      "topics": [
        "dbTableFromDSV"
      ]
    },
    {
      "page": "dbTableFromFeather",
      "title": "Create a table from a Feather (Arrow IPC) file",
      "topics": [
        "dbTableFromFeather"
      ]
    },
    {
      "page": "dbTableFromView",
      "title": "Create a table in a SQLite database from a view",
      "topics": [
        "dbTableFromView"
      ]
    },
    {
      "page": "dbTableFromXlsx",
      "title": "Create a table in a SQLite database from an Excel worksheet",
      "topics": [
        "dbTableFromXlsx"
      ]
    },
    {
      "page": "error_handler",
      "title": "error_handler manage error messages for package",
      "topics": [
        "error_handler"
      ]
    },
    {
      "page": "file_schema_dsv",
      "title": "Preview the table structure contained in a DSV file.",
      "topics": [
        "file_schema_dsv"
      ]
    },
    {
      "page": "file_schema_feather",
      "title": "Preview the table structure contained in a Feather file.",
      "topics": [
        "file_schema_feather"
      ]
    },
    {
      "page": "file_schema_xlsx",
      "title": "Preview the structure of a range of an Excel worksheet.",
      "topics": [
        "file_schema_xlsx"
      ]
    },
    {
      "page": "format_column_names",
      "title": "Format column names for SQLite",
      "topics": [
        "format_column_names"
      ]
    },
    {
      "page": "R2SQL_types",
      "title": "From R class names to SQLite data types",
      "topics": [
        "R2SQL_types"
      ]
    }
  ],
  "_pkglogo": "https://github.com/fab-algo/rsqlite.toolkit/raw/HEAD/man/figures/logo.png",
  "_readme": "https://github.com/fab-algo/rsqlite.toolkit/raw/HEAD/README.md",
  "_rundeps": [
    "arrow",
    "assertthat",
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "fastmap",
    "glue",
    "lifecycle",
    "magrittr",
    "memoise",
    "openxlsx2",
    "pkgconfig",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "RSQLite",
    "stringi",
    "tidyselect",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "dealing_with_DSV_files.Rmd",
      "filename": "dealing_with_DSV_files.html",
      "title": "Dealing with DSV files",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Data interpretation issues",
        "Issues with column names",
        "How RSQLite.toolkit handles column names",
        "Example",
        "Conclusions"
      ],
      "created": "2025-04-13 15:31:03",
      "modified": "2026-06-06 19:09:53",
      "commits": 23
    }
  ],
  "_score": 6.209515014542631,
  "_indexed": true,
  "_nocasepkg": "rsqlite.toolkit",
  "_universes": [
    "fab-algo"
  ],
  "_previous": "0.1.2.9010",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:06:37.000Z",
      "distro": "noble",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "a232d36d0d58fb2e48f40d5c27ef3d8dbb200174ddad6b6cf0b43589793bde36",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:06:36.000Z",
      "distro": "noble",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "a52460f5d743993281e4d332bf3e7de713f5f786fda3122d0c4d5210d0b8d813",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:05:53.000Z",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "1ffa9a5d289665475d9185fa95eb50b11f5fbd63b6de9130e88acaaf853a1c49",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:05:54.000Z",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "7e39a1e32f0eff6172c33a8114188591b37ae43561ea578d666c6152b1efeb60",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:06:32.000Z",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "ce4e25ea76864763e21c1015f5776b8b191ce8c16b54a27b62bb1d46217a2c6a",
      "status": "success",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:05:54.000Z",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "09fb0f04c5264038f721b0986df7053f0be8350fd6e65587d90038363336069e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:05:42.000Z",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "4c57372a4b2df192912edf8ba6121cc9c0c30137130375c82696a8009d41271e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.1.2.9030",
      "date": "2026-06-06T21:05:34.000Z",
      "commit": "b3113ff5125fbe8b816694600a89a08d9f5abdb3",
      "fileid": "97d1e9330fb98bb2048487f7a4cfcd7580ca6604b37d9fdf5f797060e313bff9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/fab-algo/actions/runs/27073786683"
    }
  ]
}