[R] remote database queries

2009-07-18 Thread David Lubbers
With good and faithful python remote database queries look something like this: url.urlopen(username/pssw...@host,query) where query is something like select * from table where Does R support queries on remote hosts with username and password? What does a simple example look like? Thank

Re: [R] remote database queries

2009-07-18 Thread Duncan Murdoch
On 18/07/2009 3:04 PM, David Lubbers wrote: With good and faithful python remote database queries look something like this: url.urlopen(username/pssw...@host,query) where query is something like select * from table where Does R support queries on remote hosts with username and password?

Re: [R] remote database queries

2009-07-18 Thread Gabor Grothendieck
That depends on the database, not R. I have done remote database calls using MySQL from R. On Sat, Jul 18, 2009 at 3:04 PM, David Lubberslu...@comcast.net wrote: With good and faithful python remote database queries look something like this: url.urlopen(username/pssw...@host,query) where

Re: [R] remote database queries

2009-07-18 Thread Cedrick Johnson
Here's my MYSQL setup for retrieving data: library(RMySQL) channel - dbConnect(MySQL(), user=xx, password=xx, dbname=HistData, host=nomnom.cvgrllc.com) EDM1 = dbGetQuery(channel, paste(select Date, o, h, l, c, v, a from HistBondData Where Symbol = 'EDM1' AND a != 0 ORDER BY Date ASC))