search for: rmsql

Dear R team / R helpers / R users , I downloaded R-1.0.0 to install it but I am currently facing the following problem : Installation of packages. Here is the output I had while trying to install RmSQL : ------------- > R INSTALL -l /software/R-1.0.0/library/ /software/archive/R/RmSQL_0.2-1.tar.gz Installing package `RmSQL' ... libs RmSQL.c:7: msql.h: No such file or directory make: *** [RmSQL.o] Error 1 R help >>> Building/Updating help pages for package `RmSQL' Form...

Hi, I am wondering if anyone has had experience w/the R database packages: RMySQL, RODBC, RPgSQL, and/or RmSQL, and if so, if you have any recommendations to make. We have some large tables we would like to store -- something like 5-10 columns by 3.5 mil rows (or maybe 7 mil rows). thanks, Natalie Hawkins Statistical Research Associate FHCRC/Scharp -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-...

...-commercial purposes. See file README for details. URL: http://www.r-project.org Index of Contents (Text) Reference Manual (PDF) Package Sources AnalyzeFMRI CoCoAn Devore5 EMV GLMMGibbs GenKern GeneSOM KernSmooth Matrix NISTnls Oarray PHYLOGR PTAk RArcInfo RMySQL RODBC RPgSQL RandomFields RmSQL Rstreams Rwave SASmixed SuppDists VR XML acepack adapt akima ash bindata blighty boot bootstrap bqtl car cclust cfa chron cluster cmprsk coda conf.design cramer date diamonds dse e1071 ellipse event.chart exactRankTests fastICA fdim fields foreign fracdiff gafit gee geoR gld gregmisc gss ineq leaps...

...d) see e.g. http://dan.emsphone.com/oracle/server.815/a68022/sqlansi.htm or http://www.cs.yorku.ca/~seela/db2/db2u0/db2u010.htm#HDRCOMPSQL (3) directly using proprietary C-functions with the .C-Interface (4) waiting for the .Java interface and using JDBC (5) use the contributed package RmSQL from CRAN to access the freely available mSQL (close to commercial MySQL) (6) use an intermediate "glue" language such as Tcl (see http://www.scriptics.com/), which is expected to work for Oracle (oratcl) and Sybase, but not for DB2 or MS-SQL-Server Sorry, I haven't fou...

...ariaDB ahora tiene grafos, por si le sirve. Si compilo Rmysql no es un principiante, entonces pregunta de principiante ¿si solo usa odbc? Le pregunto esto porque cuándo yo usaba mac compre a una empresa " conexión odbc" para base de datos, mysql tiene odbc y en R hay una librería para Rmsql en dll que no estaba disponible, de pronto puede saltar Rmysql y por odbc leer y escribir en MariaDB a una mayor velocidad. Javier Marcuzzi El 07/05/2014 03:07 p.m., Patricio Fuenmayor Viteri escribió: > Ok... gracias por las respuestas ...Bueno estoy tratando de usar en windows ... lamentab...

...y an f2c problem. Ans subselect does not recognize f2c as a fortran compiler. ======================================================================= Complicated/interface packages which compile (almost) out-of-the-box ======================================================================= RPgSQL RmSQL RMySQL gtk RGtk (although we need to add a typedef for ulong to gtkAccessors.c) RSPerl XML (this gives a multiple defined symbol for xmlParserError, which is defined in Utils.c but also in libxml.dylib -- I commented out the routine in Utils.c, but this may be a bit heavy handed). Rpy rpvm RObject...

....failed! checking for package locfit ...failed! checking for package RQuantLib ...failed! checking for package agce ...failed! checking for package lasso2 ...failed! checking for package Matrix ...failed! checking for package rpvm ...failed! checking for package tree ...failed! checking for package RmSQL ...failed! checking for package VR ...failed! checking for package wle ...failed! checking for package e1071 ...failed! checking for package mda ...failed! checking for package bindata ...failed! checking for package nlme ...failed! You can download them from: ftp://www.alex.wh.tu-darmstadt.de/pub...

Hi all, I use a function update.packages to update all packages in my R instalation. But I need compare one by one packages to discovery new packages. My question is: Exist in R any function that compare all installed packages in my R and all packages available in CRAN and return a list of the new packages (ie packages that I dont have im my installation) and automatic download and install

I have just finished a first rough cut of RODBC, a database connectivity addon. In theory it should allow access to any odbc compliant database for which the driver set is installed. On unix this includes MySQL, mSQL and postgres using the unixODBC set. On windows it should include access, sqlserver etc if the odbc drivers are installed. For those who have never taken an interest in this,

Can anyone give advice how to interactively exchange data between R and SQL-Databases like DB2, ORACLE, MS-SQL-Server ? If the answer is: 'currently not', this would be information for me as well. I will summarize to the list. Best regards -- Dr. Jens Oehlschl?gel-Akiyoshi MD FACTORY GmbH Bayerstrasse 21 80335 M?nchen Tel.: 089 545 28-27 Fax.: 089 545 28-10 http://www.mdfactory.de

...le it did work under 10.1). The problem with ROracle, RSQLite, RQuantlib is that they need libraries which I do not have. In Omegahat Perl from R and Python from R work, the other way around I don't know. RXLisp does not compile any more. what builds -- Everything from CRAN, including RMySQL, RmSQL, XML, rpvm, rsprng, RMpi, but not ROracle, RSQLite, RQuantlib -- Lindsay packages rmutil, gnlm, stable, growthm repeated, event, ordinal -- Bioconductor packages Biobase, annotate, affy, AnnBuilder, edd, genefilter, geneplotter, rhdf5, marrayTest, marrayClasses, marrayInput, marrayPlo...

R is not for Relational, but could be... I was musing on data.frames when I decided what I needed was a SQL like 'select' statement. Before I get involved in writing something like that, has anyone else written anything that allows a relational like algebra on data.frames? Thanks, John Carter EMail: ece at dwaf-hri.pwv.gov.za Telephone : 27-12-808-0374x194 Fax:-

howdy R friends, Can anyone help me with converting a ''unix'' date (seconds since 1970) into something readable? There doesn''t seem to be anything in the ''date'' package and the prospect of calculating this myself doesn''t excite me. thanks, John Strumila -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help

Hola a todos...estoy usando MariaDb como base de datos (similares caracteristicas a MySQL), y la conexión entre R y esta con RODBC.¿Existe alguna forma de incrementar la conexión para carga de datos ya que son largos, ejm: 3000 registros en 1 minuto...Si conocen de esto o me pueden sugerir alternativas, estaré agradecido. Patricio. [[alternative HTML version deleted]]

Estimados compañeros estoy con un trabajo sobre redes pathfinder y quería saber si conocéis alguna librería o función para dada la matriz de proximidades sacar la matriz de la red pathfinder. Un cordial saludo y un mejor año 2013. Juan -- ========================================================= Juan Antonio Gil Pascual Prof. Titular de Metodología Cuantitatíva correo: jgil en edu.uned.es