NickPGSmith: 2 revisions imported

2024-05-08T04:53:41Z

2 revisions imported

← Older revision	Revision as of 04:53, 8 May 2024
(No difference)

NickPGSmith: 1 revision imported

2023-02-17T21:02:13Z

1 revision imported

← Older revision		Revision as of 21:02, 17 February 2023
(No difference)

NickPGSmith: Created page with "== Notes == Guides: * [http://www.statmethods.net/index.html Quick-R] source('somefile.R') sink('somrfile.txt', append=TRUE); # Write (append) to file sink() # Return to..."

2021-05-23T14:57:02Z

Created page with "== Notes == Guides: * [http://www.statmethods.net/index.html Quick-R] source('somefile.R') sink('somrfile.txt', append=TRUE); # Write (append) to file sink() # Return to..."

New page

== Notes ==

Guides:
* [http://www.statmethods.net/index.html Quick-R]

source('somefile.R')
sink('somrfile.txt', append=TRUE); # Write (append) to file
sink() # Return to terminal
png('somefile.png') # Redirect to image
plot(x)
dev.off() # Stop writing to image
q() # Quit

Running R from an external script
* -f something.R

== RPostgreSQL ==

Include lib:

library(RPostgreSQL)

Example of connecting to postgres:

drv <- dbDriver('PostgreSQL')
con <- dbConnect(drv, dbname='somedatabase', user='someuser', pass='somepass')
data <- dbReadTable(con, 'sometable')
head(data, 100)
dbDisconnect(con)
dbUnloadDriver(drv)

Or like this with SQL/fetch (large tables can be streamed):

drv <- dbDriver('PostgreSQL')
con <- dbConnect(drv)
res <- dbSendQuery(con, 'SELECT * from sometable')
data <- fetch(res, n = -1)

See also [https://code.google.com/p/rpostgresql/ here]

R - Revision history

NickPGSmith: 2 revisions imported

NickPGSmith: 1 revision imported

NickPGSmith: Created page with "== Notes == Guides: * [http://www.statmethods.net/index.html Quick-R] source('somefile.R') sink('somrfile.txt', append=TRUE); # Write (append) to file sink() # Return to..."