How to save R plot image to database?

Question

I'd like to save a plot image directly to the database.

Is the best way in R to do this:

1. Write the plot image (png) to the filesystem
2. Read the file that was written
3. Send the file to the database via query (RODBC)

Ideally I'd like to combine steps 1 and 2 above by simply write the png image to a binary connection. Does R support this?

Answer 1

No, the graphics devices are file-based, so your steps 1-3 are correct. You need a fourth to unlink the temporary file but that is about it.