SQLite$B%i%$%V%i%j(B

NARUSES_Yui · May 15, 2009, 4:13pm

æˆç€¬ã§ã™ã€‚

Ruby 1.9ã§SQLiteãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’æ¨™æº–æ·»ä»˜ã—ã¾ã›ã‚“ã‹ï¼Ÿ

æ—§æ¥ã‹ã‚‰sqlite3-rubyã¨ã„ã†ç‰©ã¯å˜åœ¨ã—ã¦ã„ã¾ã—ãŸãŒã€
http://rubyforge.org/projects/sqlite-ruby
http://sqlite-ruby.rubyforge.org/sqlite3/

nativeã§ãªãdlçµŒç”±
ä½œè€…ãŒãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹çµ‚äº†ã‚’å®£è¨€
http://weblog.jamisbuck.org/2009/2/25/net-ssh-capistrano-and-saying-goodbye
ã¨ã„ã†è‡´å‘½çš„ãªç‰©ã‚’å«ã‚€å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚

ã“ã‚Œã«å¯¾ã—ã¦ä»Šå›žæ–°ã—ãèµ·ã“ã—ãŸãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã¯ã€

nativeã‹ã¤ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªå®Ÿè£…
ãã‚Œãªã‚Šã«ã‚„ã‚‹æ°—ã®ã‚ã‚‹ãƒ¡ãƒ³ãƒ†ãƒŠ
ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚

ä½¿ã†éš›ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªæ„Ÿã˜ã«ãªã‚Šã¾ã™ã€‚
å¤šæ®µtransactionã‚„backupãŒç‰¹å¾´ã§ã—ã‚‡ã†ã‹ã€‚

SQLite.open(“:memory:”) do |db|
db.transaction do
db.exec(“CREATE TABLE foo (int INTEGER, text TEXT)”)
10.times do |i|
db.exec(“INSERT INTO foo VALUES (#{i}, ‘foo’)”)
end

  p db.exec("SELECT * FROM foo")[0][9999]
  p db.exec("SELECT * FROM foo")[0].colnames

  db.transaction do
    10.times do |i|
      db.exec("INSERT INTO foo VALUES (#{i}, 'foo')")
    end
    db.rollback
  end

  SQLite.open(":memory:") do |db2|
    db.backup(db2)
  end
end

end

ã”æ„è¦‹ç‰ã‚ã‚Œã°ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚

NARUSES_Yui · May 15, 2009, 4:23pm

e$B@uN$$H?=$7$^$9!#e(B

JRubye$B$r;H$&?HJ,$H$7$F$Oe(BFFIe$B7PM3$G$d$C$F$/$l$k$HM-$jFq$$$G$9!#e(B
e$B!VI8=`!W$H$$$&Lu$K$O9T$+$J$/$J$C$A$c$$$^$9$1$I!#e(B

–
Hirotsugu A.

NARUSES_Yui · May 15, 2009, 5:01pm

e$B@uN$$G$9!#e(B

On May 15, 2009, at 9:44 AM, NARUSE, Yui wrote:

e$B$^$!!"e(BSQLitee$B%l%Y%k$Oe(BJRubye$B$G$bD>@%5%]!<%H$7$?J}e(B
e$B$,$$$$5$$,$7$^$9$1$I!#e(B

–
NARUSE, Yui [email protected]

e$BD>@$d$k$K$O;d$O$"$^$je(BJavae$BCN$j$^$;$s$+$i!D:$$C$A$c$$$^$9$M!#e(B

e$B<B$r8@$&$H!">/$7$@$1$G$9$,e(Bsqlite3-rubye$B$N%I%i%$%P!<$H$7$Fe(BFFI
e$B;H$C$?$d$D=q$-;O$a$F$?$s$G$9$h$M!#e(B
e$B$I$&$7$h$&$+$J!D!#e(B

e$B$b$7e(BSQLitee$B$rI8=`E:IU$9$k$H!"e(BJRubye$B$H$N7s$M9g$$$O$Ie(B
e$B$&$J$C$A$c$&$s$G$7$g$&$+!#e(B
e$B!J$3$l$OB>$NJ}!9$N0U8+$,=P$F$+$i$G$$$$$N$+!#!Ke(B

NARUSES_Yui · May 15, 2009, 4:45pm

e$B@.@%$G$9!#e(B

Hirotsugu A. wrote:

e$B@uN$$H?=$7$^$9!#e(B

JRubye$B$r;H$&?HJ,$H$7$F$Oe(BFFIe$B7PM3$G$d$C$F$/$l$k$HM-$jFq$$$G$9!#e(B
e$B!VI8=`!W$H$$$&Lu$K$O9T$+$J$/$J$C$A$c$$$^$9$1$I!#e(B

e$B$=$b$=$be(BFFIe$B$,:#I8=`E:IU$G$O$"$j$^$;$s$+$i$M$’!#e(B

e$B$^$!!"e(BSQLitee$B%l%Y%k$Oe(BJRubye$B$G$bD>@%5%]!<%H$7$?J}$,$$$$5$$,$7$^$9$1$I!#e(B

NARUSES_Yui · May 15, 2009, 5:14pm

e$B$3$s$P$s$O!#e(B

In message [email protected]
on Fri, 15 May 2009 23:12:33 +0900,
“NARUSE, Yui” [email protected] wrote:

e$B:n<T$,%a%s%F%J%s%9=*N;$r@k8@e(B
http://weblog.jamisbuck.org/2009/2/25/net-ssh-capistrano-and-saying-goodbye
e$BG3$(?T$-$?e(B…!?

e$B$3$l$KBP$7$F:#2s?7$7$/5/$3$7$?%i%$%V%i%j$G$O!"e(B

nativee$B$+$D%3%s%Q%/%H$J<BAue(B

e$B$=$l$J$j$K$d$k5$$N$“$k%a%s%F%Je(B
e$B$H$$$&MxE@$,$”$j$^$9!#e(B
e$B?7$7$$%i%$%V%i%j$O!"$=$l$O$=$l$GNI$$$3$H$H;W$$$^$9!#e(B

e$B$?$@!"$?$V$s;d$O$h$/$o$+$C$F$$$J$$$N$@$H;W$$$^$9$,!"e(BRubye$B$KI8=`E:IU$,e(B
e$BI,MW$JM}M3$O2?$G$7$g$&$+e(B?

e$BI8=`E:IU$H$J$k$H!"e(B

o Rubye$BK\BN$N%F%9%H$Ke(Bsqlitee$B$,$J$$$H:$$k!#e(B
o
e$B%Q%C%1!<%8!&%7%9%F%`$G!"e(Brubye$B$N%Q%C%1!<%8$Oe(Bsqlitee$B$K0MB8$7$J$$$H$$$1$Je(B
e$B$/$J$k!#e(B

e$B$H$$$&$3$H$K$J$k$N$G$7$g$&$+!#e(Bsqlitee$B$bHf3SE*%P!<%8%g%s$N99?7$,B?$$$3$He(B
e$B$b$"$k$N$G!"8e<T$N>u67$OHr$1$?$$$H$3$m$G$9!#e(B

e$B%Q%C%1!<%8!&%7%9%F%`$NJ}$GJL$N%Q%C%1!<%8$KJ,$1$k$3$H$b2DG=$G$O$"$j$^$9e(B
e$B$,!"JL$N$b$N$rJL$K%Q%C%1!<%8$K$^$H$a$k$N$H!“85$Oe(B1e$B$D$N$b$N$rJL$1$F%Q%Ce(B
e$B%1!<%82=$9$E$N$G$O!”:G=i$+$iJL$l$F$$$?J}$,2?$+$H<j4V$O>/$J$$$H8@$($^$9!#e(B

NARUSES_Yui · May 15, 2009, 5:34pm

e$B@.@%$G$9!#e(B

Takahiro K. wrote:

e$B?7$7$$%i%$%V%i%j$O!"$=$l$O$=$l$GNI$$$3$H$H;W$$$^$9!#e(B

e$B$?$@!"$?$V$s;d$O$h$/$o$+$C$F$$$J$$$N$@$H;W$$$^$9$,!"e(BRubye$B$KI8=`E:IU$,e(B
e$BI,MW$JM}M3$O2?$G$7$g$&$+e(B?

e$B:GBg$NM}M3$O%l%s%?%k%5!<%PEy$Ge(BSQLitee$B$,3N<B$K>uBV$G$"$k$h$&$K$9$k$?$a$G$9!#e(B
e$B8=>u$G$b1JB32=$N<jCJ$Oe(BSDBMe$B$d$ie(BPStoree$B$d$ie(BYAML::Storee$B$d$i$,$"$k$s$G$9$,!"e(B
RDBe$B$,$J$$$H$I$&$K$b$D$i$$$N$G!#!#!#e(B

e$BI8=`E:IU$H$J$k$H!"e(B

o Rubye$BK\BN$N%F%9%H$Ke(Bsqlitee$B$,$J$$$H:$$k!#e(B
o e$B%Q%C%1!<%8!&%7%9%F%`$G!"e(Brubye$B$N%Q%C%1!<%8$Oe(Bsqlitee$B$K0MB8$7$J$$$H$$$1$Je(B
e$B$/$J$k!#e(B

e$B$H$$$&$3$H$K$J$k$N$G$7$g$&$+!#e(Bsqlitee$B$bHf3SE*%P!<%8%g%s$N99?7$,B?$$$3$He(B
e$B$b$"$k$N$G!"8e<T$N>u67$OHr$1$?$$$H$3$m$G$9!#e(B

e$B%F%9%H$O%Q%C%A$K$bBgL#$JJ*$,0l1~$D$$$F$$$^$9$M!#e(B
e$B$3$l$O<h$j9~$_$^$G$K$b$C$H$^$H$b$JJ*$K$7$^$9!#e(B

e$B%Q%C%1!<%8!&%7%9%F%`$NJ}$GJL$N%Q%C%1!<%8$KJ,$1$k$3$H$b2DG=$G$O$"$j$^$9e(B
e$B$,!"JL$N$b$N$rJL$K%Q%C%1!<%8$K$^$H$a$k$N$H!“85$Oe(B1e$B$D$N$b$N$rJL$1$F%Q%Ce(B
e$B%1!<%82=$9$E$N$G$O!”:G=i$+$iJL$l$F$$$?J}$,2?$+$H<j4V$O>/$J$$$H8@$($^$9!#e(B

e$B?@8M$5$s$N%Q%C%1!<%8$K$O$*@$OC$K$J$C$F$$$k$N$G6D$C$F$$$k$3$H$O$o$+$k$N$G$9$,!“e(B
e$B$o$?$7$H$7$F$O$=$3$r2?$H$+!”$H$$$&$3$H$K$J$j$^$9!#e(B

NARUSES_Yui · May 16, 2009, 2:46am

e$B?\F#$G$9!#e(B

In [email protected]
“[ruby-dev:38463] SQLitee$B%i%$%V%i%je(B” on Fri, 15 May 2009 23:12:33
+0900,
“NARUSE, Yui” [email protected] wrote:

Ruby 1.9e$B$Ge(BSQLitee$B%i%$%V%i%j$rI8=`E:IU$7$^$;$s$+!)e(B

e$BI8=E:IU$9$k$+$I$&$+$K4X$7$F$OFC$K0U8+$O$J$$$N$G$9$,!"$3$N<Be(B e$BAu!J$H$$$&$+e(BAPIe$B!K$GI8=E:IU$5$l$k$3$H$K$OH?BP$7$^$9!#e(B

e$B$3$l$KBP$7$F:#2s?7$7$/5/$3$7$?%i%$%V%i%j$G$O!"e(B

nativee$B$+$D%3%s%Q%/%H$J<BAue(B

e$B%3%s%Q%/%H$J<BAu$H$$$&$3$H$O=EMW$J$3$H$J$N$G$7$g$&$+!)e(B

e$BNc$($P!"e(Bsqlite3_bind_*e$BAjEv$N5!G=$ODs6!$5$l$F$$$J$$$N$G$9$,!"e(B
e$B$3$l$OI,MW$,$J$$$H$$$&$3$H$G$7$g$&$+!)e(B

e$B$^$?!“e(BSQLite3e$B$N%(%i!<$Oe(BArgumentErrore$B$+e(BRuntimeErrore$B$GJV$5$l$^e(B
e$B$9$,!“e(BSQLite::Busye$B$de(BSQLite::ReadOnlye$B$J$I@lMQ$NNc30%/%i%9$rJVe(B
e$B$7$FM_$7$$$G$9!#e(Bbusye$B$N$H$-$O>/$7BT$C$F$+$i$b$&0lEY;n$7$F$_$k!“e(B
e$B$H$$$&$h$&$J=hM}$r=q$/$3$H$,$”$k$H;W$$$^$9$,!”$=$N$H$-$K%(%i!<e(B
e$B%a%C%;!<%8$r@55,I=8=$G%^%C%A$5$;$Fe(Bbusye$B$J%(%i!<$+$I$&$+$rH=CGe(B
e$B$9$k$H$$$&$3$H$O$7$?$/$”$j$^$;$s!#e(B

e$BB>$K$b!“e(Bcolnamese$B$G$O$J$/$Fe(Bcolumn_namese$B$H$+e(Bcolumnse$B$K$7$FM_$7$$e(B
e$B$J$I:Y!9$7$?$b$N$,$”$C$?$j$7$^$9!#e(B

e$B$=$l$J$j$K$d$k5$$N$“$k%a%s%F%Je(B
e$B$H$$$&MxE@$,$”$j$^$9!#e(B

e$B$$$-$J$je(BRubye$B$KI8=E:IU$9$k$N$G$O$J$/$F!"$^$:!"FHN)%i%$%V%i%je(B e$B$H$7$F;H$C$F$b$i$C$F;H$$$K$/$$$H$3$m$J$I$N%U%#!<%I%P%C%/$r$be(B e$B$i$C$?8e$GI8=E:IU$r8!F$$9$k$H$$$&$N$G$OCY$$$G$7$g$&$+!)e(B

e$BI8=`E:IU$G$J$$$H7QB3E*$K%a%s%F%J%s%9$7$F$$$/$N$O$D$i$$!“$H$$e(B
e$B$&$3$H$G$”$l$P$=$l$OFq$7$$$+$b$7$l$^$;$s$,!#e(B

e$B$H$j$"$($:!"C1BN%F%9%H$NCf$Ge(Bpe$B$H$+e(Bppe$B$r;H$C$F$$$k>uBV$G$OI8=e(B e$BE:IU$K$J$C$FM_$7$/$J$$$G$9!#7QB3$7$F2~A1$5$l$F$$$/$N$G$"$l$P!"e(B e$B$"$kDxEY7QB3$7$F2~A1$5$l$?8e$KI8=E:IU$K$J$C$FM_$7$$$G$9!#e(B

NARUSES_Yui · May 15, 2009, 5:18pm

e$B@.@%$G$9!#e(B

Hirotsugu A. wrote:

e$B<B$r8@$&$H!">/$7$@$1$G$9$,e(Bsqlite3-rubye$B$N%I%i%$%P!<$H$7$Fe(BFFIe$B;H$C$?$d$D=qe(B
e$B$-;O$a$F$?$s$G$9$h$M!#e(B
e$B$I$&$7$h$&$+$J!D!#e(B

sqlite3-rubye$B<+BN$,%a%s%F%J%s%9=*N;$7$F$$$k$N$G!"$I$&$J$s$G$7$g$&$M$’!#e(B

e$B$b$7e(BSQLitee$B$rI8=`E:IU$9$k$H!"e(BJRubye$B$H$N7s$M9g$$$O$I$&$J$C$A$c$&$s$G$7$g$&$+!#e(B
e$B!J$3$l$OB>$NJ}!9$N0U8+$,=P$F$+$i$G$$$$$N$+!#!Ke(B

Rubye$B%l%$%d!<$+$i8+$F;H$$>!<j$,F1$8$K$J$k$h$&$K!"$J$s$i$+$N%i%$%V%i%j$re(BJRubye$BMQ$Ke(B
e$BMQ0U$9$l$P$$$$$s$8$c$J$$$G$9$+$M!#e(B
SQLitee$B$@$18+$k$HBg;v$K8+$($^$9$,!"$=$&$$$&$N$Oe(Biconte$B$H$+e(Bzlibe$B$H$+e(Bgdbme$B$H$+!“e(B
e$B$9$G$K$$$/$D$+$”$k$o$1$G$9!#e(B

NARUSES_Yui · May 16, 2009, 6:13am

e$B@.@%$G$9!#e(B

Kouhei S. wrote:

e$B$3$l$KBP$7$F:#2s?7$7$/5/$3$7$?%i%$%V%i%j$G$O!"e(B

nativee$B$+$D%3%s%Q%/%H$J<BAue(B

e$B%3%s%Q%/%H$J<BAu$H$$$&$3$H$O=EMW$J$3$H$J$N$G$7$g$&$+!)e(B

sqlite3-rubye$B$h$j%3%s%Q%/%H$H$$$&AjBPE*$JOC$G$9$M!#e(B
e$B%"%l$h$j$O%a%s%F$7$d$9$$$H$$$&OC$G$9!#e(B
e$B5!G=DI2C$K4X$7$F$O$d$V$5$+$G$O$"$j$^$;$s!#e(B

e$BNc$($P!"e(Bsqlite3_bind_*e$BAjEv$N5!G=$ODs6!$5$l$F$$$J$$$N$G$9$,!"e(B
e$B$3$l$OI,MW$,$J$$$H$$$&$3$H$G$7$g$&$+!)e(B

e$B$3$l$OB>$N?M$N0U8+$rJ9$-$?$+$C$?$H$3$m$G$9!#e(B
e$B:G6a$Oe(BO/Re$B%^%C%Q!<$,e(BSQLe$BJ8$^$GAH$_N)$F$F$7$^$&$N$G!“e(B
e$B<j$G=q$/$J$H$$$&0UL#$G$”$($F30$9$N$b$"$j$+$J$!$H;W$$$D!"e(B
e$B$I$&;W$o$l$^$9$+!#e(B

e$B$^$?!“e(BSQLite3e$B$N%(%i!<$Oe(BArgumentErrore$B$+e(BRuntimeErrore$B$GJV$5$l$^e(B
e$B$9$,!“e(BSQLite::Busye$B$de(BSQLite::ReadOnlye$B$J$I@lMQ$NNc30%/%i%9$rJVe(B
e$B$7$FM_$7$$$G$9!#e(Bbusye$B$N$H$-$O>/$7BT$C$F$+$i$b$&0lEY;n$7$F$_$k!“e(B
e$B$H$$$&$h$&$J=hM}$r=q$/$3$H$,$”$k$H;W$$$^$9$,!”$=$N$H$-$K%(%i!<e(B
e$B%a%C%;!<%8$r@55,I=8=$G%^%C%A$5$;$Fe(Bbusye$B$J%(%i!<$+$I$&$+$rH=CGe(B
e$B$9$k$H$$$&$3$H$O$7$?$/$”$j$^$;$s!#e(B

e$B$3$l$b$=$&$$$&0U8+$O$"$k$@$m$&$J$!$H;W$$$D$D$H$j$"$($:30$7$F$$$$?$H$3$m$G$9!#e(B
e$B$3$N%i%$%V%i%j$K$$$$FNc30$r6hJL$7$FJ,$1$?$$$N$Oe(BSQLITE_BUSYe$B$J;~$Ke(B
e$B$A$g$C$HBT$C$F$+$i%j%H%i%$$@$H;W$&$N$G$9$,!"e(B
e$B$=$l$O$9$G$K$3$N%i%$%V%i%jB&$G9T$C$F$$$^$9!#e(B
e$B$5$i$K$b$&$7$P$i$/BT$C$F$+$i%j%H%i%$$,M_$7$$$H$+!“e(B
e$BJL$N%1!<%9$rJa3M$7$F2?$+$7$?$$Nc$,$”$k$N$J$i$PNc30$rJ,$1$^$9$,!“e(B
e$B$=$N$h$&$J%1!<%9$C$F$”$j$^$9$+!)e(B

e$BB>$K$b!“e(Bcolnamese$B$G$O$J$/$Fe(Bcolumn_namese$B$H$+e(Bcolumnse$B$K$7$FM_$7$$e(B
e$B$J$I:Y!9$7$?$b$N$,$”$C$?$j$7$^$9!#e(B

e$B$&!<$s!“e(Bcolumn_namese$B$”$?$j$K$7$^$9$+$M$’!#e(B

e$B$=$l$J$j$K$d$k5$$N$"$k%a%s%F%Je(B
e$B$H$$$&MxE@$,$"$j$^$9!#e(B

e$B$$$-$J$je(BRubye$B$KI8=E:IU$9$k$N$G$O$J$/$F!"$^$:!"FHN)%i%$%V%i%je(B e$B$H$7$F;H$C$F$b$i$C$F;H$$$K$/$$$H$3$m$J$I$N%U%#!<%I%P%C%/$r$be(B e$B$i$C$?8e$GI8=E:IU$r8!F$$9$k$H$$$&$N$G$OCY$$$G$7$g$&$+!)e(B

e$B$^$:$Oe(Bgeme$B$G$d$C$?$i$H$$$&;XE&$,$"$k$3$H$OM}2r$7$F$$$^$9!#e(B
e$B$7$+$7!“4{$K<B@S$N$”$ke(BSQLite3/Rubye$B$,e(Bgeme$B$G$"$kCf!"e(B
geme$B$G$o$6$o$6F~$l$F;n$7$F$/$l$k$+$K$D$$$F$o$?$7$OHa4QE*$K8+$F$$$^$9!#e(B
e$B$D$^$j!“FHN)%i%$%V%i%j$H$9$k$H!”;H$C$F$b$i$($J$$$N$G$O$J$$$+$H!#e(B

e$B$H$9$k$H!"$=$b$=$b$=$s$J%i%$%V%i%j$OI,MW$H$5$l$F$$$J$$$s$8$c$J$$$+$H$$$&e(B
e$BH?O@$,9M$($i$l$^$9$,!“e(BRailse$B$de(BMerbe$BEy$r$O$8$a$H$7$Fe(BWebe$B%”%W%j%1!<%7%g%se(B
e$B%U%l!<%`%o!<%/$,1I$($kCf!"%P%C%/%(%s%I$G$"$ke(BRDBe$B$N=EMW@-$OA}$90lJ}$G!"e(B
e$B3+H/MQ$N4J0W$Je(BRDBe$B$KBP$9$kI,MW@-$bF|$KF|$KA}$7$F$$$^$9!#e(B
e$B$3$N0LCV$KMh$ke(BRDBe$B$O:#$N$H$3$me(BSQLitee$B$,05E]E*$K6/$/!"e(B
e$BM-NO$JBeBX%i%$%V%i%j$NOC$bFC$KJ9$-$^$;$s!#e(B

e$B$f$($Ke(BSQLitee$B%i%$%V%i%j$Oe(BRubye$B$KI8=`E:IU$5$l$k$Y$-$@$H;W$C$F$$$^$9!#e(B
e$B$o$?$7$,$3$@$o$k$N$O$3$3$^$G$J$N$G!“e(B
e$B:#2s$N<BAu$h$j$h$$<BAu$,$”$l$P$=$l$KJQ$($k$3$H$K$OH?BP$7$^$;$s!#e(B

e$B$J$*!"e(BSQLite3/Rubye$B$O%a%s%F%J%s%9$,=*N;$7$F$$$k>e$K!“e(B
e$B0MB8@h$G$”$ke(Bdle$B$,%a%s%F%JIT:_$J$N$,LdBj$@$H;W$C$F$$$^$9!#e(B

e$B$H$j$"$($:!"C1BN%F%9%H$NCf$Ge(Bpe$B$H$+e(Bppe$B$r;H$C$F$$$k>uBV$G$OI8=e(B e$BE:IU$K$J$C$FM_$7$/$J$$$G$9!#7QB3$7$F2~A1$5$l$F$$$/$N$G$"$l$P!"e(B e$B$"$kDxEY7QB3$7$F2~A1$5$l$?8e$KI8=E:IU$K$J$C$FM_$7$$$G$9!#e(B

e$BEvA3C1BN%F%9%H$He(Brdoce$B$,B7$&$^$G$OI8=`E:IU$K$O$J$j$^$;$s$M!#e(B
e$B$=$3$OEvA3$N$3$H$@$H;W$C$F$$$^$9!#e(B
e$B$H$$$&$o$1$G!"$=$NJU$O$3$NEZF|$G$J$s$H$+$7$^$9!#e(B

NARUSES_Yui · May 16, 2009, 8:37am

e$B@.@%$G$9!#e(B

KUBO Takehiro wrote:

O/Re$B%^%C%Q!<$J$7$Ge(B SQL e$B$r;HMQ$9$k>l9g!"e(BSQL injection e$BBP:v$H$7$F!"e(B
e$B%P%$%s%IJQ?t$OI,?$G$9!#e(B

e$B$U$`!"$=$l$O$?$7$+$K!#e(B
O/Re$B%^%C%Q!<$O$^$@Mp@$$G7h$a$i$l$J$$$N$G!"IU$1$k$3$H$K$7$^$9!#e(B

http://copiousfreetime.rubyforge.org/amalgalite/
e$B$*$)!"$3$l$OCN$j$^$;$s$G$7$?!#e(B
e$B8+$F$_$k$3$H$K$7$^$9!#e(B

NARUSES_Yui · May 16, 2009, 8:18am

e$B5WJ]$G$9!#e(B

2009/5/16 NARUSE, Yui [email protected]:

e$BNc$($P!"e(Bsqlite3_bind_*e$BAjEv$N5!G=$ODs6!$5$l$F$$$J$$$N$G$9$,!"e(B
e$B$3$l$OI,MW$,$J$$$H$$$&$3$H$G$7$g$&$+!)e(B

e$B$3$l$OB>$N?M$N0U8+$rJ9$-$?$+$C$?$H$3$m$G$9!#e(B
e$B:G6a$Oe(BO/Re$B%^%C%Q!<$,e(BSQLe$BJ8$^$GAH$_N)$F$F$7$^$&$N$G!“e(B
e$B<j$G=q$/$J$H$$$&0UL#$G$”$($F30$9$N$b$"$j$+$J$!$H;W$$$D!"e(B
e$B$I$&;W$o$l$^$9$+!#e(B

SQLite e$B$re(B Ruby
e$B$KI8=E:IU$9$k$N$,L\E*$H$$$&$N$J$i$P!"e(BO/Re$B%^%C%Q!<e(B e$B$bI8=E:IU$K$7$J$$$H!“!V$”$($F30$9$N$b$"$j!W$H$O8@$($J$$$N$G$O$J$$$+$H!#e(B

O/Re$B%^%C%Q!<$J$7$Ge(B SQL e$B$r;HMQ$9$k>l9g!"e(BSQL injection
e$BBP:v$H$7$F!"e(B
e$B%P%$%s%IJQ?t$OI,?$G$9!#e(B

(snip)

e$B$f$($Ke(BSQLitee$B%i%$%V%i%j$Oe(BRubye$B$KI8=`E:IU$5$l$k$Y$-$@$H;W$C$F$$$^$9!#e(B
e$B$o$?$7$,$3$@$o$k$N$O$3$3$^$G$J$N$G!“e(B
e$B:#2s$N<BAu$h$j$h$$<BAu$,$”$l$P$=$l$KJQ$($k$3$H$K$OH?BP$7$^$;$s!#e(B

e$B$J$*!"e(BSQLite3/Rubye$B$O%a%s%F%J%s%9$,=*N;$7$F$$$k>e$K!“e(B
e$B0MB8@h$G$”$ke(Bdle$B$,%a%s%F%JIT:_$J$N$,LdBj$@$H;W$C$F$$$^$9!#e(B

amalgalite e$B$O$I$&$G$7$g$&$+!)e(B
e$B%W%m%8%'%/%H3+;O$+$i$b$&$=$m$=$m$GK~#1G/!#$+$J$j@Q6KE*$K3+H/Cf$G$9!#e(B
http://copiousfreetime.rubyforge.org/amalgalite/

NARUSES_Yui · May 16, 2009, 2:15pm

e$B?\F#$G$9!#e(B

In [email protected]
“[ruby-dev:38471] Re: SQLitee$B%i%$%V%i%je(B” on Sat, 16 May 2009
13:12:33 +0900,
“NARUSE, Yui” [email protected] wrote:

e$B$=$l$O$9$G$K$3$N%i%$%V%i%jB&$G9T$C$F$$$^$9!#e(B
e$B%?%$%%"%&%H$N;~4V$Oe(B1e$BIC$K8GDj$5$l$F$$$^$9$h$M!#e(B e$B>l9g$K$h$C$F$O$b$C$HD9$/$7$?$jC;$/$7$?$j$7$?$$$H;W$$$^$9!#e(B e$B%"%W%j%1!<%7%g%sB&$G@)8f$G$-$k$Y$-9L$@$H;W$$$^$9!#e(B

e$B$5$i$K$b$&$7$P$i$/BT$C$F$+$i%j%H%i%$$,M_$7$$$H$+!“e(B
e$BJL$N%1!<%9$rJa3M$7$F2?$+$7$?$$Nc$,$”$k$N$J$i$PNc30$rJ,$1$^$9$,!“e(B
e$B$=$N$h$&$J%1!<%9$C$F$”$j$^$9$+!)e(B

GUIe$B%“%W%j%1!<%7%g%s$N>l9g$Oe(Bsleepe$B$9$k$N$G$O$J$/!”%a%$%s%k!<%We(B
e$B$r2s$7$?$$$G$9!#e(BGTK+e$B$J$I$Ne(BGUIe$B%D!<%k%-%C%H$O%7%s%0%k%9%l%C%Ie(B
e$B$GF0$/$N$G!“JL%9%l%C%I$G$d$C$F$/$l!”$H$$$&2sHr:v$O$d$a$F$[$7e(B
e$B$$$G$9!#e(B

e$B$d$O$j!“e(Bbusye$B$J$H$-$K$I$&$d$C$FBT$D$+$b%”%W%j%1!<%7%g%sB&$G@)e(B
e$B8f$G$-$k$Y$-9`L$@$H;W$$$^$9!#$b$A$m$s!“@)8f$G$-$k$N$G$”$l$Pe(B
e$B%G%U%)%k%H$Oe(Bsleepe$B$H$$$&Iw$K$J$C$F$$$F$b$h$$$H;W$$$^$9!#e(B

e$B$D$^$j!“FHN)%i%$%V%i%j$H$9$k$H!”;H$C$F$b$i$($J$$$N$G$O$J$$$+$H!#e(B
e$B3+H/$,=*N;$7$?e(BSQLite3/Rubye$B$NBeBX$rL;X$7$F$$$k$N$+$H;W$C$F$$e(B
e$B$?$N$G$9$,!"$=$l$H$O0c$&J}8~$G$7$g$&$+!)e(B
e$B$b$7!“BeBX$rL;X$7$F$$$k$N$G$”$l$P!"e(BSQLite3/Rubye$B$NBe$o$j$K;H$Ce(B
e$B$F$b$h$$$H;W$($k$b$N$G$J$1$l$P$$$1$J$$$H;W$$$^$9!#e(B

e$B$H$j$"$($:!"C1BN%F%9%H$NCf$Ge(Bpe$B$H$+e(Bppe$B$r;H$C$F$$$k>uBV$G$OI8=e(B e$BE:IU$K$J$C$FM_$7$/$J$$$G$9!#7QB3$7$F2~A1$5$l$F$$$/$N$G$"$l$P!"e(B e$B$"$kDxEY7QB3$7$F2~A1$5$l$?8e$KI8=E:IU$K$J$C$FM_$7$$$G$9!#e(B

e$BEvA3C1BN%F%9%H$He(Brdoce$B$,B7$&$^$G$OI8=`E:IU$K$O$J$j$^$;$s$M!#e(B
e$B$=$3$OEvA3$N$3$H$@$H;W$C$F$$$^$9!#e(B
e$B$H$$$&$o$1$G!"$=$NJU$O$3$NEZF|$G$J$s$H$+$7$^$9!#e(B

e$B8D?ME*$J7P83$G$O!“%F%9%H$H%I%-%e%a%s%H$@$1$G$O$J$/!”$$$/$D$+e(B
e$B%“%W%j%1!<%7%g%s$r=q$$$F;H$C$F$$J$$$H;H$$$d$9$$e(BAPIe$B$N%i%$%V%ie(B
e$B%j$K$O$J$i$J$$$H46$8$F$$$^$9!#e(B
e$B!J%"%W%j%1!<%7%g%s$r=q$$$F$$F!”$“$^$j$N;H$$$E$i$5$KX3A3$H$9e(B
e$B$k$3$H$b$”$j$^$9$,!#!Ke(B

NARUSES_Yui · May 16, 2009, 6:10pm

e$B@.@%$G$9!#e(B

KUBO Takehiro wrote:

lib/sqlite3/database.rb e$B$Ne(B load_driver () e$B$r8+$F$_$?$i!“$^$:!“e(Bnative e$B$Ne(B
e$B3HD%%i%$%V%i%j$re(B load e$B$7$F!”<:GT$7$?$ie(B dl e$B$r;HMQ$9$k$H$$$C$?F0$-$Ke(B
e$B$J$C$F$^$9!#$D$^$je(B dl e$B$O$”$/$^$G$be(B fallback e$B$H$7$F;H$o$l$F$$$k$@$1e(B
e$B$G!"I,?$J$b$N$G$O$J$$!#$H$$$&$3$H$O!"e(Bdl e$B$r;HMQ$7$F$$$k$3$H$OK\e(B
e$B<AE*$JLdBj$G$O$J$$$H!#e(B

e$B$“$i!”$?$7$+$Ke(Bnativee$B$,%G%U%)%k%H$K$J$C$F$^$9$M!#e(B
e$B$3$l$O%A%'%C%/ITB-$G$7$?!#e(B

dl e$BA0Ds$N%3!<%I$r!“e(Bruby 1.9 e$B$X0?”$9$k$N$,BgJQ$J$N$+$H;W$C$?$+$ie(B
e$B?75,$N%i%$%V%i%j$b$"$j$+$H$O;W$C$?$1$I!“e(Bnative e$B$NItJ,$re(B ruby 1.9
e$B$X0?”$9$k$@$1$J$iBg$7$?<j4V$G$O$J$$$+$H!#<B:]!"e(Bgithub e$B>e$Ge(B fork
e$B$7$F3+H/$rB3$1$F$$$kJ}$N2??M$+$Oe(B 1.9 e$BBP1~$r$9$G$K:Q$^$;$F$$$^$9!#e(B
http://github.com/jamis/sqlite3-ruby/network

e$B$b$H$b$He(BSQLite3/Rubye$B$Oe(B1.9e$B$K$OBP1~$7$F$$$^$9$M!#e(B
e$BHsBP1~$@$C$?:"$G$b%(%i!<$r=P$7$F$$$?$N$Oe(BStringe$B$de(BArraye$B$NKd$a9~$2=e(B
e$BMm$$NItJ,$G$7$?$7!#e(B

NARUSES_Yui · May 17, 2009, 6:37am

e$B@.@%$G$9!#e(B

Kouhei S. wrote:

e$B8f$G$-$k$Y$-9`L$@$H;W$$$^$9!#$b$A$m$s!"@)8f$G$-$k$N$G$"$l$Pe(B
e$B%G%U%)%k%H$Oe(Bsleepe$B$H$$$&Iw$K$J$C$F$$$F$b$h$$$H;W$$$^$9!#e(B

e$B$J$k$[$I!"$3$N$"$?$j$O9M$(D>$9$3$H$K$7$^$9!#e(B

e$B3+H/$,=*N;$7$?e(BSQLite3/Rubye$B$NBeBX$rL;X$7$F$$$k$N$+$H;W$C$F$$e(B
e$B$?$N$G$9$,!"$=$l$H$O0c$&J}8~$G$7$g$&$+!)e(B
e$B$b$7!“BeBX$rL;X$7$F$$$k$N$G$”$l$P!"e(BSQLite3/Rubye$B$NBe$o$j$K;H$Ce(B
e$B$F$b$h$$$H;W$($k$b$N$G$J$1$l$P$$$1$J$$$H;W$$$^$9!#e(B

e$B$U$`!“3N$+$KJ}8~@-$r$O$C$-$j$5$;$kI,MW$,$”$j$^$9$M!#e(B
e$B$o$?$7$,M_$7$+$C$?$N$Oe(BRubye$B$N%*%V%8%’%/%H$r3JG<$7$d$9$$$b$N$@$C$?$N$G!"e(B
e$B$I$&$;$J$i$b$C$H%i%G%#%+%k$K$=$C$A$K?6$C$?J}$,0c$$$,$G$d$9$$$N$+$J!#e(B

e$B$=$&$9$k$H!“e(BSQLite3/Rubye$B$de(BAmaligalitee$BEy$h$j$3$C$A$N%”%W%m!<%A$NJ}$,e(B
e$BM%$l$F$$$k$H$$$&>ZL@$,I,MW$K$O$J$j$^$9$J!#e(B

e$B8D?ME*$J7P83$G$O!"%F%9%H$H%I%-%e%a%s%H$@$1$G$O$J$/!"$$$/$D$+e(B
e$B%"%W%j%1!<%7%g%s$r=q$$$F;H$C$F$$J$$$H;H$$$d$9$$e(BAPIe$B$N%i%$%V%ie(B
e$B%j$K$O$J$i$J$$$H46$8$F$$$^$9!#e(B
e$B!J%"%W%j%1!<%7%g%s$r=q$$$F$$F!"$"$^$j$N;H$$$E$i$5$KX3A3$H$9e(B
e$B$k$3$H$b$"$j$^$9$,!#!Ke(B

e$B$H$j$"$($:1JB32=%i%$%V%i%j$J$I$r$$$/$D$+=q$$$F$_$k$3$H$K$7$^$9!#e(B

NARUSES_Yui · May 16, 2009, 5:05pm

e$B5WJ]$G$9!#e(B

sqlite3-ruby
e$B$N%=!<%9$r8+$F$_$?$i!"A0Ds$N0lIt$,$/$:$l$F$$$k$h$&$Je(B…e$B!#e(B

2009/5/16 NARUSE, Yui [email protected]:

e$B$J$*!"e(BSQLite3/Rubye$B$O%a%s%F%J%s%9$,=*N;$7$F$$$k>e$K!"e(B

e$B$3$A$i$O$=$NDL$j$G$9$,!"e(B

e$B0MB8@h$G$"$ke(Bdle$B$,%a%s%F%JIT:_$J$N$,LdBj$@$H;W$C$F$$$^$9!#e(B

lib/sqlite3/database.rb e$B$Ne(B load_driver ()
e$B$r8+$F$_$?$i!“$^$:!“e(Bnative e$B$Ne(B
e$B3HD%%i%$%V%i%j$re(B load e$B$7$F!”<:GT$7$?$ie(B dl
e$B$r;HMQ$9$k$H$$$C$?F0$-$Ke(B
e$B$J$C$F$^$9!#$D$^$je(B dl e$B$O$”$/$^$G$be(B fallback
e$B$H$7$F;H$o$l$F$$$k$@$1e(B
e$B$G!"I,?$J$b$N$G$O$J$$!#$H$$$&$3$H$O!"e(Bdl
e$B$r;HMQ$7$F$$$k$3$H$OK\e(B
e$B<AE*$JLdBj$G$O$J$$$H!#e(B

dl e$BA0Ds$N%3!<%I$r!“e(Bruby 1.9
e$B$X0?”$9$k$N$,BgJQ$J$N$+$H;W$C$?$+$ie(B
e$B?75,$N%i%$%V%i%j$b$"$j$+$H$O;W$C$?$1$I!“e(Bnative e$B$NItJ,$re(B ruby
1.9
e$B$X0?”$9$k$@$1$J$iBg$7$?<j4V$G$O$J$$$+$H!#<B:]!"e(Bgithub e$B>e$Ge(B
fork
e$B$7$F3+H/$rB3$1$F$$$kJ}$N2??M$+$Oe(B 1.9
e$BBP1~$r$9$G$K:Q$^$;$F$$$^$9!#e(B
http://github.com/jamis/sqlite3-ruby/network

SQLite$B%i%$%V%i%j(B

SQLite$B%i%$%V%i%j(B