[B! Program][sql] Dogisonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Dogison id:Dogison

Programã¨sqlã«é–¢ã™ã‚‹Dogisonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
Dogison 2010/01/19
key-value

sql

Program
ãƒªãƒ³ã‚¯
PHPã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹5ã¤ã®å•é¡Œã€ã¨ãã®è§£æ±ºæ³• - GIGAZINE
IBMã®ã‚µã‚¤ãƒˆã«ã€PHPã‹ã‚‰æ“ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã—ã¦ã‚ˆãè¦‹ã‚‰ã‚Œã‚‹5ã¤ã®å•é¡Œç‚¹ã¨ãã®è§£æ±ºæ–¹æ³•ãŒæŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’ã™ã‚‹éš›ã€ä¸€èˆ¬çš„ã«ç™ºç”Ÿã™ã‚‹å•é¡Œç‚¹ã«ã¤ã„ã¦ã®è§£èª¬ã§ã™ã€‚ ã§ã€è‚å¿ƒã®5ã¤ã®å•é¡ŒãŒä½•ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®é€šã‚Šã€‚ Five common PHP database probl ems 1ã¤ã‚ã¯å¤ã„PHPã®ã‚³ãƒ¼ãƒ‰ã§ã¯ç›´æŽ¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã€‚ã‚³ãƒ¬ã«ä»£ã‚ã‚‹æ‰‹æ®µã¨ã—ã¦ã¯ã€PEARã®DBãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†ã‹ã€ã‚ã‚‹ã„ã¯PHPãƒ‡ãƒ¼ã‚¿ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€PDOã®ã‚¯ãƒ©ã‚¹ã‚’ä½¿ãˆã€ã¨ã‚ã‚Šã¾ã™ã€‚ 2ã¤ã‚ã¯ã€ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’ä½¿ã‚ãªã„ã¨ã„ã†ã“ã¨ã€‚MySQLã¯åŸºæœ¬çš„ã«ãƒ¬ã‚³ãƒ¼ãƒ‰1ã¤ã«ã¤ã„ã¦ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ã“ã‚Œã‚’æ´»ç”¨ã—ã¦ã„ãªã„ã¨ã„ã†ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’æœ‰åŠ¹ã«ä½¿ã£ã¦ã„ãªã„å ´åˆã€éžåŠ¹çŽ‡çš„ã§ã‚ã‚‹ã ã‘ã§ãªãã€è² è·ã‚‚é«˜ããªã‚‹ãã†ã§ã™ã€‚è§£
Dogison 2009/03/17
php

sql

mysql

performance

Program
ãƒªãƒ³ã‚¯
Black Hat Japan 2008:ãƒ–ãƒ©ãƒƒã‚¯ãƒãƒƒãƒˆã‚¸ãƒ£ãƒ‘ãƒ³2008
-Keynote- Black Ops of DNS 2008 : Its The End Of The Cache As We Know It -åŸºèª¿è¬›æ¼”- DNS 2008ç‰ˆã€€Black Ops. ä»Šã¾ã§ã®DNSã‚ãƒ£ãƒƒã‚·ãƒ¥ã˜ã‚ƒé€šã˜ãªã„ï¼ by Dan Kaminsky ï¼ˆãƒ€ãƒ³ãƒ»ã‚«ãƒŸãƒ³ã‚¹ã‚ãƒ¼ï¼‰ Presentation Slides New reverse engineering technique using API hooking and sysenter hooking, and capturing of cash card access APIãƒ•ãƒƒã‚¯ã¨sysenterãƒ•ãƒƒã‚¯ã‚’åˆ©ç”¨ã—ãŸæ–°ã—ã„è§£æžãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã¨ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚«ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚ãƒ£ãƒ—ãƒãƒ£ãƒªãƒ³ã‚° by Kenji Aiko Presentation Slides (ENGLISH) Presentation Slides (J
Dogison 2008/12/22
Program

security

sql
ãƒªãƒ³ã‚¯
ã€Œå®Ÿç¾ã—ãŸã„ã“ã¨ã‚’è¨ˆç®—æ©Ÿã®å•é¡Œã«ç½®ãæ›ãˆã‚‹ã“ã¨ãŒã€ŽæŠ€è¡“åŠ›ã€ã€ã€ä¼Šè—¤CTOãŒâ€œã¯ã¦ãªæµâ€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®æ¥µæ„ã‚’èªžã‚‹ï¼šCodeZine
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
Dogison 2008/11/19
ã¯ã¦ãª

mysql

linux

search

sql

Program

performance
ãƒªãƒ³ã‚¯
PHPã§ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ã«ã¤ã„ã¦ã®ãƒ¡ãƒ¢ - Liner Note
Dogison 2008/10/28
security

Program

php

ã¾ã¨ã‚

sql
ãƒªãƒ³ã‚¯
http://www.ecoop.net/memo/cat_postgresql.html
Dogison 2008/09/05
Program

postgre

sql

reference
ãƒªãƒ³ã‚¯
Google Visualization APIã‚’æ—©é€Ÿä½¿ã£ã¦ã¿ãŸ - builder by ZDNet Japan
RPAè¦‹ç›´ã•ã‚Œã‚‹â€æ¥å‹™â€ã¨â€äººâ€ã®é–¢ä¿‚ äººçš„ãƒªã‚½ãƒ¼ã‚¹ã‚’å˜ç´”ä½œæ¥ã‹ã‚‰è§£æ”¾ï¼ é«˜ä»˜åŠ ä¾¡å€¤æ¥å‹™ã¸ã®è»¢æ›ã®ãŸã‚ã« è†¨å¤§ãªã‚¢ã‚¯ã‚»ã‚¹ã‚’æ”¯ãˆã‚‹å±‹å°éª¨ é«˜ã„å®‰å®šæ€§ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸¡ç«‹ ZOZOTOWNãŒé¸ã‚“ã ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸åŸºç›¤ã‚’è§£èª¬ ãƒ“ã‚¸ãƒã‚¹ã®æŽ¨é€²ã«ã¯å¿…é ˆï¼ ZDNetÃ—ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒè´ˆã‚‹ç‰¹åˆ¥ä¼ç”» ä»Šã€å¿…è¦ãªæˆ¦ç•¥çš„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ã‚¬ãƒãƒŠãƒ³ã‚¹ ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ã‚’æˆåŠŸã•ã›ã‚‹æ–¹æ³• å¿…é ˆã¨ãªã‚‹ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’ã©ã†å¼·åŒ–ã™ã‚‹ã‹ å¿…è¦ãªå¯¾ç–5ã¤ã‚’ç´¹ä»‹ å¹´é–“5,000ä»¶ã®å•ã„åˆã‚ã›ã«å¯¾å¿œ ç–‘å•ã‚’è§£æ¶ˆã—ãŸã„ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚‚ç”ãˆã‚‹æƒ…ã‚·ã‚¹ã‚‚ ã¿ã‚“ãªå¹¸ã›ã«ãªã‚‹ãƒ˜ãƒ«ãƒ—ãƒ‡ã‚¹ã‚¯ã®æœ€é©è§£ é«˜ã„å¾“æ¥å“¡æº€è¶³åº¦ã¨å®‰å¿ƒãƒ»å®‰å…¨ æ–°æ™‚ä»£ã«ã‚€ã‘ãŸç†æƒ³ã®æ¥å‹™ç’°å¢ƒã“ã Anywhere WorkspaceãŒç›®æŒ‡ã™æœªæ¥ ã‚¨ãƒƒã‚¸å¸‚å ´ã®æ´»æ€§åŒ–ã¸ é«˜ã¾ã‚‹IoTã‚’ä¸å¿ƒã¨ã—ãŸã‚¨ãƒƒã‚¸åˆ†é‡Žã¸ã®æœŸå¾… OSSæ´»ç”¨ãŒæ–°ã—ã„æ™‚ä»£ã®ãƒ“ã‚¸ãƒã‚¹ã‚’æ‹“ã ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã¯æ¬¡ã®ã‚¹ãƒ†ãƒ¼ã‚¸ã¸ ãƒˆãƒ©ãƒ‡ã‚£ã‚·ãƒ§ãƒŠãƒ«
Dogison 2008/03/22
google

javascript

api

sql

Program
ãƒªãƒ³ã‚¯
è‰²ã€…ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€€ASH Multimedia lab
ã€Œã“ã‚“ãªã‚½ãƒ•ãƒˆã‚’ä½œã‚ŠãŸã„ã€ã€Œæˆ‘ãŒç¤¾ã®æ¥å‹™ã¨ã´ã£ãŸã‚Šãƒžãƒƒãƒã—ãŸã‚·ã‚¹ãƒ†ãƒ ãŒæ¬²ã—ã„ã€ ï¼¡ï¼³ï¼¨ã¯ã‚ãªãŸã®ãƒ‹ãƒ¼ã‚ºã«ã€å°å›žã‚Šã®ãããƒ•ãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã¨é«˜ã„æŠ€è¡“åŠ›ã§ãŠå¿œãˆã—ã¾ã™ã€‚
Dogison 2007/10/25
linux

network

Program

postgre

sql

ã¾ã¨ã‚

è¨å®š

Server
ãƒªãƒ³ã‚¯
PostgreSQL 8.2.6æ–‡æ›¸
ç›®æ¬¡ã¯ã˜ã‚ã«PostgreSQLã¨ã¯?PostgreSQLå°å²è¦ç´„ã‚ˆã‚Šé€²ã‚“ã æƒ…å ±ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³I. ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«1ç« ã•ã‚å§‹ã‚ã¾ã—ã‚‡ã†2ç« SQLè¨€èªž3ç« é«˜åº¦ãªè«¸æ©Ÿèƒ½II. SQLè¨€èªž4ç« SQLã®æ§‹æ–‡5ç« ãƒ‡ãƒ¼ã‚¿å®šç¾©6ç« ãƒ‡ãƒ¼ã‚¿æ“ä½œ7ç« å•ã„åˆã‚ã›8ç« ãƒ‡ãƒ¼ã‚¿åž‹9ç« é–¢æ•°ã¨æ¼”ç®—å10ç« åž‹å¤‰æ›11ç« ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹12ç« åŒæ™‚å®Ÿè¡Œåˆ¶å¾¡13ç« æ€§èƒ½ã«é–¢ã™ã‚‹ãƒ’ãƒ³ãƒˆIII. ã‚µãƒ¼ãƒã®ç®¡ç†14ç« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †15ç« Windowsã¸ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ã¿ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«16ç« ã‚ªãƒšãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ ã®ç’°å¢ƒ17ç« ã‚µãƒ¼ãƒã®æ§‹æˆ18ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒ¼ãƒ«ã¨æ¨©é™19ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†20ç« ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼21ç« å¤šè¨€èªžå¯¾å¿œ22ç« å®šå¸¸çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¿å®ˆä½œæ¥23ç« ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢24ç« é«˜å¯ç”¨æ€§ãŠã‚ˆã³è² è·åˆ†æ•£25ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ´»å‹•çŠ¶æ³ã®ç›£è¦–26ç« ãƒ‡ã‚£ã‚¹ã‚¯ä½¿ç”¨é‡ã®ç›£è¦–27ç« ä¿¡é ¼æ€§ã¨ãƒã‚°å…ˆè¡Œæ›¸ãè¾¼ã¿28ç« ãƒªã‚°ãƒ¬ãƒƒã‚·ãƒ§ãƒ³ãƒ†ã‚¹ãƒˆIV
Dogison 2007/09/13
ã¾ã¨ã‚

postgre

SQL

Program
ãƒªãƒ³ã‚¯
1