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

hiroyukim id:hiroyukim

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

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

erd â€“ ERå›³ã‚’ä½œæˆã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«
MOONGIFTã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ç´¹ä»‹ã™ã‚‹ãƒ–ãƒã‚°ã§ã™ã€‚2021å¹´07æœˆ16æ—¥ã§æ›´æ–°åœæ¢ã—ã¾ã—ãŸ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ€ã‚¤ã‚¢ã‚°ãƒ©ãƒ ï¼ˆERå›³ï¼‰ã‚’ä½œæˆã™ã‚‹ Haskell è£½ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã§å®šç¾©ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã€ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§ãƒ€ã‚¤ã‚¢ã‚°ãƒ©ãƒ ã¨ãªã‚‹ç”»åƒã‚’ä½œæˆã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¨è¨ˆã™ã‚‹éš›ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ãã®é–¢é€£ä»˜ã‘ã«ã¤ã„ã¦å…¨ä½“åƒã‚’æ‰‹æ—©ãä½œæˆã—ãŸã„ã€ãã‚“ãªæ™‚ã«ä¾¿åˆ©ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ erd ã®ä¸»ãªç‰¹å¾´ 1) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å…¨ä½“åƒã®è¨è¨ˆã«é›†ä¸ã§ãã‚‹ ãƒ€ã‚¤ã‚¢ã‚°ãƒ©ãƒ ã«ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«åŒå£«ã®é…ç½®ãªã©æ°—ã«ã™ã‚‹ã“ã¨ãªãã€ã¨ã«ã‹ãå…¨ä½“çš„ãªè¨è¨ˆã‚’è¡Œã„ãŸã„æ™‚ã«ä¾¿åˆ©ã§ã™ã€‚GUIãƒ„ãƒ¼ãƒ«ã‚‚ä¾¿åˆ©ã§ã™ãŒã€ä½¿ã„æ…£ã‚ŒãŸãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã§ã€ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‹ã‚‰æ‰‹ã‚’é›¢ã™ã“ã¨ãªãã€æ€ã†ã¾ã¾ã«è¨è¨ˆã‚’é€²ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ 2) er ãƒ•ã‚¡ã‚¤ãƒ«ãŒå¿…è¦ er ãƒ•ã‚¡ã‚¤ãƒ«ã¨å‘¼ã¶å®šç¾©ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ã“ã®er
hiroyukim 2015/01/01
DB
ãƒªãƒ³ã‚¯
éžåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã™ã‚‹ã€ŒDynomiteã€ã€NetflixãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹
Redisã‚„Memcachedã¨ã„ã£ãŸã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯éžå¸¸ã«é«˜é€Ÿã«ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’è¿”ã—ã¦ãã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã§ã™ãŒã€ãã‚Œå˜ä½“ã§ã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚„å¯ç”¨æ€§ãªã©ã«é™ç•ŒãŒã‚ã‚Šã¾ã™ã€‚ The Netflix Tech Blog: Introducing Dynomite - Making Non-Distributed Databases, Distributed NetflixãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã—ãŸã€ŒDynomiteã€ï¼ˆãƒ€ã‚¤ãƒŠãƒžã‚¤ãƒˆã¨ã¯ç¶´ã‚ŠãŒé•ã†ã®ã«æ³¨æ„ï¼‰ã¯ã€ã“ã†ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ã€é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ç‰¹é•·ã‚’æ´»ã‹ã—ã¤ã¤é«˜ã„ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚„å¯ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®ã‚ˆã†ãªé¢å€’ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’è¨å®šã™ã‚‹ã“ã¨ãªãã€Redisã‚„Memcachedã‚’ãƒŽãƒ¼ãƒ‰ã¨ã—ã€Cassandraã‚„Amazonã‚¯ãƒ©ã‚¦ãƒ‰ã®DynamoDBã®ã‚ˆã†ãªå¤§è¦
hiroyukim 2014/11/07
Distributed

åˆ†æ•£

