[B! DB] d4-1977ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

d4-1977 id:d4-1977

DBã«é–¢ã™ã‚‹d4-1977ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (42)

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

TypeORMã¯Node.jsé–‹ç™ºã®ã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã«ãªã‚‹ã‹ï¼Ÿ - Qiita
ã“ã‚“ã«ã¡ã¯GAOGAOã®ä»£è¡¨ã‚’ã—ã¦ãŠã‚Šã¾ã™ @tejitak ã§ã™ã€‚GAOGAOã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ 17æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚GAOGAOã®ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ã‚¹ã‚¿ã‚¸ã‚ªã«ã¦ã€æœ€è¿‘ãŠæ‰‹ä¼ã„ã—ã¦ã„ã‚‹æµ·å¤–ã®ãŠå®¢æ§˜æ¡ˆä»¶ã«ã¦TypeORMã‚’å°Žå…¥ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã®è¨˜äº‹ã§ã¯ã€TypeORMã¨ã¯ãªã‚“ãžã‚„ï¼Ÿã¨ã„ã†æ–¹ã‚’å¯¾è±¡ã¨ã—ã¦ã€ã¾ã æ¯”è¼ƒçš„æ—¥æœ¬èªžè¨˜äº‹ãŒå°‘ãªã„TypeORMã«ã¤ã„ã¦ã®ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Node.jsã®ORM Node.jsã§ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ã‚’å®Ÿè£…ã™ã‚‹éš›ã«ã¯Expressã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚Expressã¯ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ã®Webãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ORMã¯è‡ªç”±ã«å°Žå…¥ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»¥ä¸‹ä»£è¡¨çš„ãªORMã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ mongoose å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆï¼š https://mongoosejs.com/ Mongo DBã¯JavaScriptã¨ã®ç›¸æ€§ã®è‰¯ã•ã‹ã‚‰æ˜”ã‹ã‚‰Node.jsã®å¤šãã®ãƒ—
d4-1977 2021/03/28
ã‚ã¨ã§èªã‚€

TypeScript

DB
ãƒªãƒ³ã‚¯
DBã®å¯¿å‘½ã¯ã‚¢ãƒ—ãƒªã‚ˆã‚Šé•·ã„ï¼ é•·ç”Ÿãã™ã‚‹DBã«å¿…è¦ãªè¨è¨ˆã¨ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã‚’å®Ÿè·µã‹ã‚‰å¦ã¶ - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢Hubï½œè‹¥æ‰‹Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚ãƒ£ãƒªã‚¢ã‚’è€ƒãˆã‚‹ï¼
DBã®å¯¿å‘½ã¯ã‚¢ãƒ—ãƒªã‚ˆã‚Šé•·ã„ï¼Â é•·ç”Ÿãã™ã‚‹DBã«å¿…è¦ãªè¨è¨ˆã¨ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã‚’å®Ÿè·µã‹ã‚‰å¦ã¶ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¯¿å‘½ã‚ˆã‚Šã‚‚é•·ãã€ãƒ‡ãƒ¼ã‚¿ã®è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å¤‰æ›´ã§æˆé•·ã—ç¶šã‘ã‚‹ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨ã€ã©ã®ã‚ˆã†ã«ä»˜ãåˆã£ã¦ã„ã‘ã°ã‚ˆã„ã®ã§ã—ã‚‡ã†ã‹ï¼ŸÂ æ›½æ ¹å£®å¤§ï¼ˆsoudaiï¼‰ã•ã‚“ã«ã‚ˆã‚‹å¯„ç¨¿ã§ã™ã€‚ ã“ã‚“ã«ã¡ã¯ã€‚ããƒ¼ã ã„ï¼ˆ@soudai1025ï¼‰ã§ã™ã€‚ æ–°ã—ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’å§‹ã‚ã‚‹ã¨ãã€å¿…ãšã¨è¨€ã£ã¦ã„ã„ã»ã©ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ã¾ãŸä»Šç¨¼åƒã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®å¤šãã§ã‚‚ã€RDBMSã‚’ã¯ã˜ã‚ã€ã„ã‚ã„ã‚ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ãã‚“ãªã«åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã‹ã‚‰ã“ãã€å¤šãã®å•é¡Œã®å…ƒã«ãªã‚‹ã®ã‚‚ã¾ãŸäº‹å®Ÿã§ã™ã€‚ ãã“ã§ä»Šå›žã¯ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä¸å¿ƒã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é¸ã³æ–¹ã€è¨è¨ˆã«ã¤ã„ã¦ãŠè©±ã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ãã—ã¦ç§ã‚‚ã¾ã•ã«ä»Šã€2011å¹´ã‹ã‚‰ç¶šãWebã‚µãƒ¼ãƒ“ã‚¹ã€Œã‚ªãƒŸã‚«ãƒ¬ã€ã®RDBMSã®ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã«æºã‚
d4-1977 2019/10/05
ã‚ã¨ã§èªã‚€

è¨è¨ˆ

DB
ãƒªãƒ³ã‚¯
Row Level Securityã¯ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã®éŠ€ã®å¼¾ä¸¸ã«ãªã‚Šã†ã‚‹ã®ã‹ / Row Level Security is silver bullet for multitenancy?
builderscon 2019ã®ç™ºè¡¨è³‡æ–™ã§ã™
d4-1977 2019/09/02
ã—ã£ã‹ã‚Šæ¤œè¨¼ã•ã‚Œã¦ã„ã‚‹æ„Ÿã˜ãŒã™ã‚‹ï¼ˆãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã‚’ä½¿ã£ãŸäº‹ãŒãªã„ã®ã§ãƒãƒƒã‚ãƒªã¯ã‚ã‹ã‚‰ãªã„ã‘ã‚Œã©ðŸ’¦ï¼‰

PostgreSQL

