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

ShoCoh id:ShoCoh

DBã¨dbã«é–¢ã™ã‚‹ShoCohã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

O/Rãƒžãƒƒãƒ‘ãƒ¼ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚’æœªç„¶ã«é˜²ã
2. copyright Â© 2014 kuwata-lab.com all rights reserved ã¾ãˆãŒã ç¾åœ¨ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã®ç¾å ´ã§ã¯ O/R Mapper (ORM) ãŒæ™®åŠã—ã¦ã„ã¾ã™ã€‚ä»Šå¾Œ ã‚‚ ORM ã‚’ä½¿ã£ãŸé–‹ç™ºã¯ã€å¢—ãˆã‚‹ã“ã¨ã¯ã‚ã£ã¦ã‚‚æ¸›ã‚‹ã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã— ORM ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ã«ã¨ã£ã¦ã¯ä¾¿åˆ©ã§ã‚‚ã€DB ç®¡ç†è€… (DBA) ã‹ ã‚‰ã¿ãŸã‚‰ãƒˆãƒ©ãƒ–ãƒ«ã®ç¨®ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã‚ŒãŒç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹å•é¡Œã§ã‚ã‚‹ã“ ã¨ãŒå¤šã„ãŸã‚ã€é–‹ç™ºè€…ã¨ DBA ãŒå¯¾ç«‹ã™ã‚‹ã“ã¨ã‚‚çã—ãã‚ã‚Šã¾ã›ã‚“ã€‚ ã¨ã¯ã„ãˆã€ORM ã«ã‚ˆã‚‹å•é¡Œã¯ã™ã§ã«è§£æ±ºç–ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚æœ¬å½“ã® å•é¡Œã¯ã€ã™ã§ã«å˜åœ¨ã™ã‚‹è§£æ±ºç–ãŒã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã“ã¨ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ãã“ã§æœ¬ç™ºè¡¨ã§ã¯ã€ORM ã«ã‚ˆã£ã¦ã©ã®ã‚ˆã†ãªå•é¡ŒãŒèµ·ã“ã‚Šã‚„ã™ã„ã‹ã€ã©ã†è§£æ±ºãƒ»äºˆé˜² ã™ã‚Œã°ã„ã„ã‹ã€ãã—ã¦ ORM
ShoCoh 2016/06/18
sql

DB
ãƒªãƒ³ã‚¯
ã‚¨ãƒã‚²ãƒ¼ãƒžãƒ¼ã®ãŸã‚ã®SQL -ã‚¨ãƒã‚²ãƒ¼ãƒžãƒ¼ã®ãŸã‚ã®SQL-
SQLã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—ãŸã‚Šã™ã‚‹ãŸã‚ã®è¨€èªžã§ã™ã€‚ ã“ã®æ–‡æ›¸ã¯ã€ErogameScapeã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰SELECTã‚’ä½¿ã£ã¦è‡ªç”±è‡ªåœ¨ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã‚’ç›®æ¨™ã«ã—ã¾ã™ã€‚ ã‚¨ãƒã‚²ãƒ¼ã‚’ã‚„ã‚Šã¯ã˜ã‚ã‚‹å¤§å¦ç”Ÿãã‚‰ã„ã®ã¨ãã«ã€å¤§å¦ã®è¬›ç¾©ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã‚“ã§ã€é€€å±ˆã ãªãƒ¼ã¨æ€ã£ãŸæ™‚ã«ã€ErogameScapeã§SQLã‚’å¦ã¶ã“ã¨ã§ã€å°‘ã—ã§ã‚‚SQLã«èˆˆå‘³ã‚’æŒã£ã¦ã€è‡ªèº«ã§ãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ã™ã‚‹ã“ã¨ã‚’å¦ç¿’ã—ã¦é ‚ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚ â€»ç§ã®å¤§å¦ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æŽˆæ¥ã§ã¯ã€è‡ªåˆ†ã®èº«ã®å›žã‚Šã®ä½•ã‹ã‚’ERå›³ã«è½ã¨ã—è¾¼ã‚“ã§ã€DBã‚’è¨è¨ˆã—ã€PostgreSQLã«å®Ÿè£…ã—ã€å®Ÿéš›ã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã—ã¦SELECTã—ã¦ã¿ã‚‹ã¨ã“ã‚ã¾ã§ã‚’ã‚„ã‚Šã¾ã—ãŸã€‚ ERå›³ã¨ã„ã†æ¦‚å¿µã‚’å¦ã‚“ã ã¨ãã€Œã‚ã‚ã€ã“ã‚Œã¯é¢ç™½ã„ã€ã¨æ€ã„ã¾ã—ãŸã€‚ å…ˆç”Ÿã¯ã“ã†è¨€ã£ãŸã®ã§ã™ã€‚ ã€ŒERå›³ã«è½ã¨ã—è¾¼ã‚€ã¨ã€æ€ã„ã‚‚ã‚ˆã‚‰ãªã‹ã£ãŸã“ã¨ãŒåˆ†ã‹ã‚‹ã€‚ã€ã¨ã€‚ å½“æ™‚ã€
ShoCoh 2014/01/02
ã‚ã¨ã§ã‚ˆã‚€

