[B! DB] ihagã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ihag id:ihag

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

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

DBã«é–¢ã™ã‚‹ihagã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«(å…¥é–€ç·¨)
6. Step1 ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®æŠ½å‡º ç™ºé€æ‹…å½“è€…ãŒå—æ³¨ãƒªã‚¹ãƒˆã‚’ã‚‚ã¨ã«ã€å•†å“ã®åœ¨åº«ã‚’ç¢ºèªã—ã€åœ¨åº«ãŒ ã‚ã‚Œã°å•†å“ã‚’ç™ºé€ã™ã‚‹ã€‚ â‘ è¦æ±‚ä»•æ§˜ã®ã€Œå‹•è©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¡ â‘ ã«é–¢ã‚ã‚‹ã€Œåè©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¢ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£é–“ã®é–¢é€£ã«ç·šã‚’å¼•ã â‘£ å±žæ€§ã‚„å€™è£œã‚ãƒ¼ã‚‚åˆ†ã‹ã‚‹ç¯„å›²ã§æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é–“é•ã„ï¼ ã“ã®æ®µéšŽã§å®Ÿè£…ã‚’ãƒ—ãƒãƒ‘ãƒ†ã‚£ãƒ•ã‚¡ã‚¤ãƒ«ã«ã™ã‚‹ã¨ã‹ã€Enum ã«ã™ã‚‹ã¨ã‹æ±ºã‚æ‰“ã¡ã§ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã—ã¦è¡¨ã•ãªã„ã®ã¯ã‚„ ã‚ã¾ã—ã‚‡ã†ã€‚ ã¾ãšã€ã¯ã˜ã‚ã«ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’æŠ½å‡ºã—ã¾ã™ã€‚
ihag 2014/11/21
DB
ãƒªãƒ³ã‚¯
MDB2 Homepage
PEAR::MDB2 is a merge of the PEAR::DB and Metabase php database abstraction layers. Compatible with PHP 4.3.x upto 5.x It provides a common API for all supported RDBMS. The main difference to most other DB abstraction packages is that MDB2 goes much further to ensure portability. Among other things MDB2 features: An OO-style query API A DSN (data source name) or array format for specifying data
ihag 2007/10/23
PEAR::MDB2

PHP

PEAR

DB
ãƒªãƒ³ã‚¯
http://softlogger.com/6772/Ruby-on-Rails/sqldsl-a-ruby-way-to-build-sql-queries.aspx
ihag 2007/03/27
Rubyã«ã‚ˆã‚‹SQLã®wrapperã€‚ã“ã‚Œã¯ã‚ˆã•ãã†ã€‚

Ruby

DB
ãƒªãƒ³ã‚¯
ï¼ ITï¼šï¼»DB Interviewï¼½å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®â€œå®šèª¬â€ã‚’ãƒãƒƒã‚µãƒªåˆ‡ã‚‹ã€€ï¼ˆ1/2ï¼‰
ï¼»DB Interviewï¼½ æœ€æ–°RDBMSé¸ã³ã®ãƒã‚¤ãƒ³ãƒˆ ï½žæƒ…å ±ç³»ã‚·ã‚¹ãƒ†ãƒ ï½žï¼ˆå‰ç·¨ï¼‰ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®â€œå®šèª¬â€ã‚’ãƒãƒƒã‚µãƒªåˆ‡ã‚‹ ã‚¢ã‚¤ã‚¨ã‚¤ã‚¨ãƒ• ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° å¹³äº•æ˜Žå¤« 2006/7/11 æœ¬è¨˜äº‹ã¯å‰å¾Œç·¨ã«ã‚ã‚Šã€ãƒ“ã‚¸ãƒã‚¹ãƒ»ã‚¤ãƒ³ãƒ†ãƒªã‚¸ã‚§ãƒ³ã‚¹ã‚„ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã¨ã„ã£ãŸæƒ…å ±ãƒ»åˆ†æžç³»ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹RDBMSã®è£½å“é¸æŠžã®ãƒã‚¤ãƒ³ãƒˆã‚’æ¤œè¨¼ã™ã‚‹ã€‚ãŠè©±ã‚’ä¼ºã£ãŸã®ã¯BIã‚·ã‚¹ãƒ†ãƒ ã®ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã§ã¯ç¬¬ä¸€äººè€…ã®å¹³äº•æ˜Žå¤«æ°ã§ã‚ã‚‹ã€‚å‰ç·¨ã¨ãªã‚‹æœ¬ç¨¿ã§ã¯ã€RDBMSè£½å“ã®å¤‰é·ã¨æœ€æ–°ã®ãƒˆãƒ¬ãƒ³ãƒ‰ã«ã¤ã„ã¦æ•´ç†ã™ã‚‹ã€‚ï¼ˆç·¨é›†éƒ¨ï¼‰ â– 4å¤§ãƒ–ãƒ©ãƒ³ãƒ‰ãŒè¦‡ã‚’ç«¶ã„åˆã£ãŸ10å¹´å‰ã€ç”Ÿãæ®‹ã£ãŸã®ã¯ï¼Ÿ ä»Šå›žã¯ç§ã®å°‚é–€é ˜åŸŸã§ã‚ã‚‹BIï¼ˆãƒ“ã‚¸ãƒã‚¹ãƒ»ã‚¤ãƒ³ãƒ†ãƒªã‚¸ã‚§ãƒ³ã‚¹ï¼‰ã‚’ä¸å¿ƒã«ã€æƒ…å ±ç³»ã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ç”¨ã•ã‚Œã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€RDBMSï¼‰ã«ã¤ã„ã¦ãŠè©±ã—ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã€RDBMSè£½å“ã®æ´å²ã¨ãã®èƒŒå¾Œã«ã©ã†ã„ã£ãŸå‹•ããŒã‚ã£ãŸã®ã‹
ihag 2006/07/10
db