DB

ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆ
ãƒªãƒ³ã‚¯
ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«(å…¥é–€ç·¨)
6. Step1 ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®æŠ½å‡º ç™ºé€æ‹…å½“è€…ãŒå—æ³¨ãƒªã‚¹ãƒˆã‚’ã‚‚ã¨ã«ã€å•†å“ã®åœ¨åº«ã‚’ç¢ºèªã—ã€åœ¨åº«ãŒ ã‚ã‚Œã°å•†å“ã‚’ç™ºé€ã™ã‚‹ã€‚ â‘ è¦æ±‚ä»•æ§˜ã®ã€Œå‹•è©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¡ â‘ ã«é–¢ã‚ã‚‹ã€Œåè©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¢ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£é–“ã®é–¢é€£ã«ç·šã‚’å¼•ã â‘£ å±žæ€§ã‚„å€™è£œã‚ãƒ¼ã‚‚åˆ†ã‹ã‚‹ç¯„å›²ã§æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é–“é•ã„ï¼ ã“ã®æ®µéšŽã§å®Ÿè£…ã‚’ãƒ—ãƒãƒ‘ãƒ†ã‚£ãƒ•ã‚¡ã‚¤ãƒ«ã«ã™ã‚‹ã¨ã‹ã€Enum ã«ã™ã‚‹ã¨ã‹æ±ºã‚æ‰“ã¡ã§ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã—ã¦è¡¨ã•ãªã„ã®ã¯ã‚„ ã‚ã¾ã—ã‚‡ã†ã€‚ ã¾ãšã€ã¯ã˜ã‚ã«ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’æŠ½å‡ºã—ã¾ã™ã€‚
d4-1977 2019/02/03
è¨è¨ˆ

DB

dbè¨è¨ˆ

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
JJUG CCC 2017 Springã§è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã‚’ã©ã†ã«ã‹ã™ã‚‹ãŸã‚ã®è©±ã‚’ã—ã¦ãã¾ã—ãŸ ã€FOLIOã‚¹ãƒãƒ³ã‚µãƒ¼ã€‘ - itohiro73â€™s blog
JJUG CCC 2017 Springã§ã€ã€Œãƒ‡ãƒ¼ã‚¿å±¥æ´ç®¡ç†ã®ãŸã‚ã®ãƒ†ãƒ³ãƒãƒ©ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨Reladomoã®ç´¹ä»‹ã€ã¨ã„ã†è©±ã‚’ã—ã¦ãã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿å±¥æ´ç®¡ç†ã®ãŸã‚ã®ãƒ†ãƒ³ãƒãƒ©ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¨Reladomoã®ç´¹ä»‹ #jjug_ccc #ccc_g3 from Hiroshi Ito ä»Šå›žã®ç™»å£‡ã¯ã€æ ªå¼ä¼šç¤¾FOLIOã®ã‚¹ãƒãƒ³ã‚µãƒ¼ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã™ï¼FOLIOã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã®å…¥ç¤¾ã‚¨ãƒ³ãƒˆãƒªãƒ¼è¨˜äº‹ã‚‚ã”å‚è€ƒãã ã•ã„ã€‚Toggetterã¯ä¸‹ã®ãƒªãƒ³ã‚¯ã‹ã‚‰ã€‚ togetter.com ä¸–ã®ä¸ã®ã¿ãªã•ã‚“ãŒã€Œè«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã€ã‚’ä½¿ã„ãŸããªã‚‹ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦ã¯ã€å®Ÿã¯ã€Œå‰Šé™¤ã€ã§ã¯ãªãåˆ¥ã®ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã‚’å®Ÿè£…ã—ãŸã„ã ã‘ã§ã‚ã‚‹ã“ã¨ãŒã»ã¨ã‚“ã©ã ã¨æ€ã„ã¾ã™ã€‚ ãŸã¨ãˆã°è«–ç†å‰Šé™¤ãƒ•ãƒ©ã‚°ã¨ã„ã†åã®æ»äº¡ãƒ•ãƒ©ã‚° - @ledsun blogã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’å‚è€ƒã«ã•ã›ã¦ã„ãŸã ãã¨ã€ä¸‹è¨˜ã®ã‚ˆã†ãªè¦ä»¶ã®ä¾‹ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ»ç¤¾å“¡ãŒé€€è·ï¼ˆãƒ»è»¢
d4-1977 2017/05/30
ã‚ã¨ã§èªã‚€

DB

é–‹ç™º
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã«ã¤ã„ã¦è©±ã‚’ã—ã¦ããŸ #OSO2017 - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
å²¡å±±ã«ã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚»ãƒŸãƒŠãƒ¼å²¡å±±ã¨è¨€ã†æœ€é«˜ã®ã‚¤ãƒ™ãƒ³ãƒˆãŒã‚ã‚Šã¾ã™ã€‚ okayama.open-seminar.org æ˜¨æ—¥ã¯ id:t-wada ã•ã‚“ã‚„ id:naoya ã•ã‚“ã®è³‡æ–™ãŒãƒ›ãƒƒãƒˆã‚¨ãƒ³ãƒˆãƒªãƒ¼å…¥ã‚Šã—ã¦ã¾ã—ãŸã€‚ ã“ã®ç™»å£‡ã¯ãã‚Œã¨åŒã˜ã‚¤ãƒ™ãƒ³ãƒˆã«ãªã‚Šã¾ã™ã€‚ ãã®ä»–ã®æ–¹ã‚‚è¶…è±ªè¯è¬›å¸«é™£ã®ä¸ã§ã€ç§ãŒå‡ºæ¥ã‚‹ç²¾ä¸€æ¯ã®çµŒé¨“ã‚‚è¸ã¾ãˆãŸãŠè©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ speakerdeck.com ã“ã®ä¸ã§å‡ºã¦æ¥ã‚‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã¯æœ¬å½“ã«ç´ æ™´ã‚‰ã—ã„æœ¬ã§ã™ã€‚ Oracleãƒ™ãƒ¼ã‚¹ãªã®ã§ã™ãŒMySQLã ã‚ã†ãŒPostgreSQLã ã‚ã†ãŒå¿…ãšãŸã‚ã«ãªã‚‹æœ¬ã§ã™ã€‚ ã§ã™ãŒã€ã“ã®æœ¬ã¯æ—¢ã«å»ƒåˆŠã«ãªã£ã¦ãŠã‚Šå†è²©ã®äºˆå®šã‚‚ã‚ã‚Šã¾ã›ã‚“â€¦ åƒ•ã¯å¾Œä¸–ã«çµ¶å¯¾å¿…è¦ãªæœ¬ã®ä¸€ã¤ã ã¨æ€ã£ã¦ã„ã‚‹ã®ã§å†è²©ã®ãŸã‚ã«ã‚‚çš†ã•ã‚“ã®è¦æœ›ã®å£°ã‚’ä¸Šã’ã¦ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ãã—ãŸã‚‰ã‚‚ã—ã‹ã—ãŸã‚‰æœ¬ãŒä¸–ã«å¾©æ´»ã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã¾ãŸSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿
d4-1977 2017/05/21
ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã‚’ã™ã‚‹æ™‚ãŒæ¥ã‚‹ã‚“ã ã‚ã†ã‹ï¼Ÿ

MySQL

SQL

DB
ãƒªãƒ³ã‚¯
æ–°å’å‘ã‘ç¤¾å†…ç ”ä¿®ã§ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã¨æ£è¦åŒ–ã®åŸºæœ¬ã®è©±ã‚’ã—ã¾ã—ãŸ - woshidan's blog
speakerdeck.com æ–°å’å‘ã‘ç¤¾å†…ç ”ä¿®ã§ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã¨æ£è¦åŒ–ã®åŸºæœ¬ã®è©±ã‚’ã—ã¾ã—ãŸã€‚ ç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQL (WEB+DB PRESS plus) ä½œè€…: å¥¥é‡Žå¹¹ä¹Ÿå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: æŠ€è¡“è©•è«–ç¤¾ç™ºå£²æ—¥: 2015/03/10ãƒ¡ãƒ‡ã‚£ã‚¢: å˜è¡Œæœ¬ï¼ˆã‚½ãƒ•ãƒˆã‚«ãƒãƒ¼ï¼‰ã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (17ä»¶) ã‚’è¦‹ã‚‹ ã„ã¾æ–°å’ã®æ–¹ã€…ã¯Rails tutorialã‚’é€²ã‚ãªãŒã‚‰ã€Œç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQLã€ã‚’èªã‚“ã§ã„ã‚‹ã¨ã“ã‚ãªã®ã§ã™ãŒã€ä¸ã«ã¯å…¥ç¤¾ä»¥å‰ã«ã¯Webç³»ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°çµŒé¨“ã®ãªã„æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ã€‚ ãã®çŠ¶æ…‹ã§ä¸Šè¨˜ã®æœ¬ã‚’èªã¿é€²ã‚ã‚‹ã®ã¯å°‘ã—ã¤ã‹ã¿ã«ãã„ã¨ã“ã‚ã‚‚ã‚ã‚‹ã ã‚ã†ãªã€ã¨ã„ã†ã“ã¨ã§ã€ã“ã®è³‡æ–™ã«é–¢ã—ã¦ã¯ã‹ãªã‚ŠåŸºæœ¬ã«çµžã‚Šã€æ¼”ç¿’ã§è¨è¨ˆã‹ã‚‰ç¬¬1ã‹ã‚‰ç¬¬3æ£è¦åŒ–ã®ä¸€é€£ã®ãƒ—ãƒã‚»ã‚¹ã«ã¤ã„ã¦æ‰‹ã‚’å‹•ã‹ã—ã¦ã¿ã¦
d4-1977 2017/04/15
æ–°å’ç ”ä¿®ã®å……å®Ÿæ„Ÿã‚’æ„Ÿã˜ã‚‹

ã‚ã¨ã§èªã‚€

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

æ£è¦åŒ–
ãƒªãƒ³ã‚¯
å„ç¨®DBã®Macç”¨GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ - komagataã®ãƒ–ãƒã‚°
å†…éƒ¨ãƒ„ãƒ¼ãƒ«ï¼ˆåƒ•ã‚‰ã§ã„ãˆã°256interns.comã¨ã‹ï¼‰ã¯ç®¡ç†ç”»é¢ä½œã‚‰ãšGUIã‚¢ãƒ—ãƒªã§å¤‰æ›´ã¨ã‹çµæ§‹ä¾¿åˆ©ã§ã™ã€‚ã¨ã¯ã„ãˆã€railsãªã©ã®ã‚¢ãƒ—ãƒªå´ã®ã¿ã§validationã—ã¦ã‚‹ã¨ä¸æ•´åˆãŒèµ·ãã‚‹ã®ã§è¦æ³¨æ„ã€‚ã“ã‚Œå‰æã§åˆ¶ç´„è¿½åŠ ã™ã‚‹ã®ã‚‚ã„ã„ã‹ã‚‚ï¼Ÿ Sequel Pro MySQLã®GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚ã“ã‚Œã‚’æ•™ãˆã¦ã‚‚ã‚‰ã£ã¦è¨ã—ã’ã«ä½¿ã£ã¦ã¿ãŸã‚“ã§ã™ãŒã€ä»Šé¢¨ã®Macã®ä½¿ã„å‹æ‰‹ã§ä½¿ãˆã‚‹ã®ãŒã™ã”ãæ°—ã«å…¥ã£ã¡ã‚ƒã„ã¾ã—ãŸã€‚ SSLçµŒç”±ã‚„sshã§å…¥ã£ãŸã‚µãƒ¼ãƒãƒ¼è¸ã¿å°ã«ã—ã¦ã®æŽ¥ç¶šã‚‚ä¸€ç™ºã§ãã¦ä¾¿åˆ©ã€‚ PG Commander PostgreSQLã®GUIã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚Sequel Proã«æ¯”ã¹ã‚‹ã¨ä½¿ã„å‹æ‰‹ã¯è‰¯ããªã„ã‘ã©ã€Herokuã®DBã«æŽ¥ç¶šã§ãã‚‹ï¼ã“ã‚ŒãŒãƒ‡ã‚«ã‚¤ã€‚ æŽ¥ç¶šå…ˆã®ãƒ–ã‚¯ãƒžã‚’ï¼•å€‹ä»¥ä¸Šä¿å˜ã—ã¦ãŠãã«ã¯Lisenceã‚’è²·ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚Herokuã‚’å¤šç”¨ã™ã‚‹ã‹ã‚‰ï¼•å€‹ã‚ã£ã¨ã„ã†é–“ã«è¶…ãˆã¡ã‚ƒã†ã®ã§è²·ã„ã¾ã—ãŸã€‚ B
d4-1977 2014/05/02
MacOS X

