[R] [R-pkgs] RSQLite 0.11.0

containing tables with more than 2000 columns may not be compatible with versions of SQLite compiled with default settings. - Upgrade to SQLite 3.7.9. -- Seth Falcon | @sfalcon | http://userprimary.net/ ___ R-packages mailing list r-packa...@r

Re: [R] Decimals in R/SQL

to create a new table from an existing table using SQL where the new table has the types you want. + seth -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read

Re: [R] Data type problem when extract data from SQLite to R by using RSQLite

contains all the same declared type affinity. + seth Best, Jia On Tue, Mar 1, 2011 at 1:16 AM, Seth Falcon s...@userprimary.net wrote: Hi Jia, On Mon, Feb 28, 2011 at 6:57 PM, chen jia chen_1...@fisher.osu.edu wrote: The .schema of table annual_data3 is sqlite .schema annual_data3 CREATE

Re: [R] Data type problem when extract data from SQLite to R by using RSQLite

] tools_2.11.1 -- Seth Falcon | @sfalcon | http://userprimary.net/ __ 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

Re: [R] Data type problem when extract data from SQLite to R by using RSQLite

and convert if needed at the R level. - remove NA/NULL values from the db or decide on a different way of encoding them (e.g you might be able to use -1 in the db in some situation to indicate missing). Your R code would then need to map these to proper NA. Hope that helps. + seth -- Seth

Re: [R] python-like dictionary for R

in order to write it, but haven't used it much since :-P Be sure to look at R's native environment objects which provide a hash table structure and are suitable for many uses. + seth -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R-help@r

Re: [R] How to Read a Large CSV into a Database with R

chunk of data right after the previous chunk, or do we need to keep track of things using skip The purpose of using a file connection is to allow R to keep its place in the file as it reads and not have to re-read or skip. This is considerably more efficient. -- Seth Falcon | @sfalcon | http

Re: [R] How to Read a Large CSV into a Database with R

= ) dbGetPreparedQuery(db, sql.in, bind.data = part) } }, error = function(e) { if (grepl(no lines available, conditionMessage(e))) TRUE else stop(conditionMessage(e)) }) dbCommit(db) -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R

Re: [R] 64 bit RSQLite

Hi, On 8/14/10 11:43 PM, Stephen Liu wrote: Could you please explain a little bid further whether after connecting the website I can select either 32 or 64 bit version? R packages come in pre-compiled binary flavors for some OS/architectures and always as source packages. If you are on

Re: [R] Limited output

Hi, On 7/21/10 1:58 AM, confusedcius wrote: The details of my problem are as follows: I have an sql that returns 2192 rows in sqlite. In R, I typed the following: library(RSQLite) con - dbConnect(dbDriver(SQLite), dbname = C:\\sqlite\\... .sqlite) dbListTables(con) #[1] tbl_n...

Re: [R] 64 bit RSQLite

Hi Stephen, On 8/12/10 7:10 PM, Stephen Liu wrote: Hi folks, Ubuntu 10.04 64 bit Where can I find 64 bit RSQLite? It seems not there; RSQLite: SQLite interface for R http://cran.r-project.org/web/packages/RSQLite/index.html You should be able to install the RSQLite source package to

Re: [R] Compress string memCompress/Decompress

the example in a helper function to provide your own BLOB respecting write table function if you can't get dbWriteTable to work for your case. + seth -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R-help@r-project.org mailing list https

Re: [R] RSQLite install R x86_64 fail

-darwin9.8.0 The mac binary package is intended to work with the R binary installer for OS X. So if you want to use it, you need to install R that way. Hope that helps some. + seth -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R-help@r

Re: [R] Compress string memCompress/Decompress

) checkEquals(10, nrow(a)) a - dbGetQuery(db, select * from t1) checkEquals(10, nrow(a)) checkEquals(2, ncol(a)) checkEquals(z, sapply(a$data, rawToChar)) dbDisconnect(db) -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R

Re: [R] RSQLite install R x86_64 fail

/building.html + seth David On Jul 11, 2010, at 4:09 PM, Seth Falcon wrote: Hi David, On Sun, Jul 11, 2010 at 12:27 PM, David Ruau dr...@stanford.edu wrote: On a fresh install of R on mac os x 10.6.4 (snow leopard) RSQLite did not install while running biocLite() How did you install R? $ R

