[B! database][introduction] uchiuchiyamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

uchiuchiyama id:uchiuchiyama

databaseã¨introductionã«é–¢ã™ã‚‹uchiuchiyamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

ã€Œå…¨1ä¸‡9831æ›²ã€ã‚‚ã®ãƒ•ãƒªãƒ¼BGMãŒåˆ©ç”¨ã§ãã‚‹ã€Œãƒ•ãƒªãƒ¼BGMãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãŒã€æ¥å‹™åˆ©ç”¨ã«é™ã‚‰ãšå…¨ã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ã«å¯¾ã—ã¦ç„¡å„Ÿæä¾›ã‚’é–‹å§‹ã¸ã€‚ãƒ•ãƒªãƒ¼BGMä½œæ›²å®¶ãŒä½œæ›²ã—ãŸæ¥½æ›²ã‚’ã€ç”¨é€”ã«ã‚ã‚ã›ã¦æ¤œç´¢ãƒ»åˆ©ç”¨ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹
ä¸€èˆ¬ç¤¾å›£æ³•äººãƒ•ãƒªãƒ¼BGMå”ä¼šã¯ã€åŒå”ä¼šãŒå±•é–‹ã™ã‚‹ã€Œãƒ•ãƒªãƒ¼BGMãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã«ã¤ã„ã¦ã€11æœˆ26æ—¥ï¼ˆæ°´ï¼‰ã‚ˆã‚Šæ¥å‹™åˆ©ç”¨ã«é™ã‚‰ãšå…¨ã¦ã®ã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ã«å¯¾ã—ã¦ã‚‚åŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç„¡å„Ÿæä¾›ã‚’é–‹å§‹ã™ã‚‹ã“ã¨ã‚’ç™ºè¡¨ã—ãŸã€‚ ã“ã‚Œã¾ã§æ•™è‚²æ©Ÿé–¢åŠã³æ¥å‹™ã«ãŠã„ã¦ãƒ•ãƒªãƒ¼BGMã®åˆ©ç”¨ãŒäºˆæƒ³ã•ã‚Œã‚‹æ”¾é€æ¥ç•Œé–¢ä¿‚è€…ã€æ˜ åƒåˆ¶ä½œä¼šç¤¾ã€ã‚²ãƒ¼ãƒ ç‰ã®åˆ¶ä½œè€…ã«å¯¾ã—ã¦ã®ã¿æä¾›ã•ã‚Œã¦ã„ãŸãƒ•ãƒªãƒ¼BGMãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚ã—ã‹ã—æœ¬ç™ºè¡¨ã«ã‚ˆã‚Šã€æ¥å‹™åˆ©ç”¨ä»¥å¤–ã§ã‚³ãƒ³ãƒ†ãƒ³ãƒ„åˆ¶ä½œã‚’è¡Œã†å…¨ã¦ã®ã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ã‚‚åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã¨ãªã‚‹ã€‚ ã€ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ã€‘ æœ¬æ—¥ã‚ˆã‚Šã€å…¨ã¦ã®ã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ã®ã¿ãªã•ã¾ã«å‘ã‘ã€Œãƒ•ãƒªãƒ¼BGMãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã®æä¾›ã‚’é–‹å§‹ã„ãŸã—ã¾ã™ï¼ å½“å”ä¼šã”è³›åŒä½œå®¶ã•ã¾ã®ç´„1.9ä¸‡æ›²ã®ä¸ã‹ã‚‰ã€ç°¡å˜ã«æ¥½æ›²ã‚’æ¤œç´¢ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ãœã²ã”æ´»ç”¨ãã ã•ã„ã¾ã›ï¼ ï¼ˆã”åˆ©ç”¨ã«ã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ç™»éŒ²ãŒå¿…è¦ã§ã™ï¼‰https://t.co/cl2GImLICl â€” ä¸€èˆ¬ç¤¾å›£æ³•äººãƒ•ãƒªãƒ¼BG
uchiuchiyama 2024/11/28
database

music

sound

