[B! *db] komzã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

komz id:komz

*dbã«é–¢ã™ã‚‹komzã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{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}}

Oracleãƒ»DB2ãƒ»SQL Serverâ€¦â€¦ã€ç§‹ã®å¤œé•·ã¯æƒ…å ±åŽé›†ã€äº¤æµä¼šã«å‡ºã‹ã‘ã‚ˆã†ï¼ˆ1/2ï¼‰ ï¼ ï¼ IT
é£Ÿæ¬²ã®ç§‹ã€é‹å‹•ã®ç§‹ã€èŠ¸è¡“ã®ç§‹â€¦â€¦ã€‚ç§‹ã«ã¯ã„ã‚ã„ã‚ã¨ã‚ã‚Šã¾ã™ãŒã€ç§‹ã®å¤œé•·ã«ãƒ–ãƒã‚°ã‚’æ›¸ãã€ã¾ãŸã¯ãƒ–ãƒã‚°ã‚’èªã¿ã‚ã•ã‚‹ã¨ã„ã†ã®ã‚‚ã‚¢ãƒªã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä»Šæœˆã¯çŸ¥è˜ã®ã‚¤ãƒ³ãƒ—ãƒƒãƒˆãƒ»ã‚¢ãƒ—ãƒˆãƒ—ãƒƒãƒˆã®ãŸã‚ã®æƒ…å ±ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ™ãƒ³ãƒ€å„ç¤¾ã®ã‚¹ã‚¿ãƒƒãƒ•ãƒ–ãƒã‚°ã¯æ–°ã—ã„æƒ…å ±æº è£½å“ãƒ™ãƒ³ãƒ€ã‹ã‚‰ã®ç™ºè¡¨ã¨ã„ã†ã¨ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ãŒä¸å¿ƒã«ãªã‚Šã¾ã™ãŒã€ãƒ–ãƒã‚°ã¨ãªã‚‹ã¨é•ã†è¦–ç‚¹ã§èªã‚ã‚‹ã®ã§æ–°é®®ã§ã™ã€‚ç´°ã‹ãã“ã ã‚ã‚Šã®ã‚ã‚‹è§£èª¬ã€æ„›ç€ãŒä¼ã‚ã£ã¦ãã‚‹ã‚¢ãƒ”ãƒ¼ãƒ«ãªã©ã€ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ãªã©ã‚ˆã‚Šã‚‚è©³ã—ãã€èª¬å¾—åŠ›ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€ã™ãã«æ›´æ–°ã§ãã‚‹ã®ã§ã€è©±é¡ŒãŒæ–°é®®ãªã®ã‚‚é…åŠ›ã§ã™ãã€‚ ãŸã ã—ã€ãƒ–ãƒã‚°ã®å ´åˆã€è£½å“ã«ã‹ã‹ã‚ã‚Šã®æ·±ã„ç«‹å ´ã®äººã‚„ãƒãƒ¼ãƒ ãŒåŸ·ç†ã—ã¦ã„ã¦ã‚‚ã€Œä¼šç¤¾ã®å…¬å¼è¦‹è§£ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€ã¨æ–ã‚Šæ›¸ããŒã‚ã‚‹ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ã®ã§ã€äº‹å®Ÿé–¢ä¿‚ã®ç¢ºèªã®éš›ã«ã¯ã”æ³¨æ„ã‚’ã€‚å…¬å¼ã§ã¯ãªã„ã«ã—ã¦ã‚‚ã€ãƒ–ãƒã‚°ã¯è²´é‡ãªæƒ…å ±æºã®1ã¤ã¨ã„ãˆã¾ã™ã€‚ä»Šæœˆã¯å•†ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ™ãƒ³ãƒ€ã®ãƒ–ãƒã‚°ã‚’è¦‹
komz 2008/10/16
*db
ãƒªãƒ³ã‚¯
Scaffoldr
Scaffoldr - a PHP scaffold (skeletal) generator for MySQL-Databases. News 09/07/2008 - The latest revision, 2.0-05, brings you flexible primary key placement, column sort toggle and foreign key handling. 19/06/2008 - New Release: 2.0-03. This release fixes some input data bugs and improves the quality of the generated PHP and HTML source code. 16/01/2008 - Fixed a bug with non-numerical id's. Than
komz 2008/06/24
*db
ãƒªãƒ³ã‚¯
PostgreSQLã«è¶³ã‚Šãªã„ã‚‚ã®ï¼XMLDBã¸ã®æœŸå¾…ï¼ˆ1/2ï¼‰ ï¼ ï¼ IT
å±±ã«ç™»ã‚ã†ã¨ã™ã‚‹ã¨ãã€å±±é ‚ã¾ã§ä¸€ç›´ç·šã«èµ°ã‚‹ãƒãƒ¼ãƒ—ã‚¦ã‚¨ãƒ¼ãŒã‚ã£ãŸã‚‰ä¾¿åˆ©ã§ã™ã‚ˆãã€‚ã¾ãŸã¯ä¸€æ°—ã«å±±é ‚ã¾ã§ã‚¸ãƒ£ãƒ³ãƒ—ã§ããŸã‚‰ãªã‚“ã¦æ¥½ãªã“ã¨ã‹ã€‚ã—ã‹ã—å®Ÿéš›ã¯ãã†ã¯ã„ãã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é€²åŒ–ã‚‚åŒã˜ã“ã¨ãŒã„ãˆã‚‹ãã†ã§ã™ã€‚ä»Šæœˆã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£ã®ã‚¤ãƒ™ãƒ³ãƒˆãŒå¤šæ•°ã‚ã‚Šã€ãã‚Œãžã‚Œã®é–‹ç™ºå‹•å‘ã‚„æ™®åŠçŠ¶æ³ãŒãƒ¬ãƒãƒ¼ãƒˆã•ã‚Œã¾ã—ãŸã€‚ â– Bruce Momjianã¯â€œThe Long and Winding Roadâ€ã‹ã‚‰é ‚ã‚’ç›®æŒ‡ã™ ä»Šå¹´ã¯ãŸã³ãŸã³è©±é¡Œã«ã—ã¦ã„ã‚‹ã‚ˆã†ã«ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã®MySQLè²·åŽãŒã‚ã‚Šã€MySQLã¯ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºé ˜åŸŸã«å‘ã‘ã¦å¤§ããã‚¸ãƒ£ãƒ³ãƒ—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ãã®ä¸€æ–¹ã€ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DBMSã®ä¸¡é›„ã¨ã—ã¦MySQLã¨ä¸¦ã‚“ã§ã„ãŸPostgreSQLã¯ã©ã†ãªã‚‹ã®ã‹ã€ã¨ã„ã†ç–‘å•ãŒè‡ªç„¶ã¨ã‚ã„ã¦ãã¾ã™ã€‚ 6æœˆ6æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã€ŒPostgreSQL Conference 2008ã€ã§ã¯ãã®ç”ãˆã®ä¸€éƒ¨ãŒåž£é–“
komz 2008/06/23
*db
ãƒªãƒ³ã‚¯
é«˜æ©Ÿèƒ½ãªMySQLãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰Â·Sequel Pro MOONGIFT
Webã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºï¼è¦DBã¨ã„ã†é¢¨æ½®ãŒã‚ã‚‹ã€‚ç¢ºã‹ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã§ãã‚‹ã¨å¯èƒ½æ€§ãŒé£›èºçš„ã«æ‹¡å¤§ã™ã‚‹ã€‚ã•ã‚‰ã«æœ€è¿‘ã¯å„ªç§€ãªO/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚‚ç™»å ´ã—ã€DBã‚’DBã¨ã—ã¦æ„è˜ã™ã‚‹ã“ã¨ãªãé–‹ç™ºãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã‚‹ã€‚ ãƒ¡ã‚¤ãƒ³ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ ã ãŒãã®ãŸã‚ã«æ§‹é€ ã‚„å€¤ã®åˆ¶ç´„ã‚’è¨å®šã›ãšã«é‹ç”¨ã•ã‚Œã¦ã—ã¾ã†ã®ã‚‚ã‚ˆãè¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸã€‚DBã®ä½¿ã„æ–¹ã‚„é‹ç”¨æ³•ã‚’å†æ¤œè¨Žã™ã¹ãã¨ããªã®ã‹ã‚‚çŸ¥ã‚Œãªã„ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Sequel Proã€Mac OSXå‘ã‘ã®MySQL ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã ã€‚ Sequel Proã¯Cocoa MySQLã‹ã‚‰ãƒ•ã‚©ãƒ¼ã‚¯ã—ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€Cocoa MySQLåŒæ§˜ã«GUIãƒ™ãƒ¼ã‚¹ã§å‹•ä½œã™ã‚‹MySQL ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã«ãªã£ã¦ã„ã‚‹ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é¸æŠžã—ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã€è¿½åŠ ã€å‰Šé™¤ã¯ã‚‚ã¡ã‚ã‚“ã®ã“ã¨ã€ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã®ä¿®æ£ãªã©ã‚‚å®¹æ˜“ã«ã§ãã‚‹ã€‚æŽ¥ç¶šã¯SSHã‚’ä½¿ã£ãŸã‚‚ã®ã«ã‚‚
komz 2008/06/10
*db