ã‚²ãƒ¼ãƒ

DB
ãƒªãƒ³ã‚¯
RDBMSã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ãŒå¿…è¦ãªç†ç”±ã€ã‚ã‹ã‚‰ãªã„ã€‚
Takayuki Shimizukawa @shimizukawa @masa_edw ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ãŒç„¡ã„å ´åˆã€ä½¿ã„çµ‚ã‚ã£ãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå³è§£æ”¾ã•ã‚Œãªã„ï¼ˆè§£æ”¾ã¾ã§å¤šå°‘é…å»¶ã™ã‚‹ï¼‰ã®ã§å®Ÿéš›ã«ä½¿ã£ã¦ã„ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®æ•°ã‚ˆã‚Šå¤šãå˜åœ¨ã™ã‚‹ã€‚ãã®åˆ†ãƒ¡ãƒ¢ãƒªã‚’åœ§è¿«ã—ã¦åŠ¹çŽ‡ãŒæ‚ªã„ã€‚ã£ã¦ã„ã†è©±ã¯èžã„ãŸã“ã¨ãŒã‚ã‚‹ã‚ˆï¼ˆè¦å‡ºå…¸ 2013-09-04 09:27:28 ãƒã‚¤ãƒ‘ãƒ¼ã‚€ã¨ã† @masa_edw @voluntas ç¾çŠ¶ã§å¿…è¦ãªçŠ¶æ³ã¯ç†è§£ã—ã¦ã„ã¾ã™ãŒã€ãªãœãã†ãªã‚‹ã®ã‹ç†è§£ã—ã¦ã„ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ä»–ã«ã‚‚ãŸã¨ãˆã°ã€bitlyã®å‘¼ã³å‡ºã—ã¯ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ä½¿ã†ã¹ãã‹ï¼Ÿãªãœ(ã¹ãã€ã¹ãã§ãªã„)ã®ã‹ï¼Ÿã©ã†ã„ã†è¦è«‹ã§ãã†ãªã®ã‹ï¼Ÿã¨è¨€ã†å•ã„ã«åƒ•ã¯ç”ãˆã‚‰ã‚Œã¾ã›ã‚“ã€‚ 2013-09-04 09:31:22
ShoCoh 2013/09/04
db

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
ãƒ¢ãƒã‚¤ãƒ«ã‚²ãƒ¼ãƒ ã®æ´å²ã‚’å¹´ä»£åˆ¥ã«ã”ç´¹ä»‹ã—ã¾ã™ã€‚ãƒ¢ãƒã‚¤ãƒ«ã‚²ãƒ¼ãƒ ã®æˆé•·ã¨ä»Šå¾Œã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¦ã„ãã¾ã™ã€‚
ãƒ¢ãƒã‚¤ãƒ«ã‚²ãƒ¼ãƒ ç‰©å‡„ã„å‹¢ã„ã§å‹ƒèˆˆã—ãŸãƒ¢ãƒã‚¤ãƒ«ã‚²ãƒ¼ãƒ æ¥ç•Œã¯ã€ã„ã‚ã„ã‚ãªèª²é¡Œã‚„å•é¡Œã«ç›´é¢ã—ãªãŒã‚‰ã‚‚å·¨å¤§åŒ–ã—ã€ä»Šæ—¥ã®æ™‚ç‚¹ã§ã®ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³å‘ã‘ã‚²ãƒ¼ãƒ ã®å¸‚å ´ã¸ã¨ç¶™æ‰¿ã•ã‚Œã¦ã„ãã¾ã™ã€‚ ãƒ¢ãƒã‚¤ãƒ«ã‚²ãƒ¼ãƒ ã®æ´å² 2001 Javaã‚¢ãƒ—ãƒªã¨3Dã‚²ãƒ¼ãƒ ã®ç™»å ´ JavaãŒåˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã“ã¨ã«ã‚ˆã‚Šã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰åž‹ã®ã‚²ãƒ¼ãƒ ãŒä¾›çµ¦ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ 2002 æºå¸¯é›»è©±ç«¯æœ«ã®å¤§å®¹é‡åŒ–ãƒ»3DåŒ–ç«¶äº‰ Javaæè¼‰æºå¸¯é›»è©±ç«¯æœ«ãŒç™»å ´ã—ã¦ã‹ã‚‰ã”ãåƒ…ã‹1å¹´ã®é–“ã«ã€ã‚¢ãƒ—ãƒªã®ã‚µã‚¤ã‚ºã«é–¢ã—ã¦ã¯10å€ã«åºƒå¤§åŒ–ã—ã€è¡¨ç¾æ–¹æ³•ã‚‚2Dã‹ã‚‰3Dã«ã‚·ãƒ•ãƒˆã—å§‹ã‚ã¾ã—ãŸã€‚J-PHONEã¯ã€Žã‚¼ãƒ“ã‚¦ã‚¹ã€ã‚„ã€Žã‚¹ãƒšãƒ¼ã‚¹ãƒãƒªã‚¢ãƒ¼ã€ãªã©ã¨ã„ã£ãŸæ˜”ã®ã‚¢ãƒ¼ã‚±ãƒ¼ãƒ‰ã‚²ãƒ¼ãƒ ã‚’ã€ãƒ‰ã‚³ãƒ¢ã¯SIMCITYãªã©ãƒ‘ã‚½ã‚³ãƒ³ã§ä¸–ç•Œçš„è¦æ¨¡ã®ãƒ’ãƒƒãƒˆã‚’é£›ã°ã—ãŸã‚²ãƒ¼ãƒ ã‚’ä¸»åŠ›å•†å“ã¨ã—ã¦ã„ã¾ã—ãŸã€‚ 2003 ãƒ¢ãƒã‚¤ãƒ«ã‚²ãƒ¼ãƒ ã®ä¸€èˆ¬åŒ– ãƒ¡ãƒ¢ãƒªã®åˆ¶é™ãŒåŽ³ã—ã„Javaä»®æƒ³ãƒžã‚·ãƒ³ä¸Šã§ã¯ãªãã€OS
ShoCoh 2011/08/04
ã‚²ãƒ¼ãƒ

