R Observatory: Metrics for octopus version 0.4.2

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

octopus

0.4.2Package record

A Database Management Tool

0packages depend

3.5Kdownloads / year

8.2%test coverage

0/13flavors OK

Overview

About

Maintained by Marcus CodrescuCRAN page ↗GitHub ↗Website ↗Issues ↗

A database management tool built as a 'shiny' application. Connect to various databases to send queries, upload files, preview tables, and more.

Changes in 0.4.2

Minor bug fixes

From NEWS.md in the release

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("octopus", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("MCodrescu/octopus")

Development version from MCodrescu/octopus. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-octopus

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-octopus

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-octopus

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13NOTE

Check messages

NOTEDESCRIPTION meta-informationr-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-devel-windows-x86_64, r-oldrel-macos-arm64, r-oldrel-macos-x86_64, r-oldrel-windows-x86_64, r-patched-linux-x86_64, r-release-linux-x86_64, r-release-macos-arm64, r-release-macos-x86_64, r-release-windows-x86_64

r-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-oldrel-macos-arm64, r-oldrel-macos-x86_64, r-patched-linux-x86_64, r-release-linux-x86_64, r-release-macos-arm64, r-release-macos-x86_64

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘duckdb_connection.R’ ‘get_database_functions.R’ ‘mysql_connection.R’
    ‘postgres_connection.R’ ‘snowflake_connection.R’
    ‘sqlite_connection.R’ ‘submit_query.R’ ‘vertica_connection.R’

r-devel-windows-x86_64, r-oldrel-windows-x86_64, r-release-windows-x86_64

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    'duckdb_connection.R' 'get_database_functions.R' 'mysql_connection.R'
    'postgres_connection.R' 'snowflake_connection.R'
    'sqlite_connection.R' 'submit_query.R' 'vertica_connection.R'

CRAN check page ↗

Slowest check: 1.9 min · r-oldrel-macos-x86_64

Status changes

NOTE13 NOTE2026-06-09
ERROR12 NOTE, 1 ERROR2026-06-08
NOTE3 OK, 11 NOTE2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.4.2

READMEYes · 139 wordsVignettesYes · 1 · dynamicNEWSYes · 100% structured · mentions 0.4.2Citation fileNoWebsiteYes · pkgdown

Help pages: 2
Examples that run: no examples
Exported functions with examples: 0%
Documented parameters: 100%
Return-value docs: 100%
Help pages citing references: 0%

Vignettes (1)

octopus HTML

How these are measured

Downloads

3.5K

CRAN downloads in the past year

Rank #14,961 · ~10/day · ~290/mo

Releases R versions

Daily download trend is not available in this view yet.

31430 days

80890 days

3.5K1 year

Compare downloads with other packages →

Also on84 r2u3 autocran42 c2d4u

How downloads are counted

Repository

mcodrescu/octopus ↗Account: MCodrescu

12Stars

5Forks

0Open issues

0Open PRs

2Releases

147Commits

2Commit identities

data-sciencedatabaserrshiny

147 commits · Last activity 2024-04-02 · 0% stars, 30d

Responsiveness

How these are sampled

PRs merged (all time): 50%
Median days to close, 50 most recently updated closed issues: 0
Median days to close, 50 most recently updated closed PRs: 2

Stars over time

2025-10-19 · 122026-07-07 · 12

How these are measured

PracticesBeta

10 development-tooling and community-health practices detected across 5 families in the upstream repository

Checks run against github.com/mcodrescu/octopus on 2026-10-22.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Docs source (4)

README.Rmdpkgdown

GitHub Pages site last deployed 2024-04-02 · The repository has a site deploy workflow

pkgdown site last built 2024-04-02

Reproducibility and dev environment (1)

renv

CRAN release process (2)

cran-comments.mdCRAN-SUBMISSION

Show all practicesHide 1 practice

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v4 (2026-10-20)

Dependencies

Declared dependencies

21 external dependencies (excludes base and recommended)

Installing octopus adds 87 packages (45 with compiled code, 66 MB of source tarballs). Heaviest: stringi 11 MB, data.table 5.7 MB, bslib 5.6 MB.

Depends (0)

none

Imports (13)

bslib data.table DBI dplyr DT glue httr janitor rio shiny shinyAce shinyjsutils

LinkingTo (0)

none

Suggests (9)

keyring knitr odbc readr rmarkdown RMySQL RPostgres RSQLite testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

How these are counted

Code & Tests

People & History

People (1)

Marcus Codrescu

Author, Maintainer since 0.1.2 (2023)

Releases (6)

Pick two releases to compare their code metrics.

R
R 4.6.0 released · 2026-04-24
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
0.4.2Latest
record
2024-01-10 · current release · diff ↗
0.4.1
record
2023-11-07 · diff ↗
0.4.0
record
2023-10-28 · diff ↗
0.3.0
record
2023-06-16 · diff ↗
R
R 4.3.0 released · 2023-04-21
0.2.0
record
2023-04-12 · diff ↗
0.1.2
record
2023-03-22
R
R 4.2.0 released · 2022-04-22

Package metadata

First published: 2023-03-22
Total releases: 6 / 3 yrs
License: MIT + file LICENSE OSI
Download size: 175 KB

Appears in task views

Databases with R

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("octopus")

Format

Codrescu, M. (2024). octopus: A Database Management Tool (Version 0.4.2) [Computer software]. https://doi.org/10.32614/CRAN.package.octopus

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for octopus version 0.4.2 [Data set]. HJJB, LLC. Data release v2026-10-23. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-23, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →