similar to: New package RSQLite.extfuns and minor upgrade for RSQLite

CRAN (and crantastic) updates this week New packages ------------ * allan (1.0) Alan Lee http://crantastic.org/packages/allan Automates Large Linear Analysis Model Fitting * andrews (1.0) Jaroslav Myslivec http://crantastic.org/packages/andrews Andrews curves for visualization of multidimensional data * anesrake (0.3) Josh Pasek http://crantastic.org/packages/anesrake This

This is my first post. I am running Mac OS X version 10.6.3. I am running R 2.11.0 GUI 1.33 64 bit. This may or may not be related to sqldf, but I experienced this problem while attempting to use an sqldf query. The same code runs with no problem on my Windows machine. Here is what happens: > r=sqldf("select ... ") Loading required package: tcltk Loading Tcl/Tk interface ... Then

Have a long script that runs fine on windows (32 bit). When I try to run in on two different macs (64 bit), however, it hangs with identical behavior. I start with: library(sqldf) This results in messages: Loading required package: DBI Loading required package: RSQLite Loading required package: RSQLite.extfuns Loading required package: gsubfn Loading required package: proto Loading required

Hi all, Please bear with me because I'm not all that familiar with R. I manage a research cluster that's running Red Hat 5.6 (64-bit), and we recently installed version 2.15.0 of R for some users. Here's how we built it: ./configure --prefix=/opt/shared/R/2.15.0 --with-tcltk --with-system-zlib --with-system-bzlib --with-system-pcre --with-lapack --enable-R-shlib When we ran

Hello Group, I am having trouble with the sqldf package on unix. The same code works fine on windows. Silly Example script: # Load the package library(sqldf) # Use the titanic data set data(women) colnames(women) head(women) sqldf('select height, count(*) from women where height is not null group by weight') Unix Output and error: bash-3.00$ R --vanilla <testR.R

How can i replicate this in Linux: source(file.choose()) I've tried source(tkgetOpenFile()) but with no luck

Hello all, Just uploaded to CRAN updates for RSQLite, RMySQL, and DBI. The primary svn repository for these packages is now hosted by the Gentleman Lab in Seattle and our group is working with David James to help with maintenance. Details on the updates are below. RMySQL_0.5-9.tar.gz * Fixed unclosed textConnections RSQLite_0.4-4.tar.gz * Upgraded to SQLite 3.3.7 * Default when

Hello all, Just uploaded to CRAN updates for RSQLite, RMySQL, and DBI. The primary svn repository for these packages is now hosted by the Gentleman Lab in Seattle and our group is working with David James to help with maintenance. Details on the updates are below. RMySQL_0.5-9.tar.gz * Fixed unclosed textConnections RSQLite_0.4-4.tar.gz * Upgraded to SQLite 3.3.7 * Default when

Hi all, 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): > dbGetQuery(conn, "select 1 as hey, 2 as ho where 1") hey ho 1 1 2 > dbGetQuery(conn, "select 1 as hey, 2 as ho where 0") data frame

A new version of RSQLite (0.8-4) is now available on CRAN. Highlights of this release: Version 0.8-4 - Fix a memory leak in bound parameter management and resolve a missing PROTECT bug that caused spurious crashes when performing many prepared queries. - There is now a fairly comprehensive example of using prepared queries in the man page for dbSendQuery-methods. - Upgrade to SQLite

A new version of RSQLite (0.8-4) is now available on CRAN. Highlights of this release: Version 0.8-4 - Fix a memory leak in bound parameter management and resolve a missing PROTECT bug that caused spurious crashes when performing many prepared queries. - There is now a fairly comprehensive example of using prepared queries in the man page for dbSendQuery-methods. - Upgrade to SQLite

Version 0.4-1 of the RSQLite package has been uploaded to CRAN. RSQLite embeds the SQLite engine in R (see http://www.sqlite.org) Changes include: * Fixed problems exporting/importing NA's * An new experimental dbWriteTable() method to create SQLite tables from simple files (delimited unquoted fields), e.g., > dbWriteTable(con, "table_name", "file_name", ...)

Version 0.4-1 of the RSQLite package has been uploaded to CRAN. RSQLite embeds the SQLite engine in R (see http://www.sqlite.org) Changes include: * Fixed problems exporting/importing NA's * An new experimental dbWriteTable() method to create SQLite tables from simple files (delimited unquoted fields), e.g., > dbWriteTable(con, "table_name", "file_name", ...)

A new version of RSQLite has been pushed to CRAN. In this version... * Further integration of the manifest type system available since SQLite 3. We now obtain the column type from the DB instead of pulling everything across as a character vector and calling type.convert. This should improve performance and provide a more reliable interface to build on top of. Note, however, that since

A new version of RSQLite has been pushed to CRAN. In this version... * Further integration of the manifest type system available since SQLite 3. We now obtain the column type from the DB instead of pulling everything across as a character vector and calling type.convert. This should improve performance and provide a more reliable interface to build on top of. Note, however, that since

Hi All, I tried to install AnnotationDBI like so: source("http://bioconductor.org/biocLite.R") biocLite("AnnotationDbi") and got this error: .... Loading required package: RSQLite Error in dyn.load(file, ...) : unable to load shared library '/RHEL3/local/lib64/R/library/ RSQLite/libs/RSQLite.so': /RHEL3/local/lib64/R/library/RSQLite/libs/RSQLite.so: undefined

RSQLite is an R package conforming to the R DBI interface that allows for interaction with SQLite. Version 0.9-0 highlights: * Support for SQLite BLOBs using raw vectors in R * New memory model for db connections allows for more familiar R semantics and no predefined limit to the number of connections you can have in an R session. * Upgrade to SQLite 3.6.23.1 * Removed an unnecessary

RSQLite is an R package conforming to the R DBI interface that allows for interaction with SQLite. Version 0.9-0 highlights: * Support for SQLite BLOBs using raw vectors in R * New memory model for db connections allows for more familiar R semantics and no predefined limit to the number of connections you can have in an R session. * Upgrade to SQLite 3.6.23.1 * Removed an unnecessary

RSQLite 0.6-7 has been uploaded to CRAN and should hit a mirror near you in the next few days. This version changes the behavior of the dbGetQuery method to make it more consistent with dbSendQuery. Specifically: 1. dbGetQuery now closes a complete result set as dbSendQuery does. 2. If there is an incomplete result set open, dbGetQuery still opens a new temporary connection, but now issues

RSQLite 0.6-7 has been uploaded to CRAN and should hit a mirror near you in the next few days. This version changes the behavior of the dbGetQuery method to make it more consistent with dbSendQuery. Specifically: 1. dbGetQuery now closes a complete result set as dbSendQuery does. 2. If there is an incomplete result set open, dbGetQuery still opens a new temporary connection, but now issues