DB
ãƒªãƒ³ã‚¯
DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å‹‰å¼·ä¼šã«å‚åŠ ã—ã¦ SQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¯å¿…èªã ã¨ç¢ºä¿¡ã—ãŸã®ã§èªã‚€ã“ã¨ã«æ±ºã‚ãŸï¼ #dcampjp #sqlap - #garagekidztweetz
ãƒ„ã‚¤ãƒ¼ãƒˆ@nippondanji ãªå¸«åŒ ãŒç‰¹åˆ¥å¯„ç¨¿ã—ãŸã¨ã„ã†è¨˜äº‹ã‚’èªã‚“ã§ã„ã¦æœ¬ã®å˜åœ¨ã¯çŸ¥ã‚Šã¤ã¤ã€å…ˆæ—¥ã® devsumi ã§ã¯æº€å¸ã®ãŸã‚è´è¬›ã§ããªã‹ã£ãŸ SQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³æœ¬ã®è©±ã‚’ç›´æŽ¥èžã‘ã‚‹æ©Ÿä¼šã‚’ã‚‚ã‚‰ãˆã‚‹ã¨ã„ã†ã“ã¨ã§ã€å–œã³å‹‡ã‚“ã§å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚ è£ã§ã‚„ã£ã¦ã„ãŸ #awssummit Day2 ã¨ã‚®ãƒªã‚®ãƒªã¾ã§å¤©ç§¤ã«ã‹ã‘ã¦ã„ãŸã®ã§ã™ãŒã€ã‚ã¾ã‚Šã«ã‚‚#awssummit ã® Day1 ã®å°è±¡ãŒæ‚ªã‹ã£ãŸã®ã§ã€ã“ã¡ã‚‰ã«å‚åŠ ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã©ã†ã§ã‚‚ã„ã„ã“ã¨ã§ã™ãŒ å¯Œå£«ã‚½ãƒ•ãƒˆã‚¢ã‚ãƒãƒ“ãƒ« 1F ã®æ¡ˆå†…ãŒ ã€ŒPB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å‹‰å¼·ä¼šã€ã«ãªã£ã¦ã„ãŸwã•ã¦ã€æœ¬å‹‰å¼·ä¼šã®æ¦‚è¦ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã€ é–‹å‚¬æ¦‚è¦ï¼š DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®æŠ€è¡“å‹‰å¼·ä¼š ä¸»å‚¬ï¼š ã‚¨ãƒ³ãƒã‚«ãƒ‡ãƒãƒ»ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚º æ—¥ç¨‹ï¼š 2013å¹´6æœˆ6æ—¥ï¼ˆæœ¨ï¼‰ã€€13:30ã€œ16:15 ï¼ˆ13:15 å—ä»˜é–‹å§‹ï¼‰ ä¼šå ´ï¼š å¯Œå£«ã‚½ãƒ•ãƒˆã€€ã‚¢ã‚ãƒãƒ—ãƒ©ã‚¶ã€€6éšŽ ã‚»
d4-1977 2013/06/11
SQL

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

æ›¸ç±

å‹‰å¼·ä¼š

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã‚¸ãƒ§ãƒ¼ãƒ»ã‚»ãƒ«ã‚³ã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬4ç‰ˆã€ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
çš†ã•ã‚“ã€ãŠä¹…ã—ã¶ã‚Šã§ã™ã€‚é•·ã‚‰ããƒ–ãƒã‚°ã®æ›´æ–°ãŒæ¢ã¾ã£ã¦ã„ãŸã®ã¯ã€å°‘ã—å¤§ããªä»•äº‹ã‚’ã—ã¦ã„ãŸãŸã‚ã§ã™ã€‚ã‚¸ãƒ§ãƒ¼ãƒ»ã‚»ãƒ«ã‚³ã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬4ç‰ˆã€ã®ç¿»è¨³ã€‚ã“ã‚Œã«é›†ä¸ã™ã‚‹ãŸã‚ã€ãƒ–ãƒã‚°ã‚‚ã‚„ã‚‰ãšTwitterã‚‚ã‚„ã‚‰ãšï¼ˆã“ã£ã¡ã¯ã¡ã‚‡ã£ã¨ã‚„ã£ã¦ã—ã¾ã£ãŸï¼‰é ‘å¼µã£ã¦ãŠã‚Šã¾ã—ãŸã€‚ é•·ã‹ã£ãŸã€‚ æœ¬å½“ã«é•·ã‹ã£ãŸã€‚ åŽŸè‘—ãŒ800ãƒšãƒ¼ã‚¸ä»¥ä¸Šã‚ã‚‹ã†ãˆå†…å®¹ã‚‚ç°¡å˜ã§ã¯ãªã„ã®ã§ã€ã‚‚ã¨ã‚‚ã¨æ¥½ãªä»•äº‹ã¨ã¯æ€ã£ã¦ã„ã¾ã›ã‚“ã§ã—ãŸãŒã€ã„ã‚„å¤§å¤‰ã§ã—ãŸã€‚ã§ã™ãŒç„¡äº‹ä»ŠæœˆåˆŠè¡Œã¨ã‚ã„ãªã‚Šã¾ã—ãŸã€‚ã™ã§ã«Amazonã¯ã˜ã‚ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚·ãƒ§ãƒƒãƒ—ã§ã‚‚äºˆç´„å—ä»˜ã‚’é–‹å§‹ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚‰ã‹ã˜ã‚è¨€ã£ã¦ãŠãã¾ã™ãŒã€Œè¡¨ç´™ã®ãŠã£ã•ã‚“èª°ï¼Ÿã€ã¨ã„ã†è³ªå•ã¯ç§ã«ã¯ã—ãªã„ã‚ˆã†ã«ã€‚ç§ã‚‚ç”ãˆã‚‰ã‚Œãªã„ã®ã§ï¼ˆç¬‘ï¼‰ã€‚ ã•ã¦ã€æœ¬æ›¸ã®å†…å®¹ã‚’ç´¹ä»‹ã™ã‚‹ä»£ã‚ã‚Šã«ã€å°‘ã—é•·ããªã‚Šã¾ã™ãŒè¨³è€…å‰æ›¸ãã‚’å¼•ç”¨ã—ã¾ã™ã€‚è³¼å…¥ã™ã‚‹ã‹åˆ¤æ–ã®å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ãªãŠã€å®Ÿè¡Œç’°å¢ƒã¨ã—ã¦ã¯å‰æ›¸ãã§ã‚‚æ›¸ã„ã¦ã„ã¾ã™
d4-1977 2013/05/19
é–‹ç™º

SQL

æ›¸ç±

