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

wiz7 id:wiz7

DBã«é–¢ã™ã‚‹wiz7ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é…ãã™ã‚‹ãŸã‚ã®ï¼˜ã¤ã®æ–¹æ³•
ã¯ã˜ã‚ã« Twitterã®ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã‚’è¦‹ã¦ã„ãŸã‚‰ãƒãƒƒãƒç³»ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§é€æ¬¡ã‚³ãƒŸãƒƒãƒˆã‚’ã‚„ã‚ã¦ä¸€æ‹¬ã‚³ãƒŸãƒƒãƒˆã«ã—ãŸã‚‰çˆ†é€Ÿã«ãªã£ãŸã¨ã„ã†ã®ã‚’è¦‹ã¾ã—ãŸã€‚å½“ãŸã‚Šå‰ã§ã—ã‚‡ã€ã¨æ€ã£ãŸã‘ã©ç¢ºã‹ã«çŸ¥ã‚‰ãªã‘ã‚Œã°åˆ†ã‹ã‚‰ãªã„ã‚ˆãã€ã¨æ€ã£ã¦ä¸»ã«åˆå¿ƒè€…å‘ã‘ã«RDBã‚’æ‰±ã†ã¨ãã®æ³¨æ„ç‚¹ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯çš„ãªã¨ã“ã‚ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆãã‚‰ã„ã®ç¯„ç–‡ã§DBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‹ã¯å…¥ã£ã¦ãªã„ã§ã™ã€‚ è‡ªåˆ†ã®çµŒé¨“çš„ã«Oracleã‚’ãƒ™ãƒ¼ã‚¹ã«æ›¸ã„ã¦ã„ã¾ã™ãŒã€ä»–ã®RDBã§ã‚‚ç‰¹ã«å¤‰ã‚ã‚‰ãªã„ãƒ¬ãƒ™ãƒ«ã®ç²’åº¦ã ã¨æ€ã„ã¾ã™ã€‚ å¤§é‡ã®é€æ¬¡ã‚³ãƒŸãƒƒãƒˆã‚’ã™ã‚‹ ãƒãƒƒãƒã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§DBã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã™ã‚‹ã¨è¨€ã†ã®ã¯ã‹ãªã‚Šä¸€èˆ¬çš„ãªå‡¦ç†ã§ã™ã€‚ã—ã‹ã—ãƒ‡ãƒ¼ã‚¿é‡ãŒå°‘ãªã„æ™‚ã¯ã¨ã‚‚ã‹ãå¤§é‡ã®ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã‚’é€æ¬¡ã‚³ãƒŸãƒƒãƒˆã§å‡¦ç†ã™ã‚‹ã¨ã‚ã¡ã‚ƒãã¡ã‚ƒé…ããªã‚Šã¾ã™ã€‚æ•°å€ã‹ã‚‰åæ•°å€é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã®ã§ã€10åˆ†ç¨‹åº¦ã®ãƒãƒƒãƒãŒï¼‘æ™‚é–“è¶Šãˆã«åŒ–ã‘ã‚‹ã“ã¨ã‚‚ã‚¶ãƒ©ã«ã‚ã‚‹ã®ã§åŽŸ
wiz7 2020/11/15
DB

