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.5-any)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'))

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

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

On CRAN:

Conda:

openjdk

3.70 score 2 scripts 195 downloads 2 exports 28 dependencies

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

TargetResultLatest binary
Doc / VignettesOKMar 13 2025
R-4.5-winOKMar 13 2025
R-4.5-macOKMar 13 2025
R-4.5-linuxOKMar 13 2025
R-4.4-winOKMar 13 2025
R-4.4-macOKMar 13 2025
R-4.4-linuxOKMar 13 2025
R-4.3-winOKMar 13 2025
R-4.3-macOKMar 13 2025

Exports:dbGetMultiQuerydbSendMultiUpdate

Dependencies:bitbit64clicliprcpp11crayonDBIfansigluehmslifecyclemagrittrpillarpkgconfigprettyunitsprogressR6readrrJavaRJDBCrlangtibbletidyselecttzdbutf8vctrsvroomwithr

SQLove - Simple Functions for Complex Queries

Rendered fromSQLove.Rmdusingknitr::rmarkdownon Mar 13 2025.

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