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:

4.00 score 2 scripts 184 downloads 2 exports 28 dependencies

Last updated 1 years agofrom:78c0c3e84c. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 07 2024
R-4.5-winOKNov 07 2024
R-4.5-linuxOKNov 07 2024
R-4.4-winOKNov 07 2024
R-4.4-macOKNov 07 2024
R-4.3-winOKNov 07 2024
R-4.3-macOKNov 07 2024

Exports:dbGetMultiQuerydbSendMultiUpdate

Dependencies:bitbit64clicliprcpp11crayonDBIfansigluehmslifecyclemagrittrpillarpkgconfigprettyunitsprogressR6readrrJavaRJDBCrlangtibbletidyselecttzdbutf8vctrsvroomwithr

SQLove - Simple Functions for Complex Queries

Rendered fromSQLove.Rmdusingknitr::rmarkdownon Nov 07 2024.

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