oracle
ãƒªãƒ³ã‚¯
ã‚·ã‚¹ãƒ†ãƒ ã®å¯¿å‘½ã¯ã‚³ãƒ¼ãƒ‰ã§æ±ºã¾ã‚‹ï¼ï¼ˆ1/3ï¼‰ â€• ï¼ IT
ã‚³ãƒ¼ãƒ‰ã¯ã‚·ã‚¹ãƒ†ãƒ ã®å¯¿å‘½ã«å¤§ããªå½±éŸ¿ã‚’ä¸Žãˆã¾ã™ã€‚ä»Šå›žã¯ã€ã‚³ãƒ¼ãƒ‰ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®é–¢ä¿‚ã‚’é€šã—ã¦ã“ã®ã“ã¨ã‚’è§£èª¬ã—ã¾ã™ã€‚ã“ã“ã§ã„ã†ã‚³ãƒ¼ãƒ‰ã¨ã¯ã€é¡§å®¢IDã€å—æ³¨ä¼ç¥¨ç•ªå·ãªã©ã€æ¥å‹™ä¸Šåˆ©ç”¨ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’è˜åˆ¥ãƒ»åˆ†é¡žã™ã‚‹ãŸã‚ã€å„ãƒ‡ãƒ¼ã‚¿ã®æœ¬æ¥ã®åå‰ã¨ã¯åˆ¥ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹è¨˜å·ã®ã“ã¨ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¯ãƒ‡ãƒ¼ã‚¿è¨è¨ˆã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®2ã¤ã®å½¹å‰²ãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¯ãƒ‡ãƒ¼ã‚¿è¨è¨ˆã®ä¸€ç’°ã¨ã—ã¦å®‰å®šã—ãŸã‚³ãƒ¼ãƒ‰ä½“ç³»ã‚’è¨è¨ˆã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚³ãƒ¼ãƒ‰ä½“ç³»ã«ä¾å˜ã—ãªã„ã‚ˆã†ã«è¨è¨ˆã™ã‚‹ã“ã¨ãŒæ±‚ã‚ã‚‰ã‚Œã¾ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã‚’é•·ãä½¿ã„ç¶šã‘ã‚‹ãŸã‚ã«ã¯ã€ ã‚³ãƒ¼ãƒ‰ä½“ç³»ã‚’é•·æœŸã«ã‚ãŸã‚Šå¤‰æ›´ã›ãšåˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ ã‚³ãƒ¼ãƒ‰ä½“ç³»ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¨ã®çµåˆåº¦ã‚’å°ã•ãã™ã‚‹ã“ã¨ ãŒé‡è¦ã§ã™ã€‚ãªãœãªã‚‰ã€ã‚³ãƒ¼ãƒ‰ã®ã‘ãŸãŒè¶³ã‚Šãªããªã£ãŸã‚Šã€ã‚³ãƒ¼ãƒ‰ã®åˆ†é¡žãŒæ¥å‹™ã«ããã‚ãªããªã£ãŸã‚Šã—ã¦ã€ã‚³ãƒ¼ãƒ‰ä½“ç³»ã®è¦‹ç›´ã—ã‚’è¡Œã†ã“ã¨ã«ãªã‚‹ã¨ã€æ¥å‹™ãƒ»
ihag 2006/06/07
db

development
ãƒªãƒ³ã‚¯
1