From: Carl Woodward <cjwoodward@...>
Date: 2006-01-03T18:30:39+09:00
Subject: Re: macworld

Hi Hampton,

I hope I'm not repeating what anyone else is said but you can get
mysql bindings to work by:


Compiling and installing ruby, gems, etc and setting up mysql based on
the guide below:
http://hivelogic.com/articles/2005/12/01/ruby_rails_lighttpd_mysql_tiger

At the bottom of the mysql section it has:
sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql

Do this and then go read through this url:
file:///usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/README.html

Which basically says go to the mysql gems directory (from above) and
do the following:
- ruby extconf.rb --with-mysql-dir=/usr/local/mysql
- make
- su
- ruby ./test.rb [hostname [user [passwd [dbname [port [socket [flag]]]]]]]
I got one error from this test, on the test_fetch_double test but the
result seems fine.
- make install

After you do this  you can run ruby mysql fine. A sample bit of code is below:

require 'mysql'

m = Mysql.new("localhost", "root", "")
m.select_db("dbname")

result = m.query("select * from table")

result.each do |row|
  row.each do |val|
    puts val
  end
end


As an aside, I bought a mac a few days ago and love it. I bought the
17". I've written a blog:
http://carlwoodward.blogspot.com/

Hope this helps and you stick with your mac.

Cheers,
Carl.

On 1/3/06, Devin Mullins <twifkak@comcast.net> wrote:
> While we're hijacking this thread for our own purposes, I have a couple
> of requests for OS X software that might exist, but I can't find:
>
> - I'd like to press a crazy, unused modifier combo (say, Shift-Alt) and
> have click-and-drag move the entire window that I'm
> clicking-and-dragging on. I'm tired of slogging all the way to the top
> of the window just to move it.
> - I generally have gem_server, plus one or two rails servers of my own
> running, and because I like to be able to a)flip to the logs quickly,
> and b)start/stop the servers in very few keypresses, I generally keep
> 'em each open in their own Terminal window. That creates clutter
> quickly. Now, I might investigate 1)screen, 2)iTerm, 3)creating my own
> start/stop daemonizer bash script for the purpose, but what I'd really
> like is a stupid little Cocoa app that I could wire up to random shell
> scripts, and that gave me a bunch of Start/Stop and View Log buttons,
> akin to the System Controls thing that the MySQL dmg gives me.
> Basically, Locomotive, but without using Locomotive. :)
>
> Sorry about that...
>
> Chad Perrin wrote:
>
> >On Tue, Jan 03, 2006 at 08:32:51AM +0900, Kevin Brown wrote:
> >
> >
> >>On Monday 02 January 2006 14:45, Chad Perrin wrote:
> >>
> >>
> >>>I keep flirting with the idea of getting a Mac in here, but keep
> >>>discarding it with the realization that A) I probably wouldn't use it
> >>>much and B) I still don't like one-button mice (which would be something
> >>>of a problem since I'd probably want to get a laptop).
> >>>
> >>>
> >>They give you a mighty mouse now anyway, so A is your only problem.
> >>
> >>
> >
> >I direct your attention again to my reference to laptops.
> >
> >
> >
>
>
>


--
Carl Woodward
0412218979
cjwoodward@gmail.com