db
ãƒªãƒ³ã‚¯
Docker 1.0 ã§DBã‚’å‹•ã‹ã™ã¨ãã®å…±æœ‰ãƒ¡ãƒ¢ãƒªã®è¨å®š - æŠ€è¡“é‡ŽéƒŽã®å¾©ç¿’
Dockeré•·ã‚‰ããƒ–ãƒã‚°æ›¸ã„ã¦ãªã‹ã£ãŸã®ã§ã€ã©ã†ã§ã‚‚ã„ã„è©±ã‚’ã¡ã‚‡ã£ã¨æ›¸ã“ã†ã€‚Blue-Greenã§ãƒãƒ¤ãƒ›ãƒ¤ã•ã‚Œã‚‹é‹å‘½ã®Dockerã§ã€DBã‚’å‹•ã‹ã™ã¨ã„ã†éœ€è¦ã¯ã‚ã‚“ã¾ã‚Šãªã„ã¨ã¯æ€ã„ã¾ã™ãŒã€ã‚³ãƒ³ãƒ†ãƒŠã§DBã‚’å‹•ã‹ã™ã¨ã„ã†ã®ã‚‚ãã‚Œã¯ã¾ãŸä¸€èˆˆã§ã™ã€‚DBã‚’å‹•ã‹ã™ã¨ãªã‚‹ã¨å…±æœ‰ãƒ¡ãƒ¢ãƒªã‚’ãŸãã•ã‚“ä½¿ã†ã“ã¨ã«ãªã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã†å…±æœ‰ãƒ¡ãƒ¢ãƒªã®è¨å®šã«é–¢ã—ã¦ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³1.0ãŒå‡ºã¦ã‹ã‚‰ã„ã¾ã¾ã§ã®ã‚„ã‚Šæ–¹ãŒé€šç”¨ã—ãªããªã£ãŸã®ã§ã€ãã‚Œã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ã“ã‚Œã¾ã§ã“ã‚Œã¾ã§ã€åƒ•ã¯Dockerã§PostgreSQLã‚³ãƒ³ãƒ†ãƒŠã‚’å‹•ã‹ã™ã¨ãã€ã¾ãšã‚³ãƒ³ãƒ†ãƒŠå†…ã§èµ·å‹•ã‚¹ã‚¯ãƒªãƒ—ãƒˆçš„ãªã‚·ã‚§ãƒ«ã‚’å®Ÿè¡Œã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã—ãŸã€‚ãã®ãªã‹ã§ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚«ãƒ¼ãƒãƒ«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿shmmaxã®å€¤ã‚’å¤§ããã—ã¦ã„ã¾ã—ãŸã€‚ sysctl -w kernel.shmmax=4418740224 ãªãœãªã‚‰ã‚³ãƒ³ãƒ†ãƒŠå†…ã®shmmaxã®å€¤ãŒãªãœã‹å°ã•ãè¨å®šã•ã‚Œã¦ã„ã‚‹ãŸã‚ã«ã€
hiroyukim 2014/06/23
docker

db

ãƒ¡ãƒ¢ãƒª

è¨å®š
ãƒªãƒ³ã‚¯
Shoshanna Raven - Creator Of Vortex & Living Brave
In the fast-paced world of personal development, one woman has continually stood outâ€”Shoshanna Raven. Her influence extends beyond coaching sessions. Her retreats are transf ormative, and her message of â€˜Living Braveâ€™ has resonated deeply with countless individuals. But what makes her leadership so impactful? The answer lies in the voices of those who have walked the path with herâ€”her clients. Rave
hiroyukim 2014/06/02
db

database

