Learn R Programming

SQRL (version 1.0.2)

Enhances Interaction with 'ODBC' Databases

Description

Provides simple and powerful interfaces that facilitate interaction with 'ODBC' data sources. Each data source gets its own unique and dedicated interface, wrapped around 'RODBC'. Communication settings are remembered between queries, and are managed silently in the background. The interfaces support multi-statement 'SQL' scripts, which can be parameterised via metaprogramming structures and embedded 'R' expressions.

Copy Link

Version

Install

install.packages('SQRL')

Monthly Downloads

225

Version

1.0.2

License

GPL-3

Maintainer

Mike Lee

Last Published

December 3rd, 2023

Functions in SQRL (1.0.2)

sqrlUsage

How to Use the Interface Functions
sqrlSources

List Data Sources and their Interfaces
sqrlConfig

Configuration Files
sqrlOff

Close Connections and Deactivate the Package
sqrlScript

Hybrid Script Syntax
SQRL-package

Simple and Powerful ODBC Interfaces
sqrlAll

Broadcast a Command to All Data Sources
sqrlParams

Control and Communication Parameters
sqrlSource

Define New Data Sources
sqrlInterface

Creates Data Source Interfaces