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

idoya id:idoya

dbã«é–¢ã™ã‚‹idoyaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã‚’è¤‡æ•°å°æ§‹æˆã¨ã‹2010å¹´ä»£ã«ã¯æµè¡Œã‚‰ãªã„ - blog.nomadscafe.jp
å¥¥ä¸€ç©‚ã•ã‚“ã®ã€Œã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã‚’è¤‡æ•°å°æ§‹æˆã¨ã‹2010å¹´ä»£ã«ã¯æµè¡Œã‚‰ãªã„ã€ã«ãƒ•ã‚©ãƒãƒ¼ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã€‚ ä¾‹ã«ã‚ˆã£ã¦ã‚¿ã‚¤ãƒˆãƒ«ã¯ç…½ã‚Šã§ã™ã€‚ å¥¥ä¸€ç©‚ã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ã€ã€Œ5,000ä¸‡PV/Monthã€ã¨ã„ã†è¦‹ç©ã‚‚ã‚Šã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã®å°æ•°ã‚’1å°ã¨è¨ˆç®—ã—ã¦ã„ã¾ã™ãŒã€ã“ã‚Œã‹ã‚‰ã¯ã€Œ1,000ä¸‡PV/Dayã€ã‚’è¶…ãˆã‚‹ã‚µã‚¤ãƒˆãŒå¤šãç”Ÿã¾ã‚Œã¦ãã‚‹ã¨äºˆæƒ³ã—ã¦ã„ã¾ã™ã€‚ã©ã‚“ãªã‚µã‚¤ãƒˆã‹ã¨ã„ã†ã¨ã€mixiã‚¢ãƒ—ãƒªã‚„ãƒ¢ãƒã‚²ãƒ¼ãªã©ã«ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’æä¾›ã™ã‚‹ã‚µã‚¤ãƒˆã§ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚µã‚¤ãƒˆã®ã‚ãƒ£ãƒ‘ã‚·ãƒ†ã‚£ãƒ—ãƒ©ãƒ³ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã¯ä¸æ¾¤ã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ The Art of ãƒ¢ãƒã‚²ãƒ¼ Capacity Planning The Art of Mixi-mobile-appli Capacity Planning æœ€ã‚‚äººæ°—ãŒã§ãŸå ´åˆã«ã¯æ•°åƒä¸‡ã‹ã‚‰æ•°å„„PV/Dayã¨ã„ã†æ•°å—ãŒãªã‚‰ã‚“ã§ã„ã¾ã™ã€‚æ€–ã„æ€–
idoya 2010/01/12
server

DB

mysql
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬6å›žï¼šquery_cache_sizeã®é•ã„ã«ã‚ˆã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ (1/3)
MySQLã‚µãƒ¼ãƒã«ã¯ã€MySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®ã‚¯ã‚¨ãƒªã¨ãã®å®Ÿè¡Œçµæžœã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã€æ¬¡å›žã‹ã‚‰åŒã˜å†…å®¹ã®ã‚¯ã‚¨ãƒªãŒè¦æ±‚ã•ã‚ŒãŸå ´åˆã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‹ã‚‰å¿œç”ã™ã‚‹ã€ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã„ã†ä»•çµ„ã¿ãŒã‚ã‚Šã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‹ã‚‰å¿œç”ã•ã›ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹è² è·ã‚’è»½æ¸›ã—ã€ã¾ãŸå¿œç”é€Ÿåº¦è‡ªä½“ã®å‘ä¸Šã‚‚ç‹™ã£ãŸã‚‚ã®ã§ã™ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆçŠ¶æ…‹ã§ã¯ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ç”¨ã—ãªã„è¨å®šã«ãªã£ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ã®ã‚ˆã†ã«ç¾åœ¨ã®ã€Œã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ä½¿ç”¨ã™ã‚‹ãƒ¡ãƒ¢ãƒªé‡ã®æœ€å¤§å€¤ã€ã§ã‚ã‚‹query_cache_sizeã‚’ç¢ºèªã—ã¦ãã ã•ã„ã€‚
idoya 2009/09/16
DB

MySQL

server

tuning
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ èƒŒæ™¯ æ¦‚è¦³ è©³ç´° ä¸€è²«æ€§ã¨åŽŸåæ€§ æ€§èƒ½ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ "How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
idoya 2009/08/14
MySQL

DB
ãƒªãƒ³ã‚¯
Data Models
Data Models: A Comprehensive Guide to Structuring Information for Optimal Insights and Decision-Making In the realm of data management, the use of effective data models plays a pivotal role in organizing and representing information in a structured and meaningful way. Data models serve as the blueprint for databases, facilitating efficient data storage, retrieval, and analysis. This article delves
idoya 2008/11/03
[]

DB
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬5å›žï¼šã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒ (1/4)
ä»Šå›žã¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã«ãŠã‘ã‚‹4ç•ªç›®ã®ã‚«ãƒ†ã‚´ãƒªãƒ¼ã€Œã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã€ã«ã¤ã„ã¦è§£èª¬ã™ã‚‹ã€‚ â€»æ³¨æ„ï¼š ã“ã®è¨˜äº‹ã«ã¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã‚’è§£èª¬ã™ã‚‹å¿…è¦ä¸Šã€æ”»æ’ƒæ‰‹å£ã«é–¢ã™ã‚‹æƒ…å ±ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã‚Œã‚‰ã®æ‰‹å£ã‚’ä»–è€…ãŒé‹å–¶ã™ã‚‹Webã‚µã‚¤ãƒˆã«å‘ã‘ã¦ä»•æŽ›ã‘ã‚‹ã¨ã€æœ€æ‚ªã®å ´åˆåˆ‘äº‹ç½°ãŠã‚ˆã³æå®³è³ å„Ÿè«‹æ±‚ã®å¯¾è±¡ã¨ãªã‚Šã¾ã™ã€‚è„†å¼±æ€§ã®èª¿æŸ»ãƒ»æ¤œè¨¼ã¯ã€å¿…ãšã”è‡ªèº«ã®ç®¡ç†ä¸‹ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚·ã‚¹ãƒ†ãƒ ãŠã‚ˆã³ãƒãƒ¼ã‚«ãƒ«ã‚¨ãƒªã‚¢ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã§è¡Œã£ã¦ãã ã•ã„ã€‚ã“ã®è¨˜äº‹ã‚’å‚è€ƒã«ã—ãŸè¡Œç‚ºã«ã‚ˆã‚Šå•é¡ŒãŒç”Ÿã˜ã¦ã‚‚ã€ç†è€…ãŠã‚ˆã³ThinkITç·¨é›†å±€ã¯ä¸€åˆ‡è²¬ä»»ã‚’è² ã„ã¾ã›ã‚“ã€‚ ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ï¼ˆinjectionï¼‰ã¨ã¯ã€å†…éƒ¨ã«ä½•ã‹ã‚’æ³¨å…¥ã™ã‚‹ã“ã¨ã‚’æ„å‘³ã™ã‚‹è¨€è‘‰ã ã€‚ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã¨ã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒ ãŒã”ãæ™®é€šã«å—ã‘å–ã‚‹å…¥åŠ›ãƒ‡ãƒ¼ã‚¿ã®ä¸ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’ä¾µå®³ã™ã‚‹ã‚ˆã†ãªã‚³ãƒžãƒ³ãƒ‰ã‚’å·§ã¿ã«æ··å…¥ã—ã€ãã‚Œã‚’ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿å†…éƒ¨ã§æ©Ÿèƒ½ã•ã›ã¦ã—ã¾ã†æ”»æ’ƒæ‰‹å£ã®
idoya 2008/11/03
security

ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

DB

MySQL
ãƒªãƒ³ã‚¯
30åˆ†é–“ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚° ã€œERå›³ã‚’æã“ã†ï¼ã€œï¼ˆ1/4ï¼‰ â€• ï¼ IT
30åˆ†é–“ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚° ï½žERå›³ã‚’æã“ã†ï¼ï½žï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¸ã®é“ï¼ˆ2ï¼‰ï¼ˆ1/4 ãƒšãƒ¼ã‚¸ï¼‰ æœ¬é€£è¼‰ã¯ã€ITã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ç¾å ´ã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚„SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œã£ã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨è€…ï¼‰ãŒã€ãƒ‡ãƒ¼ã‚¿ç®¡ç†è€…ï¼ˆDAï¼‰ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ï¼ˆDBAï¼‰ã¸ã‚¹ãƒ†ãƒƒãƒ—ã‚¢ãƒƒãƒ—ã™ã‚‹ãŸã‚ã®ç¬¬ä¸€æ©ã¨ã—ã¦æœ‰åŠ¹ãªåŸºç¤ŽçŸ¥è˜ã‚’ç´¹ä»‹ã™ã‚‹ï¼ˆç·¨é›†å±€ï¼‰
idoya 2008/11/03
ã€€DBè¨è¨ˆãƒ»ERå›³ã‚’æã

DB

ERå›³
ãƒªãƒ³ã‚¯
fabFORCE.net
General Information - What is DBDesigner 4? DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases. DBDesigner 4 compares to products like Oracle's Designerï¿½, IBM's Rational
idoya 2008/11/03
ã€€DBè¨è¨ˆæ”¯æ´ãƒ„ãƒ¼ãƒ«