architecture
ãƒªãƒ³ã‚¯
LevelDBå…¥é–€ (åŸºæœ¬ç·¨) - from scratch
ã•ã¦ã€ä»Šå›žã¯æ¯”è¼ƒçš„æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã§ã‚ã‚‹LevelDBã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ LevelDBã¯1å¹´ã»ã©å‰ã‹ã‚‰Node.jsç•Œéšˆã§ã¯ãƒ–ãƒ¼ãƒ ãŒæ¥ã¦ã„ã¦ã€ç†ç”±ãŒã‚ˆãã‚ã‹ã£ã¦ã„ãªã‹ã£ãŸã‚“ã§ã™ãŒã€ã¾ã¨ã‚ã¦ã„ã‚‹å†…ã«åˆ†ã‹ã‚‹ã‹ãªã¨æ€ã£ã¦ã¾ã¨ã‚ã¾ã—ãŸã€‚ä»Šå›žã¯Node.jsç„¡é–¢ä¿‚ã§LevelDBã®åŸºç¤Žçš„ãªã“ã¨ã ã‘èª¿æŸ»ã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ Node.jsã§ä½¿ã£ã¦ã¿ã‚‹è©±ã¯å¾Œã«å›žã—ã¾ã™ã€‚ LevelDBã¨ã¯? key-valueåž‹ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ä¸€ã¤ã§ã™ã€‚ Googleã®ç ”ç©¶è€…ã§ã‚ã‚‹ã€Jeff Deanã¨Sanjey GhemawatãŒé–‹ç™ºã—ã€2011å¹´ã«å…¬è¡¨ã•ã‚Œã¾ã—ãŸã€‚C++ã§æ›¸ã‹ã‚Œã¦ãŠã‚Šã€å¤šãã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§bindingsãŒæ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ã‚‚ã¡ã‚ã‚“ã€JavaScript/Node.jsã§ã‚‚æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ LevelDB ã¯ Google ã®BigTableã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŒ
hiroyukim 2014/05/05
ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£

db
ãƒªãƒ³ã‚¯
The upper.io/db.v1 ORM for Go
This project is kept for historical purposes, if youâ€™re new here you may want to check out upper.io/db.v2 instead. db.v1 is deprecated and no new features will be added, only security issues will be patched, we recommend you to migrate from db.v1 to db.v2. The upper.io/db.v1 package for Go provides a common interface for interacting with different data sources using adapters that wrap mature datab
hiroyukim 2013/12/27
go

db

io

install
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã®ãƒ‰ãƒ¡ã‚¤ãƒ³è¨è¨ˆã«ã¤ã„ã¦ã®è°è«–
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’å®Ÿè·µã™ã‚‹ã«ã¯ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ï¼ˆâ‰’ãƒ‡ãƒ¼ã‚¿åž‹ï¼‰ã‚’å¦‚ä½•ã«æ£ã—ãè¨è¨ˆã™ã‚‹ã‹ã¨ã„ã†ã“ã¨ãŒæ¥µã‚ã¦é‡è¦ã«ãªã‚‹ã€‚ã—ã‹ã—ãªãŒã‚‰ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’ã©ã†è¨è¨ˆã™ã¹ãã‹ã¨ã„ã†è°è«–ã¯ã‚ã¾ã‚Šã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ã†ã€‚ãã®çµæžœã€ãƒ‰ãƒ¡ã‚¤ãƒ³ã«ã¤ã„ã¦ã®ç†è§£ã¯ã‚ã¾ã‚Šé€²ã¾ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«å¤±æ•—ã—ã¦ã„ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒå¤šã„ã‚ˆã†ã«æ€ã‚ã‚Œã‚‹ã€‚ ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã®ãƒ†ãƒ¼ãƒžã¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã§ã‚ã‚‹ã€‚ é›†åˆã‚’å®šç¾©ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã¯ä½•ã‹ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’å®Ÿè·µã™ã‚‹ã«ã¯ã¾ãšãã®ç‚¹ã‹ã‚‰ç†è§£ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿åž‹ã¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã¨å‘¼ã°ã‚Œã‚‹ã€‚ãƒ‰ãƒ¡ã‚¤ãƒ³ã¨ã¯ã€ãã®å±žæ€§ï¼ˆâ‰’ã‚«ãƒ©ãƒ ï¼‰ã«å…¥ã‚‹ã¹ãå€¤ã¯ã©ã†ã„ã£ãŸã‚‚ã®ã‹ã‚’é›†åˆã¨ã—ã¦å®šç¾©ã—ãŸã‚‚ã®ã ã€‚è¨€ã„æ›ãˆã‚‹ã¨ã€å±žæ€§å€¤ã¨ã¯ã‚ã‚‹é›†åˆã®è¦ç´ ã®ä¸€ã¤ã§ã‚ã‚‹ã¨è¨€ãˆã‚‹ã€‚å¾“ã£ã¦ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’è¨è¨ˆã™ã‚‹éš›ã«ã¯ã€SQLã§è¨€ã†ã¨ã“ã‚ã®ãƒ‡ãƒ¼ã‚¿åž‹ã€ã¤ã¾ã‚ŠINTã‚„CHARã¨ã„ã£ãŸã‚‚ã®ã ã‘ã§ãªãã€ãã®
hiroyukim 2013/12/08
è¨è¨ˆ

