[B! dbi] soh335ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

soh335 id:soh335

dbiã«é–¢ã™ã‚‹soh335ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ç”Ÿ DBI ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã® DBI Cookbook (1) - Yet Another Hackadelic
ã¡ã‚‡ã£ã¨å‰ã¾ã§ DBI ã§éžåŒæœŸã‚¢ã‚¯ã‚»ã‚¹ãªã‚¨ãƒ³ãƒˆãƒªãŒå„æ‰€ã§ä¸ŠãŒã£ã¦ã„ã¾ã—ãŸãŒçš†ã•ã‚“å¦‚ä½•ãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã•ã¦ã¨ã€ã€ã€æ´å²çš„ãªçµŒç·¯ã¨ã‹æ´å²çš„ãªçµŒç·¯ã¨ã‹ã§ç”Ÿ DBI ç›¸å½“ã‚’ä½¿ã£ã¦ã‚‹æ–¹ã‚‚ãã‚Œãªã‚Šã«ã„ã‚‹ã§ã—ã‚‡ã†ã€‚å¥¥ã•ã‚“ã€å¤§äº‹ãªäº‹ãªã‚“ã§äºŒåº¦è¨€ã„ã¾ã—ãŸã‚ˆï¼ DBI ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã£ã¦ã¾ããã‚“ãªä½¿ã„ã‚„ã™ã„ç‰©ã˜ã‚ƒãªã„ã‚“ã§ã™ãŒã€å·¥å¤«æ¬¡ç¬¬ã§å‡ºæ¥ã‚‹äº‹ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã¡ãªã¿ã«ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€MySQL Documentation - Example Databases ã® world ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ fetchall_arrayref ã§ãƒ‡ãƒ¼ã‚¿æ•´å½¢ ã¾ãšä»¥ä¸‹ã®ã‚ˆã†ã«ä½¿ã£ã¦ã¿ã¾ã™ã€‚ #!/usr/bin/perl use strict; use warnings; use Data::Dump qw(dump); use DBI; use Perl6::Say; my $dbh =
soh335 2012/06/13
dbi

perl
ãƒªãƒ³ã‚¯
DBIx::Handlerã§å®‰å¿ƒDBç”Ÿæ´» - Articles Advent Calendar 2011 Dbix
ã“ã‚“ã«ã¡ã¯ï¼nekokakã§ã™ï¼ ä»Šå¹´ã¯ãƒœã‚¯ãŒä½œã£ã¦ã‚‹DBIx::Handlerã¨ã„ã†ã‚‚ã®ã‚’ç´¹ä»‹ã—ã¦ã¿ã‚‹ã€‚ DBIx::Handlerã¯DBIã®ãƒ©ãƒƒãƒ‘ãƒ¼ã§ã‚ã‚ŠDBã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³å‘¨ã‚Šã®ç®¡ç†ã«é‡ç‚¹ã‚’ç½®ã„ãŸãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã‚ã‚‹ã€‚ ORMã‚’ä½¿ã‚ãšã«DBå‘¨ã‚Šã®å‡¦ç†ã‚’è¡Œã„ãŸã„å ´åˆã¯ã“ã®DBIx::Handlerã‚’ä½¿ã†ã“ã¨ã‚’ãŠã™ã™ã‚ã™ã‚‹ã€‚ è‡ªåˆ†ã§DBIã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ç”Ÿæˆã—åˆ©ç”¨ã™ã‚‹å ´åˆã©ã“ã¾ã§æ£ã—ãã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ã‚’ã‚ãªãŸã¯ã§ãã¾ã™ã‹ï¼Ÿ ãã‚‚ãã‚‚è¦ªãƒ—ãƒã‚»ã‚¹ã§æŽ¥ç¶šã—ãŸdbã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’åãƒ—ãƒã‚»ã‚¹å´ã§ã‚‚åˆ©ç”¨ã™ã‚‹ã“ã¨ã®å•é¡Œã‚’æ£ç¢ºã«æŠŠæ¡ã—ã¦ã„ã¾ã™ã‹ï¼Ÿ ãã“ã¾ã§æ£ã—ãç´°ã‹ãç†è§£ã—è‡ªåˆ†ã§å®Ÿè£…ã§ããŸã¨ã—ã¦ã‚‚ã ã€æ–°ã—ã„ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œã‚‹ãŸã³ã«ãã®ã‚³ãƒ¼ãƒ‰ã‚’ã‚³ãƒ”ãƒšã™ã‚‹ã®ã‹ï¼Ÿ ãã“ã§DBIx::Handlerã®å‡ºç•ªã ã€‚ DBIx::Handlerã¯ãã®ã‚ãŸã‚Šã®å‡¦ç†ã‚’ã™ã¹ã¦é¢å€’ã¿ã¦ãã‚Œã‚‹ã€‚ ã‚‚ã†ã‚ãªãŸã¯ ã„ã¤DBã¨ã®æŽ¥ç¶šãŒç€ã‚‰ã‚Œ
soh335 2011/12/11
perl