[R] [R-pkgs] New package RSQLite.extfuns and minor upgrade for RSQLite

the SQLite header files in the installed include directory so that RSQLite.extfuns (and other packages wishing to provide SQLite extension functions) can use LinkingTo. The default value of loadable.extensions is now TRUE. + seth -- Seth Falcon | @sfalcon | http://userprimary.net

Re: [R] RSQLite equivalent of .schema?

this? Thanks! dbGetQuery(db, select * from sqlite_master where tbl_name = 'yourTable') -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting

Re: [R] dbSendQuery with R variables

, only values. For details of what is supported, try reading through the examples in help(dbSendPreparedQuery) + seth -- Seth Falcon | @sfalcon | http://userprimary.net/ __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help

[R] [R-pkgs] Release announcement: RSQLite 0.9-0 now with more BLOBs

these and other changes here: http://cran.r-project.org/web/packages/RSQLite/NEWS + seth -- Seth Falcon | @sfalcon | http://userprimary.net/ ___ R-packages mailing list r-packa...@r-project.org https://stat.ethz.ch/mailman/listinfo/r-packages

[R] [R-pkgs] RSQLite 0.8-4 now on CRAN

available here: http://cran.r-project.org/web/packages/RSQLite/NEWS + seth -- Seth Falcon | @sfalcon | http://userprimary.net/ ___ R-packages mailing list r-packa...@r-project.org https://stat.ethz.ch/mailman/listinfo/r-packages

Re: [R] using setMethod or setGeneric to change S4 accessor symbol from @ to $

? You could also provide a validate function that takes a data.frame and either says OK or describes the ways in which the input does not conform. I think the benefits you would get out of a complete S4 wrapping of data.frame do not outweigh the complexity introduced. + seth -- Seth Falcon

Re: [R] shared object location

and C code you want to use/test. This would best allow other people to have a single version of the R package, no? + seth -- Seth Falcon | @sfalcon | http://userprimary.net/user __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman

Re: [R] [Fwd: Re: question on sqldf syntax]

investigating and fixing. It should be possible to avoid such conflicts by proper use of name spaces, but I have not looked into the details of what's going on. + seth -- Seth Falcon | @sfalcon | http://userprimary.net/user __ R-help@r-project.org

Re: [R] Help deciphering segfault in make check

this: R -d gdb run source(src/tests/Examples/base-Ex.R) Assuming you get a crash, type bt in the gdb console and send output. + seth -- Seth Falcon | @sfalcon | http://userprimary.net/user __ R-help@r-project.org mailing list https://stat.ethz.ch

Re: [R] R package dependencies

dependencies that would be listed on that page if there were any for this package. An example with reverse dependencies is e.g., the IRanges package: http://bioconductor.org/packages/2.5/bioc/html/IRanges.html The maintainer (Seth Falcon) would know for sure if the package will do reverse dependencies

Re: [R] Directory operations

you are using the latest R release and latest Bioconductor and CRAN packages. + seth -- Seth Falcon Bioconductor Core Team | FHCRC __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http

Re: [R] The RSQLite version of dbGetQuery drops colums

Hi Magnus, Magnus Torfason zulutime.net at gmail.com writes: I just noticed (the hard way of course) that when a query returns 0 rows, the columns in the resulting data.frame get dropped as well. See the following example code (where conn is an active connection to an SQLite db):

[R] [R-pkgs] New version of RSQLite on CRAN

Hi, RSQLite 0.7-2 is available on CRAN. Version 0.7-2 - Fixed some partial argument matching warnings. Thanks to Matthias Burger for reporting and sending a patch. - Added dbBuildTableDefinition to exports per user request. + seth ___ R-packages

[R] [R-pkgs] RSQLite 0.6-7 -- changes to dbGetQuery semantics

://stat.ethz.ch/pipermail/r-sig-db/2008q1/000399.html + seth -- Seth Falcon | [EMAIL PROTECTED] | blog: http://userprimary.net/user/ ___ R-packages mailing list [EMAIL PROTECTED] https://stat.ethz.ch/mailman/listinfo/r-packages