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

braitom id:braitom

dbã«é–¢ã™ã‚‹braitomã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

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

SQLãŒé‡ã„ã¨ãã«è¦‹ã‚‹ãŠæ°—è»½ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•
SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³• æ˜”Qiitaã§æ›¸ã„ãŸã‚‚ã®ã‚’zennã«ã†ã¤ã—ã¦ã€è‹¥å¹²ã®ä¿®æ£ã€è¿½åŠ ã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ ORACLEã§ã®çµŒé¨“ã‚’å…ƒã«æ›¸ã„ã¦ã„ã¾ã™ãŒã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ã¹ãƒ¼ã‚¹ãªã‚‰å¤§ä½“å…±é€šã®è€ƒãˆæ–¹ã ã¨æ€ã†ã®ã§ä»–ã«ã‚‚ä½¿ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã„ãˆã°æ¯”è¼ƒçš„å®¹æ˜“ã«æ¸ˆã‚€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¨ã‚Šã‚ãˆãšä½œæˆã™ã‚‹ã€‚ã¨ã„ã£ãŸå¯¾å¿œã‚’å–ã‚‰ã‚ŒãŒã¡ã§ã™ãŒã€æ•°ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ç¨‹åº¦ã§ã®ãƒ‡ãƒ¼ã‚¿é‡ã§ã¯ã‚ã¾ã‚ŠåŠ¹ãç›®ãŒãªãï¼ˆè‡ªåˆ†ã®çµŒé¨“å‰‡ï¼‰ã€ã©ã¡ã‚‰ã‹ã¨ã„ãˆã°ã€çµåˆé †ãŒå¤§å¹…ã«ç‹‚ã£ã¦ãŸã‚Šã™ã‚‹ã“ã¨ãŒåŽŸå› ã®ã“ã¨ãŒå¤šã‹ã£ãŸã‚Šã—ã¾ã™ã€‚ã‚ˆã£ã¦æœ¬å½“ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒãªã„ã“ã¨ãŒåŽŸå› ãªã®ã‹ï¼Ÿã‚’ç†Ÿè€ƒã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ï¼ˆä¾‹ãˆã°IDä»¥å¤–ã®ãƒ•ãƒ©ã‚°ã¨ã‹ã‚³ãƒ¼ãƒ‰ã«å˜é …ç›®indexã‚’è²¼ã£ã¦ã‚‹ã®ã‚‚ã¿ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚æ€–ã„ã‘ã©å®Ÿè©±ï¼‰ ã¾ãŸã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚Šã™ãŽã‚‹ã¨ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãŒç‹‚ã„ã‚„ã™ããªã£ã¦ä»–ã®SQLã«ã‚‚æ‚ªå½±éŸ¿ã‚’åŠã¼ã—ãŸã‚Šã™ã‚‹ã®ã§çµæ§‹ç†Ÿæ…®ã—ã¦è¿½åŠ
braitom 2021/05/08
DB