mysql
ãƒªãƒ³ã‚¯
MySQL :: ä¸–ç•Œã§ã‚‚ã£ã¨ã‚‚æœ‰åãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
HeatWave Use automated and integrated generative AI and machine learning (ML) in one cloud service for transactions and lakehouse scale analytics. Get faster insights from all your data with unmatched performance and deploy apps in your choice of cloud providers. Learn More Â» MySQL Enterprise Edition The most comprehensive set of advanced features, management tools and technical support to achieve
komz 2008/06/10
*db

mysql
ãƒªãƒ³ã‚¯
MOONGIFT: MySQLã®ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã€ŒMySQL Workbenchã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Railsã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨å®šã‚’Migrationãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã„ã¦ã„ã£ã¦ã€å³åæ˜ ã•ã›ãªãŒã‚‰é–‹ç™ºã‚’é‡ãã¦ã„ãã€‚ãã®ãŸã‚ã€å¹¾äººã‹ã§é–‹ç™ºã‚’è¡Œã£ã¦ã„ã‚‹ã¨ã€å¾ã€…ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ§‹é€ ãŒè¤‡é›‘åŒ–ã—ã€æœ€é©åŒ–ã•ã‚Œã¦ã„ãªã„æ§‹é€ ã«ãªã£ã¦ã—ã¾ã†ã€‚ã“ã‚Œã¯Railsã«é™ã‚‰ãšã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã§ã¯å¸¸ã«ç”Ÿã˜ã‚‹ã‚‚ã®ã ã‚ã†ã€‚ ãƒ¡ã‚¤ãƒ³ç”»é¢ åˆæœŸã®é ƒã‹ã‚‰ã™ã¹ã¦ã‚’æƒ³å®šã—ã¦ä½œã‚Šä¸Šã’ã¦ã„ãã“ã¨ã¯é›£ã—ã„ãŒã€ã‚ã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§æ£è¦åŒ–ã—ã¦ã„ãå¿…è¦ãŒç”Ÿã˜ã‚‹ã ã‚ã†ã€‚ãã®æ™‚ã«å½¹ç«‹ã¤ã®ãŒã“ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯MySQL Workbenchã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã ã€‚ MySQL Workbenchã¯ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã€ãƒ“ãƒ¥ãƒ¼ã€ãƒ«ãƒ¼ãƒãƒ³ã€SQLã‚¹ã‚¯ãƒªãƒ—ãƒˆç‰ã‚’ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ«çš„ã«è¨è¨ˆã§ãã‚‹ã€‚ãƒ€ã‚¤ã‚¢ã‚°ãƒ©ãƒ ã‚‚ä½œæˆã§ãã€æ—¢ã«ä½œæˆã•ã‚Œã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ãƒ“ãƒ¥ãƒ¼ç‰ã‚’ãƒ‰ãƒ©ãƒƒã‚°ã‚¢ãƒ³ãƒ‰ãƒ‰ãƒãƒƒãƒ—ã§é…ç½®ã—ã€ãã“ã«ç·šã‚’å¼•ã„
komz 2008/04/25
*db