introduction
ãƒªãƒ³ã‚¯
æ—¥æœ¬ã®è¡Œæ”¿æ©Ÿé–¢ç‰ãŒå…¬é–‹ã—ã¦ã„ã‚‹APIã«ã¤ã„ã¦ã®ã¾ã¨ã‚ï¼ˆ2016å¹´8æœˆ17æ—¥æš«å®šç‰ˆã€‚éšæ™‚æ›´æ–°ï¼‰ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã“ã®è¨˜äº‹ã¯ä¸‹è¨˜ã®URLã«ã‚ã‚‹ã‚³ãƒŸãƒƒã‚¯ãƒžãƒ¼ã‚±ãƒƒãƒˆ90ã§é ’å¸ƒã—ãŸåŒäººèªŒã¨è‡ªåˆ†ãŒç®¡ç†ã™ã‚‹ãƒ–ãƒã‚°ã®è¨˜äº‹ã‚’å¾®ä¿®æ£ã—ã€è»¢è¼‰ã—ãŸã‚‚ã®ã§ã™ã€‚ å—é–¢æ±é–‹ç™ºæ©Ÿæ§‹ : åŒäººèªŒã€Œæ—¥æœ¬ã®è¡Œæ”¿æ©Ÿé–¢ãŒå…¬é–‹ä¸ã®APIã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ãŸæœ¬ã€ã‚’å…¬é–‹ã—ã¾ã—ãŸ http://blog.livedoor.jp/south_kanto_dm/archives/52143201.html å—é–¢æ±é–‹ç™ºæ©Ÿæ§‹ : æ—¥æœ¬ã®è¡Œæ”¿æ©Ÿé–¢ãŒå…¬é–‹ä¸ã®APIã«ã¤ã„ã¦ã®ã¾ã¨ã‚ï¼ˆ2016å¹´8æœˆ17æ—¥æš«å®šç‰ˆï¼‰ http://blog.livedoor.jp/south_kanto_dm/archives/5
uchiuchiyama 2016/08/19
api

links

gov

database

introduction
ãƒªãƒ³ã‚¯
ææ¡ˆæ›¸ã‚„ä¼ç”»æ›¸ã¥ãã‚ŠãŒé©šãã»ã©æ—ã‚‹ï¼ç„¡æ–™ã§å…¥æ‰‹å‡ºæ¥ã‚‹çµ±è¨ˆãƒ‡ãƒ¼ã‚¿ç·ã¾ã¨ã‚ã€‚
ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’é–‹å§‹ã™ã‚‹å‰ã«ã€å¸‚å ´èª¿æŸ»ãªã©ã§çµ±è¨ˆãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžã—ä»®èª¬ã‚’ãŸã¦ã‚‹äº‹ã¯é‡è¦ã§ã™ãŒã€ãã‚Œã‚‰ã®èª¿æŸ»å¯¾è±¡ãŒä¸–ç•Œè¦æ¨¡ã€å…¨å›½è¦æ¨¡ã«ãªã‚‹ã¨ã‚³ã‚¹ãƒˆãŒæŽ›ã‹ã‚Šã™ãŽã¦ï¼ˆç‰¹ã«å€‹äººã‚„ä¸å°ä¼æ¥ã®å ´åˆï¼‰ç¾å®Ÿçš„ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãã“ã§æ´»ç”¨ã—ãŸã„ã®ãŒå›½ã‚„å›£ä½“ã€æ°‘é–“ä¼æ¥ãŒå…¬é–‹ã—ã¦ã„ã‚‹ç„¡æ–™ã®çµ±è¨ˆãƒ‡ãƒ¼ã‚¿ã§ã™ã€‚ä»Šæ—¥ã¯ãã‚“ãªãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°æ‹…å½“è€…ãªã‚‰ãã£ã¨å¿…è¦‹ã®æƒ…å ±å…¬é–‹ã‚’è¡Œãªã£ã¦ã„ã‚‹ã‚µã‚¤ãƒˆã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ 1. ç·å‹™çœçµ±è¨ˆå±€ ç·å‹™çœçµ±è¨ˆå±€ã§ã¯æ§˜ã€…ãªçµ±è¨ˆãƒ‡ãƒ¼ã‚¿ãŒå…¥æ‰‹å¯èƒ½ã§ã™ã€‚ å›½ç¨Žèª¿æŸ» äººå£æŽ¨è¨ˆ åŠ´åƒåŠ›èª¿æŸ» å°å£²ç‰©ä¾¡çµ±è¨ˆèª¿æŸ» åœŸåœ°çµ±è¨ˆèª¿æŸ» ã“ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã¯PDFç‰ˆãŒä¸€èˆ¬çš„ã§ã™ãŒExcelå½¢å¼ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã®ã‚‚é…åŠ›ã§ã™ãã€‚ãã®ä»–ã«ã‚‚ä»¥ä¸‹URLã‚ˆã‚Šæ•°å¤šãã®çµ±è¨ˆãƒ‡ãƒ¼ã‚¿ãŒå…¥æ‰‹ã§ãã¾ã™ã€‚ ã¾ãŸã€çµ±è¨ˆå±€ã§ã¯ãƒ¡ãƒ¼ãƒ«é…ä¿¡ã‚µãƒ¼ãƒ“ã‚¹ã‚‚è¡Œãªã£ã¦ã„ã¾ã™ã€‚èˆˆå‘³ã®ã‚ã‚‹æ–¹ã¯ç™»éŒ²ã‚’ãŠã™ã™ã‚ã—ã¾ã™ã€‚ www.stat.go.jp 2. æ³•å‹™çœ æ³•å‹™çœã§ã‚‚
uchiuchiyama 2015/06/15
marketing