performance
ãƒªãƒ³ã‚¯
2020å¹´ç‰ˆ ãƒ¢ãƒ€ãƒ³ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã®DBé¸å®š | DevelopersIO
ç›®çš„åˆ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é¸å®š ãã‚Œãžã‚Œã®DBã®ç‰¹å¾´ã‚„ç‰¹æ€§ã‚’è»½ãç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ï¼ˆAmazon Auroraï¼‰ RDSã«ç®¡ç†ã•ã‚Œã‚‹MySQL/PostgreSQLäº’æ›ã®RDBã§ã™ã€‚ RDSã®MySQL/PostgreSQLã¨æ¯”è¼ƒã—ãŸAuroraã®ãƒ¡ãƒªãƒƒãƒˆ å¯¾éšœå®³æ€§ ä¸¦åˆ—ã‚¯ã‚¨ãƒª Global Database ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹: MySQLã®æœ€å¤§5å€, PostgreSQLã®æœ€å¤§3å€é«˜é€Ÿ RDSã§ã¯ç‰¹æ®µç†ç”±ãŒãªã‘ã‚Œã°ã€Auroraã‚’é¸æŠžã™ã‚‹ã“ã¨ã«ãªã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ é©ã—ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ ERP CRM è²¡å‹™ãƒ»éŠ€è¡Œ SaaS(ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³) æ§‹æˆè¦ç´ DBCluster DBInstance ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹(Writer)ï¼ˆæ›¸ãè¾¼ã¿/èªã¿è¾¼ã¿ï¼‰ Auroraãƒ¬ãƒ—ãƒªã‚«(Reader) ã‚¨ãƒ³ãƒ‰ãƒã‚¤ãƒ³ãƒˆ ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã‚¨ãƒ³ãƒ‰ãƒã‚¤ãƒ³ãƒˆ èªã¿å–ã‚Šã‚¨ãƒ³ãƒ‰ãƒã‚¤ãƒ³ãƒˆ ã‚«ã‚¹ã‚¿ãƒ ã‚¨
braitom 2020/12/09
AWSã®ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¯”è¼ƒã€‚å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç‰¹å¾´ã‚„ç‰¹æ€§ã«ã¤ã„ã¦ã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚

DB

aws
ãƒªãƒ³ã‚¯
drawSQL
Loved by Developers Database design tool for creating schema diagrams, built for the modern development workflow. See the big picture Visualize your database schema and gain a birds-eye view of how different models fits together. Create a living document of your database schema that helps when architecting new features or onboarding new team members. Streamline your team's development workflow Dra
braitom 2020/04/29
ERå›³ä½œæˆã‚µãƒ¼ãƒ“ã‚¹ã€‚Open Sourceã‚¢ãƒ—ãƒªã®DBã‚¹ã‚ãƒ¼ãƒžã‚’templateã¨ã—ã¦Cloneã—ãã‚Œã‚’å…ƒã«ç·¨é›†ã§ãã‚‹æ©Ÿèƒ½ã‚‚ã‚ã‚‹ã€‚

DB

schema
ãƒªãƒ³ã‚¯
MongoDBã§ã‚ã‚‹ãƒ¡ãƒªãƒƒãƒˆãŒç„¡ããªã£ã¦ã—ã¾ã£ãŸã®ã§MySQLã«ç§»è¡Œã—ãŸã¯ãªã— - KAYAC Engineers' Blog
SREãƒãƒ¼ãƒ ã®é•·ç”°ã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯Tech Kayac Advent Calendar Migration Track 1æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ä»Šå›žã¯Lobiã§ä½¿ç”¨ã—ã¦ã„ãŸMongo DBã‚’MySQLã«ç§»è¡Œã—ãŸã¯ãªã—ã§ã™ã€‚ Mongo DBã‚’ä½•ã«ä½¿ã£ã¦ã„ãŸã‹ DAUãªã©ã®KPIãƒ¬ãƒãƒ¼ãƒˆã‚„ã€ã‚µãƒ¼ãƒ“ã‚¹ã®çŠ¶æ³ã‚’æŠŠæ¡ã™ã‚‹ãŸã‚ã®å„ç¨®é›†è¨ˆçµæžœã‚’ä¿å˜ã™ã‚‹ãŸã‚ã«ä½¿ã£ã¦ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ç›´å¾Œã¯ã“ã‚Œã‚‰ã®æ•°å—ã‚’è‰²ã€…ã¨è©¦è¡ŒéŒ¯èª¤ã—ãªãŒã‚‰è¿½åŠ ã—ãŸã‚Šã€æ¸›ã‚‰ã—ãŸã‚Šã—ã¦ã„ã¾ã—ãŸã€‚ é »ç¹ãªè¿½åŠ å‰Šé™¤ãŒã‚ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’ä¿å˜ã™ã‚‹ãŸã‚ã«ã€ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹Mongo DBã¯ã¡ã‚‡ã†ã©ã‚ˆã‹ã£ãŸã‚ˆã†ã§ã™ã€‚ (å½“æ™‚ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæµè¡Œã£ã¦ã„ãŸã¨ã„ã†ã®ã‚‚ã‚ã‚‹ã§ã—ã‚‡ã†) ãªãœç§»è¡Œã—ãŸã®ã‹ Mongo DBã«ä¿å˜ã•ã‚ŒãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯ã€ã‚¹ã‚ãƒ¼ãƒžç®¡ç†ãŒã•ã‚Œã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã§ã‚ã‚‹ã“ã¨ã‚’ã„ã„ã“ã¨ã«ã€ãã®æ™‚æ™‚ã«ã‚ˆã£ã¦æ§˜ã€…
braitom 2019/12/01
ã¯ã„ã€‚â€œã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã ã‹ã‚‰ã¨ã„ã£ã¦ã‚¹ã‚ãƒ¼ãƒžç®¡ç†ã‚’æ”¾æ£„ã™ã‚‹ã¨å¾Œã§ç—›ã„ç›®ã«ã‚ã†ã®ã§æ°—ã‚’ã¤ã‘ã¾ã—ã‚‡ã†â€

