{ "_id": "6ac201d5773a0037682c0705", "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-10-04 07:23:45 UTC", "User": "root" }, "_user": "skranz", "_type": "src", "_file": "dbmisc_0.3.tar.gz", "_fileid": "https://r2.ropensci.org/242a562615721d2732a64dec7dcd685030d3f7eb2b9d9faed107ad130bf0a84f", "_filesize": 164858, "_sha256": "242a562615721d2732a64dec7dcd685030d3f7eb2b9d9faed107ad130bf0a84f", "_expires": "2027-01-12T07:35:46.000Z", "_created": "2026-10-04T07:23:45.000Z", "_published": "2026-10-04T07:35:49.123Z", "_jobs": [ { "job": 111386923452, "time": 101, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "11296992488" }, { "job": 111386923388, "time": 94, "config": "linux-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "11296453205" }, { "job": 111386923477, "time": 83, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "11296249651" }, { "job": 111386923421, "time": 101, "config": "macos-release-arm64", "r": "4.6.1", "check": "WARNING", "artifact": "11297230886" }, { "job": 111386477370, "time": 178, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11296932473" }, { "job": 111386923365, "time": 78, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11297077344" }, { "job": 111386923381, "time": 60, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "11296363562" }, { "job": 111386923446, "time": 57, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "WARNING", "artifact": "11297122014" }, { "job": 111386923467, "time": 68, "config": "windows-release-x86_64", "r": "4.6.1", "check": "WARNING", "artifact": "11297042281" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264", "_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": 214 }, "_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/manual.pdf", "extra/readme.html", "extra/readme.md" ], "_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-10-04T07:25:32.000Z", "distro": "resolute", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/469caa59ca67eb7544e2b83d62a0d6eb9dfe3f83edbb7de15a85b57e08e38625", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" }, { "r": "4.6.1", "os": "linux", "version": "0.3", "date": "2026-10-04T07:25:27.000Z", "distro": "resolute", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/4798c2bbcc9f0f26e390435fd3030514645b2128736abe5b86513afd0f4a0745", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" }, { "r": "4.5.3", "os": "mac", "version": "0.3", "date": "2026-10-04T07:35:17.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/9db34a29889b240015005589736126de25065fb0674c87c59beab26711813942", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" }, { "r": "4.6.1", "os": "mac", "version": "0.3", "date": "2026-10-04T07:30:04.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/6dcea585450de38b2e20b3c6fde1c11382050fc9546b14cf5957153e9045096e", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" }, { "r": "4.6.0", "os": "wasm", "version": "0.3", "date": "2026-10-04T07:25:21.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/47a624896eaaca336d2d270fac76a0d884e8a9e908736dacba145c415906a50e", "status": "success", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" }, { "r": "4.7.0", "os": "win", "version": "0.3", "date": "2026-10-04T07:24:43.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/40c132250cfd285cea61d4d38e68b825ea670c5eae2da243110a07caef147c2a", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" }, { "r": "4.5.3", "os": "win", "version": "0.3", "date": "2026-10-04T07:24:43.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/4551fd2366d65610754a9d2b75a73273424517236ed331881df5b1199d6b29b9", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" }, { "r": "4.6.1", "os": "win", "version": "0.3", "date": "2026-10-04T07:24:51.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "https://r2.ropensci.org/c0ba6094f051caf502e015dfc81242022e8cb5557d5e65d5e96e982af4570f6f", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/37185497264" } ] }