db
ãƒªãƒ³ã‚¯
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã€ŒNoSQLä¸‡æ³ã€ã¨è¨€ã†å‰ã«ã€ŒWebã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã® ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“[å®Ÿè·µ]å…¥é–€ã€ã‚’èªã‚€ã¹ã (çŒ®æœ¬å¾¡ç¤¼)
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã€ŒNoSQLä¸‡æ³ã€ã¨è¨€ã†å‰ã«ã€ŒWebã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã® ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“[å®Ÿè·µ]å…¥é–€ã€ã‚’èªã‚€ã¹ã (çŒ®æœ¬å¾¡ç¤¼) ã—ã‚‡ã£ã±ãªã‹ã‚‰è©±ãŒãšã‚Œã¾ã™ãŒã€æœ€è¿‘ã€Œ[ç¿»è¨³]MVCã¯æ»ã‚“ã ã€‚MOVEã™ã‚‹ã¨ããŒããŸ - ãã—ã ã®ã¯ã¦ãªã€ã¨ã„ã†è¨˜äº‹ãŒè©±é¡Œã«ãªã£ã¦ã„ã¾ã™ã€‚ä¸€æ–¹ã§ã€ã“ã®è¨˜äº‹ã«å¯¾ã—ã¦ã¯ã€ MVCã¸ã®ä¸é©åˆ‡ãªç†è§£ã‹ã‚‰å°Žãå‡ºã•ã‚ŒãŸãšã‚ŒãŸèªè˜ã«è¦‹ãˆã¾ã™ã€‚MVCã‚’å¦å®šã™ã‚‹ç†ç”±ã«ã¯ã¨ã¦ã‚‚ã‚ãŸã‚‰ãªã„ã©ã“ã‚ã‹ã€ã“ã®äººãŒå¦ã‚“ã MVCã¯MVCã§ã¯ãªãã€MVCãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ä½¿ã„æ–¹ã§ã‚ã£ãŸäº‹ãŒã‚ˆãè§£ã‚‹ MOVEã¯æœ›ã¾ã‚Œãªã‹ã£ãŸå - the sea of fertility ã¨ã„ã£ãŸæ‰¹åˆ¤ã‚‚ãªã•ã‚Œã¦ã„ã¾ã™ã€‚ åƒ•ã¯ã€çµæžœã¨ã—ã¦ã„ã„ã‚‚ã®ãŒä½œã‚‰ã‚Œã‚‹ãªã‚‰ç„¡çŸ¥ã§ã‚‚ã„ã„ã˜ã‚ƒãªã„ã€ã¨æ€ã†ã®ã§ã™ãŒã€ã¾ã‚ã“ã®ã‚ˆã†ãªçŸ¥è˜ä¸è¶³ã«ã‚ˆã‚‹èª¤è§£ã¨ã„ã†ã®ã¯è‰¯ãã‚ã‚‹ã“ã¨ã§ã™ã€‚ å®Ÿéš›ã€ã€ŒRDBMSã¯æ»ã‚“ã ã€‚NoSQLã®æ™‚ä»£ãŒããŸã€ã¨ä¸»å¼µã™ã‚‹äººã«è€³
d4-1977 2012/07/05
æ›¸ç±

é–‹ç™º

ã‚ã¨ã§èªã‚€

DB
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
d4-1977 2009/09/17
é–‹ç™ºãƒ„ãƒ¼ãƒ«

DB

windows

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ
ãƒªãƒ³ã‚¯
æ–°åˆŠã€Œã“ã‚Œã ã‘ã¯çŸ¥ã£ã¦ãŠããŸã„ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¸¸è˜ã€ç™ºå£²
2024å¹´2æœˆ1æ—¥ æ‹™ä½œãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®è²æ¸¡ã«ã¤ã„ã¦ æ‹™ä½œã®Movable Typeã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’ã€æ ªå¼ä¼šç¤¾ãƒ¯ãƒ¼ãƒ«ãƒ‰ã‚¤ã‚ºãƒžã‚¤ãƒ³ã«è²æ¸¡ã„ãŸã—ã¾ã—ãŸã€‚ é•·ãã«ã‚ãŸã‚Šæ‹™ä½œã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’ã”æ„›é¡§ã„ãŸã ãã€ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ æ‹™è‘—æ–°åˆŠã®ã€Œã“ã‚Œã ã‘ã¯çŸ¥ã£ã¦ãŠããŸã„ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¸¸è˜ã€ãŒç™ºå£²ã«ãªã‚Šã¾ã—ãŸã€‚ æŠ€è¡“è©•è«–ç¤¾åˆŠã§ã€å®šä¾¡2,079å††ï¼ˆæ¶ˆè²»ç¨Žè¾¼ï¼‰ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºç¤Žã¨ãªã‚‹æ¦‚å¿µã‹ã‚‰ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è€ƒãˆæ–¹ã€SQLã®åŸºæœ¬çš„ãªæ›¸ãæ–¹ãªã©ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã‹ã‹ã‚ã‚‹ã“ã¨ãŒã‚ã‚‹æ–¹ãªã‚‰çŸ¥ã£ã¦ãŠãã¹ãäº‹æŸ„ã‚’è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªæ–¹ã«ãœã²ãŠå‹§ã‚ã—ãŸã„ã§ã™ã€‚ ITé–¢ä¿‚ã®å¦æ ¡ç‰ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦å¦ã¶å¦ç”Ÿã®æ–¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çŸ¥è˜ã‚’å•ã‚ã‚Œã‚‹ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ç³»è³‡æ ¼ã«ãƒãƒ£ãƒ¬ãƒ³ã‚¸ã•ã‚Œã¦ã„ã‚‹æ–¹ CMSç‰ã‚’å°Žå…¥ã—ã¦ã€ã‚ã‚‹ç¨‹åº¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦çŸ¥è˜ãŒå¿…è¦ã«ãªã£ãŸWebãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ç‰ã®æ–¹ æœ¬ã®ç›®æ¬¡ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™
d4-1977 2009/07/02
æ¬²ã—ã„ã‹ã‚‚

æ›¸ç±

