[R-SIG-Finance] Add values to time series in DB directly

[Whit Armstrong]

just append the new data to the table.  as long as you have a way of
subsetting just the new rows, this should be easy.  I haven't used
TSdbi, but I have a postgres package that uses binary write, so it's
pretty fast.  http://github.com/armstrtw/unifieddbi

-Whit


On Thu, Nov 19, 2009 at 9:32 AM, Josuah Rechtsteiner
<rechtsteiner at bgki.net> wrote:
> Dear members of the mighty list,
>
> I have a PostgreSQL DB as storage for some time series. I access the DB from
> within R with TSPostgresql/TSdbi. Today I asked myself if it is possible to
> update an existing TS in the DB with new data points without having to load
> the whole time series into R first and then replacing it in the DB.
> I tried
>
> TSreplace(x, con, append=TRUE)
>
> but this did not work. After reading the vignettes and manuals of the
> packages in use here without success, I thought I should probably conjure up
> the mighty list...
>
> Best,
>
> Josuah
>
> _______________________________________________
> R-SIG-Finance at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only.
> -- If you want to post, subscribe first.
>