statistics

introduction

links

database

research
ãƒªãƒ³ã‚¯
åˆç´šã€œä¸ç´šè€…ã®ãŸã‚ã®SQLç‰¹è¨“ - å¿˜ã‚Œãªã„ã‚ˆã†ã«ãƒ¡ãƒ¢ã£ã¨ã
ã»ã¼ã»ã¼åˆå¿ƒè€…ã§SQLã®ç·´ç¿’ãŒã—ãŸã„ã£ã¦ã„ã†äººã€çŸ¥è˜ã®å†ç¢ºèªã‚’ã—ãŸã„äººã«ã‚ªã‚¹ã‚¹ãƒ¡ã®ã‚µã‚¤ãƒˆã€‚ SQLZOO ãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§å‹•ä½œã™ã‚‹ã®ã§ã€ã‚ã‚“ã©ãã•ã„ç’°å¢ƒè¨å®šã‚‚ãªã—ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ã€MySQLã€Oracleã€SQL Serverã€Postgreã€Ingresã€DB2ã‹ã‚‰é¸ã¹ã‚‹ã€‚ ç°¡å˜ãªSELECTæ–‡ã‹ã‚‰å§‹ã¾ã£ã¦ã€SUMã‚„COUNTã¿ãŸã„ãªåŸºæœ¬çš„ãªé–¢æ•°ã®å•é¡Œã‚„ã€JOINã‚’ä½¿ã£ãŸã¡ã‚‡ã£ã¨é›£ã—ã‚ã®æ§‹æ–‡ã‚‚ã‚ã‚‹ã€‚ å®Ÿè¡Œç’°å¢ƒä»˜ãã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚‚ã‚ã‚‹ã®ãŒã‚ˆã„ï¼(è¶…ä¾¿åˆ©ï¼)
uchiuchiyama 2014/02/27
database

development

mysql

postgresql

introduction

webservice
ãƒªãƒ³ã‚¯
ãƒãƒƒãƒˆäººé¡žæœªæ¥ ç¬¬5éƒ¨ã€€è²·ã„æ™‚æ•™ãˆã¾ã™ã€€åºƒãŒã‚‹ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿è§£æž - æ—¥æœ¬çµŒæ¸ˆæ–°èž
ã€Œãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã€è§£æžã®å¯¾è±¡ã¯åºƒãŒã‚‹ä¸€æ–¹ã ã€‚å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚‚ã¨ã«ã€å•†å“ã®è²·ã„æ™‚ã‚„ãã®äººã«ãµã•ã‚ã—ã„é£Ÿã¹ç‰©ã‚’æç¤ºã™ã‚‹æŠ€è¡“ã‚„ã‚µãƒ¼ãƒ“ã‚¹ãŒç¾ã‚Œã¦ã„ã‚‹ã€‚æ¶ˆè²»è€…ã®è¿·ã„ã‚„èª¤ã‚Šã‚’é˜²ãã“ã¨ã¯å•†å“ã‚’å£²ã‚‹ä¼æ¥ã«ã¨ã£ã¦ãƒ“ã‚¸ãƒã‚¹ãƒãƒ£ãƒ³ã‚¹ã§ã‚‚ã‚ã‚‹ã€‚ã€ŒAç¤¾ã®ãƒŽãƒ¼ãƒˆãƒ‘ã‚½ã‚³ãƒ³ã¯ä»ŠãŒè²·ã„ã§ã™ã€ã€ŒBç¤¾ã®ãƒ‡ã‚¸ã‚«ãƒ¡ã¯æ¥æœˆã€æ–°è£½å“ãŒç™»å ´ã™ã‚‹ã§ã—ã‚‡ã†ã€‚æ—¢å˜å“ã¯å€¤ä¸‹ãŒã‚Šã™ã‚‹ã®ã§å¾…ã¤ã®ã‚’ãŠè–¦ã‚ã—ã¾ã™ã€å®¶é›»è£½å“ã®è²·ã„æ™‚ã‚’æŒ‡å—ã—ã¦ãã‚Œã‚‹ã‚µã‚¤ãƒˆãŒç±³
uchiuchiyama 2013/06/02
marketing