mysql
ãƒªãƒ³ã‚¯
MOONGIFT: Â» MySQLã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã€Œmysqldocã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Javadocã€PHPDocãªã©ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚½ãƒ¼ã‚¹ã‹ã‚‰ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ç”Ÿæˆã™ã‚‹ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¯å¹¾ã¤ã‹å˜åœ¨ã™ã‚‹ã€‚ãã¡ã‚“ã¨ã‚³ãƒ¡ãƒ³ãƒˆã‚’æ›¸ã‘ã°ã€ãã‚ŒãŒãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ãªã£ã¦ãã‚Œã‚‹ã®ã§ã€æ‰‹é–“ãŒæ¸›ã‚Šã¤ã¤ã‚‚ãƒ—ãƒã‚°ãƒ©ãƒ ã®å“è³ªã¯å‘ä¸Šã™ã‚‹ã¨ä¸€çŸ³äºŒé³¥ã ã€‚ å‡ºåŠ›ä¸ ãã—ã¦åŒæ§˜ã®æ‰‹æ³•ã‚’MySQLã«ã‚‚é©ç”¨ã—ã‚ˆã†ã¨è¨€ã†ã®ãŒã“ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯mysqldocã€MySQLã®æ§‹é€ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆå‡ºåŠ›ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ mysqldocã¯ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ä¸Šã§åˆ©ç”¨ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€æŒ‡å®šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆã¾ãŸã¯å…¨ã¦ï¼‰ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹é€ ã‚’ä¸€è¦§ã«ã—ã¦ãã‚Œã‚‹ã€‚ã‚«ãƒ©ãƒ åã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ã€åž‹ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã€è©³ç´°ãªèª¬æ˜Žã‚’ä¸€è¦§ã«ã™ã‚‹ã€‚ HTMLã§ã®å‡ºåŠ›ä¾‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ç‰ã‚‚å‡ºåŠ›ã•ã‚Œã‚‹ã€‚çµæžœã¯ãƒ†ã‚ã‚¹ãƒˆï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆï¼‰ã€HTMLã¾ãŸã¯XMLã§å‡ºåŠ›ãŒå¯èƒ½ã ã€‚SSLã‚’ä½¿ã£ãŸæŽ¥ç¶šã¸ã®å¯¾å¿œã‚„ã€ãƒˆãƒªã‚¬ãƒ¼ã‚„ãƒ¦ãƒ¼ã‚¶ãƒ•ã‚¡ãƒ³ã‚¯ã‚·
komz 2008/04/22
mysql