DB

Database

ãƒ‰ãƒ¡ã‚¤ãƒ³
ãƒªãƒ³ã‚¯
Big Sky :: Goè¨€èªžå‘ã‘ã® ORMã€gorp ãŒãªã‹ãªã‹è‰¯ã„
ãã‚ãã‚Webå‘¨ã‚Šã ã‘ã§ãªãDBå‘¨ã‚Šã‚‚æƒã£ã¦ãã¦ã€æœ¬æ ¼çš„ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒæ›¸ã‘ã‚‹æ§˜ã«ãªã£ã¦ãã¾ã—ãŸã€‚ DBã‚’æ‰±ã†ã«ã¯ã€SQLã‚’å®Ÿè¡Œã™ã‚‹æ§˜ãªç‰©ã¯æ¨™æº–ã§ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã—ãŸãŒã€gorp ã‚’ä½¿ã†ã¨æ¥µåŠ›SQLã‚’æ›¸ã‹ãšã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†äº‹ãŒå‡ºæ¥ã¾ã™ã€‚ coopernurse/gorp - GitHub Go Relational Persistence I hesitate to call gorp an ORM. https://github.com/coopernurse/gorp ã¾ãšã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ãªã‚‹æ§‹é€ ä½“ã‚’å®£è¨€ã—ã¾ã™ã€‚ã“ã“ã§ã¯ Person ã¨ã„ã†æ§‹é€ ã«ã—ã¾ã™ã€‚ typeÂ PersonÂ structÂ { IdÂ int32 NameÂ string } æ¬¡ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒƒãƒ‘ãƒ¼ã‚’ä½œã‚Šã¾ã™ã€‚ db, err := sql.Open("sqlite3",Â "./foo.db") db map
hiroyukim 2013/11/18
database

db

sql

go

golang

orm
ãƒªãƒ³ã‚¯
Making full table scan 10x faster in InnoDB
At MySQL Connect 2013, I talked about how we used MySQL 5.6 at Facebook, and explained some of new features we added to our Facebook MySQL 5.6 source tree. In this post, I'm going to talk about how we made full table scan faster in InnoDB. Faster full table scan in InnoDB In general, almost all queries from applications are using indexes, and reading very few rows (0..1 on primary key lookups and
hiroyukim 2013/10/11
DB

matsunobu

innodb

database
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
1. MySQL Admin ãŒè¦‹ãŸ Devs ã®å¸¸è˜ã€ DBA ã¯éžå¸¸è˜ 2013/09/14 yoku0825@MyNA PHP Conference 2013 2. ï¼¼ã“ã‚“ã«ã¡ã¯ï¼ï¼ â— yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã® DBA â— MySQL æ´ 5 å¹´ãã‚‰ã„ â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— æ—¥æœ¬ MySQL ãƒ¦ãƒ¼ã‚¶ä¼š (MyNA) ã®ã‚¹ãƒ™ã‚Šæ‹…å½“ 3. ï¼¼ã—ã‚ƒã¹ã‚‹ã“ã¨ï¼ï¼ â— æ—¥å¸¸çš„ã« MySQL ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«è§¦ã‚Œã‚‹å¤‰æ…‹ DBA ãŒãƒ•ãƒ„ãƒ¼ã® Devs ã«æŠ•ã’ãŸæ„›ã®ãƒžã‚µã‚«ãƒªé›† ( ã®ã¤ã‚‚ã‚Š ) â— ã‚¦ãƒã®é–‹ç™ºè¨€èªžã¯ PHP > Java >> Ruby ã‚‰ã—ã„ã§ã™ â— ã‚¦ãƒã§ã¯ DBA ãŒã‚µãƒ¼ãƒãƒ¼ã®æ§‹ç¯‰ã€ Devs ãŒè¨è¨ˆãƒ» ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹ç¯‰ãƒ»é‹å–¶ã€ DBA ã¯ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆã‚„æ”¹ å–„ææ¡ˆ ( é‹ç”¨ ) ã€ã¨ã„ã†ã‚µã‚¤ã‚¯ãƒ«ã§å›žã—ã¦ã„ã¾ã™ã€‚
hiroyukim 2013/09/15
mysql

