Package: sqlhelper 0.2.1
sqlhelper: Easier 'SQL' Integration
Execute files of 'SQL' and manage database connections. 'SQL' statements and queries may be interpolated with string literals. Execution of individual statements and queries may be controlled with keywords. Multiple connections may be defined with 'YAML' and accessed by name.
Authors:
sqlhelper_0.2.1.tar.gz
sqlhelper_0.2.1.zip(r-4.5)sqlhelper_0.2.1.zip(r-4.4)sqlhelper_0.2.1.zip(r-4.3)
sqlhelper_0.2.1.tgz(r-4.5-any)sqlhelper_0.2.1.tgz(r-4.4-any)sqlhelper_0.2.1.tgz(r-4.3-any)
sqlhelper_0.2.1.tar.gz(r-4.5-noble)sqlhelper_0.2.1.tar.gz(r-4.4-noble)
sqlhelper_0.2.1.tgz(r-4.4-emscripten)sqlhelper_0.2.1.tgz(r-4.3-emscripten)
sqlhelper.pdf |sqlhelper.html✨
sqlhelper/json (API)
NEWS
| # Install 'sqlhelper' in R: |
| install.packages('sqlhelper', repos = c('https://majerr.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/majerr/sqlhelper/issues
Pkgdown site:https://majerr.github.io
Last updated 1 years agofrom:1b49d2f454. Checks:9 OK. Indexed: yes.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Mar 24 2025 |
| R-4.5-win | OK | Mar 24 2025 |
| R-4.5-mac | OK | Mar 24 2025 |
| R-4.5-linux | OK | Mar 24 2025 |
| R-4.4-win | OK | Mar 24 2025 |
| R-4.4-mac | OK | Mar 24 2025 |
| R-4.4-linux | OK | Mar 24 2025 |
| R-4.3-win | OK | Mar 24 2025 |
| R-4.3-mac | OK | Mar 24 2025 |
Exports:config_examplesconnectconnection_infodefault_conndisconnectget_default_conn_nameis_connectedlive_connectionnot_connectedprepare_sqlread_sqlrun_filesrun_queriesrunfilesrunqueriesset_default_conn_name
Dependencies:classclassIntclicpp11DBIdplyre1071fansigenericsglueKernSmoothlaterlifecyclemagrittrMASSpillarpkgconfigpoolproxypurrrR6rappdirsRcpprlangs2sfstringistringrtibbletidyrtidyselectunitsutf8vctrswithrwkyaml
Executing SQL
Rendered fromexecution.Rmdusingknitr::rmarkdownon Mar 24 2025.Last update: 2024-01-18
Started: 2024-01-18
Managing Connections
Rendered fromconnections.Rmdusingknitr::rmarkdownon Mar 24 2025.Last update: 2024-01-18
Started: 2023-01-12
sqlhelper
Rendered fromsqlhelper.Rmdusingknitr::rmarkdownon Mar 24 2025.Last update: 2024-01-18
Started: 2023-01-12
Using sqlhelper in packages
Rendered fromuse_case.Rmdusingknitr::rmarkdownon Mar 24 2025.Last update: 2024-01-18
Started: 2024-01-18
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Examples of yaml configurations for database connections | config_examples |
| (Re-)Establish connections to databases | connect |
| Browse available connections | connection_info |
| Return the default connection | default_conn |
| Close all connections and remove them from the connections cache | disconnect |
| Test whether a database is connected | is_connected not_connected |
| Return the named connection or NULL | live_connection |
| prepare queries and assemble meta data prior to execution | prepare_sql |
| Read a sql file and return it's contents as a tibble | read_sql |
| Read, prepare and execute .SQL files | runfiles run_files |
| Execute a sequence of SQL queries | runqueries run_queries |
| Set/get the name of the default connection to use | get_default_conn_name set_default_conn_name |