MongoDB

DB
ãƒªãƒ³ã‚¯
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¾çŠ¶--è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã€ãƒ©ã‚¤ã‚»ãƒ³ã‚¹
George AnadiotisÂ ï¼ˆSpecial to ZDNET.comï¼‰Â ç¿»è¨³æ ¡æ£ï¼šÂ çŸ³æ©‹å•“ä¸€éƒŽ 2019-10-28 06:30 460å„„ãƒ‰ãƒ«ï¼ˆ4å…†9000å„„å††ï¼‰ã®å¸‚å ´ã®70ï¼…ã¨è¨€ãˆã°å¤§å¤‰ãªè¦æ¨¡ã ãŒã€Gartnerã®äºˆæƒ³ã«ã‚ˆã‚Œã°ã€æ–°ã—ã„ç¤¾å†…ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®70ï¼…ä»¥ä¸ŠãŒã„ãšã‚Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆOSDBMSï¼‰ä¸Šã§é–‹ç™ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã„ã†ã€‚PerconaãŒæœ€è¿‘å®Ÿæ–½ã—ãŸå¤§è¦æ¨¡ãªèª¿æŸ»ã§ã¯ã€ãã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹å¸‚å ´å‹•å‘ãŒæ˜Žã‚‰ã‹ã«ãªã£ãŸã€‚ ã“ã®ã€ŒOpen Source Data Management Software Surveyã€ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£ã®ã•ã¾ã–ã¾ãªã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã™ã‚‹ä¼æ¥ã§ã‚ã‚‹PerconaãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨è€…ã®åˆ©ç”¨ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚„æ„è¦‹ã‚’æŠŠæ¡ã™ã‚‹ãŸã‚ã«å®Ÿæ–½ã—ãŸèª¿æŸ»ã ã€‚ã‚¢ãƒ ã‚¹ãƒ†ãƒ«ãƒ€ãƒ ã§é–‹å‚¬ã•ã‚ŒãŸPerconaä¸»å‚¬ã®
braitom 2019/10/29
DB

