[R-sig-DB] rpg 1.2
Tim Keitt
tke|tt @end|ng |rom utex@@@edu
Wed Sep 3 19:51:15 CEST 2014
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]]
More information about the R-sig-DB
mailing list