*db
ãƒªãƒ³ã‚¯
Perlã®æ£è¦è¡¨ç¾ã‚’ç”¨ã„ãŸç½®æ› - builder by ZDNet Japan
æ³¨ç›®æ€¥ä¸Šæ˜‡ä¸ã®DaaSæœ€æ–°æƒ…å ± ã‚³ãƒãƒŠç¦ã‚’èƒŒæ™¯ã«åˆ©ç”¨è€…ã¨æ©Ÿèƒ½ã‚’æ‹¡å¤§ä¸ Azure Virtual Desktopæœ€æ–°æƒ…å ± MSã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“è€…ãŒç´¹ä»‹ ãƒžãƒ«ãƒã‚¯ãƒ©ã‚¦ãƒ‰ç’°å¢ƒã®ä¿è·ã‚’è¿½æ±‚ã™ã‚‹ Microsoft Defender for Cloud æ–°OSã®Win11ã¯ã©ã†é€²åŒ–ã—ãŸã‹ ãƒ“ã‚¸ãƒã‚¹ä¸Šã®å½¹å‰²ã€é–‹ç™ºã®è¦å› ã¨ Win11ãŒç›®æŒ‡ã—ãŸ5ã¤ã®ãƒã‚¤ãƒ³ãƒˆã‚’ç´¹ä»‹ å¹´é–“5,000ä»¶ã®å•ã„åˆã‚ã›ã«å¯¾å¿œ ç–‘å•ã‚’è§£æ¶ˆã—ãŸã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚‚ç”ãˆã‚‹æƒ…ã‚·ã‚¹ã‚‚ ã¿ã‚“ãªå¹¸ã›ã«ãªã‚‹ãƒ˜ãƒ«ãƒ—ãƒ‡ã‚¹ã‚¯ã®æœ€é©è§£ ã“ã‚Œã‹ã‚‰ã®ç¤¾å†…DX çœŸã®DXã®ãŸã‚ã€ã¾ãšã¯ç¤¾å†…ã®ãƒ‡ã‚¸ã‚¿ãƒ«åŒ–ã‚’ DXã®ãƒ•ã‚¡ãƒ¼ã‚¹ãƒˆã‚¹ãƒ†ãƒƒãƒ—ã®ãƒ’ãƒ³ãƒˆ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æ´»ç”¨ã¯ã‚ãŸã‚Šã¾ãˆï¼ ãã‚“ãªä»Šã ã‹ã‚‰ã“ãæ”¹ã‚ã¦è€ƒãˆã‚‹ ä¼æ¥ITã«ãŠã‘ã‚‹OSSæ´»ç”¨ã®ãƒ¡ãƒªãƒƒãƒˆã¨ãƒªã‚¹ã‚¯ Summit è¬›æ¼”ãƒ¬ãƒãƒ¼ãƒˆå…¬é–‹ï¼ ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³å¿—å‘çµŒå–¶ã‹ã‚‰DXæŽ¨é€²ã®è¦šæ‚Ÿ ãƒ–ãƒ¬ã‚¤ãƒ³ãƒ†ãƒƒã‚¯ã®å¯èƒ½æ€§ã¾ã§ ã„ã¾æ±‚ã‚ã‚‰ã‚Œã‚‹I
komz 2008/01/20
*db

