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-1Package record

Generic SQL Helper Functions for 'TSdbi' SQL Plugins

0packages depend

–downloads / year

–test coverage

–flavors OK

Overview

About

Maintained by Paul GilbertCRAN page ↗Website ↗

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)

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.

Health

CRAN checks

CRAN check results are not tracked yet.

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 2017.4-1

READMENoVignettesNoNEWSYes · 0% structuredCitation fileNoWebsiteYes

Help pages: 4 (2 internal)
Examples that run: no examples
Exported functions with examples: 0%
Documented parameters: 98%
Return-value docs: 100%
Help pages citing references: 0%

How these are measured

Downloads

Releases R versions

Daily download trend is not available in this view yet.

Compare downloads with other packages →

Also on31 r2u3 autocran

How downloads are counted

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.

How these are counted

Code & Tests

People & History

People (1)

Paul Gilbert

Contributor

Maintainer since 2013.9-1 (2013)

Releases (4)

Pick two releases to compare their code metrics.

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
record
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
record
2015-04-29 · diff ↗ ·
removed 1 export
dropTStable
R
R 3.2.0 released · 2015-04-16
R
R 3.1.0 released · 2014-04-10
2014.4-1
record
2014-04-08 · diff ↗
2013.9-1
record
2013-09-25
R
R 3.0.0 released · 2013-04-03

Package metadata

First published: 2013-09-25
Total releases: 4 / 13 yrs
License: GPL-2 OSI
Minimum R: ≥ 2.8.0

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 October 23, 2026, from https://CRAN.R-project.org/package=TSsql

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

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-10-22. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-22, 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 →