[B! tips][design] ymm1xã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ymm1x id:ymm1x

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (7)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

tipsã¨designã«é–¢ã™ã‚‹ymm1xã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

ãƒãƒƒãƒå‡¦ç†ã®æŽ¡ç”¨ã¨è¨è¨ˆã‚’è€ƒãˆã¦ã¿ã‚ˆã† | ãƒ¡ãƒ«ã‚«ãƒªã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ãƒ¡ãƒ«ãƒšã‚¤ã§ã€æ±ºæ¸ˆãƒ»æŒ¯è¾¼ç”³è«‹ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã—ã¦ã„ã‚‹ id:koemu ã§ã™ã€‚ ä»Šæ—¥ã¯ã€ãƒãƒƒãƒå‡¦ç†ã‚’è¡Œã†ç†ç”±ã«ã¤ã„ã¦ã€è€ƒå¯Ÿã‚’æ·±ã‚ã¦è¨è¨ˆã«æ´»ã‹ã—ã¦ã„ãè©±ã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ãƒãƒƒãƒå‡¦ç†ã¨ã¯ã€ã‚ã‚‹æ±ºã¾ã£ãŸã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§1ã¤ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒè¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚’ ä¸€æ‹¬å‡¦ç† ã™ã‚‹ã“ã¨ã‚’æŒ‡ã—ã¾ã™ã€‚ã“ã®åå¯¾ã®è¨€è‘‰ã¨ã—ã¦ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³å‡¦ç†ãŒã‚ã‚Šã¾ã™ã€‚ã‚ªãƒ³ãƒ©ã‚¤ãƒ³å‡¦ç†ã¨ã¯ã€ãŠå®¢æ§˜ã®æ“ä½œã‚’åˆã‚ã¨ã—ãŸã‚¤ãƒ™ãƒ³ãƒˆã‚’ã‚‚ã¨ã« é€æ¬¡å‡¦ç† ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚OLTP(Online Transaction Processing)ã¨ã‚‚è¨€ã„ã¾ã™ã€‚ æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ãƒãƒƒãƒå‡¦ç†ã‚’æŽ¡ç”¨ã™ã‚‹ã«ã‚ãŸã‚Šã€ã©ã†ã„ã£ãŸãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ãŒé©åˆ‡ãªã®ã‹ã‚’æ•´ç†ã—ã¦ã€ä»Šå¾Œã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®è¨è¨ˆã®æŒ‡é‡ã«ã§ãã‚‹ã“ã¨ã‚’ç›®æŒ‡ã—ã¦ã„ã¾ã™ã€‚ä»Šå›žã¯ã€ã€Œãƒãƒƒãƒå‡¦ç†ã‚’æŽ¡ç”¨ã™ã‚‹ã¨ãã€ã¨ã€Œãƒãƒƒãƒå‡¦ç†ã®è¨è¨ˆã€ã®2ã¤ã«ã¤ã„ã¦å–ã‚Šä¸Šã’ã¾ã™ã€‚ ãƒãƒƒãƒå‡¦ç†ã‚’æŽ¡ç”¨ã™ã‚‹
ymm1x 2019/02/27
batch

design

