NEWS.md
In mbannert/timeseriesdb: A Time Series Database for Official Statistics with R and PostgreSQL

Substantial improvements and new functionality.

R Postgres interface switched from RPostgreSQL to the DBI compliant RPostgres
time series represented as JSON instead of hstore for better performance and consistency (ensuring order).
store version of every time series to track revisions
true release date feature
meta data on vintage (time series version) level

~ quarterly release cycle planned
added convenience function to plot a list of time series (plot.tslist)
major speed up of write process by avoiding multiple selects (~2 times)
major speed up of read process by avoiding multiple selects (~ 3.5 times)
added a table to store sets of time series similar to shopping carts in web stores (basic)
basic export to .csv format to support wide and long format .csv
dependency to RJSONIO added as it used for speed up
added a shiny based data explorer GUI (use function exploredb(con))
changed upsert behavior to not affect unlocalized meta information on insert of new series
improved NULL handling
added SQL transaction utils
quiet execution of Meta Information Storage
fixed issues with quotes
added hstore lookup function
changed from deprecated hstore operator to new hstore function (see PostgreSQL release notes)
function to concatenate overlapping series
function to set attributes to each element of a list
improved read process for bulk reading to use single query instead of looping
improve store process
exported print method
added function to check whether db connection is valid
added quickHandle operator and a closure to create further quick Handle operators

mbannert/timeseriesdb documentation built on May 2, 2023, 11:17 a.m.

Note that we can't provide technical support on individual packages. You should contact the package authors for that.

timeseriesdb v1.0.0