DB
ãƒªãƒ³ã‚¯
çœ ã‚‹é–‹ç™ºå±‹blogï½œæœ€æ–°ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚«ã‚¸ãƒŽã®ãƒ‹ãƒ¥ãƒ¼ã‚«ã‚¸ãƒŽæƒ…å ±
ã‚‚ã—ã‚‚ã“ã®ä¸–ã‹ã‚‰ã€Œæ®‹æ¥ã€ãŒå®Œå…¨ã«ãªããªã£ãŸã‚‰ ï¼“å¹´ãã‚‰ã„å‰ã«èªã‚“ã æœ¬ã‚’æ€ã„å‡ºã—ãŸã€‚ ï¼‘ï¼™ï¼˜ï¼âˆ’ï¼™ï¼å¹´ä»£ã®è©±ã§ã™ãŒã€æ®‹æ¥ã«ã¤ã„ã¦ã€ ã€Œæ™‚é–“å¤–ãƒ»ä¼‘æ—¥åŠ´åƒã®å¼¾åŠ›çš„é‹ç”¨ãŒæˆ‘ãŒå›½ã®åŠ´ä½¿æ…£è¡Œã®ä¸‹ã§é›‡ç”¨ç¶æŒã®æ©Ÿèƒ½ã‚’ã¯ãŸã—ã¦ã„ã‚‹ã€ï¼ˆï¼‘ï¼™ï¼˜ï¼•å¹´åŠ´åƒåŸºæº–æ³•ç ”ç©¶ä¼šå ±å‘Šï¼‰ã¨ã‹ã€ã€Œæˆ‘ãŒå›½ã®åŠ´åƒæ…£è¡Œã®å®Ÿæƒ…ã«åˆã†ã‚ˆã†ãªä¸Šé™è¨å®šãŒå¯èƒ½ã‹ã©ã†ã‹å®šã‹ã§ãªã„ã€ï¼ˆï¼‘ï¼™ï¼™ï¼’å¹´åŒå ±å‘Šï¼‰ã¨ã€é›‡ç”¨ç¶æŒã®ç‚ºã®ã‚³ã‚¹ãƒˆã¨ã—ã¦æ’å¸¸çš„ãªé•·æ™‚é–“åŠ´åƒã‚’æ˜¯èªã™ã‚‹è€ƒãˆæ–¹ãŒä¸»æµã§ã—ãŸã€‚ éœ€è¦ã®ä½Žä¸‹ã«å¿œã˜ã¦ã€ç”Ÿç”£æ°´æº–ã‚’ä¸‹ã’ãªãã¦ã¯ãªã‚‰ãªããªã£ã¦ã‚‚ã€ãƒãƒƒãƒ•ã‚¡ãŒã‚ã‚‹ã‹ã‚‰è§£é›‡ã›ãšã«å¤§ä¸ˆå¤«ã§ã—ã‚‡ã€ã¨ã„ã†ã€‚ã€‚ã€‚ ã¾ãã€ ã¨ã“ã‚ãŒã€ãã®å¾Œã€åŠ´åƒæ³•æ”¿ç–ãŒå†…éƒ¨åŠ´åƒå¸‚å ´ã®é›‡ç”¨ç¶æŒã‹ã‚‰å¤–éƒ¨åŠ´åƒå¸‚å ´ã«ãŠã‘ã‚‹ç§»å‹•ä¿ƒé€²ã«å¾ã€…ã«ã‚·ãƒ•ãƒˆã—ã¦ã„ã£ãŸã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€ã“ã®é•·æ™‚é–“åŠ´åƒå“²å¦ã«ã¯ç–‘å•ãŒå‘ˆã•ã‚Œãªã„ã¾ã¾ï¼’ï¼‘ä¸–ç´€ã«è‡³ã£ã¦ã„ã‚‹ã®ã§ã™ã€‚ ã¨è‘—è€…ã¯å•é¡Œè¦–ã—ã¦ã„ã‚‹ã‚ã‘ã ã‘ã©ã€‚ è©±å¤‰ã‚ã£ã¦ã€æœ€è¿‘å‹äºº
d4-1977 2009/02/14
DB

é–‹ç™º

MySQL
ãƒªãƒ³ã‚¯
å˜ä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ç¶™æ‰¿ (Single Table Inheritance) ã®ä¸Šæ‰‹ãªæ‰±ã„æ–¹
Railsã®å˜ä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ç¶™æ‰¿ (Single Table Inheritance) ã‚’ä½¿ã†ã¨ã€ActiveRecordã§ã¯typeã‚«ãƒ©ãƒ ãŒnilã§ãªã„ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ã‚¯ãƒ©ã‚¹ã¯typeã‚’å…ƒã«åˆ¤å®šã•ã‚Œã¾ã™ã€‚ å˜ä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ç¶™æ‰¿ (Single Table Inheritance) ã‚’ä½¿ã†ã«ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ™‚ã«typeã¨ã„ã†ã‚«ãƒ©ãƒ ã‚’å®šç¾©ã—ã¾ã™ã€‚ PLAIN TEXT LANG : RUBY class CreatePeople <ActiveRecord::Migration def self.up create_table :people do |t| t.column :name, :string : t.column :type, :string end end def self.down drop_table :people end end ã“ã“ã§peopleãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾å¿œã—ãŸPerson
d4-1977 2008/06/16
Ruby on Rails

