[B! tips][db] Wackyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Wacky id:Wacky

tipsã¨dbã«é–¢ã™ã‚‹Wackyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

${{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 11 Expression Edition (beta)
ä¼šç¤¾ã§ã¯è£½å“ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«Oracleã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚Oracleã‚’é¸æŠžã—ãŸã®ã¯ã„ã‚ã„ã‚ãªäº‹æƒ…ãŒã‚ã‚Šã¾ã™ã€‚ãã®é¸æŠžãŒæ£ã—ã‹ã£ãŸã®ã‹é–“é•ã£ã¦ã„ãŸã®ã‹ã¯ã¾ã åˆ†ã‹ã‚Šã¾ã›ã‚“ãŒã€ãªã‚“ã ã‹ã‚“ã è¨€ã„ãªãŒã‚‰ã€ç´ æ•µãªãƒã‚°ã‚’è¸ã¿ã¤ã¤æŠ±è…¹å‰é€²ã‚’ã•ã›ã¦ã„ã¾ã™ã€‚ãã‚“ãªå¤§å¥½ããªOracleã§ã™ãŒã€ä»Šã¾ã§ã¯10gã‚’ä½¿ã£ã¦ã„ã¾ã—ãŸã€‚ã§ã‚‚ã€ã‚ˆãåˆ†ã‹ã‚‰ãªã„ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æœŸé–“ãŒä»Šå¹´ã®å¤ã«çµ‚ã‚ã‚Šã¾ã™ã€‚ä¸–ç•Œã¯ã‚„ã£ã¨11gã«å…¥ã‚Œæ›¿ã‚ã‚Šã¾ã™ã€‚ä¼šç¤¾ã®è£½å“ã¯ã¨ã£ãã®æ˜”ã«11gã«å¯¾å¿œã—ã¦ã„ã¾ã—ãŸãŒã€é¡§å®¢ã®éƒ½åˆã§10gã‚‚IE6ã®ã‚ˆã†ã«ãªã‹ãªã‹ç„¡ããªã‚‰ãªã„ã‹ã‚‚ã—ã‚Œãªã„ã—ã€Chromeã®ã‚ˆã†ã«ï½¥ï½¥ï½¥ã€‚ ã•ã¦ã€11gã«ãªã£ã¦ã®ä¸æº€ã¨ã„ã†ã‹å›°ã£ãŸã“ã¨ã¯ã€è£½å“ã¯æ£å¼ãªOracleã‚’ä½¿ã£ã¦ã„ã¾ã—ãŸãŒã€é–‹ç™ºã¯10g Express Editionã‚’ä½¿ã†ã“ã¨ã‚‚å¤šã‹ã£ãŸã®ã§ã™ã€‚ç„¡æ–™ãªã®ã§ï½¥ï½¥ï½¥ã€‚11gã¯Express EditionãŒã§ã‚‹æ°—é…ã‚‚ãªããšã£ã¨æ‚²ã—ã„æ€
Wacky 2011/04/20
db

tips
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
Wacky 2009/02/18
db

tips
ãƒªãƒ³ã‚¯
2007-09-19
å‰å›žã«å¼•ãç¶šã„ã¦TextFieldãƒã‚¿ã‚’ã€‚ TextFieldWithHistory/TextFieldWithStoredHistoryã‚¯ãƒ©ã‚¹ã¨PropertiesComponentã‚¯ãƒ©ã‚¹ å±¥æ´æ©Ÿèƒ½ä»˜ããƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã£ã¦ã®ã¯ï¼Œ...WithHistoryã‹ã‚‰å¯Ÿã™ã‚‹ã“ã¨ãŒã§ãã‚ˆã†ã€‚WithStoredHistoryã‚„PropertiesComponentã«ã¤ã„ã¦ã¯ï¼ŒãŠã„ãŠã„èª¬æ˜Žã™ã‚‹ã¨ã—ã¦ï¼Œã¾ãšã¯å¤–è¦³ã‚’ã”æŠ«éœ²ã€‚ ã“ã‚Œã‚‚ã‚ãƒ£ãƒ—ã‚·ãƒ§ãƒ³éƒ¨åˆ†ã¯JPanelã€‚å·¦ã®TextFieldWithHistoryã«ã€Œ...ã€ãƒœã‚¿ãƒ³ãŒä»˜ã„ã¦ã„ã‚‹ãŒï¼Œã“ã‚Œã¯å¾Œä»˜ã‘ã—ãŸã‚‚ã®ã§ï¼ŒTextFieldWithHistory/TextFieldWithHistoryå˜ä½“ã§ã®å¤–è¦³ã¯å³å´ã®ãªã‚“ã‹ã‚¢ã‚¤ã‚³ãƒ³ãŒä»˜ã„ã¦ã‚‹ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒãã†ã€‚ è¦‹ãŸç›®ã‹ã‚‰æ©Ÿèƒ½ã¯æŽ¨æ¸¬ã§ãã‚ˆã†ã€‚ã“ã‚“ãªå…·åˆã«å…¥åŠ›å±¥æ´ã‚’ä¿å˜ã§ãã‚‹ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒï¼ŒTe
Wacky 2007/09/20
11gã®ãƒ‰ãƒ©ã‚¤ãƒã¯Java5ä»¥ä¸Šã—ã‹ã‚µãƒãƒ¼ãƒˆã—ãªã„ã‹ã‚‰ï¼ˆJ2SE1.4ã£ã¦ãªã«ï¼Ÿï¼‰

db

tips
ãƒªãƒ³ã‚¯
Webé«˜é€ŸåŒ– || ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°Blog: ã‚¤ãƒ³ã‚¿ãƒ¼ã‚ªãƒ•ã‚£ã‚¹
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
Wacky 2007/06/18
db

tips

web
ãƒªãƒ³ã‚¯
ã‚ã‚‹ nakagami ã®æ—¥è¨˜
ä¸‰è±UFJè²¸é‡‘åº«çªƒç›—äº‹ä»¶ã®å®¹ç–‘è€…ãŒé€®æ•ã•ã‚ŒãŸ å…ˆã€…æœˆãã‚‰ã„ã«æ‡²æˆ’è§£é›‡ã•ã‚Œã¦ã„ãŸå…ƒéŠ€è¡Œå“¡ãŒã‚ˆã†ã‚„ãé€®æ•ã•ã‚ŒãŸã€‚ 2äººã®å®¢ã‹ã‚‰ 2å„„6000ä¸‡ç›¸å½“ã®é‡‘å¡Šã‚’ç›—ã‚“ã ç–‘ã„ã¨ã®ã“ã¨ã€‚ è¢«å®³è€…ã¯ 60äººãã‚‰ã„ã§ 15å„„ãã‚‰ã„ã¨ã„ã†è©±ã ãŒã€è²¸é‡‘åº«ã«ä½•ãŒå…¥ã£ã¦ã„ã‚‹ã‹ã‚ã‹ã‚‰ãªã„ã€æœ¬å½“ã«ç›—ã‚“ã ã‹ã‚ã‹ã‚‰ãªã„ã€ã¨ã„ã†ã“ã¨ã§å…¨ã¦ã«ã¤ã„ã¦åˆ‘äº‹äº‹ä»¶åŒ–ã™ã‚‹ã®ã¯é›£ã—ã„ã¨ã®ã“ã¨ã ã£ãŸã€‚ ãªã®ã§ã€ã¨ã«ã‹ãã€é€®æ•ã«ã¾ã§æ¼•ãŽã¤â€¦ç¶šãã‚’èªã‚€
Wacky 2007/03/10
MSAccess.exe" "C:\foo\bar\baz.mdb" /compact

db

tips
ãƒªãƒ³ã‚¯
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç§»è¡Œè¨˜#2 VPNè¶Šã—ã®MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
å‰å›žã•ãã‚‰iDCã«ç§»è»¢ã—å§‹ã‚ãŸã€ã¨ã„ã†ã“ã¨ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€ã‚ã‚Œã‹ã‚‰ä¸€ãƒ¶æœˆã¡ã‚‡ã£ã¨ãŒçµŒéŽã—ã¾ã—ã¦ãã®å¾Œã‚‚é †èª¿ã« iDC ã¸ã®ç§»è»¢ãŒé€²ã‚“ã§ã„ã¾ã™ã€‚ã™ã§ã«ãƒ©ãƒƒã‚¯ã‚‚ã„ãã¤ã‹å€Ÿã‚Šã¦ã€ã‚µãƒ¼ãƒãƒ¼ã‚‚æ•°åå°ãŒã•ãã‚‰ iDC ã§ç¨¼å‹•ã—ã¦ã„ã¾ã™ã€‚å›žç·šãŒã“ã‚Œã¾ã§ã‚ˆã‚Šã‚‚é«˜é€Ÿãªãƒãƒƒã‚¯ãƒœãƒ¼ãƒ³ã«æŽ¥ç¶šã•ã‚Œã¤ã¤ã€å¸¯åŸŸå¹…ã‚‚å¤§ãããªã£ãŸã“ã¨ã‹ã‚‰ã€ç§»è»¢ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã«ã‚ˆã£ã¦ã¯ã“ã‚Œã¾ã§ã‚ˆã‚Šã‚‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‡ºã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚‚ã‚ã‚Šã¾ã™ã€‚ã†ã¡æ¯”è¼ƒçš„å¤§ããªãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãƒ•ã‚©ãƒˆãƒ©ã‚¤ãƒ•ã‚‚ç§»è»¢ã‚’å®Œäº†ã—ã¦ã„ã¾ã™ãŒã€ãŠã‹ã’ã•ã¾ã§ç”»åƒã®èªã¿å‡ºã—ãŒã‹ãªã‚Šé€Ÿããªã£ãŸã®ãŒä½“æ„Ÿã§ãã‚‹ãã‚‰ã„ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆãŒå‘ä¸Šã—ã¾ã—ãŸã€‚ æ—¢å˜ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç§»è»¢ã™ã‚‹ã«ã‚ãŸã£ã¦ã€ã©ã†ã„ã£ãŸæ§‹æˆã§ãã‚Œã‚’è¡Œã£ã¦ã„ã‚‹ã‹ã‚’ã¡ã‚‡ã£ã¨ç´¹ä»‹ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ç§»è»¢å½“åˆã¯ã€æ—¢å˜ã®ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã¯ã‚ã¾ã‚Šé–¢ä¿‚ã—ã¦ã„ãªã„ã‚µãƒ¼ãƒãƒ¼ç¾¤ã‹ã‚‰æ‰‹ã‚’ä»˜ã‘ã¾ã—ãŸã€‚ä¾‹ãˆã°åºƒå‘Šã®ã‚·ã‚¹ãƒ†ãƒ ã¨ã„ã£ãŸã€ã¯ã¦ãªã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’
Wacky 2007/03/09
ã„ãšã‚Œã‹ä¸€æ–¹ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã«ãƒžã‚¹ã‚¿ã‚’ç½®ã„ã¦ãŠãã€VPN ã‚’çµŒç”±ã—ã¦ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’ç«‹ã¦ã¦ã€å„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒãƒ¼ã¯å„ã€…è‡ªåˆ†ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã«ã‚ã‚‹ã‚¹ãƒ¬ãƒ¼ãƒ–ã¸æŽ¥ç¶šã—ã«ã„ãã€ã¨ã„ã†æ§‹æˆã§ã™ã€‚

db

tips

ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯
ãƒªãƒ³ã‚¯
BKCon 2006 - ã«ã½ãŸã‚“ç ”ç©¶æ‰€
æ˜¨æ—¥ã¯ BKCon 2006 ã«è¡Œã£ã¦ããŸã€‚ BK ã¨ã„ã†ã®ã¯ã€Œä¸€èˆ¬çš„ã«ã¯ãƒãƒƒãƒ‰ãƒŽã‚¦ãƒã‚¦ã®äº‹ã€ãªã‚“ã§ã™ãŒã€æ˜¨æ—¥ã®ã¯ã€BKCon ã¨è¨€ã£ã¦ã‚‚ã€ã‹ã¤ã¦é–‹å‚¬ã•ã‚ŒãŸ Bad Knowhow Conference 2004 ã®ç¶šç·¨ã¨ã‹ã§ã¯ãªãã€"B"atara "K"esuma "Con"ference 2006 ã§ã™ã€‚ â€»æ£ã—ãã¯æ¨ªæµœ Linux ãƒ¦ãƒ¼ã‚¶ã‚°ãƒ«ãƒ¼ãƒ—ä¸»å‚¬ã®ã€Œç¬¬ 65 å›žã‚«ãƒ¼ãƒãƒ«èªæ›¸ä¼šã€ã®ãƒ†ãƒ¼ãƒž "mixi.jp: Scaling Out With Open Source" ã§ã™ã€‚ ã¡ãªã¿ã«ã€Batara Kesuma ã•ã‚“ã¨ã„ã†ã®ã¯ã€æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ã®å–ç· å½¹ã€‚ mixi ã®è£å´ã‚’è¦‹ã›ã¾ã™ã¨ã„ã†ã‹ã€ã¡ã‚‡ã£ã¨ hip ãªè¨€ã„ã‹ãŸã‚’ã™ã‚Œã° "Inside mixi's backend" ã£ã¦ã‚«ãƒ³ã‚¸ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšã€ãƒ—ãƒ¬ã‚¼ãƒ³å†…å®¹ã¯ YAPC::Asia ã®æ™‚ã¨å¤§å‡¡åŒã˜ã§ã—ãŸãŒã€ãƒ—ãƒ¬ã‚¼ãƒ³ã®æŒã¡
Wacky 2006/07/07
åŸºæœ¬çš„ã« MySQL å‘¨ã‚ŠãŒä¸€ç•ªã‚ãƒ¢ã¨ã„ã†ã“ã¨ã§ã™ãã€‚

db

tips

web

è¨è¨ˆï¼ç®¡ç†

é–‹ç™º
ãƒªãƒ³ã‚¯
ã‚ã‚‹ nakagami ã®æ—¥è¨˜
ä¸‰è±UFJè²¸é‡‘åº«çªƒç›—äº‹ä»¶ã®å®¹ç–‘è€…ãŒé€®æ•ã•ã‚ŒãŸ å…ˆã€…æœˆãã‚‰ã„ã«æ‡²æˆ’è§£é›‡ã•ã‚Œã¦ã„ãŸå…ƒéŠ€è¡Œå“¡ãŒã‚ˆã†ã‚„ãé€®æ•ã•ã‚ŒãŸã€‚ 2äººã®å®¢ã‹ã‚‰ 2å„„6000ä¸‡ç›¸å½“ã®é‡‘å¡Šã‚’ç›—ã‚“ã ç–‘ã„ã¨ã®ã“ã¨ã€‚ è¢«å®³è€…ã¯ 60äººãã‚‰ã„ã§ 15å„„ãã‚‰ã„ã¨ã„ã†è©±ã ãŒã€è²¸é‡‘åº«ã«ä½•ãŒå…¥ã£ã¦ã„ã‚‹ã‹ã‚ã‹ã‚‰ãªã„ã€æœ¬å½“ã«ç›—ã‚“ã ã‹ã‚ã‹ã‚‰ãªã„ã€ã¨ã„ã†ã“ã¨ã§å…¨ã¦ã«ã¤ã„ã¦åˆ‘äº‹äº‹ä»¶åŒ–ã™ã‚‹ã®ã¯é›£ã—ã„ã¨ã®ã“ã¨ã ã£ãŸã€‚ ãªã®ã§ã€ã¨ã«ã‹ãã€é€®æ•ã«ã¾ã§æ¼•ãŽã¤â€¦ç¶šãã‚’èªã‚€
Wacky 2006/06/17
Response.BinaryWrite(adoRs("img").GetChunk(adoRs("img").ActualSize))

db

tips

web
ãƒªãƒ³ã‚¯
Linuxã®éšœå®³è§£æžæ‰‹é †æ›¸ã‚„ãƒ„ãƒ¼ãƒ«ãªã©ã‚’IPAãŒå…¬é–‹ï¼Œã€ŒPostgreSQL 8.1ã¯8.0ã‚ˆã‚Š1.5å€é€Ÿã„ã€ã¨ã®çµæžœã‚‚
å›³1â—PGClustgerã«ã‚ˆã‚‹3ãƒŽãƒ¼ãƒ‰ã®ã‚¯ãƒ©ã‚¹ã‚¿ã¨PostgreSQLå˜ä½“ã®æ€§èƒ½æ¯”è¼ƒï¼ˆ<a href="http://www.ipa.go.jp/software/open/forum/development/download/051115/db-cls.pdf" target="_blank">ã€ŒDBå±¤ï½žDBMSã‚¯ãƒ©ã‚¹ã‚¿è©•ä¾¡ç·¨ï½žã€</a>å›³ 5.2-1ï¼‰ å›³2â—MySQL Clusterã¨MySQLå˜ä½“ã®æ€§èƒ½æ¯”è¼ƒã€‚é’ã¨èµ¤ãŒMySQLå˜ä½“ï¼ŒMySQL Cluster SQLãƒŽãƒ¼ãƒ‰1ãƒŽãƒ¼ãƒ‰ãŒé»„è‰²ï¼Œ2ãƒŽãƒ¼ãƒ‰ãŒæ°´è‰²ï¼Œ3ãƒŽãƒ¼ãƒ‰ãŒç´«ï¼Œ4ãƒŽãƒ¼ãƒ‰ãŒãƒ”ãƒ³ã‚¯ï¼ˆ<a href="http://www.ipa.go.jp/software/open/forum/development/download/051115/db-cls.pdf" target="_blank">ã€ŒDBå±¤ï½žDBMSã‚¯ãƒ©ã‚¹ã‚¿è©•ä¾¡ç·¨ï½žã€<
Wacky 2005/11/23
linux

db

tips
ãƒªãƒ³ã‚¯
ActiveRecordã§on memory sqliteã‚’ä½¿ã† - 2nd life (ç§»è»¢ã—ã¾ã—ãŸ)
http://jamis.jamisbuck.org/articles/2005/10/03/easy-activerecord-scripts ãµã¤ãƒ¼sqliteã£ã¦DBã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã—ã¦ä½¿ã†ã‚“ã ã‘ã©ã€ãƒ¡ãƒ¢ãƒªä¸Šã«ãƒ‡ãƒ¼ã‚¿ã‚’ç½®ã„ã¦ã¤ã‹ã†äº‹ã‚‚ã§ãã‚‹ã€‚ã§ã€ãã®æ–¹æ³•ãŒARã ã¨é©šãã»ã©ç°¡å˜ã€‚ ActiveRecord::Base.establish_connection( :adapter => "sqlite", :dbfile => ":memory:" ) ã¨dbfileã«":memory"ã¨æŒ‡å®šã™ã‚‹ã ã‘ï¼çŸ¥ã‚‰ãªã‹ã£ãŸâ€¦ã€‚ã¨ã„ã†ã“ã¨ã§æ—©é€Ÿãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ¡ãƒ¢ãƒªã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã¨ã£ã¦ã¿ãŸã‚Šã€‚shared memory(/dev/shm)ã‚‚ãŠã¾ã‘ã«ã€‚ã¤ã‹ã£ãŸã‚½ãƒ¼ã‚¹ã¯ http://rails2u.com/tmp/ar_sqlite.rb.txt ã«ã€‚ user system total rea
Wacky 2005/10/08
sqliteã§ã€dbã‚’ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã§å‹•ã‹ã™æ–¹æ³•

db

tips
ãƒªãƒ³ã‚¯
1