similar to: Does anybody know why activeRecord is not built on top of ruby-dbi?

I am curious about the opinionated opinion behind the decision.Was it performance? Complexity? Databases support or something else. I recently used Ruby:dbi and liked all the metadata that comes with the data. Performance looked good but I didn''t benchmark it so I don''t know which one execute faster. If I am not wrong Ruby:dbi offers true parameters binding which would be nice

Hi, Just wondering: does anybody know if ActiveRecord has been built entirely from scratch or if it''s inherited (a lot of) functionality from ruby-dbi? Jeroen

I have a standalone batch program that is going to move data between two databases. I am taking advantage of the AR connection semantics in database.yml to get connections to these two DBs. But I want to do all of my DB access at the DBI/DBD level for performance reasons. I am having trouble getting access to the underlying DBI handle so that I can prepare SQL statements, execute them etc.

require ''dbi'' # 0.4.2 dbh = DBI.connect(''DBI:ODBC:PACS'', ''username'', ''password'') This works in IRB; in Rails it fails (taken from Rails console): DBI::InterfaceError: Unable to load driver ''ODBC'' (underlying error: uninitialized constant DBI::DBD::ODBC) from

Hi. I frequently use RMySQL package to interface R with MySQL databases. I was having a try with package DBI and I got the following error: > library(RMySQL) > library(DBI) > drv <- dbDriver("MySQL") > ch <- dbConnect(drv, dbname="mydb", user="myuser", password="mypasswd") > ibm <- dbGetQuery(ch,"select * from table where

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

Hi, I'm trying to use R's DBI interface but it appears to be broken. I am using R 1.8.0 on Linux, and have just installed DBI 0.1-6 through the command 'install.packages("DBI")'. Installation went fine, but now when I try to do a simple dbConnect(), it won't do anything besides complaining about an internal error: > library(DBI) > dbConnect(anything) Error

Hello guys, I was told by the client to install Perl DBI version 1.52 on a el6 box, by default el6 branch comes with DBI version 1.6x, this version is AFAIK not the desired one. First I tried installing DBI 1.52 from some rpm package [1], which had some dependencies, Perl 5.8.8 and dbd.4.4.x, this last package was also present el6, so it made conflict and it was not possible to install DBI 1.52

Hi all, I would like the following code to work, but it doesn't: library(DBI) library(RODBC) m <- dbDriver("RODBC") # Example for dbConnect(DBI), causes error m <- dbDriver("ODBC") # Example for DBIDriver-class(DBI), causes error The errors are: Error in do.call(as.character(drvName), list(...)) : could not find function "RODBC" (substitute

Has anybody gotten Apache-DBI to work under CentOS4? My installed rpms are: httpd-2.0.52-12.1.ent.centos4 (came with CentOS4) mod_perl-1.99_16-4.centos4 (came with CentOS4) perl-Apache-DBI-0.94-1.2.el4.rf (from Dag's site) --this includes Apache::DBI and Apache::AuthDBI In my '/etc/httpd/conf/httpd.conf' file, I added: PerlModule Apache::DBI

Hi everyone, I have been following these forums closely for the last few months but this is my first time posting. Basically I am trying to get an Oracle SQL Developer Binary Large Object(BLOB/CLOB) file in as an R object in R. For those not familiar with a BLOB/CLOB file, it is basically lik a table that has cells that contain tables or files. By converting the large table into a BLOB/CLOB file

Hello, I have installed the ROracle and DBI packages, and I want to access an Oracle database that is not on the same machine as the one I am running R on. I can access the database remotely with perl DBI and Java JDBC. Does anyone know if this is possible using R DBI/ROracle ? I have looked through the documentation and also tried to guess at things which might work, but with no success. I

I wrote a rexml script that parses rather big xml files (DOM parsing) and builds an object out of them. This is what it looks like after i parse the xml file and display the object: [#<Article:0xb79e7428 @brand="This is a story from ", @id=5337, @fblurb="burb", @ntype="news type here", @copy="Copyright \302\251 2006 ", @source="source",

https://rhn.redhat.com/errata/RHSA-2005-069.html refers Updated files are :- updates/i386/RPMS/perl-DBI-1.32-9.i386.rpm updates/i386/SRPMS/perl-DBI-1.32-9.src.rpm To update run 'yum update perl-DBI' Lance -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed

https://rhn.redhat.com/errata/RHSA-2005-069.html refers Updated files are :- updates/x86_64/RPMS/perl-DBI-1.32-9.x86_64.rpm updates/x86_64/SRPMS/perl-DBI-1.32-9.src.rpm To update run 'yum update perl-DBI' Tru Huynh -- http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xBEFA581B -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type:

Hi, Has anyone seen this problem before, and does anyone have a solution? When I query a database using DBI and ROracle to retrieve a date in a format other than the system default, I get a core dump. System: Redhat Linux 7.3 uname: Linux 2.4.20-20.7smp #1 SMP Mon Aug 18 14:46:14 EDT 2003 i686 Oracle version 8i R --version: R 1.7.1 (2003-06-16). DBI_0.1-6, ROracle_0.5-0 Start up R, load

I'm trying to load an annotation file on a new R installation on a new machine (Win 7 x64, R 2.15.0) Loading this package fails; I've tried re-installing R and BioC from scratch, including all new packages etc, to no avail. Any ideas? > require("hugene10sttranscriptcluster.db") Loading required package: hugene10sttranscriptcluster.db Loading required package: AnnotationDbi

Hi, I'm running Debian (Sid), Postgres (7.3.4) and R (1.8.1). I get the following error when I tri to use DBI >library("DBI") > p <- dbDriver("PostgreSQL") Error in do.call(as.character(drvName), list(...)) : couldn't find function "PostgreSQL" Is there any other package I need in order to interface between R and Postgres ?

Hello everyone! Congratulations by this gorgeous software. My name is Germán Carrillo, I'm writting from Colombia. I don't have much experience with R, reason why I use the R-GUI (version 2.5.1) on Windows. I have some problems with DBI package, I want to connect to PostgreSQL database but I don't know the way to do it. I was reading the DBI manual and I tried write in my R Console

can anybody provide a reference to a document on using DBI and what is needed to make it work? I try: drv=dbDriver("Oracle") and it complains about not finding a function. The DBI.pdf does not require anything else installed, but looking at the archive I discovered there is more stuff to be installed. This is on Solaris 5.10 with a full Oracle install, so all Oracle libs are