DB
ãƒªãƒ³ã‚¯
ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ç ”ä¿®è¨˜ Â» E-Rå›³#2ãƒ›ãƒ†ãƒ«ã®äºˆç´„ã‚·ã‚¹ãƒ†ãƒ ã®å•é¡Œ
ichikawaã§ã™ã€‚ç§ã¯å‰å›žã®æŽˆæ¥ã‹ã‚‰è¦‹ã¦ãŠãã‚‰ãæ–°å’ã®ä¸ã§ä¸€ç•ªE-Rå›³ãŒè‹¦æ‰‹ãªã®ã§ã™ãŒã€E-Rå›³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ æœ¬æ—¥ã¯ã€å‰å›žåŒæ§˜ã«å‡ºé¡Œã•ã‚ŒãŸå•é¡Œã‚’E-Rå›³ã§æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ ã¾ãšã¯å•é¡Œå†…å®¹ã§ã™ã€‚ â– ãƒ“ã‚¸ãƒã‚¹ãƒ›ãƒ†ãƒ«ã®äºˆç´„ã€åˆ©ç”¨ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ webã‹ã‚‰éƒ¨å±‹ã®äºˆç´„ãŒã§ãã‚‹ã€‚ äºˆç´„ã¯ï¼‘ãƒ¶æœˆå‰ã‹ã‚‰è¡Œãˆã‚‹ã€‚ ç©ºãéƒ¨å±‹ã®æ•°ãŒãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§ç¢ºèªã§ãã‚‹ã€‚ éƒ¨å±‹ã«ã¯ã‚·ãƒ³ã‚°ãƒ«ã¨ãƒ€ãƒ–ãƒ«ã€ãƒ„ã‚¤ãƒ³ã®ï¼“ç¨®é¡žãŒã‚ã‚‹ ã‚·ãƒ³ã‚°ãƒ«ã«ã¯ç¦ç…™å®¤ã¨å–«ç…™å®¤ãŒã‚ã‚‹ã€‚ ã‚ªãƒ³ã‚·ãƒ¼ã‚ºãƒ³ã€ãƒŸãƒ‰ãƒ«ã‚·ãƒ¼ã‚ºãƒ³ã€ã‚ªãƒ•ã‚·ãƒ¼ã‚ºãƒ³ã§æ–™é‡‘ãŒç•°ãªã‚‹ã€‚ ã‚ªãƒ³ã€ãƒŸãƒ‰ãƒ«ã€ã‚ªãƒ•ã®è¨å®šã¯ï¼“ãƒ¶æœˆå‰ã¾ã§ã«è¡Œã†ã€‚ ä¼šå“¡ã®å ´åˆã¯ï¼‘ï¼æ—¥æ³Šã¾ã‚‹ã”ã¨ã«å‰²å¼•ã‚’è¡Œã†ï¼ˆé€£æ³Šã‚‚ã‚«ã‚¦ãƒ³ãƒˆã™ã‚‹ï¼‰ã€‚ ä¼šå“¡ã ã‘ã§ãªãéžä¼šå“¡ã‚‚äºˆç´„ã§ãã‚‹ã€‚ éžä¼šå“¡ã®å ´åˆã¯ï¼‘ï¼é€£æ³Šã—ã¦ã‚‚å‰²å¼•ã«ã¯ãªã‚‰ãªã„ã€‚ éžä¼šå“¡ã®åˆ©ç”¨å±¥æ´ã¯ã¨ã‚‰ãªã„ãŒã€æ°åã€é€£çµ¡å…ˆãªã©ã®æƒ…å ±å…¥åŠ›ã¯è¡Œã†ã€‚ ï¼’ï¼”æ™‚ã‚’éŽãŽã¦ã‹ã‚‰ã®å½“æ—¥äºˆç´„ï¼ˆæ³Šã¾ã‚‹ç›´å‰ã®äºˆ
d4-1977 2008/05/21
DB

ERå›³
ãƒªãƒ³ã‚¯
ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ç ”ä¿®è¨˜ Â» E-R å›³#3ãƒ›ãƒ†ãƒ«äºˆç´„ã‚·ã‚¹ãƒ†ãƒ ã€è§£ç”ä¾‹
æ˜¨æ—¥ã«ã²ãã¤ã¥ãE-Rå›³å¸‚å·ã§ã™ã€‚E-Rå›³ã®è§£ç”ä¾‹ãŒä¸Žãˆã‚‰ã‚Œã€ãã‚Œã‚’å…ƒã«ãƒŽãƒ¼ãƒˆã«æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ å‰å›žã®ã—ã£ã±ã„ä¾‹ã¨æ¯”ã¹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã“ã‚ŒãŒæ˜¨æ—¥æ›¸ã„ãŸE-Rå›³ã§ã™ã€‚ ç”»åƒï¼šå¤±æ•—ä¾‹ ä»Šæ—¥æ›¸ã„ãŸã®ã¯ã“ã¡ã‚‰ã§ã™ã€‚ ç”»åƒï¼šä¿®æ£ç‰ˆ ã‚ˆã‚Šã”ã¡ã‚ƒã”ã¡ã‚ƒã—ãŸã‚ˆã†ã«è¦‹ãˆã¾ã™ãŒã€è€ƒãˆã¦ã¿ã‚Œã°æ˜¨æ—¥æ›¸ã„ãŸE-Rå›³ã¯æƒ…å ±ãŒå°‘ãªã™ãŽã¾ã—ãŸã€‚ entityå†…ã§æŒãŸã›ãŸæƒ…å ±ãŒå…±æœ‰ã•ã‚Œã¦ãŠã‚‰ãšã€ã“ã‚Œã§ã¯ã‚ˆã‚Šç´°ã‹ãªæƒ…å ±ãŒä¼ã‚ã£ã¦ã„ã¾ã›ã‚“ã€‚ ã“ã‚Œã ã‘ã®å•é¡Œæ–‡ã®ã‚ˆã†ã«è¦‹ãˆã¾ã™ãŒã€æŠ½å‡ºã™ã¹ãé …ç›®ã¯ãŸãã•ã‚“ã‚ã‚Šã¾ã™ã€‚ ä¿®æ£ç‰ˆã§ã¯ã²ã¨ã¤ã²ã¨ã¤ã®entityã®å±žæ€§ã«IDã¨ç§°ã—ã¦æƒ…å ±ã‚’æŒãŸã›ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€ç¢ºã‹ã§ã‚ã‚‹ï¼ˆç‰¹å®šã§ãã‚‹ï¼‰ã‚‚ã®ã¨ã—ã¦è¦‹ã‚„ã™ã„ãŸã‚ã€ã»ã‹ã®entityã¨æƒ…å ±ã‚’å…±æœ‰ã—ã¦ã„ã‚‹ã“ã¨ã‚‚ç†è§£ã—ã‚„ã™ããªã£ã¦ã„ã¾ã™ã€‚ ã¾ãŸä¿®æ£ç‰ˆå³ä¸Šã®ã€Œå®¢å®¤æ–™é‡‘ãƒžã‚¹ã‚¿ã€ã¯ã€ã“ã‚Œã¯éƒ¨å±‹ãƒžã‚¹ã‚¿ã¨ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®ã¤ãªãŒã‚Šã§ã§ãã‚‹ã‚‚ã®ã§ã™ã®ã§ã€ä¸¡è€…ã«ç·šã®ã¤ãªãŒã‚Š
d4-1977 2008/05/21
DB