tips
ãƒªãƒ³ã‚¯
Webç³»ã®è‡ªåˆ†ãŒæƒ³åƒã¨éšœå®³ã§å¦ã‚“ã ãƒãƒƒãƒå‡¦ç†ãƒ»è¨è¨ˆã®åŸºæœ¬ - ã‚³ãƒ³ãƒãƒ„ã•ã‚“
ãƒãƒƒãƒå‡¦ç†ã¨ã„ã†ã®ã¯ãã‚Œå˜ä½“ã§å‹‰å¼·ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ãªã‹ãªã‹ä½•ã‚’å‹‰å¼·ã—ãŸã‚‰ã„ã„ã®ã‹ã‚ã‹ã‚‰ãªã„ã“ã¨ãŒå¤šã„ã€‚ ç‰¹ã«çµŒé¨“ãŒWebç³»ã°ã£ã‹ã‚Šã ã¨ã€ã„ã–ãƒãƒƒãƒå‡¦ç†ã‚’å®Ÿè£…ã—ã‚ˆã†ã¨ã—ãŸæ™‚ã«åŸºæœ¬çš„ãªãƒŽã‚¦ãƒã‚¦ã‚’çŸ¥ã‚‰ãªã„ã¾ã¾ã«æ›¸ã„ã¦ã—ã¾ã†ã“ã¨ãŒå¤šã„ã€‚ ãƒãƒƒãƒå‡¦ç†ã¨ã„ã†ã®ã¯å®Ÿæ…‹ã‚’æ•´ç†ã™ã‚‹ã¨ã€Œä½•ã‚‰ã‹ã®ãƒˆãƒªã‚¬ãƒ¼ã‚’æœŸã«èµ·å‹•ã—ã€ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ‰ãƒ»åŠ å·¥ãƒ»å¤‰æ›ãƒ»é›†è¨ˆã—ã¦ã‹ã‚‰ã€å‡ºåŠ›ã™ã‚‹ã€ã¨ã„ã†äº‹ã«ãªã‚‹ã€‚ ã¾ãã€INãŒã‚ã£ã¦å‡¦ç†ã—ã¦OUTãŒã‚ã‚‹ã¨ã„ã†ç‚¹ã§ã¯é–¢æ•°ã ã¨è€ƒãˆã¦ã‚‚ã„ã„ã ã‚ã†ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã®åˆ©ç”¨è€…(äººã«é™ã‚‰ãªã„)ã®ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ç›´æŽ¥é–¢ä¿‚ãªã„å‡¦ç†ã§ã‚ã£ãŸã‚Šã€åˆ©ç”¨è€…ã®ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚’ãƒˆãƒªã‚¬ãƒ¼ã¨ã—ã¦ã„ã¦ã‚‚ã€å³æ™‚ã«ãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒã„ã‚‰ãªã„orè¿”ã›ãªã„å ´åˆã« ãƒãƒƒãƒå‡¦ç†ã‚’é¸æŠžã™ã‚‹äº‹ãŒå¤šã„ã€‚ å®Ÿç¾æ–¹å¼ã¯ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€LLè¨€èªžã€å®Ÿè¡Œå¯èƒ½ãƒã‚¤ãƒŠãƒªã ã£ãŸã‚Šã™ã‚‹ã—ã€ãƒ‡ãƒ¼ãƒ¢ãƒ³ã¨ã—ã¦ç«‹ã¡ä¸Šã’ã‚‹å ´åˆã‚‚ã‚ã‚‹ã€‚ åˆ©ç”¨è€…ã®æ“ä½œã«å¯¾ã—ã¦å¯¾è©±çš„ãƒ»åŒæœŸçš„ãªå‡¦ç†ã¯ã‚ªãƒ³ãƒ©ã‚¤
ymm1x 2016/02/18
ãƒãƒƒãƒ

web

