[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

how can I connect ruby with postgreSQL

Vellingiri Arul

9/19/2007 10:11:00 AM


Dear Friends,
how can I connect ruby with postgreSQL.
Please give some procedure.
how can I install the proper packages and what are the configurations I
am going to made.
what are the steps I have to follow that's what all I want.

by
Vellingiri
--
Posted via http://www.ruby-....

3 Answers

Damjan Rems

9/20/2007 5:55:00 AM

0

Vellingiri Arul wrote:
>
> Dear Friends,
> how can I connect ruby with postgreSQL.
> Please give some procedure.
> how can I install the proper packages and what are the configurations I
> am going to made.
> what are the steps I have to follow that's what all I want.
>
> by
> Vellingiri

Google for "ruby DBI"

Examples:
dbh = DBI.connect('DBI:Pg:mydb', 'user', 'pwd')
rs = dbh.select_all("select * from table where id = '#{someID}'")
dbh.do("update table set num=#{n} where id='#{someID}'")

sth = dbh.prepare("INSERT INTO table (v1,v2,v3,v4) VALUES(?, ?, ?,
?)")
sth.execute('a', 'b', 'c', d)

by
TheR
--
Posted via http://www.ruby-....

Vellingiri Arul

9/20/2007 7:14:00 AM

0

Damjan Rems wrote:
> Vellingiri Arul wrote:
>>
>> Dear Friends,
>> how can I connect ruby with postgreSQL.
>> Please give some procedure.
>> how can I install the proper packages and what are the configurations I
>> am going to made.
>> what are the steps I have to follow that's what all I want.
>>
>> by
>> Vellingiri
>
> Google for "ruby DBI"
>
> Examples:
> dbh = DBI.connect('DBI:Pg:mydb', 'user', 'pwd')
> rs = dbh.select_all("select * from table where id = '#{someID}'")
> dbh.do("update table set num=#{n} where id='#{someID}'")
>
> sth = dbh.prepare("INSERT INTO table (v1,v2,v3,v4) VALUES(?, ?, ?,
> ?)")
> sth.execute('a', 'b', 'c', d)
>
> by
> TheR

Ok Friends,
Whatever you told and you gave one link know that link was very
useful for me.
But I am having only postgreSQl,Using that how can I able to install.
And also i have got lot of information form that site.
But ,I was unable to findout the proper solution for this.
Please explain clearly.

by
Vellingiri.
--
Posted via http://www.ruby-....

Marcin Raczkowski

9/20/2007 9:12:00 AM

0

Vellingiri Arul wrote:
> Damjan Rems wrote:
>> Vellingiri Arul wrote:
>>> Dear Friends,
>>> how can I connect ruby with postgreSQL.
>>> Please give some procedure.
>>> how can I install the proper packages and what are the configurations I
>>> am going to made.
>>> what are the steps I have to follow that's what all I want.
>>>
>>> by
>>> Vellingiri
>> Google for "ruby DBI"
>>
>> Examples:
>> dbh = DBI.connect('DBI:Pg:mydb', 'user', 'pwd')
>> rs = dbh.select_all("select * from table where id = '#{someID}'")
>> dbh.do("update table set num=#{n} where id='#{someID}'")
>>
>> sth = dbh.prepare("INSERT INTO table (v1,v2,v3,v4) VALUES(?, ?, ?,
>> ?)")
>> sth.execute('a', 'b', 'c', d)
>>
>> by
>> TheR
>
> Ok Friends,
> Whatever you told and you gave one link know that link was very
> useful for me.
> But I am having only postgreSQl,Using that how can I able to install.
> And also i have got lot of information form that site.
> But ,I was unable to findout the proper solution for this.
> Please explain clearly.
>
> by
> Vellingiri.
not clearly:
RFTM

clearly
read documentation on ruby-postgres
read pickaxe,
use google

this question(or similar like how to use mysql, or Active Record outside
rails) was answered already many times, on this mailing list, on blogs,
in documentation there are examples, noone here will write software for
you(well i can my hourly rate is only $10)