Hi Rainer,
dbWriteTable is a nice function but in my case I need something that can
actually save a dataframe in one row of a table. That is why I want to
serialize my data.frame.
Best
Simon
On Jul 16, 2013, at 3:05 PM, Rainer Schuermann
wrote:
> Maybe a simple
>
> dbWriteTable( db, "f
Maybe a simple
dbWriteTable( db, "frames", iris )
does what you want?
On Monday 15 July 2013 23:43:18 Simon Zehnder wrote:
> Dear R-Users,
>
> I need a very fast and reliable database solution so I try to serialize a
> data.frame (to binary data) and to store this data to an SQLite database.
Hi Jeff,
I think you are more right than me. I have not much experience with R-specific
objects and Databases. I just know, that for languages like Java, C, etc. this
process is a usual one for storing for example matrices (in case of course that
I do not have to access specific elements inside
I could be wrong, but I would guess that doing what you are describing is very
unusual. Most of the time the data frame is mapped to a table in the database
so the rows can be searched. Storing data frames as BLOBs really seems odd.
Note that there is an R-sig-db mailing list for questions of th
Dear R-Users,
I need a very fast and reliable database solution so I try to serialize a
data.frame (to binary data) and to store this data to an SQLite database.
This is what I tried to do:
library(RSQLite)
con <- dbDriver("SQLite")
db <- dbConnect(con, "test")
dbSendQuery(db, 'CREATE TABLE fr
5 matches
Mail list logo