design
ãƒªãƒ³ã‚¯
MySQL ã®NULL ã§ã¯ã¾ã£ãŸã“ã¨ã‚ã‚Œã“ã‚Œ - LukeSilviaâ€™s diary
MySQL ã«é™ã‚‰ãšã€SQL ã®NULL ã®ä»•æ§˜ã«ã¯ä½•å›žã‹ã€Œãˆã£ã€ã¨é©šãã“ã¨ãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚5.1 ç‰ˆã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒãªã‹ã£ãŸã‚‚ã®ã«ã¤ã„ã¦ã¯ã€4.1 ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚NULL ã¯ä½•ã‚’æ„å‘³ã™ã‚‹ã‹ NULL ã¯æœªå®šç¾©ã¾ãŸã¯ã€ä¸æ˜Žã‚’æ„å‘³ã™ã‚‹ã€‚ã€Œé›»è©±ç•ªå·ã‚’æŒãŸãªã„ã€ã¨ã„ã†ã“ã¨ã‚’è¡¨ç¾ã™ã‚‹å ´åˆã¯ã€NULL ã§ã¯ãªãã€ç©ºã®æ–‡å—åˆ—ã‚’ä½¿ã†ã€‚ NULL å€¤ã¨ã„ã†ã‚‚ã®ã‚’ SQL åˆå¿ƒè€…ã¯ã‚ˆãæ··ä¹±ã—ã¾ã™ã€‚SQL åˆå¿ƒè€…ã¯ã€å¤šãã®å ´åˆã€NULL ãŒç©ºæ–‡å— "" ã¨åŒã˜ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã¯é•ã„ã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯å®Œå…¨ã«åˆ¥ã®ã‚‚ã®ã§ã™ã€‚ mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (""); ã©ã¡ã‚‰ã®ã‚¹
ymm1x 2015/05/13
mysql

db

design

tips
ãƒªãƒ³ã‚¯
Web APIã‚’ä½œã‚‹ã¨ãã«è€ƒãˆã‚‹ã“ã¨ã€‚ - ãƒ‘ãƒ«ã‚«ãƒ¯2
ã“ã®è¨˜äº‹ã¯Pepabo Advent Calendar 2014ã®11æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ å‰æ—¥ã¯ã€tnmtã•ã‚“ã®Vagrantã®shell provisionerã§Apacheã®ãƒ“ãƒ«ãƒ‰æ¸ˆtarãƒœãƒ¼ãƒ«ã‚’OSãƒãƒ¼ã‚¸ãƒ§ãƒ³æ¯Žã«ä½œã‚‹è¡“ã§ã—ãŸã€‚ ã¯ã˜ã‚ã« ä»Šå›žã¯ã€Web APIã‚’ä½œã‚‹ã¨ãã«è€ƒãˆã‚‹ã“ã¨ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ æœ¬å½“ã¯ã€ç¤¾å†…å‘ã‘ã«è³‡æ–™ã‚’ä½œã£ã¦ã„ã¦ã€ç¤¾å†…ã®å‹‰å¼·ä¼šã¨ã‹ã§è©±ã›ã‚Œã°ã„ã„ã‹ã€œã£ã¦è€ƒãˆã¦ã„ãŸã‚“ã§ã™ãŒã€ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®ãƒã‚¿ãŒæœ¬å½“ã«ãªãã¦å›°ã£ã¦ã„ãŸã®ã§ã“ã‚Œã‚’ä½¿ã„ã¾ã™ã€‚ å¯¾è±¡è€… APIã‚’ä½œã‚‹æ™‚ã€ã¨æ›¸ã„ã¦ã¾ã™ãŒã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã®äººã«ã¨ã£ã¦ã‚‚çŸ¥ã£ã¦ãŠãå¿…è¦ãŒã‚ã‚‹ã“ã¨ãªã®ã§ã€ã‚µãƒ¼ãƒå´ã®äººãƒ»ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã®äººä¸¡æ–¹ãŒå¯¾è±¡è€…ã§ã™ã€‚ APIã‚’ä½œã‚‹ã¨ãã«è€ƒãˆã‚‹ã“ã¨ ã€ŒAPIã‚’ä½œã‚‹ã¨ãã€ã¨è¨€ã£ã¦ã‚‚ã€è‰²ã‚“ãªçŠ¶æ³ãŒã‚ã‚Šã¾ã™ã€‚ ã¾ãšã¯ãã‚Œã‚’çµžã‚Šã¾ã™ã€‚ APIã®ç¨®é¡ž ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆAPI ã‚¢ãƒ—ãƒªã®APIãªã©ä½¿ã†äººãŒé™å®šã•ã‚Œ
ymm1x 2014/12/11
api

tips

design
ãƒªãƒ³ã‚¯
1