{
  "_id": "6af74e4d535793c85332c91b",
  "Package": "TSdbi",
  "Version": "2017.4.1.9001",
  "Title": "Time Series Database Interface",
  "Description": "Provides a common interface to time series databases. The\nobjective is to define a standard interface so users can\nretrieve time series data from various sources with a simple,\ncommon, set of commands, and so programs can be written to be\nportable with respect to the data source. The SQL\nimplementations also provide a database table design, so users\nneeding to set up a time series database have a reasonably\ncomplete way to do this easily. The interface provides for a\nvariety of options with respect to the representation of time\nseries in R. The interface, and the SQL implementations, also\nhandle vintages of time series data (sometime called editions\nor real-time data). There is also a (not yet well tested)\nmechanism to handle multilingual data documentation.\nComprehensive examples of all the 'TS*' packages is provided in\nthe vignette Guide.pdf with the 'TSdata' package. Compatibility\nupdates by Renova.",
  "BuildVignettes": "true",
  "License": "GPL-2",
  "Copyright": "2007-2011 Bank of Canada.  2012-2017 Paul Gilbert.",
  "Author": "Paul Gilbert [aut, cre]",
  "Maintainer": "Paul Gilbert <pgilbert.ttv9z@ncf.ca>",
  "Authors@R": "person(given = \"Paul\", family = \"Gilbert\", role = c(\"aut\", \"cre\"), email = \"pgilbert.ttv9z@ncf.ca\")",
  "URL": "http://tsdbi.r-forge.r-project.org/",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-11-13 17:48:39 UTC",
    "User": "root"
  },
  "Repository": "https://renova-r.r-universe.dev",
  "Date/Publication": "2026-11-13 15:50:44 UTC",
  "RemoteUrl": "https://github.com/renova-r/TSdbi",
  "RemoteRef": "renova-2017.4.1.9001",
  "RemoteSha": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
  "_user": "renova-r",
  "_type": "src",
  "_file": "TSdbi_2017.4.1.9001.tar.gz",
  "_fileid": "https://r2.ropensci.org/2cb1924efa9ef3f8a48c98de8a3763bd4abe26174cb1dd5924bec5aa5ca9d3eb",
  "_filesize": 212062,
  "_sha256": "2cb1924efa9ef3f8a48c98de8a3763bd4abe26174cb1dd5924bec5aa5ca9d3eb",
  "_expires": "2027-02-21T17:52:11.000Z",
  "_created": "2026-11-13T17:48:39.000Z",
  "_published": "2026-11-13T17:52:13.248Z",
  "_upstream": "https://github.com/renova-r/TSdbi",
  "_status": "success",
  "_maintainer": {
    "name": "Paul Gilbert",
    "email": "pgilbert.ttv9z@ncf.ca"
  },
  "_jobs": [
    {
      "job": 132061689626,
      "time": 97,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14063147588"
    },
    {
      "job": 132061689733,
      "time": 111,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14062149551"
    },
    {
      "job": 132061689527,
      "time": 84,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14063142488"
    },
    {
      "job": 132061689872,
      "time": 78,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14062542348"
    },
    {
      "job": 132059224156,
      "time": 255,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14062468125"
    },
    {
      "job": 132061689393,
      "time": 88,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "14064025644"
    },
    {
      "job": 132061689536,
      "time": 171,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14063761091"
    },
    {
      "job": 132061689485,
      "time": 170,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14062732429"
    },
    {
      "job": 132061689621,
      "time": 137,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14062568484"
    }
  ],
  "_buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507",
  "_commit": {
    "id": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
    "author": "Renova <37424630+guanyangwang@users.noreply.github.com>",
    "committer": "Renova <37424630+guanyangwang@users.noreply.github.com>",
    "message": "Prepare Renova TSdbi 2017.4.1.9001 release\n",
    "time": 1794585044
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 2.8.0",
      "role": "Depends"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 0.3.1",
      "role": "Imports"
    },
    {
      "package": "tframe",
      "version": ">= 2015.1-1",
      "role": "Imports"
    },
    {
      "package": "zoo",
      "role": "Suggests"
    },
    {
      "package": "tseries",
      "role": "Suggests"
    },
    {
      "package": "tis",
      "role": "Suggests"
    },
    {
      "package": "tfplot",
      "role": "Suggests"
    },
    {
      "package": "tframePlus",
      "role": "Suggests"
    }
  ],
  "_owner": "renova-r",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-46",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "renova-2017.4.1.9001",
      "date": "2026-11-13"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "guanyangwang",
      "count": 2,
      "uuid": 37424630
    }
  ],
  "_userbio": {
    "uuid": 356078339,
    "type": "organization",
    "name": "Renova",
    "followers": 0,
    "description": "Reviving R software with AI."
  },
  "_downloads": {
    "count": 312,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/TSdbi"
  },
  "_devurl": "https://github.com/renova-r/tsdbi",
  "_searchresults": 0,
  "_abi": {
    "exports": [
      {
        "key": "TSdbi::OptionalChar",
        "hash": "473b98cfa31be6d5"
      },
      {
        "key": "TSdbi::OptionalPOSIXct",
        "hash": "b48965ceead2b6d0"
      },
      {
        "key": "TSdbi::TSdb",
        "hash": "1b7f0591b2197101"
      },
      {
        "key": "TSdbi::TSid",
        "hash": "d1f2305237737bd7"
      },
      {
        "key": "TSdbi::TSmeta",
        "hash": "857f5de9b3f1a426"
      },
      {
        "key": "TSdbi::conType",
        "hash": "d94b4e0103675ebd"
      },
      {
        "key": "TSdbi::generic:TSconnect",
        "hash": "22124ef4dc31c972"
      },
      {
        "key": "TSdbi::generic:TSdates",
        "hash": "00bd830124cf23fd"
      },
      {
        "key": "TSdbi::generic:TSdelete",
        "hash": "ad8b859b0f777b04"
      },
      {
        "key": "TSdbi::generic:TSdescription",
        "hash": "e174aec4c3ec8aa5"
      },
      {
        "key": "TSdbi::generic:TSdescription<-",
        "hash": "ed88551d43de5a07"
      },
      {
        "key": "TSdbi::generic:TSdoc",
        "hash": "348074768f7ce0dc"
      },
      {
        "key": "TSdbi::generic:TSdoc<-",
        "hash": "840d2d6f78166088"
      },
      {
        "key": "TSdbi::generic:TSexists",
        "hash": "8f1fe75cfe4f2ff2"
      },
      {
        "key": "TSdbi::generic:TSget",
        "hash": "cbea70cd5b2e8fdc"
      },
      {
        "key": "TSdbi::generic:TSlabel",
        "hash": "6cb1a1b7443f4f6f"
      },
      {
        "key": "TSdbi::generic:TSlabel<-",
        "hash": "3cd69f10e5d21b51"
      },
      {
        "key": "TSdbi::generic:TSmeta",
        "hash": "74301628ccf0ab8e"
      },
      {
        "key": "TSdbi::generic:TSmeta<-",
        "hash": "3f86c88b7a93fe56"
      },
      {
        "key": "TSdbi::generic:TSput",
        "hash": "7bb12c4d5627486e"
      },
      {
        "key": "TSdbi::generic:TSrefperiod",
        "hash": "c186a5ce6759ab2b"
      },
      {
        "key": "TSdbi::generic:TSrefperiod<-",
        "hash": "72c7f0efe4f0c941"
      },
      {
        "key": "TSdbi::generic:TSreplace",
        "hash": "f336ebd374d6ece8"
      },
      {
        "key": "TSdbi::generic:TSsource",
        "hash": "bf8cfc5982b942c2"
      },
      {
        "key": "TSdbi::generic:TSsource<-",
        "hash": "5018df0bf39fc176"
      },
      {
        "key": "TSdbi::generic:TSvintages",
        "hash": "e6438558d48adcef"
      },
      {
        "key": "TSdbi::logicalId",
        "hash": "d4b4adc2bf661f68"
      }
    ],
    "imports": []
  },
  "_rbuild": "4.6.2",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/TSdbi.html"
  ],
  "_cranurl": false,
  "_releases": [
    {
      "version": "2007.10-1",
      "date": "2007-11-03"
    },
    {
      "version": "2008.5-1",
      "date": "2008-05-08"
    },
    {
      "version": "2008.8-1",
      "date": "2008-08-06"
    },
    {
      "version": "2008.11-1",
      "date": "2008-11-03"
    },
    {
      "version": "2009.1-1",
      "date": "2009-01-15"
    },
    {
      "version": "2009.5-2",
      "date": "2009-06-10"
    },
    {
      "version": "2009.11-1",
      "date": "2009-12-16"
    },
    {
      "version": "2010.3-1",
      "date": "2010-04-08"
    },
    {
      "version": "2010.5-1",
      "date": "2010-05-27"
    },
    {
      "version": "2010.12-1",
      "date": "2010-12-22"
    },
    {
      "version": "2011.3-1",
      "date": "2011-03-23"
    },
    {
      "version": "2011.7-1",
      "date": "2011-07-25"
    },
    {
      "version": "2011.8-1",
      "date": "2011-08-14"
    },
    {
      "version": "2011.11-1",
      "date": "2011-11-02"
    },
    {
      "version": "2011.11-2",
      "date": "2011-11-28"
    },
    {
      "version": "2012.3-1",
      "date": "2012-03-29"
    },
    {
      "version": "2012.4-1",
      "date": "2012-05-03"
    },
    {
      "version": "2012.8-1",
      "date": "2012-10-01"
    },
    {
      "version": "2013.3-1",
      "date": "2013-03-28"
    },
    {
      "version": "2013.9-1",
      "date": "2013-09-29"
    },
    {
      "version": "2015.1-1",
      "date": "2015-04-29"
    },
    {
      "version": "2015.7-1",
      "date": "2015-12-16"
    },
    {
      "version": "2017.4-1",
      "date": "2017-05-10"
    }
  ],
  "_exports": [
    "dbDisconnect",
    "show",
    "TScon",
    "TSconnect",
    "TSdates",
    "TSdelete",
    "TSdescription",
    "TSdescription<-",
    "TSdoc",
    "TSdoc<-",
    "TSexists",
    "TSextractionDate",
    "TSfinddb",
    "TSget",
    "TSlabel",
    "TSlabel<-",
    "TSmeta",
    "TSmeta<-",
    "TSput",
    "TSrefperiod",
    "TSrefperiod<-",
    "TSreplace",
    "TSseriesIDs",
    "TSsource",
    "TSsource<-",
    "TSvintages"
  ],
  "_help": [
    {
      "page": "TSdbi-package",
      "title": "Time Series Data Base Interface",
      "topics": [
        "TSdbi-package",
        "TSdbi.Intro"
      ]
    },
    {
      "page": "TSconnect",
      "title": "Connect to a Time Series Database",
      "topics": [
        "conType-class",
        "print,TSdb-method",
        "show,logicalId-method",
        "show,TSdb-method",
        "show,TSmeta-method",
        "TSconnect",
        "TSconnect,character,character-method",
        "TSdb-class",
        "TSid-class"
      ]
    },
    {
      "page": "TSdates",
      "title": "Check Data Availability",
      "topics": [
        "end.TSdates",
        "start.TSdates",
        "tfend.TSdates",
        "tfstart.TSdates",
        "TSdates",
        "TSdates,character,ANY-method",
        "TSdates,character,missing-method"
      ]
    },
    {
      "page": "TSdescription",
      "title": "Specific Methods for Documenting Data",
      "topics": [
        "TSdescription",
        "TSdescription,ANY,missing-method",
        "TSdescription,character,ANY-method",
        "TSdescription,character,missing-method",
        "TSdescription,missing,ANY-method",
        "TSdescription,missing,missing-method",
        "TSdescription<-",
        "TSdoc",
        "TSdoc,ANY,missing-method",
        "TSdoc,character,ANY-method",
        "TSdoc,character,missing-method",
        "TSdoc,missing,ANY-method",
        "TSdoc,missing,missing-method",
        "TSdoc<-",
        "TSlabel",
        "TSlabel,ANY,missing-method",
        "TSlabel,character,ANY-method",
        "TSlabel,character,missing-method",
        "TSlabel,missing,ANY-method",
        "TSlabel,missing,missing-method",
        "TSlabel<-",
        "TSmeta",
        "TSmeta,ANY,missing-method",
        "TSmeta,character,ANY-method",
        "TSmeta,character,missing-method",
        "TSmeta-class",
        "TSmeta<-",
        "TSrefperiod",
        "TSrefperiod,default-method",
        "TSrefperiod<-",
        "TSsource",
        "TSsource,ANY,missing-method",
        "TSsource,character,ANY-method",
        "TSsource,character,missing-method",
        "TSsource,missing,ANY-method",
        "TSsource,missing,missing-method",
        "TSsource<-"
      ]
    },
    {
      "page": "TSexists",
      "title": "Check if Series Exist on a Database",
      "topics": [
        "TSexists",
        "TSexists,default-method"
      ]
    },
    {
      "page": "TSfinddb",
      "title": "Find a Time Series Database Connection",
      "topics": [
        "TSfinddb"
      ]
    },
    {
      "page": "TSget",
      "title": "Get Time Series Data Using a Database Connection",
      "topics": [
        "TSget",
        "TSget,character,ANY-method",
        "TSget,character,missing-method"
      ]
    },
    {
      "page": "TSput",
      "title": "Write Data to a Data Connection",
      "topics": [
        "logicalId-class",
        "TSdelete",
        "TSdelete,character,ANY,ANY,ANY-method",
        "TSdelete,character,ANY-method",
        "TSdelete,character,missing,ANY,ANY-method",
        "TSdelete,character,missing-method",
        "TSput",
        "TSput,ANY,character,ANY-method",
        "TSput,ANY,character,missing-method",
        "TSput,ANY,DBIConnection,missing-method",
        "TSput,ANY,missing,missing-method",
        "TSreplace",
        "TSreplace,default-method"
      ]
    },
    {
      "page": "TSsourceInfo",
      "title": "Get source information from a data object",
      "topics": [
        "TScon",
        "TSextractionDate",
        "TSseriesIDs"
      ]
    },
    {
      "page": "TSvintages",
      "title": "Indicate all Vintages at a Connection",
      "topics": [
        "TSvintages",
        "TSvintages,ANY-method",
        "TSvintages,missing-method"
      ]
    }
  ],
  "_readme": "https://github.com/renova-r/TSdbi/raw/renova-2017.4.1.9001/README.md",
  "_rundeps": [
    "DBI",
    "tframe"
  ],
  "_vignettes": [
    {
      "source": "Guide.Stex",
      "filename": "Guide.pdf",
      "title": "TSdbi Guide",
      "engine": "utils::Sweave",
      "headings": [],
      "created": "2026-11-13 15:50:44",
      "modified": "2026-11-13 15:50:44",
      "commits": 1
    }
  ],
  "_score": 2.6989700043360187,
  "_indexed": true,
  "_nocasepkg": "tsdbi",
  "_universes": [
    "renova-r"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:50:24.000Z",
      "distro": "resolute",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/781d9a3c42cfc09a2ebec0878cea1d485bee5463a9306db4b93eefef50cf36df",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:50:36.000Z",
      "distro": "resolute",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/500afe61051334f1df03f3b5321b2b31a7e750ed9e858a519ada9f2a47a0d1f2",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:50:23.000Z",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/ff09c4ae357bda932076a568f75cca07b902f34776be94914764106acb54be7e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:50:21.000Z",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/3ad54e760dbf49c4d976ad4ac7979f9b2dac7be2f727175838c48bf00c31c653",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:50:29.000Z",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/320f6bb6b0d844187b7fc29a4e4c663fe55070ff6e5af6df4e881d51b2ad5b52",
      "status": "success",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:50:43.000Z",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/dd72fac901d4ceabf80ed764162180a3b7c1e9d45196f7af9c7da4e380f955f3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:51:02.000Z",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/10a5a54055e8b971b133b6a06ffa4b2b7b1bc646aeed3495cf6fb88201832b71",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "2017.4.1.9001",
      "date": "2026-11-13T17:50:33.000Z",
      "commit": "4671c49acae177f4a1c9e9cf096c64e793fb19fd",
      "fileid": "https://r2.ropensci.org/70b8cdc080c51cbd5e9e0f7b672a2a89e2cc0598298b09989aeba154007f9c5a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/renova-r/actions/runs/43475747507"
    }
  ]
}