Package: SQLove 1.0.2

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_1.0.2.tar.gz
SQLove_1.0.2.zip(r-4.6)SQLove_1.0.2.zip(r-4.5)SQLove_1.0.2.zip(r-4.4)
SQLove_1.0.2.tgz(r-4.6-any)SQLove_1.0.2.tgz(r-4.5-any)
SQLove_1.0.2.tar.gz(r-4.6-any)SQLove_1.0.2.tar.gz(r-4.5-any)
SQLove_1.0.2.tgz(r-4.5-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

4.00 score 2 scripts 456 downloads 2 exports 30 dependencies

Last updated from:9ad293c86b. Checks:7 NOTE, 2 OK. Indexed: yes.

TargetResultTotal timeArtifact
linux-devel-x86_64NOTE118
source / vignettesOK219
linux-release-x86_64NOTE160
macos-devel-arm64NOTE177
macos-release-arm64NOTE156
windows-develNOTE63
windows-releaseNOTE61
windows-oldrelNOTE73
wasm-releaseOK164

Exports:dbGetMultiQuerydbSendMultiUpdate

Dependencies:bitbit64blobclicliprcpp11crayonDBIgluehmslifecyclemagrittrodbcpillarpkgconfigprettyunitsprogressR6RcppreadrrJavaRJDBCrlangtibbletidyselecttzdbutf8vctrsvroomwithr

SQLove - Simple Functions for Complex Queries

Rendered fromSQLove.Rmdusingknitr::rmarkdownon Dec 18 2025.

Last update: 2025-04-18
Started: 2023-02-10

Image

  • Image