search for: dbsendqueri

Dear R-Users, I need a very fast and reliable database solution so I try to serialize a data.frame (to binary data) and to store this data to an SQLite database. This is what I tried to do: library(RSQLite) con <- dbDriver("SQLite") db <- dbConnect(con, "test") dbSendQuery(db, 'CREATE TABLE frames("simID" INT, "data" BLOB)') data.bin <-

Rhelpers: I'd like to modify this RSQLite statement: rs_stations<-dbSendQuery(con_stations, "select * from stations") so that stations is actually an R variable, e.g.: stations=c("stationA","stationB") How would I modify the above statement to query from stations[[1]] (aka "stationA")? --j

R HELP, I am trying to use an R script to connect to a mysql database. I am having a problem using a variable in the where clause that contains a "space" in its value. If I include the variable inside the quotes of the query - i think it is searching for the name of the variable in the database and not the value of the variable. If I put it outside the quotes, then it complains

Hi all- I am stumped. The code in A. returns errors at lines 14 and 15 and fails to load series1 and series2. However, in B., if temp1 and temp2 are called again (which returns a "Table exists" error; see lines 14-17 in B.) series1 and series2 load correctly. Any ideas? Also-I am open to any suggestions to improve the code as I am a horrific programmer. Thanks A. 1 >

Hi. I am trying to get data from mysql database using a couple of queries. I do one query to find out the indexes. Then i need to use these indexes in another query, but i keep getting errors. Here is something: numb <- dbSendQuery(con2, "select distinct(comparison) from table1") count <- fetch(numb, -1) my.matrix <- as.matrix(count) rs <- dbSendQuery(con2, "select

Hi, I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the RPostgreSQL package for interfacing with a postgresql database. I am using postgresql 8.3.7. A query that works from the postgresql terminal is causing a segfault when executed from R. My sessionInfo, the error message, and the R code used to generate the error are listed below. I have noticed that a

I've been putting together a package that defined generic methods for database access. The packages is called "Rdbi." It borrows as much as possible from existing database packages / proposals. I'd like to start a discussion about the proposed interface. Here's what I've come up with so far: # # Rdbi: connectionMethods.R # dbConnect <- function(dbObj, ...)

Hi, I've run into a bit of a problem with using the RMySQL library. I've been attempting to create a temporary table in a MySQL database and then perform a SELECT with a WHEREs clause on the table. In effect perform a SELECT with a subSELECT. The problem is that it never seems to be able to find the table after I create it. I've been using the dbSendQuery method to create the table

I am trying to use a shiny app to update records in an sqlite database. I keep running into the following error: unable to find an inherited method for function 'dbSendQuery' for signature '"src_dbi", "character"' The query I am trying to send is: [1] "update kpquestions set mrisupercat = 'Demographics - Respondent' , set mricategory =

Someone solved the problem of saving R-objects to a database? These are the two varaints I've tried so far without success: 1) ser = rawToChar(serialize(obj, NULL, ascii=TRUE)) dbSendQuery(link, paste("insert into table values(1, '",ser,"')",sep='')) The field to save the object in the MySQL Database is of type text. unser = dbGetQuery(link,"select

Buenas, Tengo un problema y es que intentando conectarme a una base de datos SQL Server, tras cosneguirme conectarme usando el paquete odbc, me deja acceder al contenido de algunas tablas (mediante un select), pero sin embargo en otras me pone lo siguiente: Error in new_result(connection en ptr, statement) : std::bad_alloc No entiendo muy bien porque me salta ese error, ya que desde SQL si

Hi, I have been trying to output my graphs to a file (jpeg, pdf, ps, it doesnt matter) but i cant seem to be able to get it to output. I tried a few things but none of them worked and am lost as what to do now. I am using the scatter3d function, and it prints out the graphs on tot he screen without any problems, but when it comes to writing them to a file i cant make it work. Is there any

---------- Forwarded message ---------- From: Moumita Das <das.moumita.online@gmail.com> Date: Sat, May 16, 2009 at 2:26 PM Subject: Cannot allocate a new database connection error To: r-help-request@r-project.org Hi friends, why do i keep getting this error?The program runs, twice and every third time i get this error.I have to quit.Again get teh R-prompt and then run the script. *Error

I am trying to use R interfaced with MySQL. Present goal is that R should calculate the 85% quantile of AvgSpeed for each LinieID. Looking through documentation of the RMySQL Package, I guessed that dbApply would do the trick due to this example ## compute quanitiles for each network agent con <- dbConnect(MySQL(), group="vitalAnalysis") res <- dbSendQuery(con,

Hello, I'm still trying to make the life of my colleagues easier. Nice, isn't it ? At the moment, I'm looking for a way to generate multiple "single report". In fact I have a .rnw file which send a query to a MySQL database (rs<-dbSendQuery(con, statement="select * from treatdata where name='Device1'") But of course my colleagues have many devices and

Hello R users, I found the odfWeave package to create an odf document. It seems to be a very nice tool. So i tried to used it to create a report with multiple plot: I create an odt file with some code inside: I connect to a mysql database I get a list of projects foreach project I would like to make a plot (a map exactly) then in a R console I use the odfweave (inFile, outFile) function.

Hi, first thanks to Sunny Ho (and David James for the pointer) for resolving the problem of the empty rows returned from ROracle. However, I have a problem still: > library(ROracle) > ora <- dbDriver("Oracle") > con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME) > rs <- dbExecStatement(con, "select * from USER_TABLES") Error in

Hola a todos Estoy aprendiendo a trabajar con el paquete de RMySQL, y a la vez con bases SQL, así que a lo mejor no es tan complicado. Quiero agregar valores, que genero en R, a una tabla de SQL más o menos la idea es: > ssql<-"INSERT INTO tabla1 (variableA, variableB) VALUES (''valor1'',''valor2'')" > dbSendQuery(conec, ssql) pero

Hello Simon, Hello everyone, I have a problem with retrieving database-queries chunkwise. In my query (Postgresql-Database, Postgres-Version 9.1) dbHasCompleted seems to always return TRUE. dbGetQuery works for smaller tables, but not for the whole query, since then a Heap-Overflow-Error will occur (and a Error: "java.lang.OutOfMemoryError: GC overhead limit exceeded" when trying to

Dear List, I have this little problem: I work with adiacency matrix like: data me you me 0 1 you 1 0 I store those matrix in a mysql database actually I use RMySQL with: res<-dbSendQuery(connection, "SELECT * FROM table") myDataFrame<-fetch(res) to retrive the table, and I have data me you 1 io 0 1 2 tu 1 0 I would like the first column to be seen