{ "_id": "6a4b48c2a6574ff277f99064", "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-06 06:09:38 UTC", "User": "root" }, "_user": "skranz", "_type": "src", "_file": "dbmisc_0.3.tar.gz", "_fileid": "https://r2.ropensci.org/1d35aa2551dd412def9b1ae48a66a51af0a627c4399ed30f05e3d1925d7869d2", "_filesize": 163692, "_sha256": "1d35aa2551dd412def9b1ae48a66a51af0a627c4399ed30f05e3d1925d7869d2", "_expires": "2026-10-14T06:18:41.000Z", "_created": "2026-07-06T06:09:38.000Z", "_published": "2026-07-06T06:18:42.690Z", "_jobs": [ { "job": 85306051689, "time": 157, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "8101011884" }, { "job": 85306051711, "time": 131, "config": "linux-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "8101005242" }, { "job": 85306051706, "time": 101, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "8101063773" }, { "job": 85306051744, "time": 78, "config": "macos-release-arm64", "r": "4.6.1", "check": "WARNING", "artifact": "8101098959" }, { "job": 85305714854, "time": 166, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8100974190" }, { "job": 85306051679, "time": 113, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8101000759" }, { "job": 85306051741, "time": 66, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "8100990452" }, { "job": 85306051715, "time": 65, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "8100989881" }, { "job": 85306051723, "time": 65, "config": "windows-release", "r": "4.6.1", "check": "WARNING", "artifact": "8100989717" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428", "_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-06T06:12:20.000Z", "distro": "resolute", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/95eaf1419249b7e5bb402ea47ef1ce4f2faefb85eceee166a756589334e18b70", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" }, { "r": "4.6.1", "os": "linux", "version": "0.3", "date": "2026-07-06T06:11:54.000Z", "distro": "resolute", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/923a18a5c83c23864f226e2bde5b34a3f37afe2451b0227d8ab129bb206c1dae", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" }, { "r": "4.5.3", "os": "mac", "version": "0.3", "date": "2026-07-06T06:16:03.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/ede998341ab295df297eabcedfc9ff705694dd6939a9ca54892e30cf0e7d30ca", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" }, { "r": "4.6.1", "os": "mac", "version": "0.3", "date": "2026-07-06T06:18:15.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/f8f21cd05a621548d56ca3251fadfa530d2fe93fed2813d096a9aab1780a62d9", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" }, { "r": "4.6.0", "os": "wasm", "version": "0.3", "date": "2026-07-06T06:11:45.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/b17e921fbb8684c122c4e58a56e4ede70ea0f5bc0dc305f9107e0acb393dbfab", "status": "success", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" }, { "r": "4.7.0", "os": "win", "version": "0.3", "date": "2026-07-06T06:10:46.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/dfa02920b8f810cbb20731dba2f006f48e54905bd34b0ad9e787997338ce0165", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" }, { "r": "4.5.3", "os": "win", "version": "0.3", "date": "2026-07-06T06:10:42.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/7bc49905a18247622aacd1d9f9b6bbcb89d3cb83df9ed64299f0efc847c38f4c", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" }, { "r": "4.6.1", "os": "win", "version": "0.3", "date": "2026-07-06T06:10:42.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/302b9a170361b410de4c746d70030777b2c84ad84e34a4a95bbc9f57b7803137", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/28771389428" } ] }