æ€§èƒ½

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
SQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®è«–ç†çš„ãªå‡¦ç†é †åºã®ãŠè©± - Qiita
2020/9/30è¿½è¨˜ æœ¬è¨˜äº‹ã¯å…ƒã€…ã€ã€ŒSQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®å®Ÿè¡Œé †åºã®ãŠè©±ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§æŠ•ç¨¿ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ã—ã‹ã—ã€çŸ¥è¦‹ã®ã‚ã‚‹æ–¹ã‹ã‚‰ã®ã‚³ãƒ¡ãƒ³ãƒˆã¨è‡ªåˆ†ã§ã‚‚èª¿ã¹ã¦ã¿ãŸçµæžœã€ä»Šå›žç´¹ä»‹ã—ã¦ã„ã‚‹é †åºã¯ã‚ãã¾ã§è«–ç†çš„ãªå‡¦ç†é †åºã§ã‚ã‚Šã€å®Ÿè¡Œé †åºã¨ã¯åˆ¥ç‰©ã¨ã„ã†ã“ã¨ãŒã‚ã‹ã‚Šã¾ã—ãŸã€‚ èª¤ã£ãŸçŸ¥è˜ã‚’å¸ƒæ•™ã—ã¦ã—ã¾ã„ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ã€‚ 2020/9/30ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã€æœ¬è¨˜äº‹ã®ã‚¿ã‚¤ãƒˆãƒ«ã‚’ã€ŒSQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®è«–ç†çš„ãªå‡¦ç†é †åºã®ãŠè©±ã€ã«å¤‰æ›´ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ã¯ã˜ã‚ã« ã€ŒSQLã¨ã„ãˆã°ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæ‰±ã†ã‚¹ã‚ãƒ«ã€ã¨æ€ã‚ã‚ŒãŒã¡ã§ã™ãŒã€æœ€è¿‘ã¯ãƒžãƒ¼ã‚±ã‚¿ãƒ¼ã‚„å–¶æ¥ãªã©ã€éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã‚‚SQLã‚’ä½¿ã£ã¦ã€è‡ªã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—åˆ†æžã™ã‚‹æ–¹ãŒå¢—ãˆã¦ãã¦ã„ã¾ã™ã€‚ ã¾ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã§ã‚‚ã€ORMä»»ã›ã§ãªã‚“ã¨ãªãç†è§£ã—ã¦ã„ã‚‹çŠ¶æ…‹ã®æ–¹ã‚‚ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä»Šå›žã¯ã€ãã‚“ãªæ–¹ã€…ã«ã“ã
wiz7 2020/09/22
DB

SQL
ãƒªãƒ³ã‚¯
Webã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£æ¦‚è«– - ã‚†ã†ã†ããƒ–ãƒã‚°
å…ˆæœˆæŠ•ç¨¿ã—ãŸ2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å¦ã¶é“ã®ã‚Šã¨ä»£è¡¨çš„ãªå®Ÿè£…ãƒ¢ãƒ‡ãƒ«ã®æ¦‚è¦ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€å‰å›žåŒæ§˜ã€ä¸»ã«æ–°å’Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒé–“ã®æŽ¥ç¶šç®¡ç†ãƒ¢ãƒ‡ãƒ«ã¨é‹ç”¨äº‹æƒ…ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã‚„ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ä½•ãªã®ã‹ã€ãªãœå¿…è¦ãªã®ã‹ã¨ã„ã£ãŸã“ã¨ãŒä¸»ãªè©±é¡Œã§ã™ã€‚ èƒŒæ™¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã¨ã¯ãªã«ã‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–æ‰‹æ³• ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ãªã«ã‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ‰ãƒ©ã‚¤ãƒåž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ—ãƒã‚ã‚·åž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°å…¨ä½“ã«ã¤ã„ã¦ PostgreSQLã¨MySQL å‚è€ƒè³‡æ–™ ã¾ã¨ã‚ èƒŒæ™¯ 2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®è©±ã¨Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§
wiz7 2018/11/05
ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«å‘¨ã‚Šã€ä»–

DB
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902Read less
wiz7 2018/09/01
ã¤ã„æœ€è¿‘ä¸å…·åˆèµ·ã“ã—ãŸã‹ã‚‰ã‚ˆãã‚ã‹ã‚ã‚‹ã€‚çŠ¶æ…‹ã¨ã—ã¦ç®¡ç†ã™ã‚‹ã®ãŒã¾ãšã¯ç›´æ„Ÿçš„ã‹ãª

