Re: [R] Saving R-objects to a database

2008-09-25 Thread Prof Brian Ripley
Presumably this about RMySQL, and by 'database' you mean a MySQL database, not e.g. a .rdb file? R-sig-db would be a better list, but I think this is one of many aspects of the DBI package that that not been updated to match improvements in R. On Thu, 25 Sep 2008, Christian Ruckert wrote: S

[R] Saving R-objects to a database

2008-09-25 Thread Christian Ruckert
Someone solved the problem of saving R-objects to a database? These are the two varaints I've tried so far without success: 1) ser = rawToChar(serialize(obj, NULL, ascii=TRUE)) dbSendQuery(link, paste("insert into table values(1, '",ser,"')",sep='')) The field to save the object in the MySQL Da