Just a note that rpg has been updated on CRAN in case anyone wants to try it out.
Main features: 1) designed for convenience 2) most common use cases require least input 3) parameterized queries 4) asynchronous queries 5) prepared statement execution loop in C++ 6) iterate over query results using foreach + %do% or %dopar% 7) easy connection setup and changing of defaults 8) queries for password only after first trying without 9) serialize and store any R object in database 10) run psql within R session Main constraints: 1) single active connection at a time 2) only works with postgresql 3) only useful if you know SQL If you already use postgresql and have a default database (ie "psql -c '\d'" works), all you need to type is: library(rpg) list_tables() THK -- http://www.keittlab.org/ [[alternative HTML version deleted]] _______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