DBDseigner

DB

ãƒ„ãƒ¼ãƒ«

ERå›³
ãƒªãƒ³ã‚¯
http://www.kogures.com/hitoshi/webtext/db-intro/index.html
idoya 2008/11/03
ã€€åŸºç¤Ž

DB

MySQL
ãƒªãƒ³ã‚¯
XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ç¬¬2æ¬¡é»„é‡‘æœŸã®äºˆæ„Ÿï¼ˆ1/2ï¼‰ â€• ï¼ IT
Database Watch 10æœˆç‰ˆã€€Page 1/2 XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ç¬¬2æ¬¡é»„é‡‘æœŸã®äºˆæ„Ÿ åŠ å±±æµç¾Ž 2006/10/14 ã“ã‚Œã¾ã§ã‚‚XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯è©±é¡Œã«ã—ã¦ãã¾ã—ãŸãŒã€2006å¹´ã¯XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢ä¿‚ã®è©±é¡Œã‚’ã‚ˆãè€³ã«ã—ã¾ã™ã€‚ä»Šå¾Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã®ã‚ˆã†ãªXMLæ©Ÿèƒ½ã‚’æŒã¤ã‹ãŒéµã«ãªã£ã¦ããã†ã§ã™ã€‚ â– 2006å¹´ã¯W3Cã§XMLã®åŸºæœ¬ä»•æ§˜ã«å‹•ããŒ XMLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è©±ã®å‰ã«ã€2006å¹´ã®W3Cã®XMLå‹•å‘ã‚’å°‘ã—æŒ¯ã‚Šè¿”ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚2006å¹´ã¯åŸºæœ¬çš„ãªæŠ€è¡“ä»•æ§˜ã«å‹•ããŒã‚ã‚Šã¾ã—ãŸã€‚8æœˆã«ã¯XMLã®æ ¹å¹¹ã¨ãªã‚‹XML 1.0 ç¬¬4ç‰ˆã‚„åå‰ç©ºé–“ 1.0 ç¬¬2ç‰ˆãŒå‹§å‘Šã«ãªã‚Šã¾ã—ãŸã€‚ã“ã‚Œã‚‰ã¯ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ãªãã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã®æ›´æ–°ãªã®ã§ç´°ã‹ãªä¿®æ£ã‚„æ”¹è‰¯ã«ã™ãŽã¾ã›ã‚“ãŒã€å®Œæˆåº¦ã‚’é«˜ã‚ã‚‹ãŸã‚ã®åŠªåŠ›ãŒç¶™ç¶šã•ã‚Œã¦ã„ã‚‹ã“ã¨ã¯è¨˜æ†¶ã«ã¨ã©ã‚ã¦ãŠããŸã„ã¨ã“ã‚ã§ã™ã€‚ ä¸€æ–¹ã€ä¸»è¦ãªä»•æ§˜ã§æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒè¿‘ã¥ã„ã¦ã„ã‚‹ã‚‚
idoya 2008/11/03
XML

DB
ãƒªãƒ³ã‚¯
SQL Designer
idoya 2008/11/03
DB

MySQL

Ajax
ãƒªãƒ³ã‚¯
ä»Šå¤œåˆ†ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– â€• ï¼ IT
ã€é–¢é€£è¨˜äº‹ã€‘ æœ¬å†…å®¹ã«ã¤ã„ã¦ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆè¨˜äº‹ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚ã›ã¦ã”ç¢ºèªãã ã•ã„ï¼ˆç·¨é›†éƒ¨ï¼‰ Security&Trustã‚¦ã‚©ãƒƒãƒï¼ˆ60ï¼‰ ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ http://www.atmarkit.co.jp/fsecurity/column/ueno/60.html Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹æ”»æ’ƒæ‰‹æ³•ã®1ã¤ã§ã‚ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å˜åœ¨ã¯ã€ã‹ãªã‚ŠåºƒãçŸ¥ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ã—ã‹ã—ã€ãã®å¯¾ç–ã¯ã¾ã æœ¬å½“ã«ç†è§£ã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ãˆã‚‹ã€‚ãƒ•ã‚©ãƒ¼ãƒ ã‹ã‚‰æ¸¡ã•ã‚ŒãŸå€¤ã®ç‰¹æ®Šæ–‡å—ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãŸã‚Šã€PHPã®magic_quotes_gpcã¨ã„ã£ãŸè‡ªå‹•ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ©Ÿèƒ½ã‚’ã‚ªãƒ³ã«ã™ã‚‹ã ã‘ã§å¯¾ç–ã—ãŸã¤ã‚‚ã‚Šã«ãªã£ã¦ã„ãªã„ã ã‚ã†ã‹ã€‚ åŸºæœ¬ã¯ã‚‚ã¡ã‚ã‚“ã€ã‚»ã‚«ãƒ³ãƒ‰ã‚ªãƒ¼ãƒ€ãƒ¼SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒžãƒ«ãƒãƒã‚¤ãƒˆæ–‡å—ã‚’åˆ©ç”¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ”»æ’ƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚„ã€ãã®å¯¾
idoya 2008/11/03
security

