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
