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

kiririmode id:kiririmode

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

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

${{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->connect æ™‚ã«ä½¿ã†é‰„æ¿ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æ•™ãˆã¦ï¼ - blog.nomadscafe.jp
perlã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†æ™‚ã«èª°ã‚‚ãŒå¿…ãšä½¿ã†DBIã€‚ãã®æŽ¥ç¶šæ™‚ã«ä½¿ã†connectãƒ¡ã‚½ãƒƒãƒ‰ã®ç¬¬4å¼•æ•°ã«è¨å®šã—ã¦ã„ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒã‚µãƒ¼ãƒ“ã‚¹ã«ã‚ˆã‚Šã¾ã¡ã¾ã¡ãªã‚“ã ã‘ã©ã€ã ã‚Œã‹é‰„æ¿è¨å®šã‚’æ•™ãˆã¦ãã ã•ã„ã€‚ åƒ•ãŒä½¿ã†ã®ãŒã€ my $dbh = DBI->connect($dsn, $user, $password, { AutoCommit => 1, PrintError => 0, RaiseError => 1, ShowErrorStatement => 1, AutoInactiveDestroy => 1, }); ã“ã‚Œã€‚ åŠ ãˆã¦ã€mysqlã§ã‚ã‚Œã° mysql_enable_utf8 => 1 mysql_auto_reconnect => 0, SQLiteã ã¨ sqlite_unicode => 1 sqlite_use_immediate_transaction => 1 ã‚’è¿½åŠ ã—
kiririmode 2012/12/08
dbi

perl
ãƒªãƒ³ã‚¯
ç¶šDBIã¨forkã®é–¢ä¿‚ - Articles Advent Calendar 2011 Dbix
ã¯ã˜ã‚ã« DBIxã¨ã„ãˆã°Skinnyã§ã™ã€‚nihenã§ã™ã€‚ DBIï½˜ãƒˆãƒ©ãƒƒã‚¯ã¨ã„ã„ãªãŒã‚‰DBIã®è©±ã§ã‚‚ã‚ˆã„ã¿ãŸã„ãªã®ã§ã«æ›¸ã„ãŸã“ã¨ã®ç¶šç·¨tipsã‚’ä¸€ã¤æ›¸ãã¾ã™ã§ã™ã€‚ DBI->connect_cachedã¨forkã®ç½ DBI->connect_cachedã¯åŒä¸€ãƒ—ãƒã‚»ã‚¹ã§ç”Ÿæˆã•ã‚ŒãŸåŒä¸€connectã‚ªãƒ—ã‚·ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒ³ãƒ‰ãƒ«ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ãã‚Œãã‚Œã‚’è¿”ã—ã¦ãã‚Œã‚‹ä¾¿åˆ©ãªã‚‚ã®ãªã®ã§ã™ãŒã€ã“ã‚Œã¨forkã®çµ„ã¿åˆã‚ã›ã«ã¯ã‚„ã¯ã‚Šç½ ãŒå˜åœ¨ã—ã¾ã™ã€‚ use strict; use warnings; use DBI; use Data::Dumper; my $dbh = DBI->connect_cached('dbi:mysql:sandbox', 'sandbox', 'sandbox') or die $DBI::errstr; $dbh->do(q{DROP TABLE IF EXI
kiririmode 2012/02/04
db

dbi

perl
ãƒªãƒ³ã‚¯
ç¬¬6å›žã€€UNIXãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®å‹˜æ‰€ï¼ˆ2ï¼‰ | gihyo.jp
forkã¨ãƒ•ã‚¡ã‚¤ãƒ«ãƒãƒ³ãƒ‰ãƒ« UNIXç³»ã®OSã§ã¯ã€è¤‡æ•°ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒã€ãã‚Œãžã‚Œãƒ—ãƒã‚»ã‚¹ã¨ã„ã†å˜ä½ã§å‹•ä½œã—ã¦ã„ã¾ã™ã€‚forkã¨ã„ã†ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«[1]ãŒå‘¼ã³å‡ºã•ã‚Œã‚‹ã¨å‘¼ã³å‡ºã—ãŸãƒ—ãƒã‚»ã‚¹ã®è¤‡è£½ãŒOSã«ã‚ˆã£ã¦ä½œæˆã•ã‚Œã€è¤‡è£½ã•ã‚ŒãŸãƒ—ãƒã‚»ã‚¹ï¼ˆåãƒ—ãƒã‚»ã‚¹ï¼‰ãŒexecveã¨ã„ã†ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦åˆ¥ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã«ã™ã‚Šæ›¿ã‚ã‚‹ã€ã¨ã„ã†ã—ãã¿ã§ã•ã¾ã–ã¾ãªå‡¦ç†ã‚’å®Ÿè¡Œã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã€Œè¤‡è£½ã€ã¨è¨€ã£ã¦ã‚‚ã€å…¨éƒ¨ã®æƒ…å ±ãŒè¤‡è£½ã•ã‚Œã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ—ãƒã‚»ã‚¹ã®ãƒ¡ãƒ¢ãƒªã‚¤ãƒ¡ãƒ¼ã‚¸ãŒè¤‡è£½ã•ã‚Œã‚‹[2]ä¸€æ–¹ã§ã€ãƒ—ãƒã‚»ã‚¹ãŒé–‹ã„ã¦ã„ã‚‹ã€Œã‚ªãƒ¼ãƒ—ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«è¨˜è¿°ã€ï¼ˆâ open file descriptionï¼‰ï¼ˆâ æ³¨3ï¼‰ã¯è¤‡è£½ã•ã‚Œã¾ã›ã‚“ã€‚forkã®ã‚ã¨ã¯ã€è¦ªãƒ—ãƒã‚»ã‚¹ã¨åãƒ—ãƒã‚»ã‚¹ã®ä¸¡è€…ãŒã€å˜ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«è¨˜è¿°ã‚’æŒ‡ã™ã€Œãƒ•ã‚¡ã‚¤ãƒ«è¨˜è¿°åã€ï¼ˆâ file descriptorï¼‰ï¼ˆâ æ³¨4ï¼‰ã‚’æŒã¤ã“ã¨ã«ãªã‚Šã¾ã™ï¼ˆå›³2â ï¼‰â ã€‚ å›³2ã€€for
kiririmode 2011/04/10
unix

perl

fork

dbi
ãƒªãƒ³ã‚¯
ç¬¬35å›žã€€DBIï¼šç”Ÿã®SQLãŒæ•£ã‚‰ã°ã‚‹ã¨è¨€ã†å‰ã« | gihyo.jp
Perlã¨dbm ã„ã¾ã§ã¯çœã¿ã‚‰ã‚Œã‚‹ã“ã¨ã‚‚å°‘ãªããªã‚Šã¾ã—ãŸãŒã€Perlã«ã¯1989å¹´ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³3.0ä»¥é™ã€dbmã¨å‘¼ã°ã‚Œã‚‹ã‚·ãƒ³ãƒ—ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ©Ÿæ§‹ãŒæ¨™æº–ã§çµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®dbmã¯ã€ã„ã‚ã‚†ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ã¦ã‚ãƒ¼ã¨å€¤ã®çµ„ã¿åˆã‚ã›ã‚’ãƒ‡ã‚£ã‚¹ã‚¯ã«ä¿å˜ã§ãã‚‹ã ã‘ã®ã‚‚ã®ã§ã™ãŒã€ãƒãƒƒã‚·ãƒ¥ï¼ˆå½“æ™‚ã¯ã¾ã é€£æƒ³é…åˆ—ã¨å‘¼ã‚“ã§ã„ã¾ã—ãŸï¼‰ã¨çµã³ã¤ã‘ã‚‹ã“ã¨ã§ã‚¿ãƒ–åŒºåˆ‡ã‚Šãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã‚’èªã‚“ã§ã„ãã‚ˆã‚Šé«˜é€Ÿã«æ¤œç´¢ãŒã§ããŸãŸã‚ã€ãƒ¦ãƒ¼ã‚¶ç’°å¢ƒã«æ°¸ç¶šçš„ãªãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹æ‰‹æ®µã®ã²ã¨ã¤ã¨ã—ã¦é‡å®ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚Perl 3ï¼4ã®æ™‚ä»£ã«ã¯dbmopenã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã—ãŸãŒã€ã“ã®æ©Ÿæ§‹ã¯Perl 5ã«ãªã£ã¦ä¸€æ–°ã•ã‚Œã€ã„ã¾ã§ã¯ã‚ˆã‚Šæ±Žç”¨çš„ãªtieã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã“ã¨ã«ãªã£ã¦ã„ã¾ã™ã€‚ã“ã®ä»²é–“ã¨ã—ã¦ã¯å¤ãã‹ã‚‰ã‚ã‚‹Berkeley DBã‚„GDBMãªã©ã®ã»ã‹ã€æœ€è¿‘ã§ã¯å¹³æž—å¹¹é›„æ°ã®T
kiririmode 2010/08/19
*programming

perl

dbi

db
ãƒªãƒ³ã‚¯
ç”Ÿ 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 =
kiririmode 2009/08/06
*programming

perl

dbi
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
kiririmode 2009/06/01
*programming

perl

dbi

async
ãƒªãƒ³ã‚¯
1