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

[Spencer Graves]

<in line>

On 11/28/2010 7:35 AM, bill hastings wrote:
> Thanks for your great suggestions, I just looked
> at r2html, it looks like just what i need.
>
> I wanted to do all of this in a scripted fashion(automated).
> Each time I run my system(when it's finished)I would be generating thousands of
> charts and blocks of text.
>
> Have you used open office's scripting feature?
no.
> What do you think of these content management systems or
> other scripting languages to automate the production of
> web pages from R outputs?
I know nothing about them.
> The problem I found with the RODBC was that it could not
> handle blobs or binary files, only data.frames.
> I could not find a way to put a blob into a data.frame.
> Do you have any suggestions on that problem?
no.
> Thanks again,
> bill
>
>
>
>
> ________________________________
> From: Spencer Graves<spencer.graves using structuremonitoring.com>
> To: Joe Conway<mail using joeconway.com>
> Cc: bill hastings<aaacompute using yahoo.com>; r-sig-db using r-project.org
> Sent: Sat, November 27, 2010 12:01:53 PM
> Subject: Re: [R-sig-DB] R DB interfaces and saving charts
>
>         Beyond Dirk's comments, there is an "R2HTML" package.  (It has     some
> minor problems and could use maintenance.  If you have time and     interest,
> please contact either me or the officially listed     maintainer or author.)  To
> produce *.pdf, one can print from a     browser to *.pdf (e.g., using CutePDF).
> To control pagination with     that, I've manually edited the index.html file in
> Open Office, then     wrote to *.pdf.
>
>
>
>        Have you considered creating a subdirectory, e.g., called     "figs", and
> write all the individual plots to that subdirectory?      That's a more
> traditional solution, I think.
>
>
>
>        If you'd rather use MySQL than PostgreSQL, the RMySQL package     seems to
> work OK, though it cannot be installed from CRAN on a     Windows machine.
> Instead, you need to download the source in     *.tar.gz then do "R CMD INSTALL"
> from that to tailor it for the     version of MySQL you have.
>
>
>
> Hope this helps.
> Spencer
>
>
> On 11/27/2010 8:43 AM, Joe Conway wrote:
> 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
>
>
>
>   _______________________________________________ R-sig-DB mailing list -- R
> Special Interest Group R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
>
>


-- 
Spencer Graves, PE, PhD
President and Chief Operating Officer
Structure Inspection and Monitoring, Inc.
751 Emerson Ct.
San José, CA 95126
ph:  408-655-4567