business

introduction

webservice

database

statistics
ãƒªãƒ³ã‚¯
ã€ŒKDriveã€ãŒ50Gãƒã‚¤ãƒˆã¾ã§ç„¡æ–™ã«ã€€ã‚¹ãƒžãƒ›å‘ã‘æ–°ã‚«ãƒ¡ãƒ©æ©Ÿèƒ½ã§ã€Œãƒãƒ¼ã‚«ãƒ«ãƒ•ã‚©ãƒ«ãƒ€ã¯ã‚‚ã†ã„ã‚‰ãªã„ã€
iOSï¼Androidã‚¢ãƒ—ãƒªã«è¿½åŠ ã•ã‚ŒãŸã‚¯ãƒ©ã‚¦ãƒ‰ã‚«ãƒ¡ãƒ©æ©Ÿèƒ½ã€‚ã‚¢ãƒ—ãƒªå†…ã§æ’®å½±ã—ãŸç”»åƒã‚’ç›´æŽ¥ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ä¸Šã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã§ãã‚‹ ã‚ãƒ³ã‚°ã‚½ãƒ•ãƒˆã¯8æœˆ22æ—¥ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ŒKDriveã€ã®ç„¡æ–™å®¹é‡ã‚’æœ€å¤§50Gãƒã‚¤ãƒˆã«æ‹¡å¼µã—ãŸã€‚ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚½ãƒ•ãƒˆã«Mac OSç‰ˆã‚’è¿½åŠ ã™ã‚‹ã»ã‹ã€iOSï¼Androidå‘ã‘ã‚¢ãƒ—ãƒªã‚‚åˆ·æ–°ã€‚ã‚¢ãƒ—ãƒªå†…ã§æ’®å½±ã—ãŸå†™çœŸã‚’KDriveä¸Šã«ç›´æŽ¥ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€Œã‚¯ãƒ©ã‚¦ãƒ‰ã‚«ãƒ¡ãƒ©ã€æ©Ÿèƒ½ãªã©ã‚’è¿½åŠ ã—ãŸã€‚ KDriveã¯ã€2Gãƒã‚¤ãƒˆã®ç„¡æ–™ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦2011å¹´5æœˆã«ã‚¹ã‚¿ãƒ¼ãƒˆã€‚Webãƒ–ãƒ©ã‚¦ã‚¶çµŒç”±ã§ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã‚„é–²è¦§ãŒå¯èƒ½ãªã»ã‹ã€ç„¡æ–™ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚½ãƒ•ãƒˆã‚’PCã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚Œã°ã€ãƒãƒ¼ã‚«ãƒ«ãƒ‰ãƒ©ã‚¤ãƒ–ã¨ä¸¦ã¶å½¢ã§ä»®æƒ³ãƒ‰ãƒ©ã‚¤ãƒ–ã‚’ä½œæˆã—ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ä»®æƒ³ãƒ‰ãƒ©ã‚¤ãƒ–ã‚’è‡ªå‹•ã§åŒæœŸã§ãã‚‹ã€‚ ä»Šå›žã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã§ã¯ã€æ–°è¦ç™»éŒ²æ™‚ã«30Gãƒã‚¤ãƒˆã‹ã‚‰ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€ãƒã‚§ãƒƒã‚¯
uchiuchiyama 2012/08/22
introduction

webservice

