[B! ç”Ÿå³¶, å‹˜å¯Œ] lalupin4ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lalupin4 id:lalupin4

ç”Ÿå³¶, å‹˜å¯Œã«é–¢ã™ã‚‹lalupin4ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

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

RDBMSã¨NoSQLã¯ã©ã¡ã‚‰ãŒé€Ÿã„ã®ã‹ï¼Ÿã€€ã‚²ãƒ¼ãƒ é–‹ç™ºã«ãŠã‘ã‚‹RDBã®ä¸Šæ‰‹ãªä½¿ã„æ–¹
2018å¹´11æœˆ14æ—¥ã€ã€Žç¥žå§«PROJECTã€ãªã©ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ä¼ç”»ãƒ»é–‹ç™ºã‚’æ‰‹ãŒã‘ã‚‹æ ªå¼ä¼šç¤¾ãƒ†ã‚¯ãƒã‚¹ãŒä¸»å‚¬ã™ã‚‹ã‚¤ãƒ™ãƒ³ãƒˆã€ŒTECH x GAME COLLEGEã€ãŒé–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚ç¬¬8å›žã¨ãªã‚‹ä»Šå›žã®ãƒ†ãƒ¼ãƒžã¯ã€ŒåŠ¹çŽ‡çš„ãªã‚²ãƒ¼ãƒ é–‹ç™ºã®ãŸã‚ã®RDBå†å…¥é–€ã€ã€‚æ ªå¼ä¼šç¤¾ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ ä»£è¡¨å–ç· å½¹ã®ç”Ÿå³¶å‹˜å¯Œæ°ã‚’æ‹›ãã€ã‚²ãƒ¼ãƒ é–‹ç™ºã‚’ã•ã‚‰ã«é£›èºã•ã›ã‚‹ã€RDBã®ä»•çµ„ã¿ã¨è€ƒãˆæ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚å¾ŒåŠãƒ‘ãƒ¼ãƒˆã¨ãªã‚‹ä»Šå›žã¯ã€SQLã¨NoSQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã¨ã€å¤ã„æŠ€è¡“ã«å¯¾ã™ã‚‹è€ƒãˆæ–¹ã«ã¤ã„ã¦ã€æ°ã®æƒ³ã„ã‚’èªžã‚Šã¾ã™ã€‚ NoSQLã¯é€Ÿã„ã®ã‹ï¼Ÿ ç”Ÿå³¶å‹˜å¯Œæ°ï¼ˆä»¥ä¸‹ã€ç”Ÿå³¶ï¼‰ï¼šã§ã¯ã€NoSQLã¨SQLã®è©±ã«å…¥ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ã“ã®ç« ã§ã¯ã€MySQLã¨ã€memcachedã¨ã€MySQLã‚’NoSQLã®ã‚ˆã†ã«ä½¿ã†Handler Socketã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã‚“ã§ã™ãŒã€ãã®Handler Socketã«ã¤ã„ã¦ã€å°‘ã—èª¬æ˜Žã—ã¾ã™ã€‚ ã“ã‚Œ
lalupin4 2019/06/24
SQL

ç”Ÿå³¶, å‹˜å¯Œ
ãƒªãƒ³ã‚¯
ã‚¤ãƒã‹ã‚‰å¦ã¶RDBå†å…¥é–€ã€€ã‚²ãƒ¼ãƒ é–‹ç™ºã‚’é€²åŒ–ã•ã›ã‚‹ãŸã‚ã«çŸ¥ã£ã¦ãŠãã¹ãåŸºç¤ŽçŸ¥è˜
2018å¹´11æœˆ14æ—¥ã€ã€Žç¥žå§«PROJECTã€ãªã©ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ä¼ç”»ãƒ»é–‹ç™ºã‚’æ‰‹ãŒã‘ã‚‹æ ªå¼ä¼šç¤¾ãƒ†ã‚¯ãƒã‚¹ãŒä¸»å‚¬ã™ã‚‹ã‚¤ãƒ™ãƒ³ãƒˆã€ŒTECH x GAME COLLEGEã€ãŒé–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚ç¬¬8å›žã¨ãªã‚‹ä»Šå›žã®ãƒ†ãƒ¼ãƒžã¯ã€ŒåŠ¹çŽ‡çš„ãªã‚²ãƒ¼ãƒ é–‹ç™ºã®ãŸã‚ã®RDBå†å…¥é–€ã€ã€‚æ ªå¼ä¼šç¤¾ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ ä»£è¡¨å–ç· å½¹ã®ç”Ÿå³¶å‹˜å¯Œæ°ã‚’æ‹›ãã€ã‚²ãƒ¼ãƒ é–‹ç™ºã‚’ã•ã‚‰ã«é£›èºã•ã›ã‚‹ã€RDBã®ä»•çµ„ã¿ã¨è€ƒãˆæ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚å‰åŠãƒ‘ãƒ¼ãƒˆã¨ãªã‚‹ä»Šå›žã¯ã€RDBã®åŸºæœ¬çš„ãªçŸ¥è˜ã¨ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«åŠ¹ãè¨å®šã«ã¤ã„ã¦èªžã‚Šã¾ã™ã€‚ åŠ¹çŽ‡çš„ãªã‚²ãƒ¼ãƒ é–‹ç™ºã®ãŸã‚ã®RDBå†å…¥é–€ ç”Ÿå³¶å‹˜å¯Œæ°ï¼ˆä»¥ä¸‹ã€ç”Ÿå³¶ï¼‰ï¼šæ”¹ã‚ã¾ã—ã¦ã€ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã®ç”Ÿå³¶ã¨ç”³ã—ã¾ã™ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ ã¾ãšã¯è‡ªå·±ç´¹ä»‹ã§ã™ã€‚ä¸€éƒ¨ã§ã€ŒSQLã‚ªã‚¸ã‚µãƒ³ã€ã¨æ¶æ„ã•ã‚Œã¦ã„ã¾ã™ãŒã€ç§è‡ªèº«ã¯SIerç³»ã‹ã‚‰Webç³»ã€IoTãªã©ã‚’å¹…åºƒãã‚„ã£ã¦ã„ã¦ã€é–‹ç™ºã‚„ã‚³ãƒ³ã‚µãƒ«ãªã©ã‚’ã‚„ã‚‰ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ å®Ÿã¯ã‚²ãƒ¼ãƒ ç³»
lalupin4 2019/03/03
SQL

ç”Ÿå³¶, å‹˜å¯Œ
ãƒªãƒ³ã‚¯
ç¬¬14ãƒ»15å›ž SQL Server 2019å‹‰å¼·ä¼šã‚ˆã‚Š - ã¯ã¦ãªãƒ–ãƒã‚°ã«å¼•ã£è¶Šã—è¨˜å¿µ - SQLer ç”Ÿå³¶å‹˜å¯Œ ã®ãƒ–ãƒã‚°
ã¯ã¦ãªã®ãƒ–ãƒã‚°ã«å¼•ã£è¶Šã—ã¾ã—ãŸã€‚ æ€ã„å‡ºã—ãŸã‚ˆã†ã«ãƒ–ãƒã‚°ã‚’å†é–‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¬¡ ç›®æ¬¡ Twitterã¯è°è«–ã«å‘ã‹ãªã„ã€‚ ç§ã®ä¸»å¼µ SQLã®æ–¹ãŒæ¯ãŒé•·ã„ã‹ã‚‰ãƒã‚¸ãƒƒã‚¯ã‚’SQLã¸å¯„ã›ãŸæ–¹ãŒè‰¯ã„ SQLãŒåˆ†ã‹ã‚Šã«ãã„ã¨ã„ã†å¸¸è˜ã¨ã¯ï¼Ÿ æ•™è‚²ã‹ã‚‰ã‚„ã‚Šç›´ã™ã¹ã å«Œã„ãªäººã«é–¢ã‚ã‚‰ã›ãªã„ï¼ è°è«–ã«ã‚ãŸã‚Š æŠ€è¡“çš„ãªè°è«– å–¶æ¥çš„ãªè°è«– Twitterã¯è°è«–ã«å‘ã‹ãªã„ã€‚ ã€Œç¬¬14ãƒ»15å›ž SQL Server 2019å‹‰å¼·ä¼šã€ã«ã¤ã„ã¦ã€ ã‚¤ãƒã‚¤ãƒã¨Twitterã§ã”æ„è¦‹ã‚’é ‚æˆ´ã—ã¾ã—ãŸãŒã€140å—ã—ã‹æ›¸ã‘ãªã„Twitterã¯è°è«–ã«å‘ã„ã¦ã„ã¾ã›ã‚“ã€‚ ã§ã™ã‹ã‚‰ã€å‹‰å¼·ä¼šã§ã¯èªžã‚Šåˆ‡ã‚Œãªã‹ã£ãŸã“ã¨ã‚‚å«ã‚ã€ç§ã®ä¸»å¼µã‚’æ”¹ã‚ã¦ã¾ã¨ã‚ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç§ã®ä¸»å¼µ SQLã®æ–¹ãŒæ¯ãŒé•·ã„ã‹ã‚‰ãƒã‚¸ãƒƒã‚¯ã‚’SQLã¸å¯„ã›ãŸæ–¹ãŒè‰¯ã„ RDBMSï¼ˆSQLï¼‰ãŒæœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œå‡ºã—ãŸã®ã¯1990å¹´ä»£ã®ä¸é ƒã§ã—ã‚‡ã†ã€‚ ã¡ã‚‡ã†ã©ã€ç§ãŒã“ã®æ¥ç•Œã«å…¥ã£ãŸé ƒ
lalupin4 2019/02/26
SQL

ç”Ÿå³¶, å‹˜å¯Œ
ãƒªãƒ³ã‚¯
#API1st å‹‰å¼·ä¼š
upmeetup.info bot @upmeetup 12/02(é‡‘) [å‚åŠ 37äºº/å®šå“¡100äºº]bit.ly/2gAXXmQã€APIãƒ•ã‚¡ãƒ¼ã‚¹ãƒˆé–‹ç™ºå‹‰å¼·ä¼š ï¼ MVCã¯æ£ã—ããªã„ï¼ã€‘ #API1st 2016-11-23 22:44:11
lalupin4 2016/12/03
ã€Œç³žã€ã€Œæ»ãã€ã—ã‹è¨€ã£ã¦ã„ãªã„äººã¯ã‚²ã‚¹ãƒˆï¼Ÿã®ã‚ˆã†ã ã‹ã‚‰ã„ã„ã®ã‹ã‚‚ã—ã‚Œãªã„ã‘ã©ã€ã‚‚ã† 1 äººã®é‰„ç ²çŽ‰ã¿ãŸã„ãªã®ã¯ã©ã†ã„ã†ç«‹å ´ã®äººãªã®ã ã‚ã†ã‹ï¼šhttps://connpass.com/event/45178/

SQL

ç”Ÿå³¶, å‹˜å¯Œ

ã¾ã•ã‚‰ã£ã

å¤§æ£®, æ™ºå²
ãƒªãƒ³ã‚¯
SQLãŠã˜ã•ã‚“ã€Qiitaã«ç‚Žä¸Šè¨˜äº‹æŠ•ç¨¿ å‘¨å›²ã®åå¿œã¨åž¢BANã¾ã§ã®æµã‚Œ
ãƒªãƒ³ã‚¯ b.hatena.ne.jp ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ - MVCãŒãªãœé–“é•ã£ã¦ã„ã‚‹ã‹ï¼Ÿ - Qiita digo â€œ ã‚»ãƒŸãƒŠãƒ¼ã§è°è«–ã™ã‚‹ã® Liveé…ä¿¡ã—ã¦æ¬²ã—ã„â€ / beatdjam â€œä»Šæ—¥ã¯ã“ã‚Œã§æš–ã‚’å–ã‚ã†â€ / masraow â€œã“ã‚Œã‹ã€å®Œå…¨ã«ç‚Žä¸Šæ¡ˆä»¶ã â€ / ytRino â€œã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆç‚Žä¸ŠèŠ¸äººã‹ãª?â€ / beatdjam â€œä»Šæ—¥ã¯ã“ã‚Œã§æš–ã‚’å–ã‚ã†â€ / digo â€œ ã‚»ãƒŸãƒŠãƒ¼ã§è°è«–ã™ã‚‹ã® Liveé…ä¿¡ã—ã¦æ¬²ã—ã„â€
lalupin4 2016/11/13
BAN ã‹ã‚ˆã€‚ã‚³ãƒ¡ãƒ³ãƒˆã ã‘ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã—ã¨ã‘ã°ã‚ˆã‹ã£ãŸã®ã«å¼•ç”¨ã§ãããƒ¼ã ã‚ãŒã€‚

SQL

ç”Ÿå³¶, å‹˜å¯Œ
ãƒªãƒ³ã‚¯
https://qiita.com/kantomi
lalupin4 2016/06/10
@IT ã®å†ç¾ãªã‚‹ã‹ / ãªã£ãŸã‚