DB
ãƒªãƒ³ã‚¯
20æ™‚é–“ã§æº–å‚™ã™ã‚‹ã€å¿™ã—ã„äººã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆè©¦é¨“å¯¾ç– #æƒ…å ±å‡¦ç†è©¦é¨“ - log4ketancho
â€» 2019å¹´12æœˆã«æœ€æ–°æƒ…å ±ã«ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ã¾ã—ãŸã€‚ æœ€è¿‘ã€æƒ…å ±å‡¦ç†è©¦é¨“ï¼ˆé«˜åº¦è©¦é¨“ï¼‰ã®å¯¾ç–ã«ã¤ã„ã¦ãŠå®¢ã•ã‚“ã¨è©±ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ãªã‚“ã¨ãªãã‚„ã£ã¦ã„ãŸå‹‰å¼·æ–¹æ³•ã‚’è¨€èªžåŒ–ã§ãã€éžå¸¸ã«æ¥½ã—ã‹ã£ãŸã§ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€ãã®æ™‚ã«è©±ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆè©¦é¨“ã®æº–å‚™ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç§ã®å‹‰å¼·æ³•ã§ã™ãŒã€ å…ƒã€…ã€æ¥å‹™ãªã©ã§ãƒ™ãƒ¼ã‚¹ã¨ãªã‚‹çŸ¥è˜ãŒã‚ã‚‹ã‚“ã ã‘ã©ã€ ç›´å‰ï¼ˆ2é€±é–“ã€œ1ãƒ¶æœˆå‰ã‚ãŸã‚Šï¼‰ã¾ã§å‹‰å¼·ãŒã§ããªã‹ã£ãŸæ–¹ãŒã€ è©¦é¨“ã§ã—ã£ã‹ã‚Šå®ŸåŠ›ã‚’ç™ºæ®ã™ã‚‹ãŸã‚ã®æº–å‚™ã‚’20æ™‚é–“ã§è¡Œã„ã¤ã¤ã€ ã§ãã‚Œã°æ¥å‹™ã«ã‚‚ç¹‹ãŒã‚‹ã¨ã„ã„ãªãƒ¼ ã¨ã„ã†æ–¹æ³•ã«ãªã‚Šã¾ã™ã€‚ ã€Œä½•ã‚‚ã—ãªã„ã¾ã¾è©¦é¨“ã¾ã§ï¼‘ãƒ¶æœˆåˆ‡ã£ã¦ã‚‹ã€‚ã€‚ã€‚ã€ã¨ã„ã†ï¼ˆç§ã®ã‚ˆã†ãªï¼‰æ–¹ãŒã€20æ™‚é–“ã ã‘å‹‰å¼·ã™ã‚Œã°ã€è¶³åˆ‡ã‚Šã«ã‹ã‹ã‚‰ãšæ™®æ®µã®å®ŸåŠ›å‹è² ã«æŒã¡è¾¼ã‚ã‚‹ã¯ãšã€ã¨ã„ã†ã“ã¨ã‚’ã“ã®è¨˜äº‹ã§ç´¹ä»‹ã§ãã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ æƒ³å®šèªè€… SQLã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ã€ã‚ã‚‹ã„ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆçµŒé¨“
wiz7 2018/07/30
è³‡æ ¼

