Displaying 20 results from an estimated 2000 matches similar to: "RSQLite 0.11.0"
2010 May 07
0
Release announcement: RSQLite 0.9-0 now with more BLOBs
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
2010 May 07
0
Release announcement: RSQLite 0.9-0 now with more BLOBs
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
2010 May 30
0
New package RSQLite.extfuns and minor upgrade for RSQLite
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 =
2010 May 30
0
New package RSQLite.extfuns and minor upgrade for RSQLite
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 =
2010 Mar 10
0
RSQLite 0.8-4 now on CRAN
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
2010 Mar 10
0
RSQLite 0.8-4 now on CRAN
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
2005 Oct 27
2
RSQLite problems
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
2008 Jan 01
0
Wish List
Most of the items on this list have been mentioned before but it
may be useful to see them altogether and at any rate every year
I have posted my R wishlist at the beginning of the year.
High priority items pertain to the foundations of R (promises,
environments) since those form the basis of everything
else and the foundation needs to be looked after first.
The medium items are focused on
2006 Jan 19
0
RSQLite
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", ...)
2006 Jan 19
0
RSQLite
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", ...)
2008 Jan 26
0
RSQLite 0.6-7 -- changes to dbGetQuery semantics
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
2008 Jan 26
0
RSQLite 0.6-7 -- changes to dbGetQuery semantics
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
2008 Jul 16
1
RSQLite maximum table size
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
2007 Jan 04
0
RSQLite 0.4-18 sent to CRAN
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
2007 Jan 04
0
RSQLite 0.4-18 sent to CRAN
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
2006 Mar 15
3
"\r" with RSQLite
What am I doing wrong, or is the \r that I'm getting
in the example below a bug?
> a <- (1:10)
> b <- (LETTERS[1:10])
> df <- as.data.frame(cbind(a, b))
>
> df
a b
1 1 A
2 2 B
3 3 C
4 4 D
5 5 E
6 6 F
7 7 G
8 8 H
9 9 I
10 10 J
> library(RSQLite)
> drv <- dbDriver("SQLite")
> con <- dbConnect(drv, dbname = "Test")
2006 Mar 15
3
"\r" with RSQLite
What am I doing wrong, or is the \r that I'm getting
in the example below a bug?
> a <- (1:10)
> b <- (LETTERS[1:10])
> df <- as.data.frame(cbind(a, b))
>
> df
a b
1 1 A
2 2 B
3 3 C
4 4 D
5 5 E
6 6 F
7 7 G
8 8 H
9 9 I
10 10 J
> library(RSQLite)
> drv <- dbDriver("SQLite")
> con <- dbConnect(drv, dbname = "Test")
2012 Mar 27
1
RSqlite UPDATE command problem
All:
I am using RSqlite and want to be able to update individual values in a
record, such as with this simple example:
library(RSQLite)
drv<-dbDriver("SQLite")
con<-dbConnect(drv,"test.db")
my.data<-data.frame(countries=c("US","UK","Canada","Australia","NewZealand"),vals=c(52,36,74,10,98))
2011 Jan 04
2
RSQLite to input dataframe
Dear r helpers,
At first, I apologize for raising a query which seems to be a stupid interpretation on my part. I am trying to learn SQLite.
Following is an example given in the RSQLite.zip file (Page # 4)
drv <- dbDriver("SQLite")
tfile <- tempfile()
con <- dbConnect(drv, dbname = tfile)
data(USArrests)
dbWriteTable(con, "arrests", USArrests)
On the similar
2004 Nov 25
3
Searching for a string in RSQLite
I'd like to search for a particular string in an SQLite database using
RSQLite, but I'm running into problems constructing the query
properly, because of embedded quotes and parens in the string.
Is there a function that escapes these for me, or some other fixup
that would let me do the queries below? In the real situation I don't
have control over what strings get searched for.