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.

Documentation

Manual: TSsql.pdf
Vignette: None available.

Maintainer: Paul Gilbert <pgilbert.ttv9z at ncf.ca>

Author(s): Paul Gilbert <pgilbert.ttv9z at ncf.ca>

Install package and any missing dependencies by running this line in your R console:

install.packages("TSsql")

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
Enhances
Linking to
Reverse
depends
Reverse
imports
TSMySQL, TSodbc, TSPostgreSQL, TSSQLite
Reverse
suggests
TScompare, TSdata
Reverse
enhances
Reverse
linking to

Package TSsql
Materials
URL http://tsdbi.r-forge.r-project.org/
Task Views
Version 2017.4-1
Published 2017-05-10
License GPL-2
BugReports
SystemRequirements
NeedsCompilation no
Citation
CRAN checks TSsql check results
Package source TSsql_2017.4-1.tar.gz