[B! db][Perl] joan9ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

joan9 id:joan9

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

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

dbã¨Perlã«é–¢ã™ã‚‹joan9ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

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ã«ã‹ã‚‰ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€åž‹åã€ãƒ†ãƒ¼ãƒ–ãƒ«åã€ã‚«ãƒ©ãƒ åãªã©
joan9 2012/03/05
Emacs

DB

perl

elisp
ãƒªãƒ³ã‚¯
ç¬¬21å›žã€€KiokuDBï¼šãƒžãƒƒãƒ”ãƒ³ã‚°ãŒè¤‡é›‘ã™ãŽã‚‹ã¨æ„Ÿã˜ãŸã‚‰ | gihyo.jp
Shibuya.pm #12é€£å‹•ä¼ç”» æœ¬æ—¥é–‹å‚¬ã®Shibuya Perl Mongersãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ãƒˆãƒ¼ã‚¯#12ã®ãƒ†ãƒ¼ãƒžã¯ "No Perl, NoSQL, NoKVS" ã¾ãŸã¯ "Not only Perl, Not only SQL, Not only KVS" ã¨ã„ã†ã“ã¨ãªã®ã§ã€ä»Šå›žã¯ãã‚Œã«ã‚ã‚ã›ã¦YAPC::Asia 2009ã§ã‚‚ç´¹ä»‹ã•ã‚Œã¦ã„ãŸKiokuDBã«ã¤ã„ã¦ç°¡å˜ã«å–ã‚Šä¸Šã’ã¦ã¿ã¾ã™ã€‚ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ã¾ã‚‹ã”ã¨ä¿å˜ã™ã‚‹ ç‰§å¤§è¼”æ°ã‚‚ã€Žãƒ¢ãƒ€ãƒ³Perlå…¥é–€ã€ã®ãªã‹ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚·ãƒ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã€ã€Œâ åŸºæœ¬çš„ã«ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŒã£ã¦ãã‚‹æ§‹æˆã®ã¿ã«ã™ã‚‹ã¨ã€ORMã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã‚ãƒ£ãƒƒã‚·ãƒ¥ã®å°Žå…¥ã‚‚å«ã‚ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒæ¥½ã«ãªã‚Šã¾ã™ã€ã¨æ›¸ã„ã¦ã„ã‚‹ã‚ˆã†ã«ã€Perlã®ä¸–ç•Œã§ã¯æœ€è¿‘RDBMSã‚„ãã®ä¸Šä½å±¤ã§é ‘å¼µã‚Šã™ãŽã‚‹ã‚ˆã‚Šã€ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ä»•æ–¹ãã®ã‚‚ã®ã‚’å·¥å¤«ã—ã¦å®Ÿè£…ã‚„ä¿å®ˆã®ã—ã‚„
joan9 2009/12/01
kiokudb

perl

db
ãƒªãƒ³ã‚¯
SQLiteã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã®tips
DBå‘¨ã‚Šã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’é–‹ç™ºã—ã¦ã„ã‚‹å ´åˆã€ãƒ†ã‚¹ãƒˆDBã«SQLiteã‚’ä½¿ã†äº‹ãŒè‰¯ãã‚ã‚Šã¾ã™ã€‚ ãã®éš›ã€æ™®é€šã§ã‚ã‚Œã°ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã¨æ€ã„ã¾ã™ use Test::More tests => 1; use DBI; do { # SQLiteã§ä½¿ã†ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®š my $dbh = DBI->connect('dbi:SQLite:./test.db','',''); $dbh->do(q{CREATE TABLE foo (id INT, name TEXT)}); $dbh->do(q{INSERT INTO foo (id, name) VALUES (10,'nekokak')}); my $sth = $dbh->prepare('SELECT * FROM foo'); $sth->execute; my $row = $sth->fetchrow_hashref();
joan9 2008/12/13
perl

db

test

sqlite
ãƒªãƒ³ã‚¯
ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ãƒ‹ãƒ¥ãƒ¼ã‚¹ï¼ˆlivedoor ãƒ‹ãƒ¥ãƒ¼ã‚¹ï¼‰
joan9 2008/11/05
Perl

db
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
joan9 2006/11/12
perl

DBIC

DB
ãƒªãƒ³ã‚¯
ã€ç¶šã€‘ã‚„ã¯ã‚Š Perl ã¯ãƒ¡ãƒ¢ãƒªå–°ã„ãªè¨€èªžã€‚ãƒ‡ãƒ¼ã‚¿åž‹ã®å†…éƒ¨æ§‹é€
ä»¥å‰ã€ã€Œã‚„ã¯ã‚Š Perl ã¯ãƒ¡ãƒ¢ãƒªå–°ã„ãªè¨€èªžã€‚ãƒ‡ãƒ¼ã‚¿åž‹ã®å†…éƒ¨æ§‹é€ ã€ã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã™ãŒã€è‡ªåˆ†ã§æ›¸ã„ã¦ãŠããªãŒã‚‰ã—ã°ã‚‰ãç«‹ã¤ã¨å®Œå…¨å¿˜å´ã—ã¦ã¾ã—ãŸã€‚æ™‚ä»£ã¯å¤‰ã‚ã£ã¦ã€ä»Šä»•äº‹ã§é‹ç”¨ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒã¯ã€64bit ç‰ˆã®ï¼¯ï¼³ã§ã™ã€‚ æœ€è¿‘ã«ãªã£ã¦ã€DB ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ãƒ»é›†è¨ˆã—ãªãŒã‚‰ CSV ã«ãƒ€ãƒ³ãƒ—ã™ã‚‹ã£ã¦ãƒ—ãƒã‚°ãƒ©ãƒ ãŒã€ãƒ‡ãƒ¼ã‚¿æ•°ãŒéžå¸¸ã«å¤šã„ã¨ãã«ã€1.5 GByte ã»ã©ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã„ã¤ã¶ã—ã¦ã„ã‚‹ã£ã¦ã“ã¨ã«æ°—ãŒã¤ãã¾ã—ãŸã€‚ç†ç”±ã¯è‡³ã£ã¦ç°¡å˜ãªã®ã§ã™ãŒã€çµæ§‹ãƒãƒžãƒªã©ã“ã‚ãªã®ã§å‚™å¿˜éŒ²ã¨ã—ã¦è¨˜äº‹ã«ã—ã¦ãŠãã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã¿ãªã•ã‚“ã€ä»•äº‹ã¨ã‹ã§ã¯ç‰¹ã«ãã†ã ã¨æ€ã†ã®ã§ã™ãŒã€DBI ã®å‡¦ç†ã£ã¦ä½•ã‚‰ã‹ã®ãƒ©ãƒƒãƒ‘ãƒ¼ã‚’æ›¸ã„ã¦ä½¿ã£ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚åƒ•ã¯é©å½“ã«æ›¸ãã¨ã‚ˆãã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªã®ã§ã™ãŒã€ã‚¤ãƒ¡ãƒ¼ã‚¸çš„ã«ã¯ã€ã“ã‚“ãªå‡¦ç†ã®æµã‚Œã®ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¾ã—ãŸã€‚ ï¼ˆãƒ»ãƒ»ãƒ»ãˆã£ï¼Ÿãã‚“ãªã¸ã¼ã‚³ãƒ¼ãƒ‰æ›¸ã„ã¦ãªã„ï¼Ÿï¼Ÿãƒ»ãƒ»ãƒ»ã™
joan9 2006/11/08
perl

DB
ãƒªãƒ³ã‚¯
1