javascript

HTML5

DB
ãƒªãƒ³ã‚¯
Ring
Ringã¨ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ä¼šç¤¾å¾“æ¥å“¡ã‚’å¯¾è±¡ã«ã—ãŸæ–°è¦äº‹æ¥ææ¡ˆåˆ¶åº¦ã§ã™ã€‚ ã€Žã‚¼ã‚¯ã‚·ã‚£ã€ã€ŽR25ã€ã€Žã‚¹ã‚¿ãƒ‡ã‚£ã‚µãƒ—ãƒªã€ãªã©æ•°å¤šãã®äº‹æ¥ã‚’ç”Ÿã¿å‡ºã—ã¦ããŸæ–°è¦äº‹æ¥åˆ¶åº¦ã¯ã€ 1982å¹´ã«ã€ŒRINGã€ã¨ã—ã¦ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€1990å¹´ã€ŒNew RINGã€ã¨æ”¹å®šã€ãã—ã¦2018å¹´ã€ŒRingã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ã®å¾“æ¥å“¡ã¯èª°ã§ã‚‚è‡ªç”±ã«å‚åŠ ã™ã‚‹ã“ã¨ãŒã§ãã€ ãƒ†ãƒ¼ãƒžã¯ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®æ—¢å˜é ˜åŸŸã«é™ã‚‰ãšã€ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹é ˜åŸŸãŒå¯¾è±¡ã§ã™ã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã«ã¨ã£ã¦ã€Ringã¨ã¯ã€Œæ–°ã—ã„ä¾¡å€¤ã®å‰µé€ ã€ã¨ã„ã†ã‚°ãƒ«ãƒ¼ãƒ—çµŒå–¶ç†å¿µã‚’ä½“ç¾ã™ã‚‹å ´ã§ã‚ã‚Šã€ å¾“æ¥å“¡ãŒè‡ªåˆ†ã®æ„æ€ã§æ–°è¦äº‹æ¥ã‚’ææ¡ˆãƒ»å®Ÿç¾ã§ãã‚‹æ©Ÿä¼šã§ã™ã€‚ Ringãƒ•ãƒãƒ¼ ãã®å¾Œã®äº‹æ¥é–‹ç™ºæ‰‹æ³• Ringã‚’é€šéŽã—ãŸæ¡ˆä»¶ã¯ã€äº‹æ¥åŒ–ã‚’æ¤œè¨Žã™ã‚‹æ¨©åˆ©ã‚’å¾—ã¦ã€äº‹æ¥é–‹ç™ºã‚’è¡Œã„ã¾ã™ã€‚ ã•ã¾ã–ã¾ãªäº‹æ¥é–‹ç™ºã®æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä¾‹ãˆã°æ—¢å˜é ˜åŸŸã§ã®äº‹æ¥é–‹ç™ºã®å ´åˆã¯ã€ æ‹…å½“äº‹æ¥ä¼šç¤¾å†…ã§äºˆç®—ã‚„
ShoCoh 2010/11/28
API

google

jquery

javascript

db

Google Documents
ãƒªãƒ³ã‚¯
1