Ruby で MySQL に接続できるようにする
いつになったら、Ruby 1.9 系で安定して MySQL に接続できるようになるのだろうか。
MySQL は XAMMP でインストールされるものを利用。
C:\>ruby -v ruby 1.8.7 (2009-12-24 patchlevel 248) [i386-mswin32] C:\>gem install dbi Successfully installed deprecated-2.0.1 Successfully installed dbi-0.4.3 2 gems installed Installing ri documentation for deprecated-2.0.1... Installing ri documentation for dbi-0.4.3... Installing RDoc documentation for deprecated-2.0.1... Installing RDoc documentation for dbi-0.4.3... C:\>gem install dbd-mysql Successfully installed dbd-mysql-0.4.3 1 gem installed Installing ri documentation for dbd-mysql-0.4.3... Installing RDoc documentation for dbd-mysql-0.4.3... C:\>irb irb(main):001:0> require 'rubygems' => true irb(main):002:0> require 'dbi' => true irb(main):003:0> dbh = DBI.connect('DBI:mysql:database:localhost', 'user', 'password') => #<DBI::DatabaseHandle:0x2d72984 @driver_name="Mysql", @trace_mode=nil, @handle=#<DBI::DBD::Mysql::Database:0x2d72678 @have_transactions=true, @handle=#<Mysql:0x2d72754>, @attr={"AutoCommit"=>true}, @mutex=#<Mutex:0x2d72524>>, @trace_output=nil, @convert_types=true> irb(main):004:0> dbh.select_one('SELECT VERSION()') => ["5.1.33-community"] irb(main):005:0>