Ruby Way Connection Database

This side is just a general, specific to see the document itself.

1 Connection SQLite:

Require ' SQLite '
db = SQLite::D atabase.new ("library.db")
db.execute ("Select Title,author from　Books ") Do |row|
p row end
db.close　　　　　

2 connection MySQL:

Require ' MySQL '
m = mysql.new ("localhost", "name", "Password", "Maillist")
r = M.query ("SELECT * FROM People order by name "
R.each_hash does |f|
print" #{f[' name '}-#{f[' email '} "
end　

3 Connections to PostgreSQL:

Require ' postgres '
conn = Pgconn.connect ("", 5432, "", "", "TestDB")
conn.exec ("CREATE Table Rtest" (Numb ER integer default 0); "
Conn.exec (INSERT into rtest values (?)
res = conn.query ("SELECT * from Rtest")
# res ID [[' 99]]