æ£è¦è¡¨ç¾
ãƒªãƒ³ã‚¯
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ãªã„äººã®ãŸã‚ã®ã€ŒWebï¼‹DBã‚µã‚¤ãƒˆã€å…¥é–€---ç›®æ¬¡ï¼šITpro
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã‚·ã‚¹ãƒ†ãƒ ã‚’è£å´ã§ç¨¼å‹•ã•ã›ã¦ã„ã‚‹ä¼æ¥ã‚µã‚¤ãƒˆãŒæ€¥å¢—ã—ã¦ã„ã¾ã™ã€â€•â€•ã“ã‚Œã ã‘æ›¸ãã¨æ•°å¹´å‰ã«èªžã‚Šã¤ãã•ã‚ŒãŸãƒ‹ãƒ¥ãƒ¼ã‚¹ã§ã™ã€‚ç¢ºã‹ã«å¤§ä¼æ¥ã¯ï¼Œè‡ªç¤¾ã®Webã‚·ã‚¹ãƒ†ãƒ ã«ä½•å„„å††ã¨ã„ã†è¦æ¨¡ã®æŠ•è³‡ã‚’ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ´»ç”¨ã‚’æŽ¨é€²ã—ã¦ãã¾ã—ãŸã€‚ ã§ã¯ä¸å°ä¼æ¥ã§ã¯ã©ã†ã§ã—ã‚‡ã†ã‹ã€‚ ç§ã¯ç¾è·ã®Webãƒ—ãƒã‚°ãƒ©ãƒžã§ã™ã€‚å¤šãã®é–‹ç™ºæ¡ˆä»¶ã«ã‚¿ãƒƒãƒã—ã¦ãã¾ã—ãŸãŒï¼Œå¤§å¤šæ•°ã®ä¸å°ä¼æ¥ã«ã¯ãã‚“ãªäºˆç®—ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚è‡ªç¤¾ã‚µã‚¤ãƒˆã¯ãƒ¬ãƒ³ã‚¿ãƒ«ãƒ»ã‚µãƒ¼ãƒãƒ¼ã ã£ãŸã‚Šï¼Œãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’å¥‘ç´„ãƒ—ãƒãƒã‚¤ãƒ€ä¸Šã§æ§‹ç¯‰ã—ã¦ã„ã‚‹ã¨ã„ã†è¦æ¨¡ï¼ˆå¹´é–“ç¶æŒè²»20ä¸‡ï½ž100ä¸‡å††ï¼‰ãŒã»ã¨ã‚“ã§ã™ã€‚Webã‚„DBã«ã¤ã„ã¦æ·±ã„çŸ¥è˜ã®ã‚ã‚‹æ‹…å½“è€…ã‚‚ã„ã¾ã›ã‚“ã€‚ ã—ã‹ã—ï¼Œã“ã“3å¹´ã»ã©ï¼Œã“ã†ã—ãŸå°ã•ãªè¦æ¨¡ã®ä¼æ¥ã‚µã‚¤ãƒˆã‹ã‚‰ï¼Œç¶šã€…ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’çµ„ã¿è¾¼ã‚“ã Webã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºä¾é ¼ãŒèˆžã„è¾¼ã‚“ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚‚ã¯ã‚„ï¼ŒWebï¼‹DBã‚·ã‚¹ãƒ†ãƒ ã¯ï¼ŒWebã‚µã‚¤ãƒˆã®è¦æ¨¡ã«é–¢ä¿‚ãªãå¸¸è˜ã¨ãªã‚Šã¤ã¤ã‚
komz 2008/01/19
*db
ãƒªãƒ³ã‚¯
53. ã¾ã ã€PEAR::DBã‚’ãŠä½¿ã„ã®æ–¹ã¸
PHPã‹ã‚‰DBã‚’ä½¿ã†ã¨ãã«ã¯PEAR::DBã‚’ãŠä½¿ã„ã®æ–¹ã‚‚ã¾ã ãŸãã•ã‚“ã„ã‚‰ã£ã—ã‚ƒã‚‹ã¨æ€ã„ã¾ã™ã€‚ã—ã‹ã—ã€PEAR::DBã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã‚‚ã€ŒThis package been superseded by MDB2 but is still maintained for bugs and security fixesã€ï¼ˆã“ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ä»£ã‚ã‚Šã«MDB2ã®ä½¿ç”¨ãŒæŽ¨å¥¨ã•ã‚Œã¾ã™ãŒã€ãƒã‚°ã®ä¿®æ£ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã¯å¼•ãç¶šãè¡Œã‚ã‚Œã¾ã™ã€‚ï¼‰ã¨æ›¸ã‹ã‚Œã¦ã„ã‚‹ã¨ãŠã‚Šã€ä»Šå¾Œã¯PEAR::MDB2ã‚’ãŠä½¿ã„ã«ãªã‚‹ã“ã¨ã‚’ãŠå¥¨ã‚ã„ãŸã—ã¾ã™ã€‚ ã¨ã„ã†ã“ã¨ã§ã€ä»Šå›žã¯PEAR::MDB2ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ PEAR::MDB2 ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« http://www.go-pear.org/manual/ja/package.database.mdb2.php MDB2ã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã‚’ã”è¦§ä¸‹ã•ã„ http://ww
komz 2007/09/17
*db

