{ "_id": "6a49da8c2c82cd3614823a31", "Package": "editbl", "Type": "Package", "Version": "1.3.2", "Date": "2026-05-20", "Title": "'DT' Extension for CRUD (Create, Read, Update, Delete)\nApplications in 'shiny'", "Authors@R": "c(person(\"Jasper\", \"Schelfhout\", \"\", \"jasper.schelfhout@openanalytics.eu\",\nrole = c(\"aut\", \"cre\")),\nperson(\"Maxim\", \"Nazarov\", \"\", \"maxim.nazarov@openanalytics.eu\",\nrole = c(\"rev\")),\nperson(\"Daan\", \"Seynaeve\", \"\", \"daan.seynaeve@openanalytics.eu\",\nrole = c(\"rev\")),\nperson(\"Lennart\", \"Tuijnder\", \"\", \"lennart.tuijnder@openanalytics.eu\",\nrole = c(\"rev\")),\nperson(\"Saar\", \"Junius\", \"\", \"saar.junius@openanalytics.eu\",\nrole = c(\"aut\")))", "Maintainer": "Jasper Schelfhout ", "Description": "The core of this package is a function eDT() which\nenhances DT::datatable() such that it can be used to\ninteractively modify data in 'shiny'. By the use of generic\n'dplyr' methods it supports many types of data storage, with\nrelational databases ('dbplyr') being the main use case.", "License": "GPL-3", "Copyright": "Open Analytics NV, 2023", "URL": "https://github.com/openanalytics/editbl", "BugReports": "https://github.com/openanalytics/editbl/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "Config/pak/sysreqs": "cmake make libuv1-dev zlib1g-dev", "Repository": "https://openanalytics.r-universe.dev", "Date/Publication": "2026-05-25 11:38:26 UTC", "RemoteUrl": "https://github.com/openanalytics/editbl", "RemoteRef": "HEAD", "RemoteSha": "89be008c3940885ae17b327b701e679918af172a", "RemoteSubdir": "editbl", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-05 04:12:45 UTC", "User": "root" }, "Author": "Jasper Schelfhout [aut, cre],\nMaxim Nazarov [rev],\nDaan Seynaeve [rev],\nLennart Tuijnder [rev],\nSaar Junius [aut]", "_user": "openanalytics", "_type": "src", "_file": "editbl_1.3.2.tar.gz", "_fileid": "https://r2.ropensci.org/6210f7218509a379ae047659fa5fb7800cd0328a4695e8ada909f260cfcc0f3b", "_filesize": 962872, "_sha256": "6210f7218509a379ae047659fa5fb7800cd0328a4695e8ada909f260cfcc0f3b", "_expires": "2026-10-13T04:16:11.000Z", "_created": "2026-07-05T04:12:45.000Z", "_published": "2026-07-05T04:16:12.983Z", "_jobs": [ { "job": 85191732368, "time": 149, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8088204844" }, { "job": 85191732372, "time": 146, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8088204674" }, { "job": 85191732376, "time": 106, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8088201095" }, { "job": 85191732381, "time": 99, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8088200336" }, { "job": 85191559512, "time": 192, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8088191343" }, { "job": 85191732359, "time": 171, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8088206944" }, { "job": 85191732379, "time": 112, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8088201659" }, { "job": 85191732367, "time": 92, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8088199684" }, { "job": 85191732363, "time": 91, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8088199567" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756", "_status": "success", "_upstream": "https://github.com/openanalytics/editbl", "_commit": { "id": "89be008c3940885ae17b327b701e679918af172a", "author": "Jasper Schelfhout <49677239+JasperSch@users.noreply.github.com>", "committer": "GitHub ", "message": "feat: expose modifications (#21)\n\n* feat: expose modifications\n\n* Documentation\n\n* Only expose saved modifications.\n\n+ Add vignette with advise on how to implement custom logic\n\n* documentation\n\n* improve documentation\n\n* Update README\n\n* Update vignette\n\n* change README\n\n---------\n\nCo-authored-by: jschelfhout ", "time": 1779709106 }, "_maintainer": { "name": "Jasper Schelfhout", "email": "jasper.schelfhout@openanalytics.eu", "login": "jaspersch", "linkedin": "in/jasper-schelfhout", "description": "Consultant @openanalytics ", "uuid": 49677239 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "shiny", "role": "Imports" }, { "package": "shinyjs", "role": "Imports" }, { "package": "DT", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "uuid", "role": "Imports" }, { "package": "fontawesome", "version": ">= 0.4.0", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "dtplyr", "role": "Suggests" }, { "package": "data.table", "role": "Suggests" }, { "package": "vctrs", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "glue", "role": "Suggests" }, { "package": "DBI", "role": "Suggests" }, { "package": "bit64", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "dm", "role": "Suggests" } ], "_owner": "openanalytics", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-30", "n": 2 }, { "week": "2025-34", "n": 1 }, { "week": "2025-39", "n": 2 }, { "week": "2025-40", "n": 3 }, { "week": "2026-22", "n": 1 } ], "_tags": [], "_stars": 31, "_contributors": [ { "user": "jaspersch", "count": 41, "uuid": 49677239 }, { "user": "saarjunius", "count": 4, "uuid": 142490718 } ], "_userbio": { "uuid": 274806, "type": "organization", "name": "OpenAnalytics", "followers": 110 }, "_downloads": { "count": 351, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/editbl" }, "_devurl": "https://github.com/openanalytics/editbl", "_searchresults": 30, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/editbl.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/openanalytics/editbl", "_realowner": "openanalytics", "_cranurl": true, "_releases": [ { "version": "0.9.5", "date": "2023-09-05" }, { "version": "0.9.6", "date": "2023-09-19" }, { "version": "1.0.1", "date": "2023-10-13" }, { "version": "1.0.2", "date": "2023-10-30" }, { "version": "1.0.3", "date": "2024-01-10" }, { "version": "1.0.4", "date": "2024-05-07" }, { "version": "1.0.5", "date": "2024-05-21" }, { "version": "1.1.0", "date": "2025-01-31" }, { "version": "1.2.0", "date": "2025-03-31" }, { "version": "1.3.0", "date": "2025-04-24" } ], "_exports": [ "connectDB", "customButton", "e_rows_delete", "e_rows_insert", "e_rows_update", "eDT", "eDTOutput", "foreignTbl", "inputServer", "inputUI", "runDemoApp", "selectInputDT_Server", "selectInputDT_UI" ], "_help": [ { "page": "connectDB", "title": "Connect to a database.", "topics": [ "connectDB" ] }, { "page": "customButton", "title": "Generate a custom button for 'eDT'", "topics": [ "customButton" ] }, { "page": "e_rows_delete", "title": "Delete rows from a tibble", "topics": [ "e_rows_delete" ] }, { "page": "e_rows_delete.default", "title": "Delete rows from a tibble", "topics": [ "e_rows_delete.default" ] }, { "page": "e_rows_insert", "title": "Insert rows into a tibble", "topics": [ "e_rows_insert" ] }, { "page": "e_rows_insert.default", "title": "Insert rows into a tibble", "topics": [ "e_rows_insert.default" ] }, { "page": "e_rows_insert.dtplyr_step", "title": "rows_insert implementation for 'data.table' backends.", "topics": [ "e_rows_insert.dtplyr_step" ] }, { "page": "e_rows_insert.tbl_dbi", "title": "rows_insert implementation for DBI backends.", "topics": [ "e_rows_insert.tbl_dbi" ] }, { "page": "e_rows_update", "title": "Update rows of a tibble", "topics": [ "e_rows_update" ] }, { "page": "e_rows_update.data.frame", "title": "rows_update implementation for data.frame backends.", "topics": [ "e_rows_update.data.frame" ] }, { "page": "e_rows_update.default", "title": "Update rows of a tibble", "topics": [ "e_rows_update.default" ] }, { "page": "e_rows_update.dtplyr_step", "title": "rows_update implementation for data.table backends.", "topics": [ "e_rows_update.dtplyr_step" ] }, { "page": "e_rows_update.tbl_dbi", "title": "rows_update implementation for DBI backends.", "topics": [ "e_rows_update.tbl_dbi" ] }, { "page": "eDT", "title": "Create a modifieable datatable.", "topics": [ "eDT" ] }, { "page": "eDTOutput", "title": "UI part of 'eDT'", "topics": [ "eDTOutput" ] }, { "page": "foreignTbl", "title": "Create a foreign tibble", "topics": [ "foreignTbl" ] }, { "page": "get_db_table_name", "title": "Get name of the tbl in the database", "topics": [ "get_db_table_name" ] }, { "page": "inputServer", "title": "An input server for a 'data.frame'", "topics": [ "inputServer" ] }, { "page": "inputServer.default", "title": "An input server for a 'data.frame'", "topics": [ "inputServer.default" ] }, { "page": "inputUI", "title": "An input UI for a 'data.frame'", "topics": [ "inputUI" ] }, { "page": "inputUI.default", "title": "UI part for modal with input fields for editing", "topics": [ "inputUI.default" ] }, { "page": "joinForeignTbl", "title": "Merge a tbl with it a foreignTbl", "topics": [ "joinForeignTbl" ] }, { "page": "rows_delete.dtplyr_step", "title": "rows_delete implementation for data.table backends.", "topics": [ "rows_delete.dtplyr_step" ] }, { "page": "runDemoApp", "title": "Run a demo app", "topics": [ "runDemoApp" ] }, { "page": "selectInputDT_Server", "title": "Server part to use a 'datatable' as select input", "topics": [ "selectInputDT_Server" ] }, { "page": "selectInputDT_UI", "title": "UI part of a DT select input", "topics": [ "selectInputDT_UI" ] } ], "_readme": "https://github.com/openanalytics/editbl/raw/HEAD/editbl/README.md", "_rundeps": [ "base64enc", "bslib", "cachem", "cli", "commonmark", "crosstalk", "digest", "dplyr", "DT", "evaluate", "fastmap", "fontawesome", "fs", "generics", "glue", "highr", "htmltools", "htmlwidgets", "httpuv", "jquerylib", "jsonlite", "knitr", "later", "lazyeval", "lifecycle", "magrittr", "memoise", "mime", "otel", "pillar", "pkgconfig", "promises", "R6", "rappdirs", "Rcpp", "rlang", "rmarkdown", "sass", "shiny", "shinyjs", "sourcetools", "tibble", "tidyselect", "tinytex", "utf8", "uuid", "vctrs", "withr", "xfun", "xtable", "yaml" ], "_vignettes": [ { "source": "howto_switch_from_DT.rmd", "filename": "howto_switch_from_DT.html", "title": "Switching from DT", "engine": "knitr::rmarkdown", "headings": [], "created": "2024-05-07 10:26:22", "modified": "2024-05-21 07:03:49", "commits": 3 }, { "source": "howto_relational_db_dm.rmd", "filename": "howto_relational_db_dm.html", "title": "Edit tables in a relational database - dm package", "engine": "knitr::rmarkdown", "headings": [ "Creating a database connection", "Setting up the data model", "Fully fletched table editor" ], "created": "2024-05-07 10:26:22", "modified": "2024-05-21 07:03:49", "commits": 3 }, { "source": "howto_custom_logic.rmd", "filename": "howto_custom_logic.html", "title": "Custom logic", "engine": "knitr::rmarkdown", "headings": [ "Option 1", "Option 2" ], "created": "2026-05-25 11:38:26", "modified": "2026-05-25 11:38:26", "commits": 1 }, { "source": "howto_row_level_access.rmd", "filename": "howto_row_level_access.html", "title": "Row level access", "engine": "knitr::rmarkdown", "headings": [ "Hide rows completely", "Read-only access" ], "created": "2025-01-30 13:47:30", "modified": "2025-03-31 09:17:05", "commits": 4 }, { "source": "howto_relational_db.rmd", "filename": "howto_relational_db.html", "title": "Edit tables in a relational database", "engine": "knitr::rmarkdown", "headings": [ "Basics of handling a database in R", "A simple table editor", "Advanced table editor (flat, joined table).", "Advanced table editor (partial table).", "Above and beyond" ], "created": "2024-05-07 10:26:22", "modified": "2025-04-24 13:06:46", "commits": 4 } ], "_score": 7.065392961561992, "_indexed": true, "_nocasepkg": "editbl", "_universes": [ "openanalytics", "jaspersch" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.3.2", "date": "2026-07-05T04:15:04.000Z", "distro": "resolute", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/334719f72a925860a9fd7b59874ce8bf3ae52cead6bc34ff578ffb1e32afc258", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" }, { "r": "4.6.1", "os": "linux", "version": "1.3.2", "date": "2026-07-05T04:15:03.000Z", "distro": "resolute", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/0526fc54e979a758c6b1ce364343bb7912136886191cc67651055fd83d8d961b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" }, { "r": "4.5.3", "os": "mac", "version": "1.3.2", "date": "2026-07-05T04:14:26.000Z", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/13d51f6f62f1784bd72b5f910e629ae17c5bad7bf69d022e0678e2206cfccf88", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" }, { "r": "4.6.1", "os": "mac", "version": "1.3.2", "date": "2026-07-05T04:14:21.000Z", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/3d6e8a0646ab55c3e3749fbf22fdab06ba07d7ba996107fa8427c70647393e5c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" }, { "r": "4.6.0", "os": "wasm", "version": "1.3.2", "date": "2026-07-05T04:15:53.000Z", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/3f2df1a180d92cf2bd8800531cba3925b82e25580968286724d687607878e26c", "status": "success", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" }, { "r": "4.7.0", "os": "win", "version": "1.3.2", "date": "2026-07-05T04:14:08.000Z", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/e3083934afd6cde6a0fb2a5aa11a9fbc1c7771d7850157f95a473e500339dbda", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" }, { "r": "4.5.3", "os": "win", "version": "1.3.2", "date": "2026-07-05T04:13:58.000Z", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/04e3c0824b276def9e489a76ba37df4a49f3a1067f00d97266d40d4a3eec5d0d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" }, { "r": "4.6.1", "os": "win", "version": "1.3.2", "date": "2026-07-05T04:13:58.000Z", "commit": "89be008c3940885ae17b327b701e679918af172a", "fileid": "https://r2.ropensci.org/39f48e06a9b2c63a2c30f4539529452e8525f2ad520da8c64cf7798c28088381", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/28729083756" } ] }