ERå›³
ãƒªãƒ³ã‚¯
ã‚¿ã‚°ã‚’å®Ÿç¾ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’å¦„æƒ³ã™ã‚‹ - ã‚ˆãããŸblog
CREATE TABLE users ( id integer NOT NULL PRIMARY KEY, name varchar(200) NOT NULL, em ail varchar(200) NOT NULL, login_name varchar(100) NOT NULL, login_password varchar(40) NOT NULL );
d4-1977 2008/05/19
Tag

SQL

DB
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ã‚¯ãƒžã‚„blogç‰ã§æœ€è¿‘ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€Œã‚¿ã‚°ã€ã‚·ã‚¹ãƒ†ãƒ ã«ã¤ã„ã¦ã€‚â€¦
ã¯ã¦ãªãƒ–ã‚¯ãƒžã‚„blogç‰ã§æœ€è¿‘ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€Œã‚¿ã‚°ã€ã‚·ã‚¹ãƒ†ãƒ ã«ã¤ã„ã¦ã€‚ è‡ªåˆ†ã®ã‚µã‚¤ãƒˆã®å•†å“ã«ã€ ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒè‡ªåˆ†ã§ã€Œã‚¿ã‚°ã€ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã«ã¯ã€ ã©ã†ã„ã†è¨è¨ˆã‚’ã™ã‚Œã°ã„ã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ mysql/phpã§æ§‹ç¯‰ã—ã¦ã„ã¾ã™ã€‚ ï¼¡å•†å“ã«ã€ ãƒ¦ãƒ¼ã‚¶ï¼¸ãŒã€Œã‚ã€ã€Œã„ã€ã€Œã† ãˆã€ã¨ã„ã†ã‚¿ã‚°ã‚’ã¤ã‘ã€ ãƒ¦ãƒ¼ã‚¶ï¼¹ãŒã€Œã‚ã€ã€ŒãŠã€ã¨ã‚¿ã‚°ã‚’ã¤ã‘ãŸå ´åˆã€ ï¼¡å•†å“ãƒšãƒ¼ã‚¸ã« ã€Œã‚ã€ã€Œã„ã€ã€Œã† ãˆã€ã€ŒãŠã€ã®ã‚¿ã‚°ä¸€è¦§ãŒè¡¨ç¤ºã•ã‚Œã€ã€Œã‚ã€ã¯ï¼’å€‹ã¤ã„ã¦ã‚‹ã®ã§æ–‡å—ã‚’å¤§ããã™ã‚‹ã€ã¨ã„ã†ã‚ˆã†ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ã€‚ ã‚¿ã‚°ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã£ã¦ã€ å•†å“åï¼šãƒ¦ãƒ¼ã‚¶ï¼©ï¼¤ï¼šã‚¿ã‚°ã€€ãªã©ã®ã‚«ãƒ©ãƒ ä¸€è¦§ã§ã€ ã‚¿ã‚°ã‚«ãƒ©ãƒ ã«ã‚¿ã‚°ã‚’ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šãªã©ã§å…¥ã‚Œã¦ã„ã£ã¦ã‚‹ã®ã‹ãªãã€ãªã‚“ã¦æƒ³åƒã—ã¦ã¾ã™ã€‚ ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã‚„ã€å‚è€ƒã«ãªã‚Šãã†ãªã‚µã‚¤ãƒˆã‚’æ•™ãˆã¦é ‚ã‘ã¾ã™ã¨ã†ã‚Œã—ã„ã§ã™ã€‚
d4-1977 2008/05/19
Tag

SQL

DB

é–‹ç™º
ãƒªãƒ³ã‚¯
MySQL5ã®è³ªå•ã§ã™ã‚¢ã‚¯ã‚»ã‚¹è§£æžã‚’è‡ªä½œã—ã¦ã„ã¾ã™ã€‚â€¦
MySQL5ã®è³ªå•ã§ã™ã‚¢ã‚¯ã‚»ã‚¹è§£æžã‚’è‡ªä½œã—ã¦ã„ã¾ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æƒ…å ±ã‚’æ ¼ç´ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«åï¼šaccess ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ï¼šip,page ï¼ˆï¼Šå…·ä½“çš„ãªæ ¼ç´æƒ…å ±ã‚’ã‚³ãƒ¡æ¬„ã«æ›¸ã„ã¦ã„ã¾ã™ï¼‰ ã“ã“ã‹ã‚‰ã€å„ãƒšãƒ¼ã‚¸ã¸ã®ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚¢ã‚¯ã‚»ã‚¹æ•°ã‚’ç”£å‡ºã—ã¦ã€ä»¥ä¸‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã—ãŸã„ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«åï¼šunique ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ï¼špage,unique SQLã¨PHPã§ã“ã®å‡¦ç†ã‚’å®Ÿç¾ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯çŸ¥è˜ãŒå…¨ãç„¡ã„ã®ã§PHPãŒã„ã„ã§ã™ã€‚ è‡ªåˆ†ãªã‚Šã«è€ƒãˆãŸæµã‚Œã¨ã—ã¦ã¯ã€ Aãƒšãƒ¼ã‚¸ã®IPæ•°ã‚’é‡è¤‡ã‚’é™¤ã„ã¦ã‚«ã‚¦ãƒ³ãƒˆï¼ˆã“ã‚ŒãŒuniqueæ•°ã«ãªã‚‹ï¼‰ Bãƒšãƒ¼ã‚¸ã€Cãƒšãƒ¼ã‚¸ã¨åŒã˜ã‚ˆã†ã«å‡¦ç†ãƒ»ãƒ» ã§ã—ã‚‡ã†ã‹ã€‚ ä¸€æ™‚è¡¨ãªã©ä½¿ãˆã°å‡ºæ¥ã‚‹ã‚ˆã†ãªæ°—ã‚‚ã—ã¾ã™ãŒã€ä½¿ã£ãŸã“ã¨ãŒç„¡ã„ã®ã§å…·ä½“çš„ãªæ–¹æ³•ãŒæ€ã„æµ®ã‹ã³ã¾ã›ã‚“ã€‚ ã¡ã‚‡ã£ã¨è¤‡é›‘ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã®ã§ãƒã‚¤ãƒ³ãƒˆã¯500ä»¥ä¸Šã¯ç”¨æ„ã—ã¾ã™ã€‚ ã¿ãªã•ã‚“ã‚ˆ
d4-1977 2008/04/11
DB

ã‚¢ã‚¯ã‚»ã‚¹è§£æž
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