php
ãƒªãƒ³ã‚¯
InnoDB ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007 - akiyan.com ç®¡ç†äººãƒ¡ãƒ¢
http://www.mysql-ucj2007.jp/details/j25.html æœ¨ä¸‹ é–æ–‡ æ° NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨æŠ€è¡“SEéƒ¨é–€ DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— ï¼ˆã€ŒInnoDBã€ã¯ã€Œã„ã‚“ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã†ã‚‰ã—ã„...ä»Šã¾ã§ã€Œã„ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã£ã¦ã¾ã—ãŸï¼‰ InnoDBã‚’ãªãœä½¿ã†ã‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ ã‚³ãƒŸãƒƒãƒˆã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã€ã‚»ãƒ¼ãƒ–ãƒã‚¤ãƒ³ãƒˆ å¤–éƒ¨ã‚ãƒ¼ è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª MyISAMã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã¨ã‚‚ã«æ™‚é–“ãŒã‹ã‹ã‚‹ InnoDBã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã®ç›¸é–¢ãŒãªã„ InnoDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®çŽ‹é“çš„ã‚¢ãƒ—ãƒãƒ¼ãƒ ã‚¯ã‚¨ãƒªã‚’æ”¹å–„ã—ã¦å…¨ä½“çš„ã«å‡¦ç†åŠ¹çŽ‡ã‚’ä¸Šã’ã‚‹ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºã‚’ã§ãã‚‹ã ã‘å°ã•ã ãƒ¡ãƒ¢ãƒªã‚’ã§ãã‚‹ã ã‘å¤šãç©ã‚€ ã‚³ãƒŸãƒƒãƒˆæ€§èƒ½ï¼ˆåŒæœŸæ›¸ãè¾¼ã¿ï¼‰ innodb_flush_log_at_trx_commit=1,0,2
komz 2007/09/14
*db

innodb
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
komz 2007/09/13
*db

performance
ãƒªãƒ³ã‚¯
1