similar to: activerecord and ruby-dbi

Does anybody know why activeRecord is not built on top of ruby-dbi? I am curious about the reasoning behind the decision. Was it performance? Complexity? Databases support, ease of installation or something else. Let me know if anybody knows why. Thanks Diego --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

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

To Whom It May Concern: I have an ActiveRecord-based application (non-Rails). Life was grand until I upgraded ActiveRecord yesterday, after which point I was getting TONNES of these errors from my app and in PostgreSQL''s logs: FATAL: terminating connection due to administrator command According to Google searching, this happens when an external process sends PostgreSQL SIGINT or

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.

I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql but am having problems with the rails part. I can connect to the database using sqsh so I think all the freetds plumbing is good. When I try to connect to the db with a rake db:migrate or just using script/ console I get this error: >> Client.find(:first) DBI::InterfaceError: Unable to load driver

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

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, Is there an easy way of querying an active record for a maximum column value? I need to do queries like: SELECT MAX(salary) FROM employees TIA, Jeroen

Hi, I''m trying to use :through and STI using the trunk version of Rails, but I get the following error see bottom of this msg[1] here are my classes. class Player < ActiveRecord::Base end class Ladder < ActiveRecord::Base has_many :subscriptions has_many :players, :through => :subscriptions end class SingleLadder < Ladder end class Subscription <

Hi, I have a class Match that looks like this (simplified) class Match < ActiveRecord::Base belongs_to :opp1, :class_name => "Player", :foreign_key => "opp1_id" belongs_to :opp2, :class_name => "Player", :foreign_key => "opp2_id" belongs_to :winner, :class_name => "Player", :foreign_key => "winner_id" end Can I

I noticed that some of the ActiveRecord adapters depend on ruby-dbi. I''ve just started to play with the ruby-dbi database driver DBD::Proxy, which allows me to connect to other ruby-dbi drivers running on other operating systems. What seems more practical, developing a ActiveRecord database adapter for DBD::Proxy, or would you just target a specific database, and just depend on

Hi, I''ve been playing around with using DBI instead of ActiveRecord ''cause I just love to beat myself up! ;) Is this an okay way to do this, or is there any other more creative ways? require ''dbi'' module MyApp:Models class DB def self.dbh DBI.connect(''DBI:Mysql:dbname'', ''username'',

Hi I''m trying to use the Typo wordpress converter script, but it requires that the wordpress database is accessible over the connection to the Typo database. To get around this, I''m trying to use ActiveRecord::establish_connection (...) to get a connection object to run the raw SQL queries that Typo''s wordpress converter uses on. It doesn''t work with Ruby

Hi, I''m getting some trouble in connecting to a sql server 2000 database with ActiveRecord-2.0.1 and ruby 186-26, from win XP. Using the next conenction config: ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :database => "nombre_bd", :username => "usu", :password => "contra" ) I have the next error:

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

Hi, Disclaimer: I''m pretty sure this isn''t a mongrel issue, as I''m pretty sure I had the same problem back in the lighty-fastcgi days.. After a postgres restart, my rails apps crash with this error: ActiveRecord::StatementInvalid (PGError: FATAL: terminating connection due to a dministrator command server closed the connection unexpectedly This probably

Hi, Some controller filters: before_filter :require_logged_in, :only => [:create, :new, :confirm] before_filter :init_players, :only => [:create, :new, :confirm] The first one, you guessed it, redirects a user if he''s not logged in. Now when I hit this page and I''m not logged in, the 2nd filter gets executed and throws an error, because it depends on the user

Hi, I''ve got a table with an inserted_at column. When I insert a record it automatically injects the current date/time, all is well. Then when I insert a second record, it uses the exact same timestamp that is used in the first record. This behavior only seems to occur in production mode. When I restart the server, the problem goes away but then immidetatly occurs again on the

Hi, I''m looking to create a ruby script that loads a bunch of records and manipulates these. Where do I start? I got this to begin with: #!/usr/bin/env ruby require File.dirname(__FILE__) + ''/../config/boot'' players = Player.find :all But it complains about a DB connection. How do I set this up? Jeroen

Howdy. I''m trying to work with a legacy SQL Server database where some of the table names have spaces in them. I''ve done set_table_name "tablename with spaces", but I can''t get find(:all) to work. I get the following error (because apparently it''s not putting [ ] around the name as is required for SQL Server for names with spaces.