Package: editbl 1.2.0

Jasper Schelfhout

editbl: 'DT' Extension for CRUD (Create, Read, Update, Delete) Applications in 'shiny'

The core of this package is a function eDT() which enhances DT::datatable() such that it can be used to interactively modify data in 'shiny'. By the use of generic 'dplyr' methods it supports many types of data storage, with relational databases ('dbplyr') being the main use case.

Authors:Jasper Schelfhout [aut, cre], Maxim Nazarov [rev], Daan Seynaeve [rev], Lennart Tuijnder [rev], Saar Junius [ctb]

editbl_1.2.0.tar.gz
editbl_1.2.0.zip(r-4.5)editbl_1.2.0.zip(r-4.4)editbl_1.2.0.zip(r-4.3)
editbl_1.2.0.tgz(r-4.5-any)editbl_1.2.0.tgz(r-4.4-any)editbl_1.2.0.tgz(r-4.3-any)
editbl_1.2.0.tar.gz(r-4.5-noble)editbl_1.2.0.tar.gz(r-4.4-noble)
editbl_1.2.0.tgz(r-4.4-emscripten)editbl_1.2.0.tgz(r-4.3-emscripten)
editbl.pdf |editbl.html✨
editbl/json (API)
NEWS

# Install 'editbl' in R:
install.packages('editbl', repos = c('https://openanalytics.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/openanalytics/editbl/issues

On CRAN:

Conda:

6.61 score 24 stars 12 scripts 297 downloads 12 exports 52 dependencies

Last updated 3 days agofrom:3c991ab5ab. Checks:9 OK. Indexed: yes.

TargetResultLatest binary
Doc / VignettesOKMar 31 2025
R-4.5-winOKMar 31 2025
R-4.5-macOKMar 31 2025
R-4.5-linuxOKMar 31 2025
R-4.4-winOKMar 31 2025
R-4.4-macOKMar 31 2025
R-4.4-linuxOKMar 31 2025
R-4.3-winOKMar 31 2025
R-4.3-macOKMar 31 2025

Exports:connectDBcustomButtone_rows_inserte_rows_updateeDTeDTOutputforeignTblinputServerinputUIrunDemoAppselectInputDT_ServerselectInputDT_UI

Dependencies:base64encbslibcachemclicommonmarkcrayoncrosstalkdigestdplyrDTevaluatefansifastmapfontawesomefsgenericsgluehighrhtmltoolshtmlwidgetshttpuvjquerylibjsonliteknitrlaterlazyevallifecyclemagrittrmemoisemimepillarpkgconfigpromisesR6rappdirsRcpprlangrmarkdownsassshinyshinyjssourcetoolstibbletidyselecttinytexutf8uuidvctrswithrxfunxtableyaml

Switching from DT

Rendered fromhowto_switch_from_DT.rmdusingknitr::rmarkdownon Mar 31 2025.

Last update: 2024-05-21
Started: 2024-05-07

Edit tables in a relational database - dm package

Rendered fromhowto_relational_db_dm.rmdusingknitr::rmarkdownon Mar 31 2025.

Last update: 2024-05-21
Started: 2024-05-07

Row level access

Rendered fromhowto_row_level_access.rmdusingknitr::rmarkdownon Mar 31 2025.

Last update: 2025-03-31
Started: 2025-01-30

Edit tables in a relational database

Rendered fromhowto_relational_db.rmdusingknitr::rmarkdownon Mar 31 2025.

Last update: 2024-05-21
Started: 2024-05-07

Readme and manuals

Help Manual

Help pageTopics
Add modification buttons as a columnaddButtons
Start a transaction for a tibblebeginTransaction
Re-usable documentationcanXXXRowTemplate
Cast columns in 'data.frame' to editable types in datatablecastForDisplay
Cast tbl to class of templatecastFromTbl
Cast all columns that exist in a foreignTbl to factorcastToFactor
Cast the data type to something supported by SQL.castToSQLSupportedType
Cast data to tblcastToTbl
Cast 'tbl' or 'data.frame' x to the types of the templatecastToTemplate
Check if all rows in tbl fufill 'foreignTbl' constraintscheckForeignTbls
Return first non 'NULL' argumentcoalesce
Cast columns to the type of the templatecoerceColumns
'DT::coerceValue' with better 'POSIXct' supportcoerceValue
Start a transaction for a tibblecommitTransaction
Connect to a database.connectDB
Create buttons to modify the row.createButtons
Generate HTML for an in-row delete buttoncreateDeleteButtonHTML
Helper function to write HTMLcreateDeleteButtonHTML_shiny
Generate HTML for an in-row edit buttoncreateEditButtonHTML
Helper function to write HTMLcreateEditButtonHTML_shiny
Generate a custom button for 'eDT'customButton
Server of the mtcars demo appdemoServer_custom
Server of the DB demo appdemoServer_DB
Server of the mtcars demo appdemoServer_mtcars
UI of the demo mtcars appdemoUI_custom
UI of the DB demo appdemoUI_DB
UI of the demo mtcars appdemoUI_mtcars
Server of the development appdevServer
UI of the development appdevUI
Function to generate CSS to disable clicking events on a columndisableDoubleClickButtonCss
Insert rows into a tibblee_rows_insert
Insert rows into a tibblee_rows_insert.default
rows_insert implementation for 'data.table' backends.e_rows_insert.dtplyr_step
rows_insert implementation for DBI backends.e_rows_insert.tbl_dbi
Update rows of a tibblee_rows_update
rows_update implementation for data.frame backends.e_rows_update.data.frame
Update rows of a tibblee_rows_update.default
rows_update implementation for data.table backends.e_rows_update.dtplyr_step
rows_update implementation for DBI backends.e_rows_update.tbl_dbi
Create a modifieable datatable.eDT
Open interactive app to explore and modify dataeDT_app
Server of eDT_appeDT_app_server
UI of eDT_appeDT_app_ui
UI part of 'eDT'eDTOutput
Determine if a row can be deletedevalCanDeleteRow
Determine if a row can be editedevalCanEditRow
Fill data columns based on foreignTblsfillDeductedColumns
Replace instances of integer64 with actual NA values instead of weird default 9218868437227407266fixInteger64
Create a foreign tibbleforeignTbl
Get name of the tbl in the databaseget_db_table_name
Get types of columns in a tblgetColumnTypeSums
Get all columns that are not natural keysgetNonNaturalKeyCols
Add some extra columns to data to allow for / keep track of modificationsinitData
An input server for a 'data.frame'inputServer
An input server for a 'data.frame'inputServer.default
An input UI for a 'data.frame'inputUI
UI part for modal with input fields for editinginputUI.default
Merge a tbl with it a foreignTbljoinForeignTbl
Overwrite default settings with provided settingsoverwriteDefaults
Start a transaction for a tibblerollbackTransaction
Add a row to a table in the database.rowInsert
rows_delete implementation for data.table backends.rows_delete.dtplyr_step
Update rows in the database.rowUpdate
Run a demo apprunDemoApp
Run a custom demo apprunDemoApp_custom
Run a demo apprunDemoApp_DB
Run a demo apprunDemoApp_mtcars
Run a development apprunDevApp
Server part to use a 'datatable' as select inputselectInputDT_Server
UI part of a DT select inputselectInputDT_UI
Get a shiny input for a column of a 'tbl'shinyInput
Standardize colnames argument to the format of named character vectorstandardizeArgument_colnames
Standardized editable argument to be in the form of a liststandardizeArgument_editable
Generate where sqlwhereSQL