My understanding is that sqldf works in conjunction with the sqlite and H2 DBMSs. You should be able to verify that from the sqldf home page; if I'm wrong, Gabor will quickly correct me :)
Dennis On Fri, Jul 15, 2011 at 11:51 AM, Bhushan, Vipul <vipul.bhus...@geodecapital.com> wrote: > Thanks very much for your response. This sqldf package looks promising. I > just need to figure out if a dbms needs to be running/installed in our > environment (to hold the temporary SQLite DB it creates). The examples in the > documentation are helpful too. > > -----Original Message----- > From: Dennis Murphy [mailto:djmu...@gmail.com] > Sent: Friday, July 15, 2011 2:10 PM > To: Bhushan, Vipul > Cc: r-help@r-project.org > Subject: Re: [R] Querying RData Files, SQL style? > > Hi: > > If you load the data into R, there is a package called sqldf that > allows one to apply SQL syntax to an R data frame. Is that what you > had in mind? If so, Google 'sqldf R' and you should get a pointer to > its home page. > > HTH, > Dennis > > On Fri, Jul 15, 2011 at 7:29 AM, Bhushan, Vipul > <vipul.bhus...@geodecapital.com> wrote: >> Hello. Is there a package or functionality available somewhere which will >> allow for complex searches (such as what SQL can do) of collections of RData >> files? Search capability within a given RData file at a time (which could be >> put in a loop) would be good, but the capability to perform joins to data >> across multiple RData files would be great. These queries might be ad-hoc, >> so writing an R program to get(load(...)) each file and customize the search >> in home-grown R code isn't feasible. >> >> This shouldn't be dependent on environment details, but just in case: I'm >> running version 2.13.0 in a Unix environment (but could easily run in >> Windows too). >> >> Thanks very much. >> >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
