{"Package":"octopus","Type":"Package","Title":"A Database Management Tool","Version":"0.4.2","Authors@R":"person(\"Marcus\", \"Codrescu\", , \"m.codrescu@outlook.com\", role = c(\"aut\", \"cre\"))","Maintainer":"Marcus Codrescu ","Description":"A database management tool built as a 'shiny' application. Connect to various\ndatabases to send queries, upload files, preview tables, and more.","URL":"https://github.com/MCodrescu/octopus,\nhttps://mcodrescu.github.io/octopus/","BugReports":"https://github.com/MCodrescu/octopus/issues","License":"MIT + file LICENSE","Encoding":"UTF-8","Suggests":"keyring, knitr, odbc, readr, rmarkdown, RMySQL, RPostgres,\nRSQLite, testthat (>= 3.0.0)","Config/testthat/edition":"3","Imports":"bslib, data.table, DBI, dplyr, DT, glue, httr, janitor, rio,\nshiny, shinyAce, shinyjs, utils","RoxygenNote":"7.2.1","VignetteBuilder":"knitr","NeedsCompilation":"no","Packaged":"2024-01-09 23:47:09 UTC; mc678p","Author":"Marcus Codrescu [aut, cre]","Repository":"CRAN","Date/Publication":"2024-01-10 00:03:07 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/octopus_0.4.2.tar.gz","jsonAuthors":[{"name":"Marcus Codrescu","email":"m.codrescu@outlook.com","maintainer":true}],"readme":"\n\n\n# octopus

\n\n\n\n[![R-CMD-check](https://github.com/MCodrescu/octopus/actions/workflows/R-CMD-check.yaml/badge.svg)](https://github.com/MCodrescu/octopus/actions/workflows/R-CMD-check.yaml)\n[![CRAN\nstatus](https://www.r-pkg.org/badges/version/octopus)](https://CRAN.R-project.org/package=octopus)\n\n\n\n\nThe *octopus* package is a database management tool built entirely in R.\nYou can preview tables, upload files, send queries, and more.\n\nAll database credentials are handled by the R user. Simply pass a\nsupported database connection object created with `DBI::dbConnect()` to\nthe function `octopus::view_database()` and *octopus* will start a shiny\napplication allowing you to interact with the database.\n\n*Try it out here!\n[shinyapps.io](https://zszxyy-marcus-codrescu.shinyapps.io/octopusconceptapp/)*\n\n![](https://raw.githubusercontent.com/MCodrescu/octopus/da65cdba6ce2362c7b8c21cd2cf309a3cfcbb17b/images/octopusMainPage3.png)\n\n## Supported Databases\n\nThe *octopus* package currently supports the following databases:\n\n``` r\noctopus::list_drivers()\n#> [1] \"PqConnection\" \"Snowflake\" \"Vertica Database\" \n#> [4] \"duckdb_connection\" \"MySQLConnection\" \"SQLiteConnection\" \n#> [7] \"Microsoft SQL Server\"\n```\n\n## Installation\n\nInstall the stable version from CRAN.\n\n``` r\ninstall.packages(\"octopus\")\n```\n\nInstall the development version from github.\n\n``` r\ndevtools::install_github(\"MCodrescu/octopus\")\n```\n\n## Example\n\nHere is an example of connecting to a database and running the main\nfunction of octopus.\n\n``` r\n# Create a Database Connection\ndrv <- duckdb::duckdb()\ncon <- DBI::dbConnect(drv)\n\n# Write some data\nDBI::dbWriteTable(con, \"mtcars\", mtcars)\n\n# View the Database\noctopus::view_database(con)\n```","jobInfo":{"package":"octopus","version":"0.4.2","parsingStatus":"success","parserVersion":2,"parsedAt":"2024-01-10T01:30:15+0000"}}

Description

Usage

Arguments

Value