database
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã€NoSQLè»½é‡ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒLevelDBã€ã‚’å…¬é–‹ã€‚Chromeãƒ–ãƒ©ã‚¦ã‚¶ã®IndexedDBã¨ã—ã¦æŽ¡ç”¨
LevelDBã¯SQLã‚’ã‚µãƒãƒ¼ãƒˆã›ãšã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆï¼ã‚µãƒ¼ãƒåž‹ã§ã‚‚ãªãã€ã‚·ãƒ³ã‚°ãƒ«ãƒ—ãƒã‚»ã‚¹ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ã“ã¨ã‚’æƒ³å®šã—ãŸã„ã‚ã‚†ã‚‹NoSQLã®é«˜é€Ÿãªã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒˆã‚¦ã‚§ã‚¤ãƒˆãªãƒ©ã‚¤ãƒ–ãƒ©ãƒªã ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ Chromeãƒ–ãƒ©ã‚¦ã‚¶ã§HTML5ã®ä»•æ§˜ã¨ã—ã¦ç–å®šä¸ã®IndexedDBã‚’å®Ÿè£…ã™ã‚‹ã‚‚ã®ã¨ã—ã¦é–‹ç™ºã•ã‚ŒãŸã‚ˆã†ã§ã™ï¼ˆãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«æ˜Žè¨˜ã•ã‚Œã¦ã„ãªã„ã®ã§ã™ãŒï¼‰ã€‚ LevelDBã‚’é–‹ç™ºã—ãŸç†ç”± LevelDBã®Webã‚µã‚¤ãƒˆã«ã‚ˆã‚‹ã¨ã€LevelDBã¯ä»¥ä¸‹ã®ä¸»ãªæ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ åŸºæœ¬çš„ãªæ“ä½œã¯ã€Put(key,value), Get(key), Delete(key) 1ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã—ã¦è¤‡æ•°ã®å¤‰æ›´æ“ä½œãŒå¯èƒ½ ãƒ‡ãƒ¼ã‚¿ã¯è‡ªå‹•çš„ã«åœ§ç¸®ã—ä¿å˜ã•ã‚Œã‚‹ Hacker Newsã®è¨˜äº‹ã«ã‚ˆã‚‹ã¨ã€å½“åˆã¯LevelDBã‚’é–‹ç™ºã™ã‚‹ä»£ã‚ã‚Šã«å¹³æž—å¹¹é›„æ°ãŒé–‹ç™ºã—ãŸTokyo Cabin
uchiuchiyama 2011/05/18
database

google

kvs

introduction
ãƒªãƒ³ã‚¯
MOONGIFT: Â» Railsã‚’ä½¿ã£ã¦DBæ§‹é€ ã‚’ç¢ºèªã™ã‚‹ã€ŒRails schema browser pluginã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Railsã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã®ä¸€ã¤ãŒã€DBã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã ã‚ã†ã€‚RDBMSã¯ä¾¿åˆ©ãªåé¢ã€ãƒ—ãƒã‚°ãƒ©ãƒ è¨€èªžã¨æºãŒã‚ã‚Šã€æ‰±ã„ãŒé¢å€’ãªæ™‚ãŒã‚ã£ãŸã€‚ãã®ãŸã‚ã€O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã®ã‚ˆã†ãªãƒ„ãƒ¼ãƒ«ãŒä½œã‚‰ã‚Œã€çŠ¶æ…‹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã¨ã—ã¦ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒã¨ã¦ã‚‚ä¾¿åˆ©ã ã£ãŸã€‚ é–‹ç™ºã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®DBæ§‹é€ ãŒæ‰‹è»½ã«é–²è¦§ã§ãã‚‹ ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦DBã®æ§‹é€ ã‚„ä¸èº«ã‚’ã‚ã¾ã‚Šæ„è˜ã›ãšã¨ã‚‚é–‹ç™ºãŒè¡Œãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã¯ã¨ã¦ã‚‚ä¾¿åˆ©ã ã€‚ã ãŒã€ãã®åé¢DBã®ãƒªã‚½ãƒ¼ã‚¹ã‚’éŽå‰°ã«ä½¿ã£ã¦ã—ã¾ã†ã€å¯Œè±ªçš„ãªã‚·ã‚¹ãƒ†ãƒ ã«ãªã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚æ™‚ã«ã¯ãã®æ§‹é€ ã‚’è¦‹è¿”ã™æ™‚ã‚‚å¿…è¦ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Rails schema browser pluginã€DBæ§‹é€ å‡ºåŠ›ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ Rails schema browser pluginã¯Railsãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ãƒ‡ãƒ¼ã‚¿ã®è¡¨ç¤ºãªã©ã¯å…¨ã¦WW
uchiuchiyama 2008/10/15
rails

introduction

database

plugin

