Querying postgresql db using ruby

[akelabanda]

Hi

I'm a newbie with ruby. Have an installation of ruby 1.8.4 on windows xp (for some test automation stuff). From here I would like to query some tables on our postgresql DB on a remote linux box.

What do I need to do to query the postgresql db on linux using ruby on windows ?

Thanks for your help in advance.

Regards
Raj

UK's best mobile deals online

http://www.bargainmobileshop.com

 

[nrasch]

Raj:

I don't use PostGresSQL, so I'm going to be of limited help. However, here are some links I found that might guide you in the right direction:

1)

http://www.ruby-forum.com/topic/134734

2)

http://readlist.com/lists/lists.rubyonrails.org/rails/5/29525.html

3)

http://craiccomputing.blogspot.com/2008/03/ruby-activerecord-and-postgresql.html

On that last link, take a look at how he builds his connection string. I would think if you replicated something like that in your config/database.yml file you'd be able to connect remotely. Something like:

<quote>
development:
adapter: postgresql
database: <name of your database>
username: <user name>
password: <password>
host: <IP of your remote database>
</quote>

I hope that helps in some fashion or another....

Nathan

Want to learn Chinese?

http://www.gatewaychina.net