dbi
ãƒªãƒ³ã‚¯
Perl DBI disconnect invalidates 1 active statement handle
ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ Perl DBIé–¢é€£è¨˜äº‹ Perl DBIã®SQLã§DBã®æŽ¥ç¶šã‚’åˆ‡æ–ã™ã‚‹ãŸã‚ã«disconnectã‚’å‘¼ã‚“ã ã‚‰ã€ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ãªã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãƒãƒ³ãƒ‰ãƒ«ãŒã‚ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¾ã—ãŸã€‚ DBI::db=HASH(0x826faec)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at db.pl line 31. closing dbh with active statement handles at db.pl line 31. ãŸã¾ã«ã—ã‹æ›¸ã‹ãªã„ã®ã§ã€ã‚ˆãå¿˜ã‚Œã‚‹ã®ãŒ finish ã®å‘¼ã³å‡ºã—ã§ã™ã€‚ #!/usr/local/bin/perl -w
soh335 2011/11/19
dbi

perl
ãƒªãƒ³ã‚¯
DBIã¨forkã®é–¢ä¿‚ - heboi blog
å®Ÿéš›ã‚°ã‚°ã‚Œã°æ£è§£ã¯ã„ã£ã±ã„å‡ºã¦ãã‚‹ã—ã“ã“ã«è‡ªåˆ†ã‚‚ã‚³ãƒ¡ãƒ³ãƒˆã§æ›¸ã„ã¦ãŸã‚Šã—ã¦ã„ã¾ã•ã‚‰æ›¸ãå¿…è¦ã‚‚ãªã„ã‹ãªã¨æ€ã£ã¦ãŸã‘ã©ä¸€å¿œè‡ªåˆ†ã®ãƒ–ãƒã‚°ã§ã‚‚ã¾ã¨ã‚ã¦ãŠãã¨ã„ã†ã“ã¨ã§ã€‚ ä¸€èˆ¬çš„ãªè§£ DBIx::Connectorã¨ã‹DBIx::HandlerçµŒç”±ã§ã‹ãªã‚‰ãš$dbhã‚’å–å¾—ã—ã¦ã‹ã‚‰DBIã‚’ä½¿ã†ã€‚ ã‚‚ã—ãã¯fork-safeãªORM(DBIx::Class, DBIx::Skinny, Teng)ã‚’ä½¿ã†ã€‚ DBIã‚’ç›´æŽ¥ä½¿ã£ã¦ã„ã‚‹å ´åˆ ä¸€èˆ¬çš„ãªã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’ä¿æŒã™ã‚‹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨åŒæ§˜ã«DBIã‚‚forkã—ãŸåä¾›ãŒè¦ªã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’ãã®ã¾ã¾ä½¿ã†ã“ã¨ã¯ãƒã‚°ã®åŽŸå› ã«ãªã‚Šã¾ã™ã€‚ç‰¹ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å‡¦ç†ç‰ã§é‡å¤§ãªå•é¡ŒãŒèµ·ã“ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ è§£æ±ºç–ã¯ã€ DBIã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’è¦ªã§ä½œã‚‰ãªã„ã§ã€åä¾›ã§ç‹¬è‡ªã«ä½œã‚‹ è¦ªã§ä½œã£ã¦ã—ã¾ã£ãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’åä¾›ãŒå®‰å…¨ã«DESTROYã—ã€å†æŽ¥ç¶šã™ã‚‹ ã®ã©ã¡ã‚‰ã‹ã«ãªã‚Šã¾ã™ã€‚ã“ã“ã§å•é¡Œã¯2ã§
soh335 2011/11/17
perl

dbi
ãƒªãƒ³ã‚¯
SQLã§incrementã—ãŸå€¤ã‚’è¡¨ç¤ºã™ã‚‹ã‚„ã¤ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
MacBook Air 11ã‚¤ãƒ³ãƒæ¬²ã—ã„ï¼ @sugyanã•ã‚“ã®SQLã§incrementã—ãŸå€¤ã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³•ã‚’è€ƒãˆã‚‹ - ã™ãŽã‚ƒãƒ¼ã‚“ãƒ¡ãƒ¢ã‚’ç”ŸDBIã§ã‚„ã£ã¦ã¿ãŸã®ã¨ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã¨ã£ã¦ã¿ãŸã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãªã— Rate dbic teng dbi1 dbi2 dbic 578/s -- -64% -92% -92% teng 1587/s 175% -- -78% -79% dbi1 7143/s 1136% 350% -- -7% dbi2 7692/s 1231% 385% 8% --ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚ã‚Š Rate dbic teng dbi1 dbi2 dbic 581/s -- -59% -88% -92% teng 1429/s 146% -- -71% -81% dbi1 5000/s 760% 250% -- -35% dbi2 7692/s 1223% 438% 54%
soh335 2011/01/25
perl

dbi

dbic

teng
ãƒªãƒ³ã‚¯
1