R Observatory: Metrics for TSsql version 2017.4-1

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

This package was removed from CRAN on 2022-09-04. Its history is shown below.

Reason: requires archived package 'TSdbi'

Details below reflect version 2017.4-1, its last release before removal.

TSsql

2017.4-1

Generic SQL Helper Functions for 'TSdbi' SQL Plugins

0packages depend

–downloads / year

–test coverage

–checks pass

Overview

About

Maintained by Paul Gilbert4 releasesCRAN page ↗

Standard SQL query functions used by SQL plugins packages for the 'TSdbi' interface to time series databases. It will mainly be used by other packages rather than directly by end users. The one exception is the function 'TSquery' which can be used to construct a time series from a database containing observations over time (e.g. balance statements for multiple years), but where the database is not specifically designed to store time series (as with other 'TSdbi' SQL plugin packages). Comprehensive examples of all the 'TS*' packages is provided in the vignette Guide.pdf with the 'TSdata' package.

Install

R (source archive)Ubuntu (r2u)openSUSE (OBS)

url <- "https://cran.r-project.org/src/contrib/Archive/TSsql/TSsql_2017.4-1.tar.gz"
pkgFile <- "TSsql_2017.4-1.tar.gz"
download.file(url, pkgFile)
install.packages(pkgFile, type = "source", repos = NULL)

This package is no longer on CRAN, so install.packages() cannot fetch it by name. This downloads the last archived source (2017.4-1) and builds it locally. Install its dependencies first, and note that building from source needs the usual compiler toolchain.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-tssql

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-TSsql

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

CRAN check results are not tracked yet.

Code health

Yes

Tests · ratio 0.04

not tracked

Coverage

100%

Documentation · exports

7

Dependencies · direct

Documentation

READMENoVignettesNopkgdown siteNoNEWSYes · 0% structuredCode of conductNoContributing guideNo

Examples that run: not tracked
Documented parameters: 98%
Return-value docs: 100%
References docs: 0%

Downloads

Releases R versions

Daily download trend is not available in this view yet.

Compare downloads with other packages →

Also on58 r2u9 autocran

Dependencies

Declared dependencies

10 external dependencies (excludes base and recommended)

Depends (1)

R >= 2.8.0

Imports (7)

methodsDBI tframe TSdbi tframePlus zoostats

LinkingTo (0)

none

Suggests (5)

tseries tis tfplot RMySQL RSQLite

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

–indirect (not tracked)

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Other (1)

Paul Gilbert

Contributor

Package Timeline

4 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.3.0 released · 2023-04-21
archivedRemoved from CRAN
2022-09-04
requires archived package 'TSdbi'
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
R
R 4.0.0 released · 2020-04-24
R
R 3.6.0 released · 2019-04-26
R
R 3.5.0 released · 2018-04-23
2017.4-1
2017-05-10 · diff ↗
R
R 3.4.0 released · 2017-04-21
R
R 3.3.0 released · 2016-05-03
2015.1-2
2015-04-29 · diff ↗
R
R 3.2.0 released · 2015-04-16
R
R 3.1.0 released · 2014-04-10
2014.4-1
2014-04-08 · diff ↗
2013.9-1
2013-09-25
R
R 3.0.0 released · 2013-04-03

Package metadata

Total releases: 4
License: GPL-2 OSI
Minimum R: ≥ 2.8.0
Download size: not tracked yet
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("TSsql")

Format

Gilbert, P. (n.d.). TSsql: Generic SQL Helper Functions for 'TSdbi' SQL Plugins (Version 2017.4-1) [Computer software]. Retrieved August 13, 2026, from https://CRAN.R-project.org/package=TSsql

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for TSsql version 2017.4-1 [Data set]. HJJB, LLC. Data release v2026-08-11. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-11, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →