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

Kanasansoft id:Kanasansoft

sqlã«é–¢ã™ã‚‹Kanasansoftã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (19)

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

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã‚‚ã‚Œã®è²¬ä»»ã‚’é–‹ç™ºä¼šç¤¾ã«å•ã†åˆ¤æ±º
ãƒã‚¤ãƒ³ãƒˆã¯ä¸‹è¨˜ã®é€šã‚Šã§ã™ã€‚ Xç¤¾ï¼ˆåŽŸå‘Šï¼‰ã¯ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ã«ã¤ã„ã¦ç‰¹ã«æŒ‡ç¤ºã¯ã—ã¦ã„ãªã‹ã£ãŸ æå®³è³ å„Ÿã«ã¤ã„ã¦å€‹åˆ¥å¥‘ç´„ã«å®šã‚ã‚‹å¥‘ç´„é‡‘é¡ã®ç¯„å›²å†…ã¨ã™ã‚‹æå®³è³ å„Ÿè²¬ä»»åˆ¶é™ãŒã‚ã£ãŸ å½“åˆã‚·ã‚¹ãƒ†ãƒ ã¯ã‚«ãƒ¼ãƒ‰æ±ºæ¸ˆã‚’å¤–éƒ¨å§”è¨—ã—ç›´æŽ¥ã‚«ãƒ¼ãƒ‰æƒ…å ±ã‚’æ‰±ã£ã¦ã„ãªã‹ã£ãŸ Xç¤¾ãŒã€Œã‚«ãƒ¼ãƒ‰ä¼šç¤¾æ¯Žã®æ±ºæ¸ˆé‡‘é¡ã‚’çŸ¥ã‚ŠãŸã„ã€ã¨Yç¤¾ã«ä¾é ¼ã‚’ã—ã¦ã€ãã®çµæžœã‚«ãƒ¼ãƒ‰æƒ…å ±ã‚’ã„ã£ãŸã‚“DBã«ä¿å˜ã™ã‚‹ä»•æ§˜ã¨ãªã£ãŸï¼ˆ2010å¹´1æœˆ29æ—¥ï¼‰ Xç¤¾ã‹ã‚‰ã®å•ã„åˆã‚ã›ã«å¯¾ã—ã¦Yç¤¾ã¯ã€ã‚«ãƒ¼ãƒ‰æƒ…å ±ã‚’ä¿æŒã—ãªã„æ–¹å¼ã«å¤‰æ›´ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã€ãã®ã»ã†ãŒå®‰å…¨ã¨ãªã‚Šã€è²»ç”¨ã¯20ä¸‡å††ç¨‹åº¦ã§ã‚ã‚‹æ—¨ã‚’ä¼ãˆãŸï¼ˆ2010å¹´9æœˆ27æ—¥ï¼‰ãŒã€ãã®å¾ŒXç¤¾ã¯æ”¹è‰¯ã®æŒ‡ç¤ºã‚’ã—ãªã‹ã£ãŸ ä»¥ä¸‹ã®è„†å¼±æ€§ãã®ä»–ãŒèªã‚ã‚‰ã‚ŒãŸ ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†æ©Ÿèƒ½ã®IDã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒ admin/password ã§ã‚ã£ãŸ å€‹äººæƒ…å ±ãŒè¨˜è¼‰ã•ã‚ŒãŸãŠå•ã„åˆã‚ã›ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®é–²è¦§ãŒå¯èƒ½ï¼ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒªã‚¹ãƒ†ã‚£ãƒ³ã‚°ã¨æ„å›³ã—ãªã„ãƒ•ã‚¡ã‚¤
Kanasansoft 2015/01/24
privacy

db

security

sql

development
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2013/04/03
RDBã«é–¢ã™ã‚‹éžå¸¸ã«å¤šãã®ãƒŽã‚¦ãƒã‚¦ãŒè¼‰ã£ã¦ã„ã‚‹ã€‚

db

programming

database

sql

tips
ãƒªãƒ³ã‚¯
ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ã¦ä¸Šä½15è¨˜äº‹ã‚’æ¤œè¨¼ã—ãŸ - ockeghem's blog
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ãƒãƒƒãƒˆä¸Šã§ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½15ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ãŸçµæžœã‚’å ±å‘Šã—ã¾ã™ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã®å¯¾ç–ã¯ã€æ—¢ã«ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã«ãƒ•ã‚¡ã‚¤ãƒŠãƒ«ã‚¢ãƒ³ã‚µãƒ¼ï¼ˆå¾Œè¿°ï¼‰ã‚’ç¤ºã—ã¦ã„ã¾ã™ãŒã€ã¾ã ã“ã®æ–‡æ›¸ã‚’çŸ¥ã‚‰ãªã„äººãŒå¤šã„ã ã‚ã†ã“ã¨ã¨ã€ã‚„ã‚„ä¸Šç´šè€…å‘ã‘ã®æ–‡æ›¸ã§ã‚ã‚‹ã“ã¨ã‹ã‚‰ã€ã¾ã ååˆ†ã«å®Ÿè·µã•ã‚Œã¦ã¯ã„ãªã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®çŠ¶æ³ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ã“ã¨ã‚’ã‚ˆãçŸ¥ã‚‰ãªã„äººãŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã®è¡Œå‹•ã‚’äºˆæ¸¬ã—ã¦ã¿ã‚‹ã¨ã€ã‹ãªã‚Šã®å‰²åˆã®äººãŒGoogleç‰ã§æ¤œç´¢ã—ã¦å¯¾å‡¦æ–¹æ³•ã‚’èª¿ã¹ã‚‹ã¨æ€ã‚ã‚Œã¾ã™ã€‚ãã“ã§ã€ä»¥ä¸‹ã®URLã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–æ–¹æ³•ã‚’æ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ç«‹ã¡ã¾ã—ãŸã€‚ http://www.google.co.jp/search?q=SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– ã©ã“ã¾ã§èª¿ã¹ã‚‹ã‹ã§ã™ãŒã€ä»¥å‰NH
Kanasansoft 2011/11/09
ã€Žã€Œã‚µãƒ‹ã‚¿ã‚¤ã‚ºã€çš„ãªå¯¾ç–ã‚’æŒ™ã’ã‚‹ã€ã€Žãã†ã„ã£ãŸæ¥è€…ã€ã€Žè¡€ç¥ã‚Šã«ã‚ã’ã‚‰ã‚Œã¦ã„ã‚‹ã€ã€Žã“ã®ã‚ãŸã‚Šã®ã“ã¨ã«ã¤ã„ã¦çµè«–ã‚’å‡ºã—ã¦ã„ãŸã ãã¾ã™ã€‚ã€ã€Žã“ã‚Œã‚’èªã‚“ã ç§ã®ãƒ—ãƒ¬ãƒƒã‚·ãƒ£ãƒ¼ã‚’å¯Ÿã—ã¦ã„ãŸã ã‘ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ã€

sql

security

database
ãƒªãƒ³ã‚¯
www.tamandua-webtools.net is Expired or Suspended.
ã€Œ www.tamandua-webtools.net ã€ã®ãƒšãƒ¼ã‚¸ã¯ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ãŒç„¡åŠ¹ãªçŠ¶æ…‹ã§ã™ã€‚ ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆç®¡ç†è€…ã®æ–¹ã¯ã“ã¡ã‚‰ã‹ã‚‰å¤‰æ›´ãƒ»æ›´æ–°ã‚’è¡Œã£ã¦ãã ã•ã„ã€‚ ã€Œ www.tamandua-webtools.net ã€is Expired or Suspended. The WHOIS is here.
Kanasansoft 2011/02/22
db

database

sql

sqlite
ãƒªãƒ³ã‚¯
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã€ç„¡å„Ÿã®Webé–‹ç™ºç’°å¢ƒã€ŒWebMatrixã€ã‚’å…¬é–‹ã€‚HTML/CSS/JavaScriptã‚¨ãƒ‡ã‚£ã‚¿æ©Ÿèƒ½ã€PHPå¯¾å¿œã€FTPæ©Ÿèƒ½ãªã©æ‰‹è»½ã§ä¾¿åˆ©ãªçµ±åˆãƒ„ãƒ¼ãƒ«
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã¯å…ˆé€±ã€ç„¡å„Ÿã®Webé–‹ç™ºç’°å¢ƒã€ŒWebMatrixã€ã®æä¾›ã‚’é–‹å§‹ã—ã¾ã—ãŸã€‚WebMatrixã«ã¯ä»¥ä¸‹ã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ãŠã‚Šã€Windowsã§ç°¡å˜ã«Webã‚µã‚¤ãƒˆã®æ§‹ç¯‰ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ Webé–‹ç™ºãƒ„ãƒ¼ãƒ« HTML/CSS/JavaScript/PHPãªã©ã«å¯¾å¿œã—ãŸãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã‚’å«ã‚€é–‹ç™ºãƒ„ãƒ¼ãƒ«ã€‚FTPã«ã‚ˆã‚Šãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ›ã‚¹ãƒˆã¸ãƒœã‚¿ãƒ³1ã¤ã§è»¢é€ã§ãã‚‹ HTTPã‚µãƒ¼ãƒ IIS Express 7.5ã«ã‚ˆã‚Šã€Webãƒ–ãƒ©ã‚¦ã‚¶ã§ã™ãã«ãƒ–ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§ãã‚‹ã€‚ã—ã‹ã‚‚ï¼ˆè¿½åŠ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã‚ˆã‚Šï¼‰PHPã«ã‚‚å¯¾å¿œã™ã‚‹ã€‚å½“ç„¶ASP.NETã«ã‚‚å¯¾å¿œ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ SQL Server Compact Edition 4ã«ã‚ˆã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚‚ãƒãƒ¼ã‚«ãƒ«ã§é–‹ç™ºå¯èƒ½ã€‚MySQLã‚‚è¿½åŠ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¯èƒ½ èª¿ã¹ãŸé™ã‚Šã§ã¯IIS Expressã¯WebMatrixã®ç”»é¢ã‹ã‚‰ç°¡
Kanasansoft 2011/01/19
javascript

web

php

sql

server

html

iis

microsoft

development

tools
ãƒªãƒ³ã‚¯
ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€€ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ
ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã¨ã„ã†SQLã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«ç„¦ç‚¹ã‚’å½“ã¦ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒã€2010å¹´3æœˆã«IPAï¼ˆç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼‰ã‹ã‚‰å…¬é–‹ã•ã‚ŒãŸã€‚ ã“ã‚Œã¯2006å¹´1æœˆã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹ã€Webã‚µã‚¤ãƒˆé–‹ç™ºè€…ã‚„é‹å–¶è€…å‘ã‘ã®ã‚»ã‚ãƒ¥ã‚¢Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã®ãŸã‚ã®è³‡æ–™ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã®åˆ¥å†Šã¨ã—ã¦æ›¸ã‹ã‚ŒãŸã‚‚ã®ã§ã‚ã‚‹ã€‚ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ãŒ92ãƒšãƒ¼ã‚¸ãªã®ã«å¯¾ã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã ã‘ã§40ãƒšãƒ¼ã‚¸ã‚‚ã®åˆ†é‡ãŒã‚ã‚‹ã€‚ãªãœã“ã‚“ãªã«åˆ†åŽšã„ã®ã ã‚ã†ã‹ã€‚ ã“ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆä½œæˆã«å”åŠ›ã—ãŸã¨ã„ã†ã€ç‹¬ç«‹è¡Œæ”¿æ³•äººç”£æ¥æŠ€è¡“ç·åˆç ”ç©¶æ‰€ æƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶ã‚»ãƒ³ã‚¿ãƒ¼ã®é«˜æœ¨æµ©å…‰æ°ã«ãŠè©±ã‚’ä¼ºã†ã“ã¨ãŒã§ããŸã€‚é«˜æœ¨æ°ã¯å€‹äººãƒ–ãƒã‚°ã€Œé«˜æœ¨æµ©å…‰ï¼ è‡ªå®…ã®æ—¥è¨˜ã€ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£é–¢é€£ã®å•é¡Œã‚’è¿½æ±‚ã™ã‚‹è«–å®¢ã¨ã—ã¦ã‚‚çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ç†è€…ã‚‚ä»¥å‰ã€ã“ã®é€£è¼‰ã®ã€Œä»Šå¤œã‚ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã®å›žï¼ˆ2006å¹´11æœˆ
Kanasansoft 2010/06/28
ã€Žã€Œã¾ãŸä¸Šé‡Žå®£ã‹ã€‚ã€ã€ã€Žâ€œã‚µãƒ‹ã‚¿ã‚¤ã‚ºè¨€ã†ãªã€‚â€ã€ã€Žä»Šå›žã®å–æã§ã¯ä»²è‰¯ãæ¡æ‰‹ã™ã‚‹å†™çœŸã¯æ’®ã‚‰ã›ã¦ã‚‚ã‚‰ãˆãªã‹ã£ãŸãŒã€ã€Œé–“é•ã£ãŸå¯¾ç–ã‚’æ™®åŠã•ã›ã‚‹ãªã€ã¨ã„ã†é«˜æœ¨æ°ã®æ€ã„ã«ã¯è§¦ã‚Œã‚‹ã“ã¨ãŒã§ããŸã€‚ã€

security

sql

web
ãƒªãƒ³ã‚¯
ã€ŒWebã‚¢ãƒ—ãƒªã®è„†å¼±æ€§å¯¾ç–ã¯ç°¡å˜ã§ã™ã€
ã€ŒWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§å¯¾ç–ã¯ç°¡å˜ã§ã™ã€ã€‚ ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£é–¢é€£ã®å–æã‚’ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦10å¹´ä»¥ä¸Šã«ãªã‚‹ãŒã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ãŒã€Œç°¡å˜ã€ã ã¨èžã„ãŸã®ã¯æã‚‰ãåˆã‚ã¦ã§ã‚ã‚‹ã€‚å–æã®ç›¸æ‰‹ã¯ã€TISã®æ—©çŸ¢ä»•å–„å¼˜æ°ï¼ˆæŠ€è¡“æœ¬éƒ¨ ã‚»ã‚ãƒ¥ã‚¢ãƒ¯ãƒ³å®¤ å®¤é•·ï¼‰ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å¯¾è±¡ã«ã—ãŸè„†å¼±æ€§ãƒã‚§ãƒƒã‚¯ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ç±³Fortify Softwareã«ã€åŒç¤¾ã‚½ãƒ•ãƒˆã®æ¤œè¨¼ã‚’ä¾é ¼ã•ã‚ŒãŸã“ã¨ã‚‚ã‚ã‚‹ã¨ã„ã†ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®å°‚é–€å®¶ã§ã‚ã‚‹ã€‚ æ—©çŸ¢ä»•æ°ã«ã‚ˆã‚‹ã¨Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã¯ã€ãŸã£ãŸå››ã¤ã®åŽŸå‰‡ã‚’å®ˆã‚Œã°é˜²ã’ã‚‹ã¨ã„ã†ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚°ï¼ˆXSSï¼‰ãªã©è‘—åãªã‚‚ã®ã¯ã‚‚ã¡ã‚ã‚“ã€æœ€è¿‘ã«ãªã£ã¦ç™ºè¦‹ã•ã‚Œã¦ã„ã‚‹æ•°å¤šãã®è„†å¼±æ€§ãŒã€ã„ãšã‚Œã‹ã®åŽŸå‰‡ã®å¯¾è±¡ã«ãªã‚‹ã€‚å››ã¤ã®åŽŸå‰‡ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ ï¼ˆ1ï¼‰ãƒ¦ãƒ¼ã‚¶ãƒ¼å…¥åŠ›ã‚’ç²¾æŸ»ã™ã‚‹ Webãƒšãƒ¼ã‚¸ã®ãƒ•ã‚©ãƒ¼ãƒ ãªã©ã«å…¥åŠ›ã•ã‚ŒãŸæ–‡å—åˆ—ã¯ã€ãã¡ã‚“ã¨ãƒã‚§ãƒƒã‚¯ã—ãªã‘ã‚Œã°
Kanasansoft 2010/06/24
ã“ã‚Œã¯...ã€‚

web

sql

xss

programming

development

security
ãƒªãƒ³ã‚¯
Google App EngineãŒSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆã¸ã€‚ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ‹¡å……
Google App EngineãŒSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆã¸ã€‚ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ‹¡å…… ã‚°ãƒ¼ã‚°ãƒ«ã¯5æœˆ19æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã«ç±³ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚ŒãŸã‚¤ãƒ™ãƒ³ãƒˆã€ŒGoogle I/Oã€ã®åŸºèª¿è¬›æ¼”ã§ã€ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ãŸã€ŒGoogle App Engine for Businessã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ãã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ï¼ˆåŸºèª¿è¬›æ¼”ã®å†…å®¹ã¯ã€è¨˜äº‹ã€Œï¼»é€Ÿå ±ï¼½Google I/Oã§ç™ºè¡¨ã•ã‚ŒãŸ4ã¤ã®ãƒã‚¤ãƒ³ãƒˆï¼šVP8ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–ï¼Chrome Web Storeï¼VMwareã¨ã®å”æ¥ï¼Google App Engine for Businessã€ã‚’ã”è¦§ãã ã•ã„ï¼‰ã€‚ åŸºèª¿è¬›æ¼”ã§æœ€å¾Œã®ç™ºè¡¨è€…ã¨ã—ã¦å£‡ä¸Šã«ç«‹ã£ãŸã®ã¯ã€ã‚°ãƒ¼ã‚°ãƒ«ã®Kevin Gibbsæ°ã€‚App EngineãŒã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã«å—ã‘å…¥ã‚Œã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã«ã¯ã€ã„ãã¤ã‹ã®ãƒãƒªã‚¢ã‚’ä¹—ã‚Šè¶Šãˆãªã‘ã‚Œã°ãªã‚‰ãªã„ã¨èªž
Kanasansoft 2010/05/20
sql

google

business

gae
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚³ãƒ¼ãƒ‰ãŒæ›¸ã‹ã‚ŒãŸãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆ
ã‚‚ã—ã“ã‚Œã§ã‚ªãƒ¼ãƒ“ã‚¹ãªã©ã®é€Ÿåº¦é•åãƒã‚§ãƒƒã‚¯æ©Ÿå™¨ã®ã‚·ã‚¹ãƒ†ãƒ ãŒãƒ€ã‚¦ãƒ³ã—ãŸã‚‰ã€ãã‚Œã¯ã‚ªãƒ¼ãƒ“ã‚¹å´ã®è¨è¨ˆãƒŸã‚¹ã¨ã„ã†ã‚ˆã‚Šã¯ã€ã“ã®ã‚®ãƒ¼ã‚¯ã®æ–¹ãŒå¤©æ™´ã‚Œã€ã¨ã„ã†æ°—ãŒã—ã¾ã™ãã€‚ [See Also] Joel Johnsonï¼ˆã„ã¡ã‚‹ï¼‰
Kanasansoft 2010/03/26
QRã‚³ãƒ¼ãƒ‰ã«åŸ‹ã‚è¾¼ã‚€ã®ã‚‚æœ‰ã‚Šã‹ã€‚

sql

security

programming

db

joke

humor
ãƒªãƒ³ã‚¯
æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼šæƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ï¼šè„†å¼±æ€§å¯¾ç– :ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã‚’å…¬é–‹
IPAï¼ˆç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ã€ç†äº‹é•·ï¼šè¥¿åž£ æµ©å¸ï¼‰ã¯ã€ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’ç‹™ã£ãŸSQL(*1)ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒ(*2)ãŒç¶™ç¶šã—ã¦ã„ã‚‹ã“ã¨ã‹ã‚‰ã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³(*3)ã®å®‰å…¨ãªå®Ÿè£…æ–¹æ³•ã‚’è§£èª¬ã—ãŸè³‡æ–™ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã‚’2010å¹´3æœˆ18æ—¥ï¼ˆæœ¨ï¼‰ã‹ã‚‰IPAã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§å…¬é–‹ã—ã¾ã—ãŸã€‚ URLï¼šhttp://www.ipa.go.jp/security/vuln/websecurity.html è¿‘å¹´ã€ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’ç‹™ã£ãŸæ”»æ’ƒãŒç¶™ç¶šã—ã¦ã„ã¾ã™ã€‚æ”»æ’ƒã®å®Ÿä¾‹ã¨ã—ã¦ã€IPAãŒç„¡å„Ÿã§å…¬é–‹ã—ã¦ã„ã‚‹ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ¤œå‡ºãƒ„ãƒ¼ãƒ«iLogScanner(*4)ã€ã§ã€ã€Œè„†å¼±æ€§å¯¾ç–æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹JVN iPedia(*5)ã€ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã‚’è§£æžã—ãŸäº‹ä¾‹ã‚’å›³1ã«ç¤ºã—ã¾ã™ã€‚ å›³1ã‚’è¦‹ã‚‹ã¨ã€2008å¹´é ƒã‹ã‚‰æ€¥å¢—ã—ã¦ã„ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒãŒå…¨ä½“ã®45%ã€ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãƒ•ã‚¡ã‚¤
Kanasansoft 2010/03/19
sql

security

programming

development
ãƒªãƒ³ã‚¯
Flashå´ã‹ã‚‰PHPã«POSTã§æ¸¡ã™å‡¦ç†ã§ ãã®ä¸ã«SQLã‚’æ··ãœã‚‹ã®ã¯ã€ã‚„ã¯ã‚Šã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£çš„è¦³ç‚¹ã‹ã‚‰ ï¼®ï¼§ã§ã—ã‚‡ã†ã‹ï¼Ÿ
Flashå´ã‹ã‚‰PHPã«POSTã§æ¸¡ã™å‡¦ç†ã§ ãã®ä¸ã«SQLã‚’æ··ãœã‚‹ã®ã¯ã€ã‚„ã¯ã‚Šã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£çš„è¦³ç‚¹ã‹ã‚‰ ï¼®ï¼§ã§ã—ã‚‡ã†ã‹ï¼Ÿ
Kanasansoft 2009/12/16
æ”¯æ´ãƒ–ã‚¯ãƒžã€‚

security

flash

sql
ãƒªãƒ³ã‚¯
SQLiteã®DBãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã•ã›ã¦ã¿ãŸ (Kanasansoft Web Lab.)
SQLiteã®DBã¯ã€è‚¥å¤§åŒ–ã—æ˜“ã„ã‚‰ã—ã„ã€‚ ä¸€åº¦å¤§ãããªã£ãŸãƒ•ã‚¡ã‚¤ãƒ«ãŒå‹æ‰‹ã«ã¯å°ã•ããªã‚‰ãªã„ã¨ã‹ãªã‚“ã¨ã‹ã€‚ ã¤ã¾ã‚Šä¸€åº¦å¤§ããªãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚ŒãŸå¾Œã«ã€Deleteã‚„Dropã‚’å®Ÿè¡Œã—ã¦ã‚‚å®¹é‡ã¯å¤‰ã‚ã‚‰ãªã„ã¨ã„ã†äº‹ã‚‰ã—ã„ã€‚ ã§ã€ãã‚Œã‚’æ•´ç†ã™ã‚‹ã®ãŒvacuumã¨ã„ã†å‡¦ç†ã€‚ SQLiteã®manã‚’è¦‹ã¦ã‚‚--helpã‚’è¦‹ã¦ã‚‚ã‚ˆãã‚ã‹ã‚‰ãªã‹ã£ãŸã®ã§GUIã®ã‚ã‚‹toolã‚’æŽ¢ã—ã¦ã¿ãŸã€‚ ã§ã€ã‚ã¡ã“ã¡ã§è¨€åŠã•ã‚Œã¦ã„ã‚‹ã®ãŒTkSQLiteã¨ã„ã†ã‚„ã¤ã€‚
Kanasansoft 2009/04/18
id:progd firefoxã®èµ·å‹•ä¸ã«ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’å¼„ã‚‹ã®ã¯å±é™ºãªã®ã§ã€cronã¯ã‚„ã‚ã¦ãŠã„ãŸæ–¹ãŒã„ã„ã¨æ€ã„ã¾ã™ã€‚

firefox

addon

sql
ãƒªãƒ³ã‚¯
Firefoxã®æ¿€é‡ãŒãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‰Šé™¤ã—ãŸã‚‰æ”¹å–„ã—ãŸã§ã”ã–ã‚‹ : ãƒã‚±ã‚¹ã‚¿ç¤¾é•·æ—¥è¨˜
æœ€è¿‘ã€ã©ã†ã‚‚ãƒ‘ã‚½ã‚³ãƒ³ãŒé‡ã„ãªã‚ã€ã¨æ€ã£ã¦ãŸã®ã§ã™ã€‚ ã‚‚ã£ã¨ã„ã†ã¨ã€FirefoxãŒç•°å¸¸ã«é‡ã„ã€‚ãƒšãƒ¼ã‚¸ã‚’é–‹ã“ã†ã¨ã™ã‚‹ã¨ã‚‚ãŸã¤ãã—ã€ã‚¿ãƒ–ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹æ™‚ã‚‚ã‚‚ãŸã¤ãã€‚ ãƒ‘ã‚½ã‚³ãƒ³ã®ã›ã„ã ã‚ã†ã‹ã¨ã€ã„ã‚ã„ã‚ã¨è©¦ã—ã¦ãŸã®ã§ã™ãŒã€ãªã‹ãªã‹åŠ¹æžœãŒã§ãšã€‚ (Â´ï½¥Ï‰ï½¥`)é‡ã„ãªã ã¨é‡ã„ãªãŒã‚‰1é€±é–“ãã‚‰ã„æˆ‘æ…¢ã—ã¦ã¾ã—ãŸã€‚ ã—ã‹ã—ã€ãã‚ŒãŒé•·ã„é–“ç¶šãã¨ã€ã ã‚“ã ã‚“ã¨è…¹ãŒç«‹ã£ã¦ãã¦ é‡ã„ã‚ˆï¼ãƒ½(`Ð”Â´)ï¾‰ ï¾‘ï½¯ï½·ï½° ã¨ã‚¤ãƒ©ã‚¤ãƒ©ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ç”Ÿç”£æ€§ãŒè½ã¡ã¦ãŸã‚ã‘ã§ã™ã€‚ ã§ã€ä»Šæ—¥ã€‚ ã„ã¤ã‚‚ã«æ¯”ã¹ã¦é‡ã„é‡ã„é‡ã„ï¼ãƒ½(`Ð”Â´)ï¾‰ï¾Œï½«ï½«ï½¯ï½«ï½µï½«ï½« ã¨ãªã£ã¦ã„ãŸã®ã§ã™ãŒã€æ‰“ã¡åˆã‚ã›ã®ä¸ã§Gmailã‚’é–‹ã“ã†ã¨ã—ãŸã‚‰ã‚‚ãŸã¤ãã‚‚ãŸã¤ãï¼ (ãƒŽ#`Ð”Â´)ãƒŽâŒ’â”»â”â”»ã€€ï½·ï¾žï½¬ï½±ï½±ï½±ï½± é–‹ã‹ããˆã‚ˆï¼ï¼ ãƒ½(`(`(`(`ãƒ½(`Ð”Â´)ï¾‰ ãƒ•ã‚¡ãƒ»ãƒ•ã‚©ã‚¡ãƒ»ãƒ•ãƒ¯ã‚©ã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªãƒ³!! ã£ã¦ãªã‚Šã€ã¤ã„ãã®å ´ã®å‹¢ã„ã§F
Kanasansoft 2009/04/16
å±¥æ´ã‚„ã‚ãƒ£ãƒƒã‚·ãƒ¥ç‰ã®å‰Šé™¤ã‹ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ãƒ•ã‚©ãƒ«ãƒ€å†…ã®.sqliteã®åœ§ç¸®ã‚’å…ˆã«ã™ã¹ãã€‚å‰Šé™¤ã¯æœ€çµ‚æ‰‹æ®µã€‚æ‰‹å‰å‘³å™Œ http://www.kanasansoft.com/weblab/2008/10/sqlitedb.html vacuumã®å‰ã«.sqliteã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’!

db

sql

firefox
ãƒªãƒ³ã‚¯
ã‚¯ãƒƒã‚ãƒ¼ã«éš ã•ã‚ŒãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€å¯¾ç–ã¯ï¼Ÿ
Cookieã®å€¤ã«SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ãŒã€æ³¨ç›®ã™ã¹ããƒã‚¤ãƒ³ãƒˆã¯Cookieã«å«ã¾ã‚Œã¦ã„ã‚‹ãã®å½¢å¼ã§ã™ã€‚URLã®â€œ/index.aspâ€ã®å¾Œã«ç¶šãã¹ããƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãŒãã®ã¾ã¾Cookieã«å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ASPã®Requestã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼ˆASP.NETã®å ´åˆã€HttpRequest.Paramsï¼‰ã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã€ã‚¯ã‚¨ãƒªæ–‡å—åˆ—ã‚„ãƒ•ã‚©ãƒ¼ãƒ ä»¥å¤–ã‹ã‚‰ã§ã‚‚ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚ã¾ã™ã€‚ã‚‚ã—Requestã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‹ã‚‰èªã¿è¾¼ã‚“ã ãƒ‡ãƒ¼ã‚¿ã®å–ã‚Šæ‰±ã„ã«SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±ï¼ˆãœã„ã˜ã‚ƒãï¼‰æ€§ãŒã‚ã‚‹å ´åˆã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ IISï¼ASPã®æ©Ÿèƒ½ã‚’æ‚ªç”¨ ä»Šå›žã®æ”»æ’ƒæ‰‹æ³•ã®ã‚‚ã†1ã¤ã®ç‰¹å¾´ã¯æ”»æ’ƒã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã«â€œ%â€ã‚’å«ã¾ã›ã‚‹ã“ã¨ã§ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ©Ÿå™¨ã®æ¤œçŸ¥æ©Ÿèƒ½ã®å›žé¿ã‚’ç‹™ã£ã¦ã„ã‚‹ã“ã¨ã§ã™ã€‚%æ–‡å—ã‚’å«ã‚“ã SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªãƒªã‚¯ã‚¨ã‚¹ãƒˆã«ãªã£ã¦ã„ã¾ã™ã€‚ è‰²ã‚’ä»˜ã‘ãŸã€ŒDE%CLAR
Kanasansoft 2008/10/29
Requestã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ãã®ã¾ã¾ä½¿ã†ã¨å±ãªã„ã®ã¯å¸¸è˜ã¨ã„ã†ã®ãŒå½“ãŸã‚Šå‰ã ã¨æ€ã£ã¦ãŸã‘ã©é•ã†ã®ã‹...ã€‚ã“ã‚Œãã‚‰ã„ã‚‚å¯¾ç–ã•ã‚Œã¦ã„ãªã„ã¨ã¯...ã€‚ServerVariablesæ±šæŸ“ã‚‚ã‚ã‚Šãã†ã ã€‚

cookie

security

sql
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
Kanasansoft 2007/09/13
db

interview

mysql

performance

perl

programming

scalability

server

sql

sns
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2007/09/03
algorithm

database

db

programming

tips

sql
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€NEWSã€‘SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ•ãƒªãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€
GUIã«ã‚ˆã‚‹SQLæ–‡ã®ä½œæˆãªã©ã€ã•ã¾ã–ã¾ãªé–‹ç™ºæ”¯æ´æ©Ÿèƒ½ã‚’å‚™ãˆã‚‹SQLé–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€v1.1.7.413ãŒ6æœˆ4æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã€‚Windows 2000/XPã«å¯¾å¿œã—ã¦ãŠã‚Šã€å€‹äººä½¿ç”¨ãƒ»æ¥å‹™ã«ã‹ã‹ã‚ã‚‰ãšãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã¨ã—ã¦åˆ©ç”¨å¯èƒ½ã€‚ç¾åœ¨ä½œè€…ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã€Œé»’çŒ« SQL Studioã€ã¯ã€SQLæ–‡ã®ä½œæˆã‚„ãƒ†ã‚¹ãƒˆã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚æœ¬ã‚½ãƒ•ãƒˆä¸Šã‹ã‚‰OLE DBæŽ¥ç¶šã¾ãŸã¯ODBCãƒ‰ãƒ©ã‚¤ãƒã«å¯¾å¿œã™ã‚‹å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ç›´æŽ¥æŽ¥ç¶šå¯èƒ½ã§ã€ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿéš›ã«ãƒ†ã‚¹ãƒˆå®Ÿè¡Œã§ãã‚‹ã€‚ç”»é¢ã¯3ãƒšã‚¤ãƒ³æ§‹æˆã§ã€å·¦å´ã«ã¯è¤‡æ•°ã®SQLã‚½ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç®¡ç†ã§ãã‚‹ãƒ•ã‚¡ã‚¤ãƒ©ãƒ¼ã€ä¸å¤®ã«ã¯è¤‡æ•°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¿ãƒ–ã§åˆ‡ã‚Šæ›¿ãˆã¦è¡¨ç¤ºã§ãã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã€å³å´ã«ã¯æŽ¥ç¶šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’ãƒ„ãƒªãƒ¼ã¨ãƒªã‚¹ãƒˆã§è¡¨ç¤ºã™ã‚‹â€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©â€ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ SQLæ–‡ã®ä½œæˆæ™‚ã¯ã€ã•ã¾ã–
Kanasansoft 2007/07/05
db

gui

sql

software

tool
ãƒªãƒ³ã‚¯
ã€ŒPostgreSQLã¯é…ã„ã€ã¯æœ¬å½“ã‹ï¼Ÿï¼šOSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯”è¼ƒ - CNET Japan
å°åˆ·ã™ã‚‹ ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ ãƒ†ã‚ã‚¹ãƒˆ HTML é›»åæ›¸ç± PDF ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ†ã‚ã‚¹ãƒˆ é›»åæ›¸ç± PDF ã‚¯ãƒªãƒƒãƒ—ã—ãŸè¨˜äº‹ã‚’Myãƒšãƒ¼ã‚¸ã‹ã‚‰èªã‚€ã“ã¨ãŒã§ãã¾ã™ LAMPã‚„LAPPã¨ã„ã£ãŸè¨€è‘‰ãŒç¤ºã—ã¦ã„ã‚‹ã‚ˆã†ã«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆOSSï¼‰ã§ã®ä»£è¡¨çš„ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã¨ã„ãˆã°ã€ã€ŒMySQLã€ã¨ã€ŒPostgreSQLã€ã ã€‚ã“ã®2ã¤ã®RDBMSã¯åŒç‰ã§ã‚ã‚‹ã‹ã®ã‚ˆã†ã«æ€ã‚ã‚Œã¦ã„ã‚‹ãŒã€ã—ã‹ã—PostgreSQLã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å›£ä½“ã€Œæ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã€ã§ç†äº‹é•·ã‚’å‹™ã‚ã‚‹ç‰‡å²¡è£•ç”Ÿæ°ã«ã‚ˆã‚Œã°ã€ã€ŒPostgreSQLã¯ã‚ã¾ã‚Šä¿¡ç”¨ã•ã‚Œã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ãã†ã ã€‚ ã€Œååˆ†ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸMySQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„PostgreSQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€åå¯¾ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸPostgreSQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„MySQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€ã‚ã‚‹ã„ã¯æ¯”
Kanasansoft 2007/04/13
benchmark

db

performance

software

sql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tips - PHPãƒ—ãƒï¼ãƒ‹ãƒ¥ãƒ¼ã‚¹
å¹³ç´ ã‚ˆã‚Šã€ŒPHPãƒ—ãƒï¼ã€ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ 2006å¹´ã‚ˆã‚Šé‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€ŒPHPãƒ—ãƒï¼ã€ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚’é‘‘ã¿ã¾ã—ã¦ã€2018å¹´9æœˆ25æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã¾ã—ã¦ã€2018å¹´8æœˆ28æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’æŒã¡ã¾ã—ã¦ã€æ–°è¦ä¼šå“¡ç™»éŒ²ãªã‚‰ã³ã«Q&AæŽ²ç¤ºæ¿ã¸ã®æ–°ãŸãªè³ªå•ã€å›žç”ã®æŠ•ç¨¿ã‚’åœæ¢ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãªãŠã€ã”ç™»éŒ²ã„ãŸã ã„ãŸçš†æ§˜ã®å€‹äººæƒ…å ±ã«ã¤ãã¾ã—ã¦ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†å¾Œã€å¼Šç¤¾ãŒè²¬ä»»ã‚’ã‚‚ã£ã¦æ¶ˆåŽ»ã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¤šãã®çš†æ§˜ã«ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã€çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ã“ã¨ã€å¿ƒã‚ˆã‚ŠãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚ æœ¬ä»¶ã«é–¢ã™ã‚‹ãŠå•ã„åˆã‚ã›ã¯ã“ã¡ã‚‰ã‚ˆã‚ŠãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2007/04/10
db

mysql

sql
ãƒªãƒ³ã‚¯
1