development
ãƒªãƒ³ã‚¯
_ [Rails] ã¨ã‚Šã‚ãˆãšDBåˆ†å‰²ã™ã‚‹ã ã‘ãªã‚‰é©šãã»ã©ç°¡å˜ã ã£ãŸä»¶ - Don'tStopMusic(2007-10-31)
_ [Ruby] Ruby ã®æ–°ãƒã‚´ Ruby Associationã¯2007å¹´10æœˆ29æ—¥ã€Rubyå…¬å¼ãƒã‚´é¸å®šã‚³ãƒ³ãƒ†ã‚¹ãƒˆã€ŒRubyãƒã‚´ã‚³ãƒ³ãƒ†ã‚¹ãƒˆã€ã®çµæžœã‚’ç™ºè¡¨ã—ãŸã€‚Rubyã®å…¬å¼ãƒã‚´ã«ã¯Tom Schaubæ°ã®ä½œå“ãŒæŽ¡ç”¨ã•ã‚ŒãŸã€‚ Rubyã®å…¬å¼ãƒã‚´æ±ºå®š! | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ« å…¬å¼ãƒã‚´ãŒæ±ºå®šã—ã¾ã—ãŸã€‚ãŠãªã˜ã¿ã®ãƒ«ãƒ“ãƒ¼ã‚’ä½¿ã£ã¦ã„ã‚‹ã›ã„ã‹ã€ãã‚“ãªã«ä»£ã‚ã‚Šæ˜ ãˆã—ãªã„ã‚ˆã†ãªã€‚ ã¾ã¤ã‚‚ã¨ã•ã‚“ãŒ [ruby-list:44161]Rubyå…¬å¼ãƒã‚´ã‚³ãƒ³ãƒ†ã‚¹ãƒˆçµæžœç™ºè¡¨ ã§é¸è€ƒåŸºæº–ã‚’è¿°ã¹ã¦ã„ã¾ã™ãŒã€ãã‚Œãžã‚Œã†ãªãšã‘ã‚‹ç†ç”±ã§ã™ã€‚ èˆˆå‘³æ·±ã„ã¨æ€ã£ãŸã®ãŒã€ã€Žã€Œã‹ã‚ã„ã„ã€ã‚‚ã®ã¯é™¤ãã€ã¨ã„ã†é …ã€‚ã€Œã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã€ã¨ã„ã†è¨€è‘‰ã‚‚å›ã‹ã‚Œå§‹ã‚ã¦ã„ã‚‹ä»Šæ—¥ã“ã®é ƒã€Rubyã‚‚ãã‚ãã‚å¤§äººã¨ã—ã¦æ‰±ã‚ã‚Œã‚‹ã‚ˆã†ã«ã¨ã„ã†è¦ªå¿ƒãªã®ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãã€‚ _ [Ruby] ç¬¬äºŒå›žRubyèªå®šè©¦é¨“ã‚’å—ã‘ã‚‹äºˆå®š ç ”
uchiuchiyama 2007/11/02
introduction

rails

tips

database
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ:phpspoté–‹ç™ºæ—¥èªŒ
SQL Injection Cheat Sheet Currently only for MySQL and Microsoft SQL Server, some ORACLE and some PostgreSQL. Most of samples are not correct for every single situation. Most of the real world environments may change because of parenthesis, different code bases and unexpected, strange SQL sentences. SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ–¹æ³•ã«ã¤ã„ã¦ã®ä¾‹ãŒæ›¸ã‹ã‚Œã¦ãŠã‚Šã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«ä½¿ãˆã¾ã™ã€‚ MySQL, PostgreSQL, Oracle, M
uchiuchiyama 2007/04/15
introduction

security

database

tips
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹84ã®TIPS:phpspoté–‹ç™ºæ—¥èªŒ
Top 84 MySQL Performance Tips -- Debian Admin MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹84ã®TIPS. æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã®TIPSãŒ84ç´¹ä»‹ã•ã‚Œã¦ã‚‹ã¨ã„ã†ã“ã¨ã§ä¸€åº¦ã¯ç›®ã‚’é€šã—ã¦ãŠããŸã„ã§ã™ãã€‚ ä»¥ä¸‹ã€æµã—èªã¿ã§ãƒ¡ãƒ¢ ã‚¯ã‚¨ãƒªã®ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã«ã¯Explainæ–‡ã‚’ä½¿ãŠã† ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚’æ´»ç”¨ã—ã‚ˆã† GROUP BY ã‚’ä½¿ã†ã¨ãã¯ DISTINCTã‚’ä½¿ã‚ãªã„ LIMIT m,n ã¯ãã‚“ãªã«é€Ÿããªã„ã‹ã‚‚ inno
uchiuchiyama 2006/12/30
introduction

mysql

tips

database

performance
ãƒªãƒ³ã‚¯
1