similar to: RSQLite 0.4-18 sent to CRAN

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 uploaded to CRAN. Details on the enhancements and fixes are below. Please direct questions to the R-sig-db mailing list. Version 0.11.0 - Enhance type detection in sqliteDataType (dbDataType). The storage mode of a data.frame column is now used as part of the type detection. Prior to this patch, all vectors with class other than numeric or logical were

A new version of RSQLite has been uploaded to CRAN. Details on the enhancements and fixes are below. Please direct questions to the R-sig-db mailing list. Version 0.11.0 - Enhance type detection in sqliteDataType (dbDataType). The storage mode of a data.frame column is now used as part of the type detection. Prior to this patch, all vectors with class other than numeric or logical were

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

RSQLite.extfuns provides SQLite extension functions for use with RSQLite. The package is a wrapper of extension functions written by Liam Healy and made available through the SQLite website (http://www.sqlite.org/contrib). You can make the extension functions available on a per db connection basis like this: library("RSQLite.extfuns") db <- dbConnect(SQLite(), dbname =

RSQLite.extfuns provides SQLite extension functions for use with RSQLite. The package is a wrapper of extension functions written by Liam Healy and made available through the SQLite website (http://www.sqlite.org/contrib). You can make the extension functions available on a per db connection basis like this: library("RSQLite.extfuns") db <- dbConnect(SQLite(), dbname =

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

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

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

Seth, I encountered problems installing RSQLite, R-2.7.0, on RHEL4 using Intel 10.1 icc, My sysadmin helped me track down the problem and kindly forwarded me the fix, which corrected the problem. What follows is from the sysadmin. Mark I looked at the error, looks like there is a bug in the source code. I've attached a new tarball, hopefully fixed. I added #include <sys/types.h>

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 mailing list R-packages at r-project.org https://stat.ethz.ch/mailman/listinfo/r-packages

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 mailing list R-packages at r-project.org https://stat.ethz.ch/mailman/listinfo/r-packages

Hi, I'm experimenting with using (R)SQLite to do data management. Here are two little problems that I've encountered: 1. The presence of ',' in string values causes trouble since ',' is also the delimiter used in the SQL statement. 2. A newline '\n' line attached to the last string value of each row. Some examples: > library (RSQLite) Loading required

Hi, On a fresh install of R on mac os x 10.6.4 (snow leopard) RSQLite did not install while running biocLite() $ R R version 2.11.1 (2010-05-31) Copyright (C) 2010 The R Foundation for Statistical Computing ISBN 3-900051-07-0 [...] Loading required package: utils BioC_mirror = http://www.bioconductor.org Change using chooseBioCmirror(). [Previously saved workspace restored] >

Hi All, I am trying to make write a table in RSQLite. And I get the error mentioned below mat<-as.data.frame(matrix(rnorm(n=244000000),nrow=244000,ncol=1000)) > dbWriteTable(con, "array", mat) [1] FALSE *Warning message: In value[[3]](cond) : RS-DBI driver: (error in statement: too many SQL variables)* Can someone please tell me what is maximum size of a table( max number of