Package: SQLove 0.0.4

SQLove: Execute 'SQL' Scripts in 'R' Containing Multiple Queries

The nature of working with structured query language ('SQL') scripts efficiently often requires the creation of temporary tables and there are few clean and simple 'R' 'SQL' execution approaches that allow you to complete this kind of work with the 'R' environment. This package seeks to give 'SQL' implementations in 'R' a little love by deploying functions that allow you to deploy complex 'SQL' scripts within a typical 'R' workflow.

Authors:Kerns Sam [aut, cre]

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

# Install 'SQLove' in R:
install.packages('SQLove', repos = c('https://samkerns.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/samkerns/sqlove/issues

Uses libs:
  • openjdk– OpenJDK Java runtime, using Hotspot JIT

On CRAN:

2 exports 0.83 score 28 dependencies 2 scripts 173 downloads

Last updated 10 months agofrom:78c0c3e84c. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKSep 08 2024
R-4.5-winOKSep 08 2024
R-4.5-linuxOKSep 08 2024
R-4.4-winOKSep 08 2024
R-4.4-macOKSep 08 2024
R-4.3-winOKSep 08 2024
R-4.3-macOKSep 08 2024

Exports:dbGetMultiQuerydbSendMultiUpdate

Dependencies:bitbit64clicliprcpp11crayonDBIfansigluehmslifecyclemagrittrpillarpkgconfigprettyunitsprogressR6readrrJavaRJDBCrlangtibbletidyselecttzdbutf8vctrsvroomwithr

SQLove - Simple Functions for Complex Queries

Rendered fromSQLove.Rmdusingknitr::rmarkdownon Sep 08 2024.

Last update: 2023-02-10
Started: 2023-02-10