{ "_id": "6a16cb5cacfb0bcc41d89b64", "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-05-27 10:43:14 UTC", "User": "root" }, "MD5sum": "c76d8e09e3e485110f8dcb5d8a59e2af", "_user": "skranz", "_type": "src", "_file": "dbmisc_0.3.tar.gz", "_fileid": "1eceb54127c2ffd9e569c94537778f16c79923e8d8369733c86d2ac28b51cd43", "_filesize": 161444, "_sha256": "1eceb54127c2ffd9e569c94537778f16c79923e8d8369733c86d2ac28b51cd43", "_created": "2026-05-27T10:43:14.000Z", "_published": "2026-05-27T10:45:48.291Z", "_distro": "noble", "_jobs": [ { "job": 78059715636, "time": 102, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "7238352048" }, { "job": 78059715630, "time": 114, "config": "linux-release-x86_64", "r": "4.6.0", "check": "WARNING", "artifact": "7238355324" }, { "job": 78059715633, "time": 71, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "7238342457" }, { "job": 78059715609, "time": 94, "config": "macos-release-arm64", "r": "4.6.0", "check": "WARNING", "artifact": "7238349531" }, { "job": 78059304493, "time": 159, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7238320436" }, { "job": 78059715603, "time": 103, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7238352058" }, { "job": 78059715671, "time": 119, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "7238356958" }, { "job": 78059715632, "time": 86, "config": "windows-oldrel", "r": "4.5.3", "check": "WARNING", "artifact": "7238347346" }, { "job": 78059715623, "time": 71, "config": "windows-release", "r": "4.6.0", "check": "WARNING", "artifact": "7238342206" } ], "_buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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" }, "_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.0", "_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-05-27T10:44:59.000Z", "distro": "noble", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "241ae1fcb0d8cb0cd2a00b3456b64ab0e0b1e59c5e403d40e3bcf6c3e5344643", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" }, { "r": "4.6.0", "os": "linux", "version": "0.3", "date": "2026-05-27T10:45:10.000Z", "distro": "noble", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "3c423bef97bd8a6d58614300ed5c8bc1d7c58c4a4d8c0fe744df62143d813e8f", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" }, { "r": "4.5.3", "os": "mac", "version": "0.3", "date": "2026-05-27T10:44:32.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "85cc97fe4f4533128ddb697b55d777884c43fca08e740d617df2ab83701f777b", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" }, { "r": "4.6.0", "os": "mac", "version": "0.3", "date": "2026-05-27T10:44:54.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "dde2f2dabe92b5bdfd9dfcd46f24a12de2c976e84caabe6332c7e832f78fe189", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" }, { "r": "4.6.0", "os": "wasm", "version": "0.3", "date": "2026-05-27T10:45:11.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "d4b5b5b651eb82081f378a2b76499644e89947411baf9ae7b0964ce70d9c1dc7", "status": "success", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" }, { "r": "4.7.0", "os": "win", "version": "0.3", "date": "2026-05-27T10:45:10.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "dfa7ddb2853caa52019df8957c05fa0e2bf0bebdff4de2a1b45f3d6121b60468", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" }, { "r": "4.5.3", "os": "win", "version": "0.3", "date": "2026-05-27T10:44:37.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "cddf663eb6f26b0d0d502cccf96751728592e6c4392243974cd0d2a77fe3c1a2", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" }, { "r": "4.6.0", "os": "win", "version": "0.3", "date": "2026-05-27T10:44:19.000Z", "commit": "aef87129585de20453627f7246effebf00fac596", "fileid": "7e920494439efb05c4e3f6dc5808cb366b86606143ee6ad81bb2fa7531418329", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/skranz/actions/runs/26506235365" } ] }