Learn R Programming

RPostgreSQL (version 0.7-5)

dbApply-methods: Apply R/S-Plus functions to remote groups of DBMS rows (experimental)

Description

Applies R/S-Plus functions to groups of remote DBMS rows without bringing an entire result set all at once. The result set is expected to be sorted by the grouping field.

Arguments

Methods

res

a PostgreSQL result set (see dbSendQuery).

...

any additional arguments to be passed to FUN.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or https://cran.r-project.org/package=DBI.

See Also

PostgreSQL postgresqlDBApply dbSendQuery fetch

Examples

Run this code
if (FALSE) {
## compute quanitiles for each network agent
con <- dbConnect(PostgreSQL(), user="user", password="passwd",dbname="dbname")
rs <- dbSendQuery(con, 
             "select Agent, ip_addr, DATA from pseudo_data order by Agent")
out <- dbApply(rs, INDEX = "Agent", 
        FUN = function(x, grp) quantile(x$DATA, names=FALSE))
}

Run the code above in your browser using DataLab