[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