ä¼æ¥
ãƒªãƒ³ã‚¯
RDBMS in Action
RDBMS ç†è§£åº¦ã®å£: ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã‚„é‹ç”¨ä¿å®ˆã§å›°ã‚‰ãªã„ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã‚Œã‚‹çŸ¥è˜ ï¼œï¼œï¼œãã‚Œã£ã½ãå‹•ãã‚‚ã®ã‚’ä½œã‚Œã‚‹çŸ¥è˜ å®Ÿéš›ã®ã‚·ã‚¹ãƒ†ãƒ ã§éé‡ãƒ»è¦‹èžãã—ãŸäº‹è±¡ã‚’ã‚‚ã¨ã«ã€ä¸Šè¨˜ã®ã‚¹ã‚ãƒžã«ã‚ã‚‹å„ç¨® RDBMS çŸ¥è˜ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ RDBMS æœ¬ä½“ã®é‹ç”¨ã‚ˆã‚Šã‚‚ã€ç¾å®Ÿã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹è¨è¨ˆâ€¦
braitom 2019/10/02
RDBMSã‚’åˆ©ç”¨ã™ã‚‹ä¸Šã§ã®ãƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æ•´åˆæ€§ã€è£½å“ã”ã¨ã®å†…éƒ¨è¨è¨ˆã®é•ã„ã«ã‚ˆã‚‹è€ƒæ…®ã€ãƒ—ãƒªãƒŸãƒ†ã‚£ãƒ–åž‹ã®å–ã‚Šæ‰±ã„ã®é•ã„ã€è£½å“ã”ã¨ã«ç‰¹ã«æ°—ã‚’ã¤ã‘ãŸæ–¹ãŒã‚ˆã„è¨å®šãªã©ãŒã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚

DB

RDB
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã®GraphQLã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆ
GraphQLã®ã‚ˆã„ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆã«ã¤ã„ã¦ã§ã™ã€‚
braitom 2019/09/04
ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆã®ãƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦ã€‚Trelloã®ã‚ˆã†ãªã‚«ãƒ³ãƒãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä¾‹ã«èª¬æ˜Žã•ã‚Œã¦ã„ã‚‹ã€‚å®Ÿè£…ã®è©³ç´°ã‚’å«ã‚ãªã„ã€ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã‚’æä¾›ã™ã‚‹ãªã©ã€‚

è¨è¨ˆ

DB

GraphQL
ãƒªãƒ³ã‚¯
åˆã‚ã¦0ã‹ã‚‰DBè¨è¨ˆã—ã¦ã¿ã¦ã‚„ã‚‰ã‹ã—ãŸã“ã¨ - Qiita
èƒŒæ™¯ ã¤ã„å…ˆæ—¥ã€è‡ªåˆ†ã®æ‹…å½“ãƒ—ãƒãƒ€ã‚¯ãƒˆãŒã²ã¨ã¾ãšÎ±ç‰ˆãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã®ã‚ãƒ£ãƒªã‚¢ã§ã¯æ—¢å˜ã‚·ã‚¹ãƒ†ãƒ ã®æ‹¡å¼µãªã©ãŒå¤šãã€ãƒ“ã‚¸ãƒã‚¹ã¨ã—ã¦ã¯è‡ªåˆ†ã§0ã‹ã‚‰DBã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’ã™ã‚‹æ©Ÿä¼šãŒãªã‹ã£ãŸãŸã‚ã€ã‚ãƒ£ãƒƒã‚ãƒ£ã—ãªãŒã‚‰ä»Šå›žåˆã‚ã¦ã™ã¹ã¦ã®è¨è¨ˆã‚’ã—ãŸã®ã§ã™ãŒã€ç¾å®Ÿã¯åŽ³ã—ã„ã€‚çµæ§‹ãªæ•°ã®å¤±æ•—ã‚’ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ãã‚“ãªã€Œå¤±æ•—ã—ãŸãªã€œã€ã¨æ€ã£ãŸè¨è¨ˆã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã€ä¾›é¤Šã«ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ å¤±æ•—ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾© ã¨ã„ã†ã‚ã‘ã§ã€ã‚ˆã‹ã‚Œã¨æ€ã£ã¦ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã—ã¦ã¿ãŸã‚‰ã¤ã‚‰ã‹ã£ãŸã“ã¨ãŸã¡ã€‚ ãƒãƒƒãƒˆåºƒå‘Šç³»ã®ä¼šç¤¾ãªã®ã§ã€åºƒå‘Šã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®ã‚µãƒ³ãƒ—ãƒ«å¤šã‚ã§ã™ã€‚ éŽåº¦ãªãƒ†ãƒ¼ãƒ–ãƒ«åˆ†å‰² åºƒå‘Šãƒ†ãƒ¼ãƒ–ãƒ« id name status bid url
braitom 2019/08/13
DB