DB

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DBA
ãƒªãƒ³ã‚¯
ãªãœBTreeãŒIndexã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã‹ - maru source
â€»ã“ã®å†…å®¹ã¯å€‹äººçš„ãªè€ƒå¯Ÿãªã®ã§ã€é–“é•ã£ã¦ã„ã‚‹ç®‡æ‰€ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã†éƒ¨åˆ†ã‚’è¦‹ã¤ã‘ãŸéš›ã¯ãœã²æ•™ãˆã¦ä¸‹ã•ã„ã€‚ RDBMSã®æ¤œç´¢ã‚’æ—©ãã™ã‚‹ãŸã‚ã«Indexã£ã¦ä½¿ã„ã¾ã™ã‚ˆãã€‚ä¾‹ãˆã°ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE user ( id INT UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, UNIQUE INDEX (id) ); idã‚«ãƒ©ãƒ ã«Indexã‚’å¼µã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯idã§ã®æ¤œç´¢ã‚’é«˜é€Ÿã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ã“ã“ã§idã‚«ãƒ©ãƒ ã«IndexãŒè²¼ã£ã¦ã„ãªã„å ´åˆã¨æ¯”ã¹ã‚‹ã¨æ¤œç´¢æ™‚é–“ãŒå¤§å¹…ã«å¤‰ã‚ã£ã¦ãã¦ã—ã¾ã„ã¾ã™ï¼ˆç‰¹ã«ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå¤šããªã£ãŸæ™‚) ã§ã¯ãªãœIndexã‚’è²¼ã‚‹ã¨æ¤œç´¢ãŒæ—©ããªã‚‹ã‚“ã§ã—ã‚‡ã†ï¼Ÿï¼Ÿ Indexã¨ã¯ãã®åã®é€šã‚Šç´¢å¼•ã‚’æ„å‘³ã—ã¾ã™ã€‚ç‰¹å®šã®ã‚«ãƒ©ãƒ ã®ç´¢å¼•ã‚’ä½œæˆã—ã¦ãŠãã“ã¨ã§æ¤œç´¢ã‚’é«˜é€ŸåŒ–ã—ã¾ã™ã€‚ (æœ¬ã®æœ€å¾Œã«ã‚ˆã¿ãŒãªé †ã§å˜èªžãŒä¸¦ã¹ã‚‰ã‚ŒãŸã‚Šã—ã¦ã„ã¾ã™
hiroyukim 2013/09/12
index

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ

DB

RDBMS

btree
ãƒªãƒ³ã‚¯
GitHub - tokuhirom/UnQLite: Perl5 bindings for Unqlite.
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
hiroyukim 2013/07/03
å¾Œã§èªã‚€

db

unqlite
ãƒªãƒ³ã‚¯
RethinkDB: the open-source database for the realtime web
RethinkDB pushes JSON to your apps in realtime. When your app polls for data, it becomes slow, unscala ble, and cumbersome to maintain. RethinkDB is the open-source, scala ble database that makes building realtime apps dramatically easier. What is RethinkDB?go
hiroyukim 2013/06/18
db

C++
ãƒªãƒ³ã‚¯
GitHub - google/leveldb: LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.
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
hiroyukim 2011/06/02
ãƒªãƒ³ã‚¯
LevelDBã‚’èªã‚€äººãŸã¡
SKS rep @repeatedly ã‚ï¼ŒWALä½¿ã£ã¦ãªã‹ã£ãŸï¼Žã—ã‹ã—ã©ã†ã‚„ã£ã¦éžåŒæœŸã«ãªã£ã¦ã‚“ã ï¼Ÿæ™®é€šã«memcpyã¨ã‹ã—ã¦ã‚‹ã‚ˆã†ã«ã—ã‹è¦‹ãˆã‚“ãŒâ€¦ 2011-05-17 03:22:15
hiroyukim 2011/05/18
C++

togetter

èªã‚€

DB
ãƒªãƒ³ã‚¯
1