[R-sig-DB] R DB interfaces and saving charts

[Joe Conway]

On 11/27/2010 07:57 AM, bill hastings wrote:
> 1) Is there anyway to save a chart(produced by plot)
> 
>     to a data base?
> 
>     I see that most of the R DB methods
> 
>     save output as data.frames or files.

Use PL/R with PostgreSQL.
  http://www.joeconway.com/plr/

For some ideas how to do this see:

http://blog.credativ.com/en/2010/07/postgresql-topic-of-the-day---advanced-analytics.html

-or-

http://bit.ly/9NZ0fz

This example shows saving data frames directly as R objects to tables in
the database, and also shows returning a chart as binary data (jpg) as a
result of a SQL query. It would be a simple matter to store that
returned data into a bytea column in PostgreSQL.

HTH,

Joe


-- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 899 bytes
Desc: OpenPGP digital signature
URL: <https://stat.ethz.ch/pipermail/r-sig-db/attachments/20101127/27b40187/attachment.sig>