è¨è¨ˆ
ãƒªãƒ³ã‚¯
Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒä»Šã“ãçŸ¥ã‚‹ã¹ãã€ RDBMSã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å‹˜æ‰€ / rdb-basic - Speaker Deck
Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒä»Šã“ãçŸ¥ã‚‹ã¹ãã€ RDBMSã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å‹˜æ‰€ / rdb-basic
braitom 2019/02/11
RDBMSã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å‹˜æ‰€ã«ã¤ã„ã¦ã€‚å®Ÿè¡Œè¨ˆç”»ãªã©ã®RDBMSã®åŸºæœ¬çš„ãªã—ãã¿ã€INDEXã‚’åˆ©ç”¨ã§ãã¦ã„ãªã„ãªã©ã®RDBMSã‚’æ´»ç”¨ã§ãã¦ã„ãªã„ä¾‹ãªã©ãŒã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚

DB

performance
ãƒªãƒ³ã‚¯
ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿å‡¦ç†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…¨ä½“åƒã¨ä½¿ã„åˆ†ã‘â€¨2018å¹´version
1. (C) Recruit Techno logies Co.,Ltd. All rights reserved. ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿å‡¦ç†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…¨ä½“åƒã¨ä½¿ã„åˆ†ã‘ 2018å¹´version 2018/9/21 æ ªå¼ä¼šç¤¾ãƒªã‚¯ãƒ«ãƒ¼ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚º ãƒ‡ãƒ¼ã‚¿ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ãƒ©ãƒœéƒ¨ æ¸¡éƒ¨å¾¹å¤ªéƒŽ db tech showcase Tokyo 2018 2. (C) Recruit Techno logies Co.,Ltd. All rights reserved. è‡ªå·±ç´¹ä»‹ {"ID" ï¼š"fetaro" "åå‰"ï¼š"æ¸¡éƒ¨ å¾¹å¤ªéƒŽ" "ç ”ç©¶"ï¼š"æ±äº¬å·¥æ¥å¤§å¦ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨æƒ…å ±æ¤œç´¢ã®ç ”ç©¶" "ä»•äº‹"ï¼š{å‰è·:["è¨¼åˆ¸ä¼šç¤¾ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚·ã‚¹ãƒ†ãƒ ã®WebåŸºç›¤", "ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãªã‚‰ä½•ã§ã‚‚ã€‚ä¸»ã«Mongo DB,NoSQL"], ç¾è·:["ãƒªã‚¯ãƒ«ãƒ¼ãƒˆåˆ†æžåŸºç›¤ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãƒªãƒ¼ãƒ€, BigQuery,
braitom 2018/09/24
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«/ã‚¢ãƒŠãƒªãƒ†ã‚£ãƒƒã‚¯ã€ã‚ªãƒ³ãƒ—ãƒ¬/DBã‚µãƒ¼ãƒ“ã‚¹/ã‚¯ã‚¨ãƒªã‚µãƒ¼ãƒ“ã‚¹ã¨ã„ã†è»¸ã§åˆ†é¡žã—ã¦ã¾ã¨ã‚ã¦ã„ã‚‹è³‡æ–™ã€‚ãã‚Œãžã‚Œã®ç‰¹å¾´ã€ä»£è¡¨çš„ãªã‚µãƒ¼ãƒ“ã‚¹ã®èª¬æ˜ŽãŒæ›¸ã‹ã‚Œã¦ã„ã‚‹ã€‚

DB
ãƒªãƒ³ã‚¯
TeamSQL - Cross-platform SQL Client Built for Collaboration
Looking for an Amazon Redshift client? TeamSQL has retired and is not available for download anymore. You can The world's first and the only query and management tool built for Amazon Redshift. Get DataRow for Amazon Redshift Hello, TeamSQL has been a great platform to experiment with modern UI and powerful features to help you manage your popular databases with collaborative features. Over two ye
braitom 2018/09/22
ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ å¯¾å¿œã—ã¦ã„ã‚‹SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚ä¸»è¦ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã ã„ãŸã„ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã€‚ã‚¯ã‚¨ãƒªä¿å˜ã€å±¥æ´ä¿æŒã€ãƒãƒ£ãƒ¼ãƒˆå‡ºåŠ›ãªã©ã®æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚

sql

DB

tool
ãƒªãƒ³ã‚¯
ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ æ¯”è¼ƒè§£èª¬ã¾ã¨ã‚
æœ€çµ‚æ›´æ–° 2019-09-11 ã‚¯ãƒ©ã‚¦ãƒ‰ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ Amazon RDSã€Azure SQL Databaseã€Google Cloud SQL ã«ã¤ã„ã¦ã€æ©Ÿèƒ½ãƒ»æ–™é‡‘ãƒ»ç®¡ç†é¢ãªã©ã®æ¯”è¼ƒã‚’ã—ã¦ã¿ã¾ã™ã€‚ 2019/06/21ã€Amazon RDS ã«ã¦ Aurora ä»¥å¤–ã«ã‚‚å®¹é‡è‡ªå‹•æ‹¡å¼µæ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¾ã—ãŸã€‚è©³ç´°019/04/26ã€Amazon RDS ã® 1æ™‚é–“å˜ä½ã®èª²é‡‘ãŒç§’å˜ä½ (ãŸã ã—æœ€ä½Žåˆ©ç”¨10åˆ†) ã«ãªã£ãŸã“ã¨ã‚’è¿½è¨˜ã€‚2019/04/10ã€DBãƒãƒ¼ã‚¸ãƒ§ãƒ³ãƒ»CPUãƒ»ãƒ¡ãƒ¢ãƒªç‰ã‚’æœ€æ–°åŒ–ã€‚Azure SQL Database ã®ã€Œèªã¿å–ã‚Šã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã€ã®èª¬æ˜Žã‚’è¿½è¨˜ (è¿½åŠ ã‚³ã‚¹ãƒˆãªã—ï¼) ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ (RDBMS) ã¨ã¯ã€è¡¨å½¢å¼ã§ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã§ãã€ SQL ãªã©ã®è¨€èªžã«ã‚ˆã£ã¦ãƒ‡ãƒ¼ã‚¿ã®å–å¾—ãƒ»é›†è¨ˆãƒ»åŠ å·¥ãŒè¡Œãˆã‚‹ã‚‚ã®ã§
braitom 2018/07/27
Amazon RDSã€Azure SQL Databaseã€Google Cloud SQLã®æ¯”è¼ƒ

DB

æ¯”è¼ƒ
ãƒªãƒ³ã‚¯
365æ—¥24æ™‚é–“ç¨¼åƒå¿…é ˆã‚µãƒ¼ãƒ“ã‚¹ã® å®Œå…¨ç„¡åœæ¢DBç§»è¡Œ
Rails Developers Meetup 2018: Day 1ã€€ç™ºè¡¨è³‡æ–™ https://techplay.jp/event/639872
braitom 2018/03/24
MongoDBã‹ã‚‰Amazon Auroraã¸ã®ç„¡åœæ¢ãƒ‡ãƒ¼ã‚¿ç§»è¡Œã—ãŸè©±ã€‚ãƒ•ãƒ©ã‚°ãƒ™ãƒ¼ã‚¹ã§ã®ç§»è¡Œã€‚ã“ã‚Œã¯ã™ã”ã„ã€‚

DB

ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
[è¬›ç¾©] ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®è¬›ç¾©è³‡æ–™ã‚’å…¬é–‹ã—ã¾ã™ - YoheiM .NET
ã“ã‚“ã«ã¡ã¯ã€@yoheiMuneã§ã™ã€‚ G's ACADEMY TOKYOã•ã‚“ã§ã„ãã¤ã‹è¬›ç¾©ã‚’æ‹…å½“ã•ã›ã¦ã„ãŸã ã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€æ–°ã—ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®è¬›ç¾©ã‚’è¡Œã£ãŸã®ã§ã€ãã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å…¬é–‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ è¬›ç¾©å†…å®¹ ã“ã®è¬›ç¾©ã¯ã€åˆã‚ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã‚“ã æ–¹å‘ã‘ã§ã€å’æ¥åˆ¶ä½œã§ä½œã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã‚’ç›®æ¨™ã«ã—ã¦ã„ã¾ã™ã€‚ç‰¹ã«è«–ç†è¨è¨ˆã‚’æ‰±ã„ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§æ‰±ã†ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’èªã¿è§£ã„ã¦ç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ è«–ç†è¨è¨ˆã§ã¯ä»¥ä¸‹ã®é …ç›®ã‚’æ‰±ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ç†è§£ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®å®šç¾© ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ãƒƒãƒ—ã®å®šç¾© ãƒ‡ãƒ¼ã‚¿é …ç›®ã®å®šç¾© åˆ—ã®å®šç¾© å°‘ã—ã§ã‚‚å‚è€ƒã«ãªã‚Œã°ã¨æ€ã„ã€ã‚‚ã—æ°—ã«ãªã£ãŸæ–¹ã¯ãƒãƒ©ãƒƒã¨è¦‹ã¦ã¿ã¦é ‚ã‘ãŸã‚‰å¬‰ã—ã„ã§ã™ã€‚ ç·¨é›†å¾Œè¨˜ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ã¤ã„ã¦ã„ã–è¬›ç¾©ã‚’ä½œã‚ã†ã¨ã™ã‚‹ã¨ãªã‹ãªã‹ã‚¢ã‚¤ãƒ‡ã‚¢ãŒã¾ã¨ã¾ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã„ã¤ã‚‚ã‚„ã£ã¦ã„ã‚‹ã“ã¨ã‚’ã„ã–æ˜Žæ–‡åŒ–ã—ã‚ˆã†ã¨ã™ã‚‹
braitom 2018/03/01
DB

è¨è¨ˆ
ãƒªãƒ³ã‚¯
2000ä¸‡ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ç„¡åœæ¢ãƒ‡ãƒ¼ã‚¿ç§»è¡Œã®è£å´
#DataMigrationNight ã«ã¦ç™ºè¡¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã§ã™
braitom 2017/05/30
ãƒ‡ãƒ¼ã‚¿ç§»è¡Œã®éš›ã«æ–°æ—§ã©ã¡ã‚‰ã®ãƒ‡ãƒ¼ã‚¿ã‚‚ä½¿ãˆã‚‹ã‚ˆã†ã«å¸¸ã«ãƒ‡ãƒ¼ã‚¿åŒæœŸã—ã¦ä»»æ„ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ç§»è¡Œå¯èƒ½ã«ã™ã‚‹è©±ã€‚èª²é¡Œã¨ã©ã†å®Ÿç¾ã—ãŸã‹ãŒæ›¸ã‹ã‚Œã¦ã„ã‚‹ã€‚ã™ã”ã„ã€‚

db

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
DBeaver Community | Free Universal Database Tool
Basic support for relational databases: MySQL, SQL Server, PostgreSQL and others Data Editor SQL Editor Database schema editor DDL Basic ER Diagrams Basic charts Data export/import Task management Database maintenance tools All DBeaver Community featuresAdvanced securityAdvanced support for relational databasesConnection through ODBC driversNoSQL databases support: Mongo DB, Cassandra, Redis, Couch
braitom 2017/05/05
æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã—ãŸGUIã®ç®¡ç†ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€‚MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Serverãªã©ä»£è¡¨çš„ãªã‚‚ã®ã¯ã»ã¨ã‚“ã©ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã€‚

DB

client
ãƒªãƒ³ã‚¯
RDBã¨ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹DBã®ä½¿ã„åˆ†ã‘ã«ã¤ã„ã¦ | ã•ã«ã‚ã‚‰ãš
ã¯ã˜ã‚ã«#RDB ã¨ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ DB ã‚’ã©ã†ã„ã†åŸºæº–ã§ä½¿ã„åˆ†ã‘ã‚‹ã®ã‹ã‚’ã€ä¼šç¤¾ã§èžã‹ã‚ŒãŸéš›ã«ç”ãˆãŸé›‘ãªå›žç”ã‚’ãƒ¡ãƒ¢æ›¸ãã—ã¦ãŠãã€‚ ä»–ã«ã‚‚å¤šãã®åŸºæº–ãŒã‚ã‚‹ã ã‚ã†ã—ã€ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ DB ã¨ã„ã†ã‹ KVS ã¯æ§˜ã€…ãªå®Ÿè£…ãŒã‚ã‚Šã€ãã®ãã‚Œãžã‚ŒãŒå¾®å¦™ã«é•ã†ã®ã§è°è«–ã¨ã—ã¦æ›–æ˜§ãªéƒ¨åˆ†ã¯ã‚ã‚‹ã€‚ ç‰¹ã«ã€é‹ç”¨é¢ã‚„ãƒ‡ãƒ¼ã‚¿é‡ãŒãƒšã‚¿ãƒã‚¤ãƒˆã‚¯ãƒ©ã‚¹ã«ãªã‚‹çŠ¶æ³ã«ã¤ã„ã¦ã¯è€ƒæ…®ã—ã¦ã„ãªã„ã€‚ åƒ•ã¯ SI æˆ¦å£«ãªã®ã§ã€æœ€çµ‚çš„ã«ã¯é‡‘ã‚’ç„¡é™ã«çªã£è¾¼ã‚“ã Oracle å…ˆç”ŸãŒæœ€é«˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã„ã‚‹ã€‚ ãã†ã„ã†ãƒã‚¤ã‚¢ã‚¹ã®ã‚ã‚‹äººé–“ã®æ„è¦‹ã ã¨æ€ã£ã¦ä»¥ä¸‹ã®æ–‡ç« ã¯èªã‚“ã§æ¬²ã—ã„ã€‚ å¿µé ã«ç½®ã„ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦#ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ãã«ã‚ãŸã£ã¦å¿µé ã«ãŠã„ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ä»¥ä¸‹ã®é€šã‚Š RDB OraclePostgreSQL MySQLã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ DBMongo DB Amazon DynamoDBæœ€åˆã¯ Redis ã‚’ DB ã¨æ›¸ã„ã¦ã„ãŸ
braitom 2017/02/23
RDBã¨ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹DBä½¿ã„åˆ†ã‘ã®3ã¤ã®åŸºæº–ã«ã¤ã„ã¦ã€‚

DB
ãƒªãƒ³ã‚¯
GitHub - nodesocket/jsonlite: A simple, self-contained, serverless, zero-configuration, json document store.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
braitom 2017/02/16
â€œA simple, self-contained, serverless, zero-configuration, json document store.â€

json

DB
ãƒªãƒ³ã‚¯
PouchDB, the JavaScript Database that Syncs!
The Database that Syncs! PouchDB is an open-source JavaScript database inspired by Apache CouchDB that is designed to run well within the browser. PouchDB was created to help web developers build applications that work as well offline as they do online. It enables applications to store data locally while offline, then synchronize it with CouchDB and compatible servers when the application is back
braitom 2016/12/06
DB

JavaScript
ãƒªãƒ³ã‚¯
Time-series-database-world
æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç•Œã«ã¤ã„ã¦é©å½“ã«å–‹ã‚Šã¾ã—ãŸ Slide source is here: https://github.com/rrreeeyyy/talks/blob/29efd49d4aff915fde403ef9dd305b0b9d9f3b9d/20161013/time-series-dataâ€¦
braitom 2016/10/14
æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ä½•ã‹ã€ãã®æ´å²ã€ã©ã‚“ãªã‚‚ã®ãŒã‚ã‚‹ã‹ã€ã©ã†ã‚„ã£ã¦é¸ã¶ã‹ãŒã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚

time

db

database
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