On Fri, Oct 15, 2010 at 12:54 PM, Graham Smith <myotis...@gmail.com> wrote: > Tom, > > Thanks for this. > > My main reason for asking is because I am trying to encourage my > students and indeed clients to think "database" rather than > "spreadsheet". Most of the time these aren't big or complex data sets > (normally records in the hundreds, sometimes the thousands) but still > big enough to create major problems for themselves and me, just > because the spreadsheet gives them the freedom to really screw things > up. > > While far from perfect, I could live with a single table in a database > that could be queried from R . But it needs to be user friendly and > run on Linux, Windows and Macs. >
If the purpose of this is teaching with R then the R package sqldf lets you query all R data frames in your session using sql as if they were one big giant database. If you stick with the few dozen data frames that ship with R or ones you create yourself using various R facilities then you don't have to enter anything in the first place. See the sqldf home page at: http://sqldf.googlecode.com -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
