CRAN/E | TSsql

TSsql

Generic SQL Helper Functions for 'TSdbi' SQL Plugins

Installation

About

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.

tsdbi.r-forge.r-project.org/
Copyright 2007-2011 Bank of Canada. 2012-2017 Paul Gilbert.

Key Metrics

Version 2017.4-1
R ≥ 2.8.0
Published 2017-05-10 2543 days ago
Needs compilation? no
License GPL-2
CRAN checks TSsql results

Downloads

Yesterday 4 0%
Last 7 days 5 -44%
Last 30 days 39 -20%
Last 90 days 128 -26%
Last 365 days 563 -71%

Maintainer

Maintainer

Paul Gilbert

pgilbert.ttv9z@ncf.ca

Authors

Paul Gilbert

Material

NEWS
Reference manual
Package source

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

r-oldrel

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

TSsql archive

Depends

R ≥ 2.8.0

Imports

methods
DBI
tframe ≥ 2015.1-1
TSdbi ≥ 2015.1-1
tframePlus
zoo
stats

Suggests

tseries
tis
tfplot
RMySQL
RSQLite

Reverse Imports

TSMySQL
TSodbc
TSPostgreSQL
TSSQLite

Reverse Suggests

TSdata