| Title: | A Database Management Tool |
|---|---|
| Description: | A database management tool built as a 'shiny' application. Connect to various databases to send queries, upload files, preview tables, and more. |
| Authors: | Marcus Codrescu [aut, cre] |
| Maintainer: | Marcus Codrescu <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.4.2 |
| Built: | 2025-02-26 05:47:36 UTC |
| Source: | https://github.com/mcodrescu/octopus |
List Compatible Database Drivers
list_drivers()list_drivers()
A character vector of compatible database drivers.
Upload a csv file to a in-memory duckdb database and write queries against it.
view_csv(csv_file_path, table_name = "csv_file")view_csv(csv_file_path, table_name = "csv_file")
csv_file_path |
A string. The csv file path. |
table_name |
A string. The name of the table in the duckdb database. |
A shiny app instance.
This function opens a shiny instance where the database can be viewed.
view_database(con, options = list(), max_file_upload_size = 2000 * 1024^2)view_database(con, options = list(), max_file_upload_size = 2000 * 1024^2)
con |
A database connection object. The result of DBI::dbConnect(). |
options |
A named list of options to be passed along to shinyApp(). |
max_file_upload_size |
An integer. The max number of bits allowed in file uploads. |
An R Shiny instance.