[B! perl][db] issmã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

issm id:issm

perlã¨dbã«é–¢ã™ã‚‹issmã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (25)

${{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ã®ç¬¬4å¼•æ•°ã®å†…å®¹ã¯è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã‹ãªã„ã»ã†ãŒè‰¯ã„ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
Perlã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹å ´åˆã¯ä»¥ä¸‹ã®æ§˜ãªæ„Ÿã˜ã«ãªã‚Šã¾ã™ã€‚ã©ã‚“ãªORMãªã‚Šãƒ©ãƒƒãƒ‘ãƒ¼ãªã‚Šã‚‚DBIã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯å†…éƒ¨çš„ã«ã¯ã“ã†ã„ã†ã“ã¨ã‚’ã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ã€‚ DBI->connect($dsn, $user, $password, { mysql_enable_utf8 => 1, RaiseError => 1, PrintError => 0, ShowErrorStatement => 1, AutoInactiveDestroy => 1, }); ç¬¬1ã€œç¬¬3å¼•æ•°ã¯ç’°å¢ƒã«ã‚ˆã£ã¦å·®ç•°ãŒã‚ã‚‹ã®ã§è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«æƒ…å ±ã‚’æŒãŸã›ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãŸã ã€ãã‚Œã«ã¤ã‚‰ã‚Œã¦ç¬¬4å¼•æ•°ã‚‚è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã„ã¦ã—ã¾ã†ã®ãŒæ•£è¦‹ã•ã‚Œã¾ã™ãŒã€ã“ã‚Œã¯è‰¯ããªã„ã€‚ ç¬¬4å¼•æ•°ã®å€¤ã¯ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã¯å›ºå®šã«æ±ºã¾ã£ã¦ã„ã‚‹ã®ã§ã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚ˆã£ã¦è‡ªç”±åº¦ã‚’æŒãŸã›ã‚‹å¿…è¦æ€§ãŒå…¨ãç„¡ã„ã¨ã„ã†ã‹ã‚€ã—ã‚æ‚ªã€‚ã“ã®äººã®ç’°å¢ƒã§ã¯ãƒ†ã‚¹ãƒˆã«é€š
issm 2014/03/03
dbi

perl

db
ãƒªãƒ³ã‚¯
Teng ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç† & ã¯ã¾ã£ãŸç‚¹ - amari3ã®æ—¥è¨˜
å‰å›žã¯ã€Teng ã§ä¸€é€šã‚Šã® CRUD ã®ä»•æ–¹ã‚’ç´¹ä»‹ã—ãŸã‚“ã§ã™ãŒã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’è€ƒæ…®ã—ã¦ã„ãªã‹ã£ãŸã®ã§ã€Teng ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ æº–å‚™ ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å‰å›žä½¿ç”¨ã—ãŸ memo ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã„ã¾ã™ã€‚ äº‹å‰ã«ä»¥ä¸‹ã®æ§˜ãªãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã¦ãŠãã¾ã—ãŸã€‚ mysql> select * from memo order by id; +----+-------+---------+---------------------+---------------------+ | id | title | body | created_at | updated_at | +----+-------+---------+---------------------+---------------------+ | 1 | Hello | World | 2011-11-24 23:0
issm 2013/03/09
teng

db

perl
ãƒªãƒ³ã‚¯
DBIx::TransactionManager::EndHook - soh335 memo
DBIx::TransactionManager ä½¿ã£ã¦ãƒã‚¹ãƒˆã—ãŸãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ç™ºè¡Œã—ã¦ã€å…¨ã¦ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒã†ã¾ãè¡Œã£ãŸæ™‚ã ã‘ã»ã’ã»ã’ã—ãŸã„ã€‚ ã ã‘ã©ã€ãã‚Œã‚’æœ€å¾Œã«ã¾ã¨ã‚ã¦ã‚„ã‚‹ã¨ã„ã†æ–¹æ³•ã ã¨æƒ…å ±ã‚’æŒã¡å›žã•ãªã„ã¨ã„ã‘ãªã‹ã£ãŸã‚Šã—ã¦ã‚ã‚“ã©ãã•ãã€é©å®œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å˜ä½ã§ã‚„ã‚ŠãŸã„æ„Ÿã˜ã ã£ãŸã®ã§ DBIx::TransactionManager::EndHook ã¨ã„ã†ã®ã‚’ä½œã‚Šã¾ã—ãŸã€‚ my $txm1 = $tm->txn_scope; $dbh->do('...'); $tm->add_end_hook(sub { # do something }); my $txm2 = $tm->txn_scope; $dbh->do('...'); $tm->add_end_hook(sub { # do something }); $txm2->commit; $txm1->commit;
issm 2013/01/14
perl

dbix-transactionmanager

db

transaction
ãƒªãƒ³ã‚¯
DBIã®connect_cachedã®ã„ã‚ã„ã‚ - $shibayu36->blog;
æœ€è¿‘DBã¸ã®æŽ¥ç¶šã‚’ãƒªã‚¯ã‚¨ã‚¹ãƒˆå˜ä½ã§ã¯ãªããƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†ã™ã‚‹ãƒ—ãƒã‚»ã‚¹å˜ä½(Starmanã®workerãƒ—ãƒã‚»ã‚¹å˜ä½)ã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãŸã„ã¨ã„ã†ã“ã¨ãŒã‚ã£ã¦ã€DBIã®connect_cachedã‚’ä½¿ã†ã“ã¨ã«ãªã£ãŸã€‚Scope::Container::DBIã§ã‚‚ã‚‚ã—ã‹ã—ãŸã‚‰å‡ºæ¥ã‚‹ã®ã‹ã‚‚ã—ã‚Œãªã„ã‘ã©ã€ã¨ã‚Šã‚ãˆãšconnect_cachedã§å®Ÿè£…ã—ãŸã€‚ãã“ã§ã„ã‚ã„ã‚ã¯ã¾ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ connect_cachedã«ã¤ã„ã¦ perldocã« connect_cached is like "connect", except that the database handle returned is also stored in a hash associated with the given parameters. If another call is made to connect_cached wit
issm 2013/01/11
perl

db

dbi

process

fork
ãƒªãƒ³ã‚¯
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 ã‚’è¿½åŠ ã—
issm 2012/11/27
dbi

perl

db

mysql

sqlite
ãƒªãƒ³ã‚¯
DBIx::TransactionManager ã®ç›®çš„ã¨ã€ãã®ä½¿ç”¨æ³•ã«ã¤ã„ã¦ - tokuhirom's blog
ãŠã¯ã‚ˆã†ã”ã–ã„ã¾ã™ã€‚ DBI ã§ã¯å½“ãŸã‚Šå‰ã®ã‚ˆã†ã« $dbh->do('BEGIN') ã¨ $dbh->do('COMMIT') ã‚’ã¤ã‹ãˆã°ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒã¤ã‹ãˆã‚‹ã‚ã‘ã§ã™ãŒã€ãªãœ DBIx::TransactionManager ã®ã‚ˆã†ãªã‚‚ã®ãŒå¿…è¦ã«ãªã£ãŸã®ã§ã—ã‚‡ã†ã‹ã€‚ ãã‚Œã¯å‹¿è«–ã€DBI ã§ç›´æŽ¥ transaction ã‚’ã¨ã‚Šã‚ã¤ã‹ã†ã¨å•é¡ŒãŒç™ºç”Ÿã™ã‚‹ã‚±ãƒ¼ã‚¹ãŒå˜åœ¨ã™ã‚‹ã‹ã‚‰ã§ã™ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ RAIIä¸€ç•ªãŠãŠãã„ã®ã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒä¸é€”åŠç«¯ãªçŠ¶æ…‹ã«ãªã£ã¦ã—ã¾ã†ã“ã¨ã‚’é˜»æ¢ã™ã‚‹ã“ã¨ã§ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ã§ã¯ã€ãŠã‹ã—ãªã“ã¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ my $dbh = DBI->connect(...); for (@stuff) { eval { $dbh->do("BEGIN"); $dbh->do(q{INSERT INTO t1 (v) VALUES (?)}, $_
issm 2012/10/22
dbi

dbix-transactionmanager

db

transaction

perl
ãƒªãƒ³ã‚¯
Kappa ã®é£¼ã„æ–¹(Kappa ã¨ã„ã† ORM ã®è©±) ãã®1 é–‹ç™ºã®èƒŒæ™¯ã®ãŠè©± - tsucchi ã®æ—¥è¨˜ 2nd season
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚ ã‚‚ã†ã™ãã€ŒPerl ã®ãŠç¥ã‚Šã€ã“ã¨ YAPC::Asiaã§ã™ãï¼çš†æ§˜ã€è¦‹ã‚‹æ–¹ã‚‚ç™ºè¡¨ã™ã‚‹æ–¹ã‚‚æº–å‚™ã¯ä¸‡å…¨ã§ã—ã‚‡ã†ã‹ï¼Ÿ (ç§ï¼ŸãŠå¯Ÿã—ãã ã•ã„ã€‚ã€‚ã€‚) ã“ã“ã§å®£ä¼ã€‚Perl ã¨ SQL ã®ã„ã‚ã„ã‚ ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ãŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚è£ç•ªçµ„ãŒã©ã¡ã‚‰ã‚‚å¤§å¤‰ãªãƒ“ãƒƒã‚°ãƒãƒ¼ãƒ ãªã®ã§æç¸®ãªã®ã§ã™ãŒã€åˆä¸ç´šè€…ãã‚‰ã„å‘ã‘ã« Perl ã¨ SQL ã«ã¾ã¤ã‚ã‚‹è©±ã‚’ ã•ã›ã¦ã„ãŸã ã“ã†ã¨æ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ (ã“ã“ã¾ã§ãƒ†ãƒ³ãƒ—ãƒ¬) ã•ã¦ã€YAPC ã¨ã¯ä»Šå›žã®è©±ã¯é–¢ä¿‚ãªãã¦ã€(ã™ã’ãƒ¼åéŸ¿ãŒã‚ã£ãŸã‚‰é–¢ä¿‚ã™ã‚‹ã‹ã‚‚ã—ã‚Œã‚“ã§ã™ãŒã€ãã‚Œã¯ç„¡ã„ã§ã—ã‚‡ã†w) ç§ã€Kappa ã¨ã„ã† ORM ã‚’æ›¸ã„ã¦ã¾ã™ã€‚ä»Šå›žã¯ãã®ãŠè©±ã§ã™ã€‚ ç›®æ¬¡ ãã®1 é–‹ç™ºã®èƒŒæ™¯ã®ãŠè©± ã¯ã¦ãƒ€ã«ã„ã‚ã„ã‚æ›¸ã„ã¦ã‚‹ã®ã§ã€åƒ•ã®ã‚¹ãƒˆãƒ¼ã‚«ãƒ¼ã ã£ãŸã‚‰è‰¯ãåˆ†ã‹ã‚‹ã¨æ€ã†ã®ã§ã™ãŒã€ãã‚“ãªäººã¯å¤šåˆ†ã„ãªã„ã®ã§(å±…ãŸã‚‰å±…ãŸã§å«Œã ã—w)ã€é †ã‚’è¿½ã£ã¦èª¬æ˜Žã—ã¾ã—ã‚‡ã†ã€‚ æœ€
issm 2012/09/15
perl

db

orm
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ã‚’è¿”ã™ã‚ˆã†ãªãƒ¢ãƒ‡ãƒ«ãƒ¡ã‚½ãƒƒãƒ‰ã®ãƒ†ã‚¹ãƒˆã¯fixtureã - æ–°ã ã‚‹ã‚ãè·¡åœ°
ãƒã‚¸ãƒƒã‚¯ã‚„ã€booleanã¨ã‹å€¤ã‚’è¿”ã™ã‚ˆã†ãªãƒ¡ã‚½ãƒƒãƒ‰ã®ãƒ†ã‚¹ãƒˆã¯æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ã®å•ã„åˆã‚ã›çµæžœã€DBICã§ã„ã†ResultSetã‚’è¿”ã™ã‚ˆã†ãªãƒ¡ã‚½ãƒƒãƒ‰ã§ã¯ã©ã†æ›¸ã‘ã°ã„ã„ã‹åˆ†ã‹ã‚‰ãªã‹ã£ãŸã€‚ ã¨ã„ã†ã“ã¨ã‚’Twitterã§ã¼ã‚„ã„ãŸã‚‰å¤©ã‹ã‚‰ç¥žã®å£°ãŒé™ã£ã¦ããŸã€‚ ãã‚Œfixtureã§ã§ãã‚‹ã‚ˆ æ™®é€šã«ã‚„ã‚ã†ã¨ã™ã‚‹ã¨è¶…å¤§å¤‰ã ã‘ã©ï¼ˆæ„è¨³ï¼‰ ãã†ã„ãˆã°ãã‚“ãªåå‰ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒrailsã®ä¸ã«ã‚ã£ãŸãªãƒ¼ã¨æ€ã„ã¤ã¤ã‚°ã‚°ã‚‹ã€‚ ãƒ†ã‚¹ãƒˆç”¨ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä½œã£ã¦ãã“ã«å¯¾ã—ã¦ãƒ†ã‚¹ãƒˆã™ã‚‹çš„ãªã€‚ãªã‚‹ã»ã©ã€‚ å¤§å¤‰ãªã®ã¯ã‚ã©ã„ã®ã§ã‚°ã‚°ã‚‹ã€‚Test::Fixture::DBIC::Schemaã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ç™ºè¦‹ã€‚ ä»¥ä¸‹ã»ã¼SYNOPSISã¾ã¾ã€‚ Schema.pm package Schema; use strict; use parent 'DBIx::Class::Schema::Loader'; 1; fi
issm 2012/03/11
perl

db

test

fixture
ãƒªãƒ³ã‚¯
Test::Fixture::DBI ã§è¦šãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ†ã‚¹ãƒˆ - Articles Advent Calendar 2010 Hacker
ã•ã¦ã€ä»Šå¹´ã‚‚ JPerl Advent Calendar ã®å£ç¯€ãŒã‚„ã£ã¦ãã¾ã—ãŸãã€‚ã“ã‚“ã«ã¡ã‚ã“ã‚“ã«ã¡ã‚ zigorou ã§ã™ã€‚ ä»Šå›žã¯æ‹™ä½œ Test::Fixture::DBI ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ã‚¹ãƒˆã‚’ã™ã‚‹ãŠè©±ã‚’ã—ã¾ã™ã‚ˆï¼ ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ãƒ¢ãƒã‚²ãƒ¼ã‚ªãƒ¼ãƒ—ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã® API é–‹ç™ºæ™‚ã«å¿…è¦ã«ã‹ã‚‰ã‚Œã¦ä½œã‚Šã€ä»Šã§ã¯ DeNA ã®ç¤¾å†…ã§ã‚‚æ™®é€šã«ä½¿ã‚ã‚Œã¦æ¥ã¦ã„ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ã€‚ ãƒ¬ãƒã‚¸ãƒˆãƒªã¯ github ã§ã™ã€‚ ã¯ã˜ã‚ã« ã¨ã‚Šã‚ãˆãšã¯ãƒ†ã‚¹ãƒˆç”¨ã® table ã‚’ç”¨æ„ã—ã¾ã—ã‚‡ã†ã€‚ USE test; DROP TABLE IF EXISTS location; CREATE TABLE location ( id int(10) unsigned not null, user_id int(10) unsigned not null, title varchar(255) not null
issm 2012/03/10
jpac2010

perl

test

db

fixture

test-fixture-dbi
ãƒªãƒ³ã‚¯
Big Sky :: Vimã§DBãŒæ“ä½œã§ãã‚‹ vdbi-vim ä½œã£ãŸã€‚
DBæ“ä½œãƒ„ãƒ¼ãƒ« Emacs DBI ã‚’ä½œã£ã¦ã¿ãŸ - æŠ€è¡“æ—¥è¨˜ï¼ kiwanami ã“ã®ãƒ„ãƒ¼ãƒ«ã®ç›®çš„ã¯ã€ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ä¾¿åˆ©ãªDBæ“ä½œç’°å¢ƒã‚’å®Ÿç¾ã™ã‚‹ã“ã¨ã§ã™ã€‚ pgAdmin ã‚„ MySQL Query Browser ã®ã‚ˆã†ãªGUIã®è‰¯ã•ã‚’CUIã§å®Ÿç¾ã—ã¦ã¿ã‚ˆã†ã¨ã—ã¦ã¿ã¾ã—ãŸã€‚ã™ãªã‚ã¡ã€ã¼ãã®ã‹ã‚“ãŒãˆãŸã•ã„ãã‚‡ã†ã®DBãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ã¡ãªã¿ã«ã€ã“ã®ãƒ„ãƒ¼ãƒ«ã«ã¨ã£ã¦Emacsã¯ãŸã ã®å®Ÿè¡Œç’°å¢ƒã§ã™ã€‚Emacsä½¿ã‚ãªã„äººã§ã‚‚ä½¿ã†ã¨ä¾¿åˆ©ã ã¨æ€ã„ã¾ã™ã€‚ http://d.hatena.ne.jp/kiwanami/20120305/1330939440 Vimã‚‚ãƒ¼Vimã‚‚ãƒ¼ï¼ ã£ã¦äº‹ã§ä½œã‚Šã¾ã—ãŸã€‚ mattn/vdbi-vim - GitHub Database client for Vim https://github.com/mattn/vdbi-vim Emacsç‰ˆã¯epcã¨ã„ã†RPCãƒ—ãƒãƒˆ
issm 2012/03/07
vim

db

dbi

perl
ãƒªãƒ³ã‚¯
DBæ“ä½œãƒ„ãƒ¼ãƒ« Emacs DBI ã‚’ä½œã£ã¦ã¿ãŸ - æŠ€è¡“æ—¥è¨˜ï¼ kiwanami
åŽ»å¹´ã‹ã‚‰ã»ãã¼ãã¨ä½œã£ã¦ããŸã€Emacsã‹ã‚‰DBã‚’æ“ä½œã§ãã‚‹ãƒ„ãƒ¼ãƒ« Emacs DBI ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Emacs DBI ã®ç°¡å˜ãªç´¹ä»‹ ã“ã®ãƒ„ãƒ¼ãƒ«ã®ç›®çš„ã¯ã€ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ä¾¿åˆ©ãªDBæ“ä½œç’°å¢ƒã‚’å®Ÿç¾ã™ã‚‹ã“ã¨ã§ã™ã€‚ pgAdmin ã‚„ MySQL Query Browser ã®ã‚ˆã†ãªGUIã®è‰¯ã•ã‚’CUIã§å®Ÿç¾ã—ã¦ã¿ã‚ˆã†ã¨ã—ã¦ã¿ã¾ã—ãŸã€‚ã™ãªã‚ã¡ã€ã¼ãã®ã‹ã‚“ãŒãˆãŸã•ã„ãã‚‡ã†ã®DBãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ã¡ãªã¿ã«ã€ã“ã®ãƒ„ãƒ¼ãƒ«ã«ã¨ã£ã¦Emacsã¯ãŸã ã®å®Ÿè¡Œç’°å¢ƒã§ã™ã€‚Emacsä½¿ã‚ãªã„äººã§ã‚‚ä½¿ã†ã¨ä¾¿åˆ©ã ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç”»é¢ e2wmã§3ãƒšã‚¤ãƒ³ã®ç”»é¢ æ©Ÿèƒ½æ¦‚è¦ ä»¥ä¸‹ã®ã‚ˆã†ãªæ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ Emacsã¨DBæŽ¥ç¶šå¯èƒ½ãªPerlãŒå‹•ã‘ã°ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§ã‚‚ä½•å‡¦ã§ã‚‚å‹•ã DBå®šç¾©ã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ãŒã™ãè¦‹ã‚Œã‚‹ auto-complete ã«ã‚ˆã‚‹SQLè£œå®Œ æŽ¥ç¶šå…ˆDBã«ã‹ã‚‰ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€åž‹åã€ãƒ†ãƒ¼ãƒ–ãƒ«åã€ã‚«ãƒ©ãƒ åãªã©
issm 2012/03/05
emacs

db

dbi

perl
ãƒªãƒ³ã‚¯
DBI#cloneã¨ã„ã†ãƒ¡ã‚½ãƒƒãƒ‰ - blog.nekokak.org
http://search.cpan.org/dist/DBI/DBI.pm#clone DBIã«cloneãƒ¡ã‚½ãƒƒãƒ‰ãŒã‚ã‚‹ã“ã¨ã‚’@nihenã•ã‚“ãŒã¿ã¤ã‘ã¾ã—ãŸã€‚ #ã„ã‚„ãƒ¼DBIã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯è‰¯ãèªã‚€ã¨ä¾¿åˆ©ãƒ¡ã‚½ãƒƒãƒ‰ãŒä¸€æ¯ã‚ã‚Šã¾ã™ã Tengã¨ã‹Skinnyã§ã¯connect_infoã‚’å—ã‘å–ã‚‹ã ã‘ã§ãªãã€ $dbhã‚’å—ã‘å–ã£ã¦åˆ©ç”¨ã™ã‚‹ä»•çµ„ã¿ã‚‚æä¾›ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ ãã“ã§ä¸€ç•ªå•é¡Œã«ãªã£ã¦ã„ãŸã®ã¯dbã¸ã®æŽ¥ç¶šãŒãƒ–ãƒã‚®ãƒ¬ãŸå ´åˆã®reconnectã®å•é¡Œã§ã—ãŸã€‚ connect_infoãŒã‚ã‚‹å ´åˆã¯æŽ¥ç¶šæƒ…å ±ã‚’è‡ªåˆ†ã§æŒã£ã¦ãŠã‚Šã€ç°¡å˜ã«å†æŽ¥ç¶šã§ãã‚‹ã‚“ã§ã™ãŒ $dbhã—ã‹ãªã„å ´åˆã¯ã„ã¾ã¾ã§ã§ããªã„ã¨ãŠã‚‚ã£ã¦ã„ã¾ã—ãŸã€‚ DBIçš„ã«ã‚‚æŽ¥ç¶šæ™‚ã«ã¤ã‹ã£ãŸpasswordã‚’å–ã‚‹ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ãŒãªã‹ã£ãŸã€‚ ãªã®ã§$dbhã‚’æ¸¡ã•ã‚ŒãŸå ´åˆã¯è‡ªå‹•reconnectã¯è¡Œã‚ãšã«ã‚¨ãƒ©ãƒ¼ã§æ»äº¡ã«ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ãŸã‚“ã§ã™ãŒã€ D
issm 2011/11/17
perl

dbi

db

teng

dbix-skinny
ãƒªãƒ³ã‚¯
Perlã®DBIã®cloneã®å†æŽ¥ç¶šã‚’æ¤œè¨¼ã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã¨ã‹ | hirobanex.net
Perlã®DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®cloneãƒ¡ã‚½ãƒƒãƒ‰ãŒã„ã„ã‚‰ã—ã„ ã€ŽDBIã¨forkã®é–¢ä¿‚ã€ã¨ã‹ã€ŽDBI#cloneã¨ã„ã†ãƒ¡ã‚½ãƒƒãƒ‰ã€ã¨ã‹ã§ã€å–ã‚ŠæŒ™ã’ã‚‰ã‚Œã¦ã„ã‚‹DBIã®cloneãƒ¡ã‚½ãƒƒãƒ‰ã‚’å®Ÿæ„Ÿã™ã‚‹ãŸã‚ã®ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã€‚ #!/usr/bin/env perl use strict; use warnings; use DBI; my $dbh = DBI->connect('dbi:mysql:;', 'test', 'test'); warn $dbh->do('show processlist'); $dbh->disconnect; warn $dbh->do('show processlist'); $dbh = $dbh->clone; warn $dbh->do('show processlist'); ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®å†æŽ¥ç¶šãŒãªã‚“ã¨ãŠæ‰‹è»½! ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®ç¶æŒã«é–¢ã—ã¦ã¯ã€ŽScope::
issm 2011/11/17
perl

dbi

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

dbi

db

fork
ãƒªãƒ³ã‚¯
ã«ã²ã‚Šãšã‚€::ã—ã‚“ã·ã‚‹ - DBI ã§å®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã‚¯ã‚¨ãƒªãƒ¼ã‚’å–å¾—ã™ã‚‹ DBIx::QueryLog ã‚’æ›¸ã„ãŸ
å£ç¯€ãŒå¤‰ã‚ã£ã¦ã€æ—©é€Ÿé¢¨é‚ªã‚’ã²ã„ã¦ã„ã¾ã™ã€‚ ã•ã¦ã€ã‚‚ã†ç§‹ã‚’é€šã‚Šè¶Šã—ã¦å†¬ã®æ§˜ç›¸ã‚’å‘ˆã—ã¦ããŸæ˜¨ä»Šã§ã¯ã‚ã‚Šã¾ã™ãŒã€DBI ã§ã¯ã€æ™®é€šã¯ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã„ my $stmt = 'SELECT * FROM user WHERE user_id = ?'; my @bind = ($user_id); $dbh->do($stmt, undef, @bind); ã¨ã‹æ›¸ãã¨æ€ã„ã¾ã™ã€‚ ã“ã®ã¨ãã«ã€å®Ÿéš›ã«ãƒã‚¤ãƒ³ãƒ‰ã•ã‚ŒãŸå¾Œã® SQL ã‚’ã¿ãŸã„ãªãƒ¼ã£ã¦è¡å‹•ã«é§†ã‚‰ã‚Œã‚‹ã¨æ€ã„ã¾ã™ãŒ*1ã€ã©ã†é ‘å¼µã£ã¦ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’èªã‚“ã§ã‚‚ã‚ã‹ã‚Šã¾ã›ã‚“ãã€‚ ã“ã†ã„ã†ã¨ãã¯ä»•æ–¹ãªã„ã®ã§ã€$stmt ã¨ @bind ã‚’ä¸¡æ–¹ãƒã‚°ã«å‡ºã—ã¦ãŠèŒ¶ã‚’æ¿ã—ã¦ã„ã¾ã—ãŸã€‚ $self->log->_dump($stmt, @bind); # => SELECT * FROM user WHERE user_id = ?, [1234] ã§ã‚‚ã“ã‚Œã£
issm 2010/11/03
perl

dbi

db

sql

log

dbix-querylog
ãƒªãƒ³ã‚¯
DBIx::Encoding ã§Perlã¨DBé–“ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ & utf8 flagã‚’é€éŽçš„ã«æ‰±ã† - JPerl Advent Calendar 2009
DBIx::Encoding ã§Perlã¨DBé–“ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ & utf8 flagã‚’é€éŽçš„ã«æ‰±ã† - JPerl Advent Calendar 2009 Perl ã«é–¢ã™ã‚‹ã¡ã‚‡ã£ã¨ã—ãŸ Tips ã‚’ã®ã£ã‘ã¦ã¿ã‚‹ã‚ˆã€‚ã¡ã‚ƒã‚“ã¨ç¶šãã‹ãªï¼Ÿ ã¯ã˜ã‚ã« ã¯ã˜ã‚ã¾ã—ã¦ã€myfinderã¨ã„ã„ã¾ã™ã€‚ Casual Trackã®è¨˜äº‹ã‚’upã—ãŸã¨ãã«è©±ãŒå‡ºãŸã®ã§ã€è¨˜äº‹ã‚’æ›¸ã„ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã”ç´¹ä»‹ã™ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ DBIx::Encoding ã§ã™ã€‚ DBIx::Encodingã¯éžå¸¸ã«å°ç²’ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ãŒã€BKã ãªã¨è‡ªåˆ†ã§ã‚‚æ€ã£ã¦ã„ã¾ã™ã€‚ cho45ã•ã‚“ã®ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨å‰²ã¨è¶£ãŒè¿‘ã„æ°—ãŒã—ã¾ã™ã€‚ Casual Trackã®xai cronã•ã‚“ã®è¨˜äº‹ã«ã‚‚ã‚ã‚‹ã‚ˆã†ã«ã€ã„ã‚ã‚†ã‚‹ãƒ¢ãƒ€ãƒ³ãªPerlé–‹ç™ºã§ã¯ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã§è¨˜è¿°ã—ã€Œuse utf8;ã€ã—ã€æ–‡å—åˆ—ã¯ã€Œå…¥åŠ›æ™‚ã«decodeã€
issm 2009/12/19
perl

dbi

utf-8

encode

db

mysql
ãƒªãƒ³ã‚¯
ç”Ÿ DBI ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã® DBI Cookbook (2) - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
ã•ã¦ã€ã¾ã•ã‹ç¶šç·¨æ›¸ãã¨æ€ã‚ãªã‹ã£ãŸã‘ã©ã€d:id:ZIGOROu:20090731:1249050735 ã®ç¶šãã§ã™ã€‚ è¿½è¨˜ (2009-08-15T00:30:56+09:00) ã¡ãªã¿ã«ã€ä¸‹è¨˜ã§ç´¹ä»‹ã—ã¦ã‚‹æ–¹æ³•ã¯ä¸€èˆ¬çš„ã«ã¯ DBI ã®è³‡ç”£ãŒãŸãã•ã‚“åˆã£ã¦ãƒ¢ã‚´ãƒ¢ã‚´ãªçŠ¶æ³ã‚’ã©ã†ã™ã‚‹ã‹â€¦ã¿ãŸã„ãªçŠ¶æ³ã®äººå‘ã‘ã§ã™ã€‚ ä¸€èˆ¬çš„ã«ã¯å®œã—ããªã„ã§ã™ã€ã¨è¨€ã†ã“ã¨ã‚’è¸ã¾ãˆã¦ã©ã†ãžã€‚ DBI ã®æ‹¡å¼µã‚’ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã‚’ç”¨ã„ã¦è¡Œã† Subclassing the DBI ã«ã¡ã‚ƒã‚“ã¨æ›¸ã„ã¦ã‚ã‚‹ã‚“ã§ã™ãŒã€DBI ã¯ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹ç‚ºã®ç’°å¢ƒãŒæ•´ã£ã¦ã„ã¾ã™ã€‚ è«–ã‚ˆã‚Šè¨¼æ‹ ã€å®Ÿéš›ã®ä¾‹ã§ã™ã€‚ #!/usr/bin/perl use strict; use warnings; use DBI; use YAML; { package DBIx::Hideki; use base qw(DBI); package DBIx::Hide
issm 2009/08/17
perl

cpan

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 =
issm 2009/08/05
perl

cpan

dbi

db
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Perl ã®ãƒ†ã‚¹ãƒˆç”¨ã« MySQL ç’°å¢ƒã‚’è‡ªå‹•ã§æ§‹ç¯‰ã™ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« Test::mysqld ã‚’æ›¸ã„ãŸ
ORM ã‚„ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–¢é€£ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãªã©ã®ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã‚’æ›¸ãã«ã‚ãŸã£ã¦ã¯ã€ RDBMS ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ã—ã‹ã—ã€SQLite ã®ã‚ˆã†ãªã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ¼ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨æ¯”è¼ƒã™ã‚‹ã¨ã€ã‚µãƒ¼ãƒåž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ MySQL ã«æŽ¥ç¶šã—ã¦ãƒ†ã‚¹ãƒˆã‚’æ›¸ãã®ã¯ã€æ—¢å˜ã® MySQL ã®æ¨©é™è¨å®šã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚’æ°—ã«ã™ã‚‹å¿…è¦ãŒã‚ã£ãŸã‚Šã¨ã€ã„ã‚ã„ã‚ä¸ä¾¿ã§ã™ã€‚ãã“ã§ã€MySQL ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«è‡ªå‹•ç”Ÿæˆã—ã€ãƒ†ã‚¹ãƒˆãŒçµ‚ã‚ã£ãŸã‚‰å‰Šé™¤ã—ã¦ãã‚Œã‚‹ Perl ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« Test::mysqld ã‚’æ›¸ãã¾ã—ãŸã€‚ã“ã‚“ãªæ„Ÿã˜ã§ä½¿ã„ã¾ã™ã€‚ use DBI; use Test::mysqld; use Test::More; my $mysqld = Test::mysqld->new( my_cnf => { 'skip-networking' => '' }, # TCPæŽ¥ç¶šã‚’
issm 2009/08/04
perl

cpan

test

test-mysqld

mysql

db
ãƒªãƒ³ã‚¯
YappoLogs: KVSã§ORãƒžãƒƒãƒ‘ãƒ¼ã‚’ä½¿ã†ã¨ã„ã†äº‹
KVSã§ORãƒžãƒƒãƒ‘ãƒ¼ã‚’ä½¿ã†ã¨ã„ã†äº‹ ã‚±ã‚¤ãƒ¬ã‚.jpã®ä¸ã§ã‚±ã‚¤ãƒ¬ã‚.jpã«æ‹›å¾…ã—ã¦æ¬²ã—ã„äººã‚’å‘¼ã³ã‹ã‘ã¦ã‚‚çµ¶è³›ã‚¹ãƒ«ãƒ¼ã•ã‚Œã¦ã‚‹Yappoã§ã™ã€‚ã•ã¦ä»Šå›žã¯ä»Šå··ã§å¤§äººæ°—ã®Key Value Storageã§ORãƒžãƒƒãƒ‘ãƒ¼ã‚’ä½¿ã†äº‹ã«ã¤ã„ã¦ãŠè©±ã™ã‚‹ã®ã˜ã‚ƒã€‚ ä¸€èˆ¬çš„ã«ORãƒžãƒƒãƒ‘ãƒ¼ã¨ã¯ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒžãƒƒãƒ”ãƒ³ã‚°ã™ã‚‹ç‚ºã®ä»•çµ„ã¿ã®å‘¼ã³åã ã¨è¨€ã†ã®ã¯çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹æ‰€ã§ã™ã€‚ã¯ã„ã€ãã†ã™ã‚‹ã¨KVSã£ã¦ã®ã¯ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã‚ã‘ãªã®ã§ãŠã‹ã—ã„ã§ã™ãã€‚ä»Šå›žã®è©±ã¯Data::Model::Driver::Memcachedã‚’ä½¿ã†äº‹ã‚’å‰æã¨ã—ã¦ã‚‹ã®ã§å•é¡ŒãŒç„¡ã„ã®ã§ã™ã€‚ãªãœãªã‚‰ã€Œdata/object mapperã€ã¨ã‹æ›¸ã„ã¦ã‚ã‚‹ã‹ã‚‰ã€‚ ã„ã‚ã‚†ã‚‹PerlãªORãƒžãƒƒãƒ‘ãƒ¼ã£ã¦ã®ã¯è¡Œãƒ‡ãƒ¼ã‚¿ã‚’HASHã§ç®¡ç†ã—ã¾ã™ã€‚ãã‚Œã¯RDBãŒä¸€èˆ¬çš„ã«è¡¨å½¢å¼ã§ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã—ã¦ã„ã‚‹ã‹ã‚‰ãªã‚“ã ã¨æ€ã„ã¾ã™ã€‚ãªã‚“ã§KVSã‚’ã‚ªãƒ–ã‚¸
issm 2009/08/04
perl

memcached

db

keyvalue

orm

data-model
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