Package: dabr 0.0.4

Roberto Villegas-Diaz

dabr: Database Management with R

Provides functions to manage databases: select, update, insert, and delete records, list tables, backup tables as CSV files, and import CSV files as tables.

Authors:Roberto Villegas-Diaz [aut, cre], SPECIAL Research Group @ University of Reading [cph]

dabr_0.0.4.tar.gz
dabr_0.0.4.zip(r-4.5)dabr_0.0.4.zip(r-4.4)dabr_0.0.4.zip(r-4.3)
dabr_0.0.4.tgz(r-4.4-any)dabr_0.0.4.tgz(r-4.3-any)
dabr_0.0.4.tar.gz(r-4.5-noble)dabr_0.0.4.tar.gz(r-4.4-noble)
dabr_0.0.4.tgz(r-4.4-emscripten)dabr_0.0.4.tgz(r-4.3-emscripten)
dabr.pdf |dabr.html✨
dabr/json (API)
NEWS

# Install 'dabr' in R:

install.packages('dabr', repos = c('https://special-uor.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/special-uor/dabr/issues

On CRAN:

13 exports 3 stars 0.94 score 27 dependencies 345 downloads

Last updated 2 years agofrom:5c223451c8. Checks:OK: 7. Indexed: yes.

Target	Result	Date
Doc / Vignettes	OK	Sep 13 2024
R-4.5-win	OK	Sep 13 2024
R-4.5-linux	OK	Sep 13 2024
R-4.4-win	OK	Sep 13 2024
R-4.4-mac	OK	Sep 13 2024
R-4.3-win	OK	Sep 13 2024
R-4.3-mac	OK	Sep 13 2024

Exports:%>%attributes close_conn delete get_attr insert is.connected list_tables open_conn_mysql quote select select_all update

Dependencies:bit bit64 blob cli cpp11 DBI evaluate fansi generics glue highr hms knitr lifecycle lubridate magrittr pillar pkgconfig plogr rlang RMariaDB tibble timechange utf8 vctrs xfun yaml

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Combine attributes	attributes
Close connection to database	close_conn close_conn.default close_conn.MariaDBConnection
Execute 'DELETE' query	delete delete.MariaDBConnection
Get attributes of a table	get_attr get_attr.MariaDBConnection
Execute 'INSERT' query	insert insert.MariaDBConnection
Verify connection	is.connected is.connected.MariaDBConnection
List tables	list_tables list_tables.MariaDBConnection
Connect to database	open_conn_mysql
Add single quotes	quote
Execute 'SELECT' query	select select.MariaDBConnection
Select all the records	select_all select_all.MariaDBConnection
Execute 'UPDATE' query	update update.MariaDBConnection