{ "_id": "6a483256e06c18f0a6530428", "Package": "dbmisc", "Type": "Package", "Title": "Tools for working with SQLite in R", "Version": "0.3", "Date": "2021-03-11", "Author": "Sebastian Kranz", "Maintainer": "Sebastian Kranz ", "Description": "Tools for working with SQLite in R, in particular support\nfor simple YAML schemas.", "License": "GPL >= 2.0", "RoxygenNote": "7.1.1", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://skranz.r-universe.dev", "Date/Publication": "2022-10-15 06:02:54 UTC", "RemoteUrl": "https://github.com/skranz/dbmisc", "RemoteRef": "master", "RemoteSha": "aef87129585de20453627f7246effebf00fac596", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-03 22:03:37 UTC", "User": "root" }, "_user": "skranz", "_type": "src", "_file": "dbmisc_0.3.tar.gz", "_fileid": "https://r2.ropensci.org/923a8e972cf775998db35ae29cf078db0c6bc2ddc799812efdd5933bff3eb663", "_filesize": 163676, "_sha256": "923a8e972cf775998db35ae29cf078db0c6bc2ddc799812efdd5933bff3eb663", "_expires": "2026-10-11T22:06:12.000Z", "_created": "2026-07-03T22:03:37.000Z", "_published": "2026-07-03T22:06:14.456Z", "_jobs": [ { "job": 85076671575, "time": 121, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "8075382098" }, { "job": 85076671546, "time": 112, "config": "linux-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "8075380917" }, { "job": 85076671536, "time": 68, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "8075373261" }, { "job": 85076671541, "time": 108, "config": "macos-release-arm64", "r": "4.6.1", "check": "WARNING", "artifact": "8075379978" }, { "job": 85076438367, "time": 152, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8075360972" }, { "job": 85076671537, "time": 116, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8075381397" }, { "job": 85076671559, "time": 69, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "8075373209" }, { "job": 85076671560, "time": 58, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "8075371246" }, { "job": 85076671558, "time": 59, "config": "windows-release", "r": "4.6.1", "check": "WARNING", "artifact": "8075371359" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350", "_status": "success", "_upstream": "https://github.com/skranz/dbmisc", "_commit": { "id": "aef87129585de20453627f7246effebf00fac596", "author": "Sebastian Kranz ", "committer": "Sebastian Kranz ", "message": "Update db_util.r\n\nbugfix\n", "time": 1665813774 }, "_maintainer": { "name": "Sebastian Kranz", "email": "sebastian.kranz@uni-ulm.de", "login": "skranz", "bluesky": "@sebkranz.bsky.social", "description": "", "uuid": 1413022 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Depends" }, { "package": "restorepoint", "role": "Depends" }, { "package": "yaml", "role": "Depends" }, { "package": "stringtools", "role": "Depends" }, { "package": "glue", "role": "Depends" } ], "_owner": "skranz", "_selfowned": true, "_usedby": 3, "_updates": [], "_tags": [], "_topics": [ "database", "schema", "sql", "sqlite" ], "_stars": 27, "_contributors": [ { "user": "skranz", "count": 35, "uuid": 1413022 } ], "_userbio": { "uuid": 1413022, "type": "user", "name": "Sebastian Kranz", "followers": 216 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbmisc" }, "_devurl": "https://github.com/skranz/dbmisc", "_searchresults": 17, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbmisc.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_exports": [ "convert.db.to.r", "convert.r.to.db", "dbConnectSQLiteWithSchema", "dbCreateSchemaTable", "dbCreateSchemaTables", "dbCreateSQLiteFromSchema", "dbDelete", "dbGet", "dbGetMemoise", "dbInsert", "dbTableCols", "dbUpdate", "empty.df.from.schema", "empty.row.from.schema", "example.empty.row.schema", "get.db.schema", "get.db.schemas", "get.table.memoise", "init.schema", "load.and.init.schemas", "logDBcommand", "schema.r.classes", "schema.template", "set.db.schema", "set.db.schemas", "set.table.memoise", "sql.where.code", "to.db.date", "to.db.datetime" ], "_help": [ { "page": "convert.db.to.r", "title": "Convert data from a database table to R format", "topics": [ "convert.db.to.r" ] }, { "page": "convert.r.to.db", "title": "Convert data from a database table to R format", "topics": [ "convert.r.to.db" ] }, { "page": "dbConnectSQLiteWithSchema", "title": "Creates a connection to an SQLite database and sets the specified schema", "topics": [ "dbConnectSQLiteWithSchema" ] }, { "page": "dbCreateSchemaTable", "title": "Create database table and possible indices from a simple yaml schema", "topics": [ "dbCreateSchemaTable" ] }, { "page": "dbCreateSchemaTables", "title": "Create or update database tables and possible indices from a simple yaml schema", "topics": [ "dbCreateSchemaTables" ] }, { "page": "dbCreateSQLiteFromSchema", "title": "Create or update a SQLite database from a schema file", "topics": [ "dbCreateSQLiteFromSchema" ] }, { "page": "dbDelete", "title": "Delete row(s) from table", "topics": [ "dbDelete" ] }, { "page": "dbGet", "title": "Get rows from a table", "topics": [ "dbGet" ] }, { "page": "dbGetMemoise", "title": "Get results from a database like dbGet put buffer the results in memory", "topics": [ "dbGetMemoise" ] }, { "page": "dbInsert", "title": "Insert row(s) into table", "topics": [ "dbInsert" ] }, { "page": "dbTableCols", "title": "Get a data frame with column information for a database table", "topics": [ "dbTableCols" ] }, { "page": "dbUpdate", "title": "Update a row in a database table", "topics": [ "dbUpdate" ] }, { "page": "empty.df.from.schema", "title": "Creates an example data frame from a database schema table using provided column values and default values specified in schema", "topics": [ "empty.df.from.schema" ] }, { "page": "empty.row.from.schema", "title": "Creates an example row from a database schema table using provided column values and default values specified in schema", "topics": [ "empty.row.from.schema" ] }, { "page": "get.db.schema", "title": "Extract schemas from a data base connection", "topics": [ "get.db.schema" ] }, { "page": "init.schema", "title": "Init a schema by parsing table definition and store info in easy accessibale R format", "topics": [ "init.schema" ] }, { "page": "load.and.init.schemas", "title": "Load and init database table schemas from yaml file", "topics": [ "load.and.init.schemas" ] }, { "page": "logDBcommand", "title": "log a command that changes a database", "topics": [ "logDBcommand" ] }, { "page": "schema.r.classes", "title": "Get a vector of R classes of the database columns described in a schema", "topics": [ "schema.r.classes" ] }, { "page": "schema.template", "title": "Create an example schema from a list of R objects", "topics": [ "schema.template" ] }, { "page": "set.db.schema", "title": "Set schemas as hidden attribute to a data base connection db", "topics": [ "set.db.schema" ] }, { "page": "sql.where.code", "title": "Create a parametrized or escaped SQL WHERE clause from the provided parameters.", "topics": [ "sql.where.code" ] }, { "page": "to.db.date", "title": "Convert an R object to a date object that can be used in a WHERE clause.", "topics": [ "to.db.date" ] }, { "page": "to.db.datetime", "title": "Convert an R object to a datetime object that can be used in a WHERE clause.", "topics": [ "to.db.datetime" ] } ], "_readme": "https://github.com/skranz/dbmisc/raw/master/README.md", "_rundeps": [ "cli", "DBI", "glue", "lifecycle", "magrittr", "restorepoint", "rlang", "stringi", "stringr", "stringtools", "vctrs", "yaml" ], "_score": 4.315025199312605, "_indexed": true, "_nocasepkg": "dbmisc", "_universes": [ "skranz" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3", "date": "2026-07-03T22:05:42.000Z", "distro": "resolute", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/5afd91c82f9d1dc69ea84cf10f15c845ecd58ee67773f20637d5aa182cd7bb48", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" }, { "r": "4.6.1", "os": "linux", "version": "0.3", "date": "2026-07-03T22:05:35.000Z", "distro": "resolute", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/bb3dc7a4c29e7850926326b102711950efd902f9f07777c09ee4b756270cbff7", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" }, { "r": "4.5.3", "os": "mac", "version": "0.3", "date": "2026-07-03T22:04:56.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/ce20a6eef2a13948a650f4d1fe1bd5e58e9caab4d21d1601cec61557721d4afd", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" }, { "r": "4.6.1", "os": "mac", "version": "0.3", "date": "2026-07-03T22:05:28.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/d4e9c0ed95874812e2ede56e3eea9d5d15984278f571b0ee2414bd21aab676f8", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" }, { "r": "4.6.0", "os": "wasm", "version": "0.3", "date": "2026-07-03T22:05:48.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/2e5f3c00fc4300d65426e38caaab9881094b99fe717bef94ecb28c7345df6031", "status": "success", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" }, { "r": "4.7.0", "os": "win", "version": "0.3", "date": "2026-07-03T22:04:46.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/057a374c48c17fb6e8c1176ac17c35dae819f7ddb6db5ed21617f2df28563ece", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" }, { "r": "4.5.3", "os": "win", "version": "0.3", "date": "2026-07-03T22:04:37.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/0ca6be5ed6ca6b13d26a78d762be5e8330b5fc492561607a53509724279c2fb9", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" }, { "r": "4.6.1", "os": "win", "version": "0.3", "date": "2026-07-03T22:04:36.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/dc978723b2e21d0a41999714e05d3a3addf0152e3272b6b67e462b8f5478b1f0", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28685173350" } ] }