DB
ãƒªãƒ³ã‚¯
[MySQL][Python]8000ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’Insertã™ã‚‹ | Momentum
æ¦‚è¦ ãƒ»ã¨ã‚ã‚‹ç‰©ä»¶ã§8000ä¸‡å¼±ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ–°è¦ã®DBã«åŠ¹çŽ‡çš„ã«ã¶ã¡è¾¼ã‚€æ–¹æ³•ã‚’è€ƒãˆã‚‹å¿…è¦ã« ãƒ»MySQL(Amazon RDS) + Python(mysql.connector)ã‚’æƒ³å®š ãƒ»mysql.connector + pythonã«ã¤ã„ã¦ã¯æ‹™æ–‡ãªãŒã‚‰(http://nekopuni.holy.jp/?p=927)ã«æ›¸ã„ã¦ãŠã‚Šã¾ã™ã€‚ ãƒ»ã‚³ãƒŸãƒƒãƒˆã®ä½ç½®ã«ã¯æ°—ã‚’ã¤ã‘ã‚ˆã† + Multiple Insertæœ€å¼·ãã¨ã„ã†ãŠè©±ã€‚ æ–¹æ³•ãã®1 ã¾ãšã¯æœ€åˆã«ã‚„ã£ãŸæ–¹æ³•ã€‚1ãƒ¬ã‚³ãƒ¼ãƒ‰ã”ã¨ã«Insertã—ã¦ã‚³ãƒŸãƒƒãƒˆã—ã¦ã„ãæ–¹æ³•ã€‚ ä»Šã¾ã§DBé–¢é€£ã§ã‚„ã£ãŸã‚³ãƒ¼ãƒ‰ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰é‡ã‚‚å¤§ã—ãŸã“ã¨ãªã‹ã£ãŸã®ã§ä»¥ä¸‹ã®æ–¹æ³•ã§ã‚‚ç‰¹ã«å•é¡Œãªã‹ã£ãŸã€‚ å…·ä½“çš„ãªç’°å¢ƒã¨ã—ã¦ã¯ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿(csv)ã‚’èªã¿è¾¼ã¿ã€ãã‚Œã‚’DBã«Insertã—ã¦ã„ãã¨ã„ã†ã‚‚ã®ã€‚ csvã®ä¸èº«ã¯æ—¥ä»˜(DATE)ã¨ãƒ‡ãƒ¼ã‚¿å€¤(VALUE)ãŒã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã«ãªã£ã¦ã„
wiz7 2018/03/20
â€œMultiple Insertæœ€å¼·â€

DB
ãƒªãƒ³ã‚¯
Amazon Auroraã®å…ˆé€²æ€§ã‚’èª°ã‚‚è§£èª¬ã—ã¦ãã‚Œãªã„ã‹ã‚‰è§£èª¬ã™ã‚‹ - Qiita
TL;DR; Amazon Auroraã¯In-Memory DBã§ã‚‚ãªãDisk-Oriented DBã§ã‚‚ãªãã€In-KVS DBã¨ã§ã‚‚å‘¼ã¶ã¹ãæ–°åœ°å¹³ã«ç«‹ã£ã¦ã„ã‚‹ã€‚ ãã®æ–¬æ–°ã•ãŸã‚‹ã‚„ãƒžã‚¹ã‚¿ãƒ¼ã®ãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã§ã‚ã‚ŠãªãŒã‚‰Write-Backã§ã‚‚ãªãWrite-Throughã§ã‚‚ãªã„ã¨ã„ã†é©šå¤©å‹•åœ°ã€‚ ã¤ã„ã§ã«å¾“æ¥ã®ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆå‡¦ç†ã‚‚ä¸è¦ã«ãªã£ãŸã®ã§ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚‚å‘ä¸Šã—ãŸã€‚ è©³ç´°ãŒæ°—ã«ãªã‚‹äººã¯ã“ã®è¨˜äº‹ã‚’ãƒã‚§ã‚ï¼ Amazon Aurora Amazon Auroraã¯AWSã®ä¸ã§åˆ©ç”¨å¯èƒ½ãªãƒžãƒãƒ¼ã‚¸ãƒ‰(ï¼é‹ç”¨ã‚’AWSãŒé¢å€’è¦‹ã¦ãã‚Œã‚‹)ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã¯ãŸã ã®MySQLã€ã‚‚ã—ãã¯PostgreSQLã¨ã—ã¦æ‰±ã†äº‹ãŒã§ãã‚‹ã®ã§ãã‚Œã‚‰ã«ä¾å˜ã™ã‚‹æ—¢å˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è³‡ç”£ã‚’ãã®ã¾ã¾åˆ©ç”¨ã™ã‚‹äº‹ãŒã§ãã¦ã€è½ã¡ãŸã‚‰å†èµ·å‹•ã—ãŸã‚Šã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ‘ãƒƒãƒã‚’ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ãªã—ã§(!?)é©
wiz7 2017/12/13
ãŸã ã®åŠ¹çŽ‡ã®ã„ã„My sqlã‹ã¨æ€ã£ã¦ãŸã€å¾Œã§èªã‚€

DB
ãƒªãƒ³ã‚¯
Dockerã§ã‚µã‚¯ãƒƒã¨DBã‹ã‚‰ERå›³ã‚’ä½œæˆã™ã‚‹ - Qiita
SchemaSpyã¨ã„ã†DBã®ã‚¹ã‚ãƒ¼ãƒžã‚’è§£æžã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã‚„ERå›³ã‚’å‡ºåŠ›ã—ã¦ãã‚Œã‚‹ãƒ„ãƒ¼ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒ„ãƒ¼ãƒ«ã®å…¬å¼Dockerã‚¤ãƒ¡ãƒ¼ã‚¸ãŒå…¬é–‹ã•ã‚Œã¦ãŠã‚Šã€éžå¸¸ã«ä½¿ã„ã‚„ã™ã„ã®ã§ç´¹ä»‹ã•ã›ã¦é ‚ãã¾ã™ã€‚ https://hub.docker.com/r/schemaspy/schemaspy/ ã‚³ãƒžãƒ³ãƒ‰ docker run -v "$PWD/schema:/output" --net="host" schemaspy/schemaspy:snapshot \ -t <DBç¨®é¡ž> -host <DB ãƒ›ã‚¹ãƒˆå/IP>:<ãƒãƒ¼ãƒˆ> -db <DBå> -u <DBãƒ¦ãƒ¼ã‚¶ãƒ¼å> -p <DBãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰> ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®schemaãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«è§£æžçµæžœã®HTMLãŒå‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ ï¼ˆã‚³ãƒ³ãƒ†ãƒŠã¯è‡ªå‹•çš„ã«çµ‚äº†ã—ã¾ã™ï¼‰ docker run ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ -vã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§æŒ‡
wiz7 2017/07/30
DB

è¨è¨ˆ

ERD
ãƒªãƒ³ã‚¯
DBè«–ç†è¨è¨ˆã®ãƒŽã‚¦ãƒã‚¦ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? DBè¨è¨ˆã®æ¦‚è¦ã‚’ç°¡å˜ã«ãŠã•ã‚‰ã„ã—ãŸå¾Œã€è«–ç†è¨è¨ˆã«ã¤ã„ã¦ä¸»ã«ã¾ã¨ã‚ã¦ã„ãã¾ã™ã€‚ DBè¨è¨ˆã®å…¨ä½“æ‰‹é †ã®ãŠã•ã‚‰ã„ DBè¨è¨ˆã¯ã€å¤§ããè«–ç†è¨è¨ˆã¨ç‰©ç†è¨è¨ˆã«åˆ†ã‘ã‚‰ã‚Œã¾ã™ã€‚ è«–ç†è¨è¨ˆ æ¦‚å¿µã‚¹ã‚ãƒ¼ãƒžã‚’å®šç¾©ã—ã¾ã™ã€‚ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®æŠ½å‡º ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®å®šç¾© æ£è¦åŒ– ERå›³ã®ä½œæˆ ç‰©ç†è¨è¨ˆ è«–ç†è¨è¨ˆã®çµæžœã‚’å—ã‘ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ãŸã‚ã®ç‰©ç†çš„ãªé ˜åŸŸã‚„æ ¼ç´æ–¹æ³•ã‚’æ±ºã‚ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾© ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å®šç¾© ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ã‚µã‚¤ã‚¸ãƒ³ã‚° ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å†—é•·æ§‹æˆæ±ºå®š ãƒ•ã‚¡ã‚¤ãƒ«ã®ç‰©ç†é…ç½®æ±ºå®š ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹æˆè¦ç´ ã®ãŠã•ã‚‰ã„ è¡Œã¨åˆ— è¡Œ(ãƒ¬ã‚³ãƒ¼ãƒ‰)ï¼šæ¨ªã®ãƒ‡ãƒ¼ã‚¿ã®çµ„ åˆ—(ã‚«ãƒ©ãƒ
wiz7 2017/06/29
DB

ERD

è¨è¨ˆ
ãƒªãƒ³ã‚¯
Amazon DynamoDB Accelerator(DAX) â€“ Read heavyãªãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰å‘ã‘ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåž‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚¯ãƒ©ã‚¹ã‚¿ | Amazon Web Services
Amazon Web Services ãƒ–ãƒã‚° Amazon DynamoDB Accelerator(DAX) â€“ Read heavyãªãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰å‘ã‘ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåž‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚¯ãƒ©ã‚¹ã‚¿ æ—¢ã«Amazon DynamoDBã®äº‹ã¯ã”å˜çŸ¥ã®æ–¹ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ã”å˜ã˜ã®ã‚ˆã†ã«ã€å¿…è¦ãªã ã‘ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã€èªã¿è¾¼ã¿å®¹é‡ã€æ›¸ãè¾¼ã¿å®¹é‡ã«å¯¾å¿œã§ãã‚‹ã‚ˆã†ã«æ‹¡å¼µã•ã‚ŒãŸãƒ•ãƒ«ãƒžãƒãƒ¼ã‚¸ãƒ‰ã®NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚å¿œç”æ™‚é–“ã¯1æ¡ã®ãƒŸãƒªç§’å˜ä½ã§æ¸¬å®šã•ã‚Œã€å¤šãã®ãŠå®¢æ§˜ãŒadtechã€IoTã€ã‚²ãƒ¼ãƒ ã€ãƒ¡ãƒ‡ã‚£ã‚¢ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³å¦ç¿’ã€æ—…è¡Œã€é›»åå•†å–å¼•ã€é‡‘èžãªã©ã€ã•ã¾ã–ã¾ãªç¨®é¡žã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«DynamoDBã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ä¸€éƒ¨ã®ãŠå®¢æ§˜ã§ã¯ä¸€ã¤ã®DynamoDBãƒ†ãƒ¼ãƒ–ãƒ«ã«100TBä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ã€1ç§’å½“ãŸã‚Šä½•ç™¾ä¸‡ã‚‚ã®èªã¿å–ã‚Šã¾ãŸã¯æ›¸ãè¾¼ã¿è¦æ±‚ã‚’è¡Œã„ã¾ã™ã€‚ Amazonã®å°å£²ã‚µã‚¤ãƒˆã¯DynamoDBã«ä¾å˜ã—ã¦ãŠã‚Š
wiz7 2017/04/28
ã‚ã‚Œï¼ŸãŸã ã®Dynamoã£ã¦ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªåž‹ã˜ã‚ƒãªã‹ã£ãŸã®ã‹â€¦â€¦å‹˜é•ã„ã—ã¦ãŸã€‚DAXã®æ–™é‡‘ä½“ç³»ã¯ã©ã†ãªã£ã¦ã‚‹ã®ã‹ã€è¦ç¢ºèª

DB

ã‚¤ãƒ³ãƒ•ãƒ©
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«å‰Šé™¤ã¨å‰Šé™¤ã®å–ã‚Šæ¶ˆã— - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL å…¥é–€
DROP TABLEã€FLASHBACK TABLE ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã®å‰Šé™¤ã¨å¾©æ´» ã‚‚ã—ä½œæˆã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚’èª¤ã£ã¦ä½œæˆã—ãŸå ´åˆã‚„ä¸è¦ã«ãªã£ãŸå ´åˆã«ä»¥ä¸‹ã®ã¨ãŠã‚Šã«å®Ÿè¡Œã™ã‚‹ã€‚ USER_MASTER è¡¨ã‚’å‰Šé™¤ SQL*Plus ã«ã¦ä»¥ä¸‹ã® DDL æ–‡ã‚’å®Ÿè¡Œã€‚ DROP TABLE USER_MASTER CASCADE CONSTRAINTS ; ãªãŠ Oracle10g ã‹ã‚‰ã€Œã”ã¿ç®±ã€ã®æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œ DROP TABLE ï¼å–ã‚Šè¿”ã—ã®ã¤ã‹ãªã„å‰Šé™¤ã§ã¯ãªã„ã€‚(â€») å¾“æ¥é€šã‚Šã€ã”ã¿ç®±ã«å…¥ã‚Œãšå³åº§ã«å‰Šé™¤ã™ã‚‹å ´åˆã¯ PURGE å¥ã‚’ä»˜ã‘ã‚‹ DROP TABLE USER_MASTER CASCADE CONSTRAINTS PURGE ; (â€») ä½†ã— SYSTEM è¡¨é ˜åŸŸ ã«è¡¨ã‚’ä½œæˆã—ã¦ã„ãŸå ´åˆã«ã¯å³åº§ã«å‰Šé™¤ã•ã‚Œã‚‹ã®ã§ä¾‹å¤–ã€‚ï¼ˆOracle 10g æ™‚ç‚¹ï¼‰ è£œè¶³ï¼šSYS ã‚„SYSTEM ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‡ãƒ•ã‚©
wiz7 2016/09/02
DB
ãƒªãƒ³ã‚¯
ç’°å¢ƒæ§‹ç¯‰ä¸è¦ï¼åˆå¿ƒè€…ã§ã‚‚æ¥½ã—ãå…¥é–€ã§ãã‚‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å¦ç¿’ã‚µã‚¤ãƒˆã€paizaãƒ©ãƒ¼ãƒ‹ãƒ³ã‚°ã€‘
paizaãƒ©ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã—ãªãŒã‚‰ã‚¹ã‚ãƒ«ã‚¢ãƒƒãƒ—ã§ãã‚‹ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€å¦ç¿’ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã§ã™ã€‚
wiz7 2016/08/23
æ™®é€šã«é¢ç™½ãã†ã€‚æ–°äººã®é ƒã«ã“ã‚“ãªã®ãŒã‚ã‚Œã°ãªãâ€¦ã€‚éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®äººã«ã‚‚ã„ã„ã‹ã‚‚ã€‚

Webã‚µãƒ¼ãƒ“ã‚¹

DB
ãƒªãƒ³ã‚¯
OTN Japan - 404 Error
wiz7 2016/08/04
SQL Plusåˆ©ç”¨ã—ã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆã€ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ

é–‹ç™º

DB
ãƒªãƒ³ã‚¯
1