How to connect to Mysql & Query for Database Tables

[Idealone Ideally]

Hi Guys,
Ruby imposes several way of connecting to Mysql (DBI,activerecord..)
Database using ruby code. Let me know if anybody knows how to connect to
mysql the easiest way.
I am getting all sorts of error trying to connect to mysql. I am using
Windows XP OS.
Hope to hear from you guys soon!!

Cheers

 

[Jeff Peng]

Hi Guys,
Ruby imposes several way of connecting to Mysql (DBI,activerecord..)
Database using ruby code. Let me know if anybody knows how to connect to
mysql the easiest way.

DBI is generally an easy way.
http://www.kitebird.com/articles/ruby-dbi.html

You have to
gem install mysql
gem install dbd-mysql
gem install dbi
before using it.

HTH.

 

[Idealone Ideally]

DBI is generally an easy way.
http://www.kitebird.com/articles/ruby-dbi.html

You have to
gem install mysql
gem install dbd-mysql
gem install dbi
before using it.

HTH.

Hi,

On Trying, " gem install mysql " , i get the following error:

C:\Documents and Settings\user1\Desktop>gem install mysql
Building native extensions. This could take a while...
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

D:/Softwares/ruby/bin/ruby.exe extconf.rb
checking for main() in libmysql.lib... no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for mo
details.

Thanks

 

[Jeff Peng]

On Trying, " gem install mysql " , i get the following error:

C:\Documents and Settings\user1\Desktop>gem install mysql
Building native extensions. This could take a while...
ERROR: Error installing mysql:
ERROR: Failed to build gem native extension.

D:/Softwares/ruby/bin/ruby.exe extconf.rb
checking for main() in libmysql.lib... no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for mo
details.

Well, you have to install mysql client before all the operation.
There have to be:

/usr/lib/libmysqlclient.a
/usr/lib/libmysqlclient.so

in my Linux OS.

Jeff.

 

[Albert Schlef]

Hi Guys,
Ruby imposes several way of [...] using ruby code.

That's certainly an interesting observation.

 

[Idealone Ideally]

Hi Guys,
Ruby imposes several way of [...] using ruby code.

That's certainly an interesting observation.

Guys,
I eventually got it working, just adding gem 'dbi'..


require "rubygems"
gem "dbi"
require "dbi"

def connect_to_mysql()
puts "\nConnecting to MySQL..."
me = DBI.connect("dbi:MysqlBname:localhost", "root", "")
query = me.prepare("SELECT * FROM browsers where id > ?")
query.execute(0)
while row = query.fetch() do
puts row
end


Thanks