All working. R had sufficient piping to files and allowed me to get it.
On 5/4/10, Gabor Grothendieck <ggrothendi...@gmail.com> wrote: > You don't need to dump the data to a csv file and then read it into R > and there is no need to use the sqlite3 console at all as R's RSQLite > package can directly read and write SQLite databases. Also see the > sqldf package. > > On Tue, May 4, 2010 at 1:02 PM, Matt Young <youngsan...@gmail.com> wrote: >> I can work SQLite from by R stat package, but I am having hard time >> mixing special sqlite command intermixed with SQL statements when I >> send a text sequence to swqlite (even from the dos consol) >> >> >> sqlite3 test.db ".mode csv select * from selected limit 4" >> >> Makes sqlite choke because I do not know what the inline terminator is >> for a text invocation argument, and can't find it in the docs. >> >> That is my last minor detail, and I have indices, joins, and unions >> going on the Bureau of Labor Statistic under R. Will make SQLite >> quite popular among the economists. Getting access to reams of data >> from economic we sites, directly into R dataframes via a set of common >> key words familiar to economists. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users