SQL

ç”Ÿå³¶, å‹˜å¯Œ
ãƒªãƒ³ã‚¯
SQLer ç”Ÿå³¶å‹˜å¯Œ ã®ãƒ–ãƒã‚°
Webã‚·ã‚¹ãƒ†ãƒ ã«MVCã‚’é©ç”¨ã™ã‚‹ã®ã¯é–“é•ã£ã¦ã„ã¾ã™ï¼ˆæ£ç¢ºã«ã¯ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ãŒè¶³ã‚Šã¾ã›ã‚“ï¼‰ã€‚ paperface.hatena blog.com ã“ã®ã‚ˆã†ã«æ€è€ƒåœæ¢ã—ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¯ã‚ã‹ã‚‰ãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã‚‚ã†ä¸€åº¦è§£èª¬ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ç›®æ¬¡ ç›®æ¬¡ ãã‚‚ãã‚‚MVCã¨ã¯ï¼Ÿ æ´å²ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ã¾ã—ã‚‡ã† ã‚¤ãƒ³ãƒ”ãƒ¼ãƒ€ãƒ³ã‚¹ãƒŸã‚¹ãƒžãƒƒãƒã¨ORMã®ç™»å ´ï¼ ã“ã†ã‚ã‚‹ã¹ãã§ã—ã‚‡ã†ï¼Ÿ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã«ã™ã‚‹ã“ã¨ã«å•é¡Œã¯ãªã„ã®ï¼Ÿ Fetch ã—ã¦ã‚°ãƒ«ã‚°ãƒ«ã—ãªã„ æ–‡å—åˆ—é€£çµã¯è¦ã‚‰ãªã„ ã©ã¡ã‚‰ãŒæ¥µç«¯ã§ã™ã‹ï¼Ÿ åˆ†é›¢é–‹ç™ºã™ã‚‹ã¹ã ãã‚‚ãã‚‚MVCã¨ã¯ï¼Ÿ MVCãŒã§ããŸé ƒ MVCã¯ã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ¼å‘ã‘ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒã‚ã¾ã‚Šã«ãã¡ã‚ƒãã¡ã‚ƒã ã£ãŸã®ã§ã€ã€Œé•ã†æ©Ÿèƒ½ã¯ç–Žçµåˆã«ã—ã‚ˆã†ï¼ã€ã¨ã„ã†è€ƒãˆã§ä½œã‚Šå‡ºã•ã‚Œã¾ã—ãŸã€‚ 1980å¹´ä»£ã®é ƒã®ãŠè©±ã§ã™ã€‚ ãã‚Œè‡ªä½“ã¯æ£ã—ã„ã§ã™ã€‚ æ´å²ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ã¾ã—ã‚‡ã† Webã‚·ã‚¹ãƒ†ãƒ ã‚’ã€ŒMVCã«é©ç”¨ã•ã›
lalupin4 2010/06/07
ç”Ÿå³¶, å‹˜å¯Œ

RDB

SQL

ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ
ãƒªãƒ³ã‚¯
ãƒ™ãƒ³ãƒãƒ£ãƒ¼ç¤¾é•·ã§æŠ€è¡“è€…ã§ï¼šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ©ã‚¤ãƒ•
ç‚Žä¸Šã—ãŸã®ã§ã€è«–ç‚¹ã‚’æ•´ç†ã—ã¦ãŠãã€‚1ï¼Žæ¥å‹™ç³»ã§ã¯åŠ¹çŽ‡ãŒãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã§ããªã„å¿…è¦æ¡ä»¶æ¥å‹™ç³»ã®è·å‹™ã§ã¯ã€ã€ŒåŠ¹çŽ‡ã‚’æ±‚ã‚ã‚‹ã“ã¨ã€ãŒãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã—ã¦ã¯ã„ã‘ãªã„å¿…è¦æ¡ä»¶ã§ã™ï¼ˆååˆ†æ¡ä»¶ã§ã¯ãªã„ï¼‰ã€‚åŒ»è€…ã§ã„ã†ãªã‚‰ã°ã€...
lalupin4 2010/01/20
ç”Ÿå³¶, å‹˜å¯Œ

ã‚¸ãƒ¼ãƒ¯ãƒ³ã‚·ã‚¹ãƒ†ãƒ

SQL
ãƒªãƒ³ã‚¯
1