DB

MySQL
ãƒªãƒ³ã‚¯
Ajaxã‚’ä½¿ã£ã¦ãã®å ´ã§MySQLã®å€¤ã‚’æ›¸ãæ›ãˆã‚‰ã‚Œã‚‹ã‚¦ã‚£ã‚¸ã‚§ãƒƒãƒˆä½œæˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒMySQLPHPGridã€:phpspoté–‹ç™ºæ—¥èªŒ
Ajaxã‚’ä½¿ã£ã¦ãã®å ´ã§MySQLã®å€¤ã‚’æ›¸ãæ›ãˆã‚‰ã‚Œã‚‹ã‚¦ã‚£ã‚¸ã‚§ãƒƒãƒˆä½œæˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒMySQL PHPGridã€ 2007å¹´01æœˆ17æ—¥- MySQL PHPGrid MySQL PHPGrid puts data from a MySQL table in a configurable grid on a webpage. Ajaxã‚’ä½¿ã£ã¦ãã®å ´ã§MySQLã®å€¤ã‚’æ›¸ãæ›ãˆã‚‰ã‚Œã‚‹ã‚¦ã‚£ã‚¸ã‚§ãƒƒãƒˆä½œæˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒMySQL PHPGridã€ã€‚ MySQLã®å€¤ã‚’ã¡ã‚‡ã“ã£ã¨æ›¸ãæ›ãˆãŸã„ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã‚’ä½œã‚‹å ´åˆã¯ã©ã®ã‚ˆã†ã«è¡Œã£ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ Excelã®ã‚ˆã†ã§ã‚ã‚Šã€phpMyAdminã®ã‚ˆã†ã§ã‚‚ã‚ã‚‹ä½¿ã„ã‚„ã™ã„ç›´æ„Ÿçš„ãªUIã‚’æŒã¤ã‚¦ã‚£ã‚¸ã‚§ãƒƒãƒˆã‚’MySQL PHPGridã‚’ä½¿ã†ã“ã¨ã§ç°¡å˜ã«å®Ÿç¾ã§ãã¾ã™ã€‚ ï¼ˆã‚»ãƒ«éƒ¨åˆ†ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨ãã®å ´ã§æ›¸ãæ›ãˆã‚‹ã“ã¨ãŒå‡ºæ¥ã€å·¦ç«¯ã®å‰Šé™¤ãƒœã‚¿ãƒ³ã§è¡Œã‚’å‰Šé™¤ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ï¼‰ ã©ã®ãã‚‰ã„ç°¡
idoya 2008/11/03
mysql

php

javascript

ajax

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

php

db

sql

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
MOONGIFT: Â» å‡„ã„ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒtxtSQLã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚ˆã‚Šã€‚ æ˜¨æ—¥ãŠä¼ãˆã—ãŸGladius DBã®å¯¾æŠ—é¦¬ã¨ã—ã¦ç´¹ä»‹ã—ãŸã„ã€‚ã“ã¡ã‚‰ã‚‚ã¾ãŸã€ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’DBã¨ã—ã¦æ‰±ã†ã“ã¨ãŒã§ãã‚‹ã€‚ã•ã‚‰ã«Gladius DBã¸ã®æŒ‘æˆ¦ãªã®ã‹ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å…¬é–‹ã—ã¦ã„ã‚‹ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯txtSQLã€ãƒ†ã‚ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ txtSQLã¯Gladius DBã¨ã¯ç•°ãªã‚Šã€SQLæ–‡ã‚’è§£é‡ˆã—ãªã„ã€‚ç‹¬è‡ªã®é–¢æ•°ã«ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ï¼ˆSELECT/INSERT/UPDATE/DELETEç‰ï¼‰ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã€ãƒ‡ãƒ¼ã‚¿ã€WHEREå¥ãªã©ã‚’æŒ‡å®šã—ã¦æ¸¡ã™å¿…è¦ãŒã‚ã‚‹ã€‚ ãã®ãŸã‚ã€æ—¢å˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¹—ã‚Šæ›ãˆã‚‹ã«ã¯ä¿®æ£ãŒå¿…è¦ã«ãªã£ã¦ã—ã¾ã†ã®ãŒé›£ç‚¹ã ã€‚ã ãŒã€æ–°è¦é–‹ç™ºã§ã‚ã‚Œã°é–¢ä¿‚ãªã„ã ã‚ã†ã€‚ã¾ãŸã€ãã®çµæžœã¨ã—ã¦é«˜é€Ÿæ€§ãŒå£²ã‚Šã ã€‚Gladius DBã®10å€è¿‘ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‡ºã¦ã„ã‚‹ã€‚ é¢ç™½ã„ã®ã¯ã€ã‚µãƒ³ãƒ—ãƒ«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
idoya 2008/11/03
SQL

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

