Introduction | The Problem | dbGetMultiQuery | dbSendMultiUpdate
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:
SQLove_1.0.2.tar.gz
SQLove_1.0.2.zip(r-4.7)SQLove_1.0.2.zip(r-4.6)SQLove_1.0.2.zip(r-4.5)
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.7-any)SQLove_1.0.2.tar.gz(r-4.6-any)
SQLove_1.0.2.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
SQLove/json (API)
| # 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
Last updated from:9ad293c86b. Checks:7 NOTE, 2 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | NOTE | 121 | ||
| source / vignettes | OK | 172 | ||
| linux-release-x86_64 | NOTE | 131 | ||
| macos-release-arm64 | NOTE | 111 | ||
| macos-oldrel-arm64 | NOTE | 167 | ||
| windows-devel | NOTE | 78 | ||
| windows-release | NOTE | 73 | ||
| windows-oldrel | NOTE | 71 | ||
| wasm-release | OK | 116 |
Exports:dbGetMultiQuerydbSendMultiUpdate
Dependencies:bitbit64blobclicliprcpp11crayonDBIgluehmslifecyclemagrittrodbcpillarpkgconfigprettyunitsprogressR6RcppreadrrJavaRJDBCrlangtibbletidyselecttzdbutf8vctrsvroomwithr
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Query a database with multiple query actions and one, final, select statement. | dbGetMultiQuery |
| Run multiple SQL query actions within the DB environment. | dbSendMultiUpdate |
