ivo welch wrote:
stumped again by SQL... If I have a table named "main" in an SQLite
data base, how do I get the names of all its columns? (I have a mysql
book that claims the SHOW command does this sort of thing, but it does
not seem to work on SQLite.)
If you are using RSQLite, then a lot
wow! the answer seems to be "pragma table_info(main);" thanks, Gabor.
__
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,
Date: Sun, 31 Aug 2008 21:29:38 -0400
From: "ivo welch"
Subject: Re: [R] SQL Primer for R
stumped again by SQL... If I have a table named "main" in an SQLite
data base, how do I get the names of all its columns? (I have a mysql
book that claims the SHOW command does thi
On Sun, Aug 31, 2008 at 9:29 PM, ivo welch <[EMAIL PROTECTED]> wrote:
> stumped again by SQL... If I have a table named "main" in an SQLite
> data base, how do I get the names of all its columns? (I have a mysql
> book that claims the SHOW command does this sort of thing, but it does
> not seem t
stumped again by SQL... If I have a table named "main" in an SQLite
data base, how do I get the names of all its columns? (I have a mysql
book that claims the SHOW command does this sort of thing, but it does
not seem to work on SQLite.)
regards, /iaw
PS: Thanks for the earlier emails on "warn
On Tue, 26 Aug 2008, ivo welch wrote:
Sorry, chaps. I need one more:
dbDisconnect(con.in)
Error in sqliteCloseConnection(conn, ...) :
RS-DBI driver: (close the pending result sets before closing this connection)
I am pretty sure I have fetched everything there is to be fetched.
dbClea
Sorry, chaps. I need one more:
> dbDisconnect(con.in)
Error in sqliteCloseConnection(conn, ...) :
RS-DBI driver: (close the pending result sets before closing this connection)
>
I am pretty sure I have fetched everything there is to be fetched. I
am not sure what I need to do to say goodbye (
Not really, if you want R to be as mainstream as other stats packages
that can read more than a few gigabytes on the PC.
R's relative inefficiency in reading large datasets (due to the RAm
loading thing) ,forces people to opt for lesser softwares which are
way too expensive for annual license fees
On Mon, 25 Aug 2008, ivo welch wrote:
Dear R wizards:
I decided to take the advice in the R data import/export manual and
want to learn how to work with SQL for large data sets. I am trying
SQLite with the DBI and RSQLite database interfaces. Speed is nice.
Alas, I am struggling to find a tut
This would be a function of the database software more than R. For sqlite
a few dozen gigabytes should be ok. Other databases can handle even
larger requirements.
On Mon, Aug 25, 2008 at 9:17 AM, Ajay ohri <[EMAIL PROTECTED]> wrote:
> R 's ability to work with large data sets is limited on PC. I
The sqldf package's home page
http://sqldf.googlecode.com
has quite a few examples as well as links to resources. Also see the
examples in ?sqldf
On Mon, Aug 25, 2008 at 9:12 AM, ivo welch <[EMAIL PROTECTED]> wrote:
> Dear R wizards:
>
> I decided to take the advice in the R data import/export
R 's ability to work with large data sets is limited on PC. I am
trying it on cloud to overcome this but need help from other
programmers.
Also tutorials would help to newbies
regards,
Ajay
On Mon, Aug 25, 2008 at 6:42 PM, ivo welch <[EMAIL PROTECTED]> wrote:
> Dear R wizards:
>
> I decided to
Dear R wizards:
I decided to take the advice in the R data import/export manual and
want to learn how to work with SQL for large data sets. I am trying
SQLite with the DBI and RSQLite database interfaces. Speed is nice.
Alas, I am struggling to find a tutorial that is geared for the kind
of stan
13 matches
Mail list logo
