{
  "_id": "6ac2234a773a0037682c28ba",
  "Package": "editbl",
  "Type": "Package",
  "Version": "1.3.2-9000",
  "Date": "2026-07-09",
  "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 <jasper.schelfhout@openanalytics.eu>",
  "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-08-05 12:57:34 UTC",
  "RemoteUrl": "https://github.com/openanalytics/editbl",
  "RemoteRef": "HEAD",
  "RemoteSha": "caa88d30244381266786519e992cb6c05b32e8db",
  "RemoteSubdir": "editbl",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-04 09:55:27 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-9000.tar.gz",
  "_fileid": "https://r2.ropensci.org/edb54e9b253d1efc6fe6424cf3889c59064f7367b7c1bc7e210edf762ba2b1df",
  "_filesize": 966434,
  "_sha256": "edb54e9b253d1efc6fe6424cf3889c59064f7367b7c1bc7e210edf762ba2b1df",
  "_expires": "2027-01-12T09:58:32.000Z",
  "_created": "2026-10-04T09:55:27.000Z",
  "_published": "2026-10-04T09:58:34.779Z",
  "_jobs": [
    {
      "job": 111411089096,
      "time": 140,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11299758299"
    },
    {
      "job": 111411089051,
      "time": 143,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11299364619"
    },
    {
      "job": 111411089071,
      "time": 103,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11300371330"
    },
    {
      "job": 111411089057,
      "time": 110,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11300157114"
    },
    {
      "job": 111410564732,
      "time": 198,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11299374265"
    },
    {
      "job": 111411089037,
      "time": 124,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11299414272"
    },
    {
      "job": 111411089077,
      "time": 90,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11300321514"
    },
    {
      "job": 111411089103,
      "time": 89,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11300325693"
    },
    {
      "job": 111411089038,
      "time": 94,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11300251927"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716",
  "_status": "success",
  "_upstream": "https://github.com/openanalytics/editbl",
  "_commit": {
    "id": "caa88d30244381266786519e992cb6c05b32e8db",
    "author": "jschelfhout <jschelfhout@openanalytics.eu>",
    "committer": "jschelfhout <jschelfhout@openanalytics.eu>",
    "message": "fix: add refresh button to dm vignette",
    "time": 1785934654
  },
  "_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-40",
      "n": 3
    },
    {
      "week": "2026-22",
      "n": 1
    },
    {
      "week": "2026-28",
      "n": 1
    },
    {
      "week": "2026-32",
      "n": 3
    }
  ],
  "_tags": [],
  "_stars": 31,
  "_contributors": [
    {
      "user": "jaspersch",
      "count": 42,
      "uuid": 49677239
    },
    {
      "user": "saarjunius",
      "count": 4,
      "uuid": 142490718
    }
  ],
  "_userbio": {
    "uuid": 274806,
    "type": "organization",
    "name": "OpenAnalytics",
    "followers": 118
  },
  "_downloads": {
    "count": 432,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/editbl"
  },
  "_devurl": "https://github.com/openanalytics/editbl",
  "_searchresults": 33,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/editbl.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_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"
    },
    {
      "version": "1.3.2",
      "date": "2026-07-09"
    }
  ],
  "_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": "2026-08-05 12:57:34",
      "commits": 6
    },
    {
      "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.00987563371216,
  "_indexed": true,
  "_nocasepkg": "editbl",
  "_universes": [
    "openanalytics",
    "jaspersch"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:57:40.000Z",
      "distro": "resolute",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/d675c17a5454a99c314144a95f018cfd39fa49851f8ab1f42fdb22d54683c129",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:57:44.000Z",
      "distro": "resolute",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/5fca8fd953500672a39e3ed94bd3552ec17c231695b8701cde3a140d09f5a037",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:57:15.000Z",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/b4147f374bc3f2606d05f2559958a5e294d74929fffab96d1baafa2c18accea0",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:57:16.000Z",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/7744c3f215999b1648406ae92792cdac785b35dda92d4d76bc2e56f4daa3e8bd",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:57:50.000Z",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/1368c5a720734738ce15c8d8db4e2f8f2a7037f45ad3f0cab79bad99383e284f",
      "status": "success",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:56:40.000Z",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/57e7881c459e329760059aa445a466a3e8209c50dc9dbba0e4217f36332139e8",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:56:43.000Z",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/527cb2024bcb4b283f6920d0178c53e338854988b329ac8000819dda271f958e",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.3.2-9000",
      "date": "2026-10-04T09:56:45.000Z",
      "commit": "caa88d30244381266786519e992cb6c05b32e8db",
      "fileid": "https://r2.ropensci.org/e86676aa2bf3222bcdc6eb0b52c7537bb90851adb3462a2cc6e4d1340733e4fb",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/openanalytics/actions/runs/37193523716"
    }
  ]
}