MySQL
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MyISAM vs InnoDB
ã‚ãã¾ã§æ†¶æ¸¬ã§ä»®èª¬ã§ã—ã‹ãªã„ã‚“ã§ã™ãŒã€‚ MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ã†ã¡ä»£è¡¨çš„ãªäºŒã¤ã€MyISAM ã¨ InnoDB ã¯ã‚ˆã MyISAM: Read ã¯é€Ÿã„ã‘ã©ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã®ãŸã‚ä¸¦è¡Œæ€§ãŒä½Žã„ã€‚é‹ç”¨ãŒç°¡å˜ã€‚ InnoDB: MyISAM ã‚ˆã‚Š Read ã¯é…ã„ã‘ã©ä¸¦è¡Œæ€§ãŒé«˜ã„ ã€‚è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ã€‚ã‚ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã€‚é‹ç”¨ãŒ MyISAM ã‚ˆã‚Šã¡ã‚‡ã£ã¨ã‚ã‚“ã©ãã•ã„ã€‚ ã¨ã„ã†åŒºåˆ¥ãŒã•ã‚Œã¾ã™ã€‚ã“ã“ã‹ã‚‰è»¢ã˜ã¦ã€ MyISAM ã¯å‚ç…§ç³»ã‚¯ã‚¨ãƒªãŒå¤§éƒ¨åˆ†ã‚’å ã‚ã‚‹å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ä¾‹ãˆã° blog ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€‚ InnoDB ã¯æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå¤šã„å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ ã¨è¨€ã‚ãŸã‚Šã—ã¾ã™ã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ã§ã‚‚ç¬¬2ç« ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«åž‹) P.30 ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒãªãã€ä¸»ã« SELECT ã¾ãŸã¯ I
idoya 2008/11/03
MyISAM

InnoDB

MySQL

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
idoya 2008/11/03
PHP

PEAR

DB
ãƒªãƒ³ã‚¯
ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ - ç‰¹é›†:åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼šITpro
ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã€‚ã©ã‚“ãªSQLæ–‡ã‚’æŠ•ã’ãŸã‚‰ã©ã‚“ãªçµæžœãŒè¿”ã£ã¦ãã‚‹ã‹ã•ãˆçŸ¥ã£ã¦ã„ã‚Œã°ã‚ˆã„ã€---ãã†æ€ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã—ã‹ã—ï¼Œæœ¬ç‰©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã™ã®ã§ã‚ã‚Œã°ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå‹•ãä»•çµ„ã¿ã‚’å¦ã¶ã“ã¨ã¯é¿ã‘ã¦é€šã‚Œã¾ã›ã‚“ã€‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªã©ã«å•é¡ŒãŒç”Ÿã˜ãŸã¨ãã©ã“ã‹ã‚‰æ‰‹ã‚’ä»˜ã‘ã¦ã„ã„ã®ã‹çš†ç›®è¦‹å½“ãŒã¤ã‹ãªã„ï¼Œã¨ã„ã£ãŸäº‹æ…‹ã«é™¥ã‚Šã‹ãã¾ã›ã‚“ã€‚ å¸‚è²©ã®RDBMSã®å†…éƒ¨ã¯ã‹ãªã‚Šè¤‡é›‘ã§ã™ãŒï¼ŒåŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’ç†è§£ã™ã‚‹ã®ã¯ãã‚Œã»ã©é›£ã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã®ç‰¹é›†ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å‹•ãä»•çµ„ã¿ã‚’ç†è§£ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒˆãƒ â—ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ1ï¼‰ ï¼°ï½ï½’ï½”ï¼‘ â—SQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ2ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ3ï¼‰ åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ4ï¼‰ åŸº
idoya 2008/11/03
DB

MySQL

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

è² è·åˆ†æ•£

SNS
ãƒªãƒ³ã‚¯
1