JJUG CCC 2009 fall ã«è¡ã£ã¦ãã¾ãã
ã¹ã¼ãã¼å°é¢¨ãç´æããå±±æç·ãã¯ãã主è¦äº¤éæ©é¢ãå ¨é¢çã«ã¹ããããããªããCCC ã¯ååä¸ 30 åé ãã«ãªã£ããã®ã®ãåºæ¬çã«ã¤ã¤ããªãé²è¡ãããããã
é ç¥ã»ã®äºå£ããã®åºèª¿è¬æ¼ã«ä½ã¨ãæ»ãè¾¼ã¿ãã»ã«ã¤ã«ã¡ã©ã®éæãèããªãããä¼å ´ã«ãã¿ã£ã¨ã¨ã¢ã¿ã°ãè²¼ã£ãããã¦ãã¾ããã :-p
åå¾ã®ã»ãã·ã§ã³æåã®ãæ¥çµBP社 / æ¥çµã³ã³ãã¥ã¼ã¿ã®ä¸ç°æ¦ããã®ã話ãå人çã«ã¯ã¨ã¦ã楽ããã£ãã®ã§ãå°ã詳ããã«ã¡ã¢ãæ®ãã¦ããã¾ãã
# èãééããåéãããããããããªãã®ã§ãã容赦ãã ããã
ãã¼ã¿ã»ã³ã¿ã¼è¦ç¹ã§æ¯è¼ããã¯ã©ã¦ãã®å å´
- ä¸ç°ãã
- æ¥çµã³ã³ãã¥ã¼ã¿ã¯ã©ã¦ãæ å½
- èæ¸: クラウド大全 サービス詳細から基盤技術まで
- ãã®ä»ãæ¥çµã³ã³ãã¥ã¼ã¿ã® Google ç¹é㧠"Google ã¯ç°å½¢ã®ã¡ã¼ã«ã¼" ã¨ã
- (ããè¨ãã°ãErlang User Conference ã®ã¨ãã«ååºäº¤æãããª...)
- åé¡æè
- ãªãã¯ã©ã¦ãã使ãã®ã
- å®ãããã¨ããã®ã¯èª¤è§£
- ã¯ã©ã¦ããæä¾ããã¢ããªã®ã»ãããPC ã®ã¢ããªããåªç§ã ãã
- CPU ãã¡ã¢ãªããã£ã¹ã¯ããã¹ã¦æ§è½ãä¸
- æ¤ç´¢ã¨ã³ã¸ã³ãGoogle Mapsã...ã¨ããã¼ã«ã«ã¢ããªã¨ãã¦å®ç¾ãããã¨ããã大å¤ã ãã
- Web ãã©ã¦ã¶ä»¥å¤ã§ã®å©ç¨ãå¯è½ã«
- Google ãæä¾ããã¢ããªã±ã¼ã·ã§ã³ã¯ãªãé«éãªã®ãï¼
- Ken Thompson æ°:ãéè¦ãªã®ã¯ã¯ã©ã¦ãã³ã³ãã¥ã¼ã¿ã Google ã«ãããã¨ã
- å人ããã¡ããªãè¶ é«éã³ã³ãã¥ã¼ã¿ããããã¤ãã£ãã¨ããæå³ã§ç°å½¢ã®ã¡ã¼ã«ã¼
- ãµã¼ãçç£å°æ°
- DELLãHP ã«ç¶ãã¦ä¸ç 3 ä½ã®å¯è½æ§!!!
- ãã¼ã¿ã»ã³ã¿ã¼ã§ã¯ 300 ä¸å°ã稼åãã¦ãããããå¹´ã«æ°ç¾ä¸å°çç£ãã¦ããã¯ã
- ä¸ççã«ã¯ãå¹´é 800ä¸å°ã®ãµã¼ããçç£
- MS,Google,Amazon,Yahoo! ã® 4社㧠20%ãç´ 150ä¸å°ã®ãµã¼ãã 1å¹´ã§è³¼å ¥ï¼
- Google ã®å
é²æ§
- 2006å¹´ã« Project Black Box ã Sun ãçºè¡¨ããã¨ã誰ã使ãã®ï¼ã¨æã£ããã
- å®ã¯ 2005å¹´ 11æãã Googleã¯ãã§ã«éç¨ãã¦ãã!?
- å»å¹´ã®ä»é ã«ã¯ãæ½®åçºé»ã®æ°´ä¸åãã¼ã¿ã»ã³ã¿ã¼ã®ç¹è¨±ãã¨ã£ã¦ãã...
- ããã§ãã¤ã¤ããã®ãããããªã
- Google ãµã¼ã
- ãã¼ãPC ã®ããã« 12V ã®ããããªã¼å èµ
- UPS 使ããªã
- 200 or 400 V ã§èé»ãã¦ãç¡é§ãªã®ã§ããã¶ã¼ãã¼ãã®ãã°ã§èé»ããã»ããå¹çãé«ã
- é»åå©ç¨å¹ç
- PUE
- å·å´ã³ã¹ããé«ãã»ã©å¤ã大ãããªã£ã¦ãã¾ã
- Google 㯠1.2 ãå®ç¾
- æ¥æ¬ã®æ¨æºçãªãã¼ã¿ã»ã³ã¿ã¼ã¯ PUE 2.3 - 2.5 ã¨ã
- IBM ã®ææ°é㧠1.8ãæ¥ç«ã®ææ°é㧠1.6
- ã§ãããã¯è¨ç»å¤ã§ããããã¼ã¿ã»ã³ã¿ã¼ãæºåºã«ãªããªãã¨ã ã
- Google ã¯ãã§ã«å®æ¸¬å¤ãªã®ãããã
- å½±é¿ãåãã¦ããã®ã¯ãã¤ã¯ãã½ãã
- Gmail 1GB ã®ã¨ããMS 㯠25MB
- 追ãä»ããã¨ãããã追ãä»ããªã
- MS ã¯çµç¹ãå ¨é¢å¤æ´ããã³ã¿ã¼ã»ã³ã¿ã¼éç¨é¨éãå é¨ã«ãã£ã
- ATOM æè¼ãµã¼ã㯠DELL ãã¤ãã£ã¦ãããã
- äºé建ã³ã³ãããµã¼ãããã¹ã¦ MS ã®ããã«ã¤ãã£ã¦ãã·ã«ã´ã®ãã¼ã¿ã»ã³ã¿ã¼ã«ç´å ¥ããã¦ãã
- MS ã®ãã¼ã¿ã»ã³ã¿ã¼é¨éãè¨è¨ãããã®ããDELL ã«ã¤ãããã¦ããã£ã½ã
- Amazon
- ãã¼ã¿ãå ¬éããã¦ãªãã®ã§è¦æ¨¡ãæ¨æ¸¬ãã¦ã¿ã
- Rackable System (ç¾ SGI)ã®ãµã¼ãå£²ä¸ 2å5åä¸ãã«ã®ãã¡ 35% ã Amazon
- 1年㧠2ä¸5åå°ããã調éãã¦ããã¯ã
- ã¨ãªãã¨ãã¼ã¿ã»ã³ã¿ã¼çã«ã¯ 7-10ä¸å°ãããããã¯ã
- æè¿ã¯ Amazon ãèªä½ãã¯ãããã¨ããåãã§ã¦ãã
- Yahoo!
- æ¬ç¤¾åã«ã³ã³ããåãã¼ã¿ã»ã³ã¿ã¼
- ãªã㧠Hadoop ã¾ããã¦ãï¼
- SGI ã® ICEcube ã§æ°´å·æ¹å¼
- ã³ã³ãã 1å°ããã 2400å°
- ã¹ãã¬ã¼ã¸å®¹éã 1å°ã§ãã¿ãã¤ãç´
- MS ã®ã·ã«ã´ã®ãã¼ã¿ã»ã³ã¿ã¼
- ã³ã³ãã 112å° (å½å㯠200å°ã®äºå®ã ã£ã)
- ãµã¼ã 22ä¸4000å° (äºå®ã¯ 50ä¸?)
- ã³ã³ããåãã¤ããçç±
- å·å´å¹çããã
- ã©ãã¯ã«ãã¦ã³ãããã³ã¹ããã°ãã«ãªããªã
- å¹´éä½åä¸å°ããããã¤ã§ããªã
- ã©ã¼ãã¨é§è»å ´ã®ãããªåºãå ´æã«ã³ã³ããã並ã¹ãã ã
- 第åä¸ä»£ãã¼ã¿ã»ã³ã¿ã¼æ§æ³
- 建ç©ãã¤ãããã«ã³ã³ãããéæãã§ããã ã
- HP, DELL, IBM 㯠Google ã 3å¹´é ããããã§ããããã¦ãã®ãç¾ç¶
- ã·ã«ã´ã®ãã¼ã¿ã»ã³ã¿ã¼ã®è¦æ¨¡æ
- æ¥æ¬ã®å¹´éã®PCãµã¼ãã®åºè·ä»£æ° 55ä¸å°
- ã·ã«ã´ãã¼ã¿ã»ã³ã¿ã¼ã30 - 40ä¸å°
- 50M ã¯ããã®å¹´éé»æ°æé㯠110åå (æ±äº¬é»å)
- 1ãµã¼ããããã100-150 ã¯ãã
- ATOM ã¨ã ARM ã¨ã
- ATOM ã¯è¶ ä½æ¶è²»ãæ°åã¯ããï¼
- James Hamilton 㯠ARM ããã»ããµã§ãµã¼ããã¤ããã¨ãè¨ã£ã¦ã
- LADIS (Large-Scale Distributed Systems and Middleware) ã§ãã¼ãã¼ãããã¹ã£ãã²ã¨
- http://mvdirona.com/jrh/TalksAndPapers/JamesRH_Ladis2008.pdf
- ATOM 㯠ECC ã¡ã¢ãªã«å¯¾å¿ãã¦ãªãããARM ã¯å¯¾å¿ãã¦ãã (ãµã¼ãã«ãããã)
- ãã㦠ARM ã¯è¶ è¶ ä½æ¶è²»ã2W..!?
- The Data Center as a Computer
- ä½è : Luiz Andre Barroso,Urs Holzle
- åºç社/ã¡ã¼ã«ã¼: Morgan and Claypool Publishers
- çºå£²æ¥: 2009/08/15
- ã¡ãã£ã¢: ãã¼ãã¼ããã¯
- ã¯ãªãã¯: 17å
- ãã®ååãå«ãããã° (2件) ãè¦ã
- ãã©ã¼ã¬ã¹
- Google ã®ãã«ã®ã¼ã®ãã¼ã¿ã»ã³ã¿ã¯ãã©ã¼ã¿ã¯ã¼ããªã
- é«ãã¨ãã«æ°´ãéãã§è½ã¨ããã¨ã§æ°åç±ã§å·ã¾ããããããã©ã¼ã¿ã¯ã¼
- ãã«ã®ã¼ã¿ããæ°´ãè±å¯ãªã¨ãã§ã¯ãããä¸è¦
- å·ããæ°´ãã²ãã¦ãã£ãããã¾ã¾è¿ãã®ããªï¼ (^^;
- ããã«ãå¯ãã¨ãã«ãã¼ã¿ã»ã³ã¿ã¼ã¤ãããã¨ã§å·å´ã³ã¹ããªãã«ãããã¨ãã¦ã
- éã«ãå·ããå¿
è¦ã¯ãªã!?
- ãã¼ã¿ã»ã³ã¿ã¼ã¯ã27 - 29 度ãæé©ã¨ãè¨ã£ã¦ãã by Google
- ææ°50度æªæºãªããã¼ããã£ã¹ã¯æ¸©åº¦ã¨æ éçã«ç¸é¢é¢ä¿ã¯ãªã
- ãµã¼ãã«ã¼ã ã®é«æ¸©å競äº
- ãããã°ãªã¼ã³IT ww
- ãã°ãªã¼ã³ãã¼ã¿ã»ã³ã¿ã¼ã
- ãµã¼ãã®ç®¡ç
- MS ã§ã¯ 1人ã®ç®¡çè ã 5000å°ã管ç
- ãããããµã¼ãã¯ä¿®ç/交æããªããå®æçãªã¡ã³ããã³ã¹æã«ã®ã¿äº¤æãã
- ãµã¼ãã®ã¡ã³ããã³ã¹ã¯ãããå¦ççã«è¡ã£ãã»ããå¹çç
- Amazon ã§ã Google ã§ããããã¦ãããã
- 50ä¸å°ãã£ã¦ã100人ã§ç®¡ç
- ã·ã«ã´ã®åµåºéç¨ã¯50人ãã100人ï¼
- èªè´ãã¦ãç¡é§..w
- èªå主義
- ä¸çªå¤§äºãªãã¼ã¿ã»ã³ã¿ã¼ã®ããããã£ã¯ãªã¼ãã³ã«ãã¦ãªã
- Android ã¯ããæå³ã©ãã§ãããé¨å
- ã巨大ãªã¯ã©ã¹ã¿ãä¿æããªããµã¼ããã¼ãã£ãã½ããã¦ã§ã¢ããããã¤ããã½ããã¦ã§ã¢ã®ãã¹ãããã¥ã¼ãã³ã°ãååãªæ°´æºã§è¡ãã®ã¯å°é£ã ã
- OS ã¬ã¤ã¤ãããã¨ããããããã¯ãCluster-Level Infrastructureãã®ãã¨ã
- Linux 㯠OS ã ã¨æã£ã¦ãªãï¼
- ProLiant ã®ä¾¡æ ¼æ§è½æ¯ã¯ãSuperDome ã®4å
- ã©ããªå¤§ã㪠SMP ãµã¼ãã§ã1å°ã§ã¯ã¾ããªããããªã
- ã¬ã¤ãã³ã·ã¯LANã«éç´ãããã®ã§ãSMP ãµã¼ããå©ç¨ããã®ã¯ç¡é§
- ããã»ããµä½¿ç¨çãé«ãã»ã©æ¶è²»é»åå¹çãè¯ã
- ã¤ã¾ããå®ãé ãã»ãããã
- Google ã«ã¨ã£ã¦ã®é害 (ä¸ããé ã«éã)
- åªå¤±ããã¼ã¿ãåçæã§ããªã
- æªå°éããµã¼ãã¹ããã¦ã³
- å£åããµã¼ãã¹ã¯ä½¿ãã¦ãããå£åãã¦ããç¶æ
- é è½ãS/W H/W ã§åé¡ãã«ãã¼ã§ãã¦ãç¶æ
- ã¹ã«ã¼ãããæåã¨ã¬ã¹ãã³ã¹æå
- 両ç«ã§ããªãã¨ãããªã
- MapReduce ããã¾ãããã®ã¯æ°åå°ãé£æºããªããããã¾ãããã対é害æ§
- Salesforce CTO
- è¿ãå°æ¥ Oracle ããªããªããããããªã
- ã¯ã©ã¦ããã¼ã¹ã®ãã¼ã¿ãã¼ã¹ã®æ代ã®å°æ¥ãäºæãã¦ãã
- Oracle ã¹ã£ãããªã¨ããããGoogle ã®ãããããã¨ãå ¥ãã¯ããã¦ã
From SQL way to Bigtable way by ã²ãããããã
ã¯ã©ã¦ãã«ãããã¹ã±ã¼ã«ã¢ã¦ãè¨è¨ãæãä¸ãã by è©åæ£ç¾©ãã
- Azure ã«ã¯ SQLAzure ãããããã
- ã¹ã±ã¼ã©ããªãã£ã¯å£ãããæ¢åè³ç£ã®ç§»è¡ã§ã¯ä¾¿å©
- ã¯ã©ã¦ãã®ä½¿ç¨æã¨ãã¦ã¯ RDBMS ã¯ããªãé«ã
- èªåã§ãã£ãã»ããå®ããªãw
- ã¯ã©ã¦ãã®ã¢ããªã±ã¼ã·ã§ã³ã¢ã¼ããã¯ãã£ãã©ãèããã
- æ¦å¿µã¢ãã«ãããã¼ã¿ã¨ãã¼ã¿ã®é¢ä¿æ§
- æå³ãã³ã³ããã¹ã
- é¢æ°å¾å±æ§ãæ£è¦å
- ã¦ã¼ã¹ã±ã¼ã¹ããä¸è²«æ§ã®æ¡ä»¶
- ãã©ã³ã¶ã¯ã·ã§ã³ã¨ããããã¡ã§ã¢ãã«å
- ACID ã§ã¯ãªããä¸è²«æ§è¦æ±ã«ãã¨ã¥ãããã®
- ä¸è²«æ§ã«å¯¾ããè¦æ±ã®å¼·å¼±ã«å¿ãã¦ã¢ãã«å
- Immediate/Eventually/No Consistency
- åç §/æ´æ°ãCRUDãã¢ã¯ã»ã¹é »åº¦
- 並åæ§ãå¯ææ§
- ãã¹ãå¯è½æ§
- ä¿å®æ§ãé å¸
- æ¦å¿µã¢ãã«ãããã¼ã¿ã¨ãã¼ã¿ã®é¢ä¿æ§
ã¯ã©ã¦ãã¢ããªã±ã¼ã·ã§ã³ã®ã¤ããæ¹
- edge2.cc ã®æµ
æµ·æºæ´ãã
- ã¢ãã«é§åéçºÃã¯ã©ã¦ãã³ã³ãã¥ã¼ãã£ã³ã°ã®å®è¨¼ããã¸ã§ã¯ã
- GAEJ
- åºæ¬çã«ã¯ Servlet ã³ã³ãã
- 使ç¨ã§ãã API ãéããã¦ããã®ã§ãã¬ã¼ã ã¯ã¼ã¯ãªã©ã¯å®å ¨ã«åä½ããªã
- RDBMS ãµãã¼ãããªããKVS ã®ã¿
- ã¹ã¬ããã¯ä½¿ç¨ã§ããªã
- MOM ã¯æªãµãã¼ã
- Cron ã«ããå®æçå®è¡
- 1.2.5 ãã experimental ã¨ã㦠TaskQueue ããµãã¼ã
- GAEJ ã§éçºãã¦ã¿ãçµé¨ãã
- REST ã§ããã®ã楽
- MVC2 (Webã¢ããªã±ã¼ã·ã§ã³åã)ãããMVC (GUIã¢ããªã±ã¼ã·ã§ã³åã)
- ãµã¼ãå´ã®éçºææ³ã¯æ¢åã® F/W ãå©ç¨ã§ããªãã®ã§å¤ãããã
- HTML5 & RESTããããã¯æ·å± ãé«ããã° GWT ãåè£ã
- ã¡ãã»ã¼ã¸æåãããã㯠Apache Camelï¼
- SimpleModeler ã®è©±
- TwitterRecommender ã®è©±
æå¾ã¯ã©ã¤ãã³ã¼ãã£ã³ã°ãå°ãè¦ãã¤ã¤ãå¼ãããã¦ãã¾ããã¼ãslim3 ã wicket ã®ã©ã¤ãã³ã¼ãã£ã³ã°ãè¦ããã®ã¯é¢ç½ãã£ãã§ãã
ã¹ã¿ããã®çæ§ãè¬æ¼è ã®çæ§ããã¤ãããã¾ã§ããã
Redmine ã§æ·»ä»ãã¡ã¤ã«ã¯ãã¼ã¿ãã¼ã¹ã«æ ¼ç´ããªãã®?
先日の記事ã§ãã¡ãã£ã¨æ¸ãã¦ãã¾ããããRedmine ã§ã¯ãã±ããã¸ã®æ·»ä»ãã¡ã¤ã«ãææ¸ã®ç»é²ãã¾ã Wiki ã«è²¼ãä»ããç»åããã®ä»ã®æ·»ä»ãã¡ã¤ã«ã¯ãREDMINE_ROOT 以ä¸ã® files ãã©ã«ãã«æ ¼ç´ããã¾ãã
ãã±ããã¸ã®æ·»ä»ãã¡ã¤ã«ã®è¿½å
- (snip)
- æ·»ä»ãã¡ã¤ã«ã¯ REDMINE_HOME ã®files 以ä¸ã«ãã¡ã¤ã«åã« prefix ãã¤ãã¦æ ¼ç´ããã
- ããã¯ææ¸ããã以å¤ã§ã®æ·»ä»ã®ã¨ãã§ãåã
æ¹ãã¦èãã¦ã¿ãã¨ãæ·»ä»ãã¡ã¤ã«çã ãããã£ã¹ã¯ã§ç®¡çãããã®ã¯ã以ä¸ã®åé¡ãããããã«ãæãã¦ãã¾ãã
- ããã¯ã¢ãã
- è¤æ° Redmine ã®ã¤ã³ã¹ã¿ã³ã¹ããã¦ãå ´å
ãã¼ã¿ãã¼ã¹ã ãã§ãªã files 以ä¸ãå¿ããã«ããã¯ã¢ããããªãã¨ãããªãã®ã¯å¾®å¦ã«é¢åã§ãããã¯ã©ã¹ã¿ãçµãã å ´åã«ãã¼ã«ã«ãã£ã¹ã¯ç®¡çã®æ·»ä»ãã¡ã¤ã«ãã»ãã®ã¤ã³ã¹ã¿ã³ã¹ããã©ãåç
§ããã? ã¨ãã£ãåé¡ãã¤ãã¦ã¾ããã¾ãã
Redmine.JP ã§ãApache上でRuby on Railsアプリケーションを動かす/Passenger(mod_rails for Apache)の利用ããªãã¦è¨äºãè¦ããã¾ããããè¤æ°ã¤ã³ã¹ã¿ã³ã¹ã並å稼åããããã¨ã«ããã¬ã¹ãã³ã¹ã®æ¹åã«ã¯è¨åããã¦ãããã®ã®ãæ·»ä»ãã¡ã¤ã«ã¾ããã®è§£æ±ºã«ã¤ãã¦ã¯ã¨ãã«è§¦ãããã¦ãªãã£ãããã¾ãã
ã§ããããªãã¨ã¯ãã§ã«èª°ããèãã¦ãã ããã¨æã£ã¦ãWeb ãæ¼ã£ã¦ãããã©ã¼ã©ã ã§æ¬¡ã®æ稿ãè¦ããã¾ããã
Adding the attachments to the database means one entity to backup, one entity to restore (or migrate). Also allows redmine to be proxied across machines in a cluster for load balancing without doing special filesystem sharing.
2008å¹´ã®4æé ã«èµ·ç¥¨ããã¦ããã§ã«ã¯ãã¼ãºã¨ãªã£ã¦ãããã±ããã§ãã (^^;
ä¸è¨ã®ã¨ãããæ·»ä»ãã¡ã¤ã«ããã¼ã¿ãã¼ã¹ã«æ ¼ç´ã§ããããã«ãã¦ã»ãããã¨ãã£ãè¦æãªã®ã§ããã
... ããããæç² & é©å½è¨³ ...
The idea of storing files in the db may have some merit, but this is clearly a design decision and not a defect.
æ·»ä»ãã¡ã¤ã«ããã£ã¹ã¯ã«ç®¡çããããã«ããã®ã¯ãè¨è¨ä¸ã®å¤æã
This would make an excellent feature as a configurable option for the reasons Carl mentioned.
è¨å®ãªãã·ã§ã³ã§åãæ¿ããããã£ã¦ã®ã¯ãããã
Storing standalone files in databases is just totally missing the point of what filesystems are made for. I admit one might like the idea of a single-point, network-enabled, access to all the data. But putting blobs in the DB is a poor design, really. Jean Philippe was right in his design.
If you want single-point access to the data, accessible through network, do not put blobs in the DB, this will not be the correct design. Better write an abstraction client/server layer, let's call this a proxy, between RedMine data access and actual data storage. You might find inspiration from the ZEO / ZODB design for Zope, although I would not recommend to mimic it entirely.
DB ã« blob ã§ãã ã¤ã£ããã£ã¦ã®ã¯ã¤ã±ã¦ãªãè¨è¨ã ãã
ãããã¯ã¼ã¯è¶ãã«ã¢ã¯ã»ã¹ã§ããããã«ããããªããblob ã«ã¤ã£ããã®ã¯æ£ããè¨è¨ãããªããã¯ã©ã¤ã¢ã³ã/ãµã¼ãã¼ãªæ½è±¡å層ãæãã ã»ããããããRedmine ã®ãã¼ã¿ã¢ã¯ã»ã¹ã¨å®éã®ãã¼ã¿ã¹ãã¬ã¼ã¸éã®ãããã·ã¨å¼ã¹ããã®ããã®çºæ³ã¯ Zope ã® ZEO / ZODB ãããå¾ããããããã çä¼¼ããã£ã¦ã®ã¯ãããããããªããã©ãã
I can think of a lot of good reasons to not toss files into the database:
- It balloons the db size, making backups take longer.
- It puts extra work on the db, which has plenty to do as is.
- It means files would have to be serialized through rails (because there is no file for the webserver to point to) -- which means that rails process will block incoming web requests while the file is being downloaded. There are ways around this, but they are really hackish, or don't lend well to simple deployments.
- There are a ton of database "gotchas" that ActiveRecord can't abstract away when dealing with blobs.
Plus, backing up files is exceedingly easy. Just rsync them to another box. I admit it might not be blatantly obvious that you need to do it, but I think that's a point for documentation rather than creating a ton of work with little real-world benefit.
If you need single-point access to the data over a network, just use a NFS/SMB share. It is plenty fast for attachments.
ãã¡ã¤ã«ããã¼ã¿ãã¼ã¹ã«æ ¼ç´ããªãã»ããããçç±ãããããæãã¤ããã
DB ã®ãµã¤ãºãå¢ãããããã®åããã¯ã¢ããæéãããããä½è¨ãªä»äºã DB ã«ãããããªãããã¡ã¤ã«ã¯ Rails ã§ã·ãªã¢ã©ã¤ãºããããã¨ã«ãªããããã¡ã¤ã«ããã¦ã³ãã¼ãããã¦ãé㯠Rails ããã»ã¹ããããã¯ããããAR 㯠blob ãæ½è±¡çã«æ±ããªããã¨ããã
ãã¡ã¤ã«ãããã¯ã¢ããããã®ã¯ãã£ã¨ç°¡åãå¥çä½ã« rsync ããã°ãããè¤æ°ã¤ã³ã¹ã¿ã³ã¹ããã¦ãå ´åã¯ãNFS ã SMB ã§å
±æããã°ããããããéãããã
If it's a bad idea, then I suggest dropping the feature. If so, I'll file feature request for configurable storage location and a backup script that backs up the db, attachment files, and configuration to some specified location.
æ ¼ç´å ´æãè¨å®å¯è½ããã¨ããDB / æ·»ä»ãã¡ã¤ã« / è¨å®ãã¡ã¤ã«ãªã©ãããã¯ã¢ããããã¹ã¯ãªãããã»ãããã
I've added a few words about this at the end of RedmineInstall guide.
(ãããªæãã®ã¹ã¯ãªããã) Redmine ã¤ã³ã¹ãã¼ã«ã¬ã¤ãã®æå¾ã«ã¡ãã£ã¨è¿½è¨ãã¨ããã
... ããã¾ã§ ...
ã£ã¦ãªæãã§ãã±ããã¯ã¯ãã¼ãºãã¦ãã¾ãã
å®éãã¤ã³ã¹ãã¼ã«ã¬ã¤ããè¦ã¦ã¿ãã¨ããããªæãã
Installing Redmine
Backups
Redmine backups should include:
- data (stored in your redmine database)
- attachments (stored in the files directory of your Redmine install)
Here is a simple shell script that can be used for daily backups (assuming you're using a mysql database):
# Database
/usr/bin/mysqldump -u-p | gzip > /path/to/backup/db/redmine_`date +%y_%m_%d`.gz # Attachments
rsync -a /path/to/redmine/files /path/to/backup/files
æã家㫠iPhone ããã£ã¦ãã¾ãã
RubyKaigi2009 ã®æ親ä¼ã§æ£ã Bump ãã¦ã姿ãè¦ãã¤ããããçµæããã£ã±ã欲ãããªã£ã¦ç¨è°ãéãã¦ãã¾ãã¾ããã (^^;
ã±ã¼ã¹ã¯ã²ã¨ãããæ©ãã çµæãã·ã³ãã«ãªã¨ããã«è½ã¡çãã¾ãããã§ã...
- ã±ã¼ã¹ã¨ãã£ã«ã ã®è£ ç
- iPhone ã® OS ãã¼ã¸ã§ã³ã¢ãã
- Wifi ã®è¨å®
- Gmail ã®ã¢ã«ã¦ã³ãè¨å®
- é»è©±å¸³ã®ã³ãã¼
- å¿ è¦ãããªã¢ããªãã©ã©ã£ã¨ã¤ã³ã¹ãã¼ã«
- ã¢ããªã®ä¸¦ã³æ¿ã (ä»ããã©ãå«ã㦠80 åããã)
- æããªã£ã¦ãã¹ã³ã¼ãå°å ¥..
- twitter ã楽ãããªã£ã¦ãã
- iPhone SDK å°å ¥
- ä½ãã¤ãã£ã¦ã¿ãããªã£ã¦ãã â ãã¾ãã
ãªæãã§ãã
# SnowLeopard ãã»ãããª...
SHIELD iShell for iPhone 3G/3GS ã·ã§ã«ã«ãã¼ ãããã»ã¬ãã
- åºç社/ã¡ã¼ã«ã¼: SHIELD
- ã¡ãã£ã¢: ã¨ã¬ã¯ãããã¯ã¹
- è³¼å ¥: 1人 ã¯ãªãã¯: 18å
- ãã®ååãå«ãããã° (2件) ãè¦ã
ãã¯ã¼ãµãã¼ã ã¢ã³ãã°ã¬ã¢ãã£ã«ã ã»ãã for iPhone 3G PPC-02
- åºç社/ã¡ã¼ã«ã¼: ãã¯ã¼ãµãã¼ã
- çºå£²æ¥: 2008/08/19
- ã¡ãã£ã¢: ã¨ã¬ã¯ãããã¯ã¹
- è³¼å ¥: 90人 ã¯ãªãã¯: 990å
- ãã®ååãå«ãããã° (40件) ãè¦ã
- ãã¨ã§ãã
- å¥ç´ãã©ã³ã®å¤æ´
- ãã£ã³ãã¼ã³ç¹å ¸ã®é©ç¨
9arrows ã (MySQLã§) 試ãã¦ã¿ã¾ãã
æ¬å®¶ãã 9arrows ã®ææ°çãè½ã¨ãã対å¿ãããã¼ã¸ã§ã³ã® Rails ãå ¥ãã¦ããã¾ãããã¼ã¿ãã¼ã¹ã«ã¯ PostgreSQL ã使ç¨ããã¿ããã§ãããä»å㯠MySQL ã§å¼·å¼ã«åããã¦ã¿ã¾ãã
% svn co http://9arrows.googlecode.com/svn/trunk/ 9arrows % gem install rails -v 2.1.0
æ©éãdatabase.yml ãæ¸ãæ¿ãã¦ãrake ã³ãã³ãããããã¾ãããããã®åã« MySQL ã«ãã¼ã¿ãã¼ã¹ãç¨æããªãã¨ãããªãã§ããã
development: adapter: mysql database: 9arrows_development username: root password: host: 127.0.0.1 (snip)
% mysql -u root -p mysql> create database 9arrows_development; mysql> create database 9arrows_production; mysql> create database 9arrows_test; mysql> exit; % cd 9arrows % rake db:schema:load
rake ã³ãã³ãã®çµæãè¦ãã«ããã¼ãã«ã®ä½æã¯ãã¾ããã£ã¦ã¾ãããåæãã¼ã¿ã®ç»é²ã§å¤±æãã¦ããã£ã½ãã§ããããã§ãschema.rb ã®ä¸ã§ execute ã§å¼ã°ãã¦ããä¸èº«ãæåã¤ã³ãµã¼ããããã¨ã«ãã¾ããã¡ãªã¿ã«ãdatetime ã®ãã©ã¼ãããã PostgreSQL ã¨å¾®å¦ã«éãã®ãããã®ã¾ã¾ã ã¨ã¤ã³ãµã¼ãã§ããªãã£ãã§ãã¡ããã£ã¨ã ãæãå ãã¦ã¾ããã
-INSERT INTO mst_messages VALUES (2, 'project_name', 1, 'ããã¸ã§ã¯ãå', 'ããã¸ã§ã¯ãå', 'ããã¸ã§ã¯ãå', 'ããã¸ã§ã¯ãå', 1, NULL, '2007-07-08 19:32:00+09', NULL, '2007-07-08 19:39:20.984+09'); +INSERT INTO mst_messages VALUES (2, 'project_name', 1, 'ããã¸ã§ã¯ãå', 'ããã¸ã§ã¯ãå', 'ããã¸ã§ã¯ãå', 'ããã¸ã§ã¯ãå', 1, NULL, '2007-07-08 19:32:00', NULL, '2007-07-08 19:39:20.984');
ä½æãããã¼ã¿ãã¼ã¹ã«æµãè¾¼ã¿ã¾ãã
% rake db:schema:load > insert.sql (ä¸è¿°ã®ããã«ã¡ãã£ã¨ããã£ã¦...) % mysql -u root -p mysql> use 9arrows_developemt; mysql> charset utf8; mysql> source insert.sql; mysql> exit;
"ERROR 1366 (HY000): Incorrect string value" ãããã®ã¨ã©ã¼ãã§ã¦ããã¾ãè¡ããªã«ãããªãæåã³ã¼ãã®ç¢ºèªãã
mysql> show variables like 'character%'; +--------------------------+-------------------- | Variable_name | Value +--------------------------+-------------------- | character_set_client | utf8 | character_set_connection | utf8 | character_set_database | utf8 | character_set_filesystem | binary | character_set_results | utf8 | character_set_server | utf8 | character_set_system | utf8
ãã¦ããã®ã¾ã¾ã 㨠auto increment 㪠id ãå¢ãã¦ããªãã¨æãã®ã§ãsequence ã® current å¤ãå¤æ´ããã㨠setval ããããå¼ã³ãããªãã¨æã£ãã®ã§ããããããªé¢æ°ã¯ãªãã¨æããã¾ãã
mysql> SELECT setval('mst_messages_id_seq', max(id)) FROM mst_messages; ERROR 1305 (42000): FUNCTION 9arrows_development.setval does not exist
ãããã£ï¼ã¨æããã²ã¨ããã調ã¹ã¦ã¿ã¾ããããã©ããã MySQL ã§ã¯æ±ããªãããã§ããã©ããããããªã..ã¨æããã®ã®ãshow table status ã§ç¢ºèªãã¦ã¿ãã¨ãã¡ãã㨠auto increment ããã¦ããã§ã¯ãªãã§ãã!ï¼
MySQL ã§ã¯ãããã¦å¼ããã§ãããã£ããããã§ãã (^^;
mysql> show table status; +-------------------+------+----------------+-------------+----------------+ | Name | Rows | Avg_row_length | Data_length | Auto_increment | +-------------------+------+----------------+-------------+----------------+ | dat_calls | 0 | 0 | 16384 | 1 | | dat_callusers | 0 | 0 | 16384 | 1 | | dat_eventfiles | 0 | 0 | 16384 | 1 | | dat_events | 0 | 0 | 16384 | 1 | | dat_eventusers | 0 | 0 | 16384 | 1 | | dat_milestones | 0 | 0 | 16384 | 1 | | dat_mylogcmts | 0 | 0 | 16384 | 1 | | dat_mylogs | 0 | 0 | 16384 | 1 | | dat_projectcomps | 0 | 0 | 16384 | 1 | | dat_projectlogs | 0 | 0 | 16384 | 1 | | dat_projects | 0 | 0 | 16384 | 1 | | dat_projectusers | 0 | 0 | 16384 | 1 | | dat_taskcmts | 0 | 0 | 16384 | 1 | | dat_taskfiles | 0 | 0 | 16384 | 1 | | dat_taskhistories | 0 | 0 | 16384 | 1 | | dat_tasks | 0 | 0 | 16384 | 1 | | dat_taskusers | 0 | 0 | 16384 | 1 | | mst_compositions | 29 | 564 | 16384 | 30 | | mst_messages | 175 | 374 | 65536 | 198 | | mst_templates | 2 | 8192 | 16384 | 3 | | mst_tpevents | 3 | 5461 | 16384 | 4 | | mst_tpmilestones | 4 | 4096 | 16384 | 5 | | mst_tptasks | 22 | 744 | 16384 | 23 | | mst_users | 1 | 16384 | 16384 | 2 | +-------------------+------+----------------+-------------+----------------+ 24 rows in set (0.02 sec)
ã¨ãããã¨ã§ãåé¡ãªããããªã®ã§æ°ãåãç´ãã¦èµ·åãã¦ã¿ã¾ãã
# å¿
è¦ãããã°ãtestãproduction ç°å¢ãåæ§ã«è¨å®ããä»å㯠development ã ãã§é²ãã¾ãã
% ruby script/server => Booting Mongrel (use 'script/server webrick' to force WEBrick) => Rails 2.1.0 application starting on http://0.0.0.0:3000 ... DEPRECATION WARNING: config.action_view.cache_template_extensions option has been deprecated and has no affect. Please remove it from your config files. See http://www.rubyonrails.org/deprecation for details. (called from send at c:/ruby/ruby-186-25/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/initialize r.rb:455)
ãªãã¦ãã°ãåºã¦ãã¾ãããã¨ããããç¡äºèµ·åããããã§ãã
http://localhost:3000/ ã«ã¢ã¯ã»ã¹ããã¨ããã°ã¤ã³ID/ãã¹ã¯ã¼ããæå®ãã¦ãã°ã¤ã³ããããæ°è¦ã¦ã¼ã¶ã¼ãç»é²ãããã¨ã«ãªãã¾ããæ°è¦ã«ã¦ã¼ã¶ã¼ãç»é²ããã«ã¯ã¡ã¼ã«ãµã¼ãã®è¨å®ã¨ãããã¦ãããªãã¨ãããªããããªã®ã§ãã²ã¨ã¾ãåæè¨å®ããã¦ãããã°ã¤ã³ID ã§éãã¾ãã
# mst_users ãã¼ãã«ã® login_id ãè¦ã¦ããã¹ã¯ã¼ãã¯åã§ã
ninearrows/ninearrows
ãã°ã¤ã³ããã¨ããã¸ã§ã¯ãä½æç»é¢ã«ãªãã¾ããã¾ããããã¸ã§ã¯ã管çã¢ããªã§ããã¸ã§ã¯ãããªãã£ããæå³ããªãã®ã§ããããããã£ã¦æãã§ããããã¸ã§ã¯ãã®ãã³ãã¬ã¼ãã¯ãã·ã¹ãã éçºç³»ãã¨ãWEB製ä½ç³»ãã®2ã¤ããé¸ã¹ã¾ããåè
ãé¸ãã§ããã¾ãã
ããã¸ã§ã¯ããä½æããã¨ãTodoãEventãInformationãMember 㧠4åå²ãããç»é¢ãéãã¾ããããã DashBoard ã®ããã§ãããååã®ã¡ãã¥ã¼ã«ã¯ãWBSãGanttãCalendarãFile ã並ã³ã¾ãããããã®ä¸ã§ããã¸ã§ã¯ããã¿ãå½¢å¼ã§è¤æ°ä¸¦ã¹ãããããã«ãªã£ã¦ããã®ã§ããã«ãããã¸ã§ã¯ã管çãã§ãããã§ãããã(å®å ¨ã«è¦ãç®ã ãããæ©è½ã追ã£ã¦ãã¾ã)
DashBoard ã®ç»é¢ã¯åç §ãªã³ãªã¼ã
WBS 画面ã«ã¯å ã»ã©é¸æãããã³ãã¬ã¼ã㧠WBS ããã§ã«æããã¦ãã¾ããé ç®ã¯ãã¿ã¹ã¯ãæ å½è ãæéãç¶æ³ãä¾é ¼è ããã©ãã° & ããããã§åã®ä¸¦ã³ã¯å ¥ãæ¿ãããã¾ããã¿ã¹ã¯ã®é ç®ã«ã¯ããã¤ã«ã¹ãã¼ã³ã¨ã¤ãã³ããããã¦ãã ã®ã¿ã¹ã¯ã追å ã§ãã¾ããã¾ã親ã¿ã¹ã¯ãã¯ãªãã¯ãããã¨ã§åã¿ã¹ã¯ããã°ã«ã§ãã¾ãã
Gantt の画面ã¯ãWBS ã®ç»é¢ã¨åã縦軸ã§æ¨ªè»¸ãæéã«ãªãã¾ããGantt ããã§ã WBS ããã§ãåæ§ã«æ å½è ãæéã®ç·¨éã¯ã§ããããéã«ä¸¡æ¹ã並ã¹ã¦è¦ããã¨ãªãã¨ã¤ããã®ããªã
Calendar ã¯ãã®ã¾ãã¾ãã¿ã¹ã¯ããã¤ã«ã¹ãã¼ã³ã®è¿½å ã¯ããããã§ãã§ãã¾ãããã ããGoogle Calendar ã»ã©ã®æä½æ§ã¯ãªãã¿ããã
Files の画面ã§ã¯ããã¡ã¤ã«ã管çã§ãã¾ãããã©ã«ãæ§é ãã¨ããã®ã¯ããããSCM ã¨é£æºãã¦ããããã§ã¯ãªãã§ããã¡ãªã¿ã«ãã©ã«ãã¯ã¤ããã¾ãããããªããã¢ãããã¼ãã¯ãã¾ãããã¾ããã§ãããã¢ãããã¼ããããã¡ã¤ã«ã¯ 9arrows_home/public/files ã«ã¯ããã¯ããç´ ç´ã« SCM ã¨é£æºãã¦ãªãã¸ããªãã©ã¦ã¶ã¿ãããªç»é¢ã«ãã¡ããã°ããã£ãã®ã«ã¨æãã®ã§ãã..ã
ãã£ã¨ãããªã¨ããã ã¨æãã®ã§ãæå¾ã« ERD ãçºãã¦ã¿ã¾ãã
- 9arrows's ERD
ãã¼ãã«æ°ã¯ããã»ã©å¤ããªãã§ãããã²ã¨ã¾ãä»æ¥ã¯ããã¾ã§ã
# 9arrows 㯠GPLv3 ãªãã ããªã... (^^;
åè
- ベーシスト兼ソフトウェアエンジニアのブログ 9arrowsを使ってみる。。。あれ?うむむ。
- æ¹åããããããã¤ã³ãã®æ示
- 9arrowsをさっそく改造 | nautilus note the Room
- ã³ã¡ã³ãããã
- 9ArrowsをMySQLで入れるのと便利な改造 | nautilus note the Room
- è¨äºå 容ãæ¶ãã¦ããã®ã§ Google ãã£ãã·ã¥ãã
- タスク共有やプロジェクト管理が可能でガントチャート表示もできる国産オープンソースツール「9Arrows」を使ってみた - GIGAZINE
- screenshot ãå å®
Redmine ã® ERD ãæãã¦ã¿ã¾ãã
ã¡ãã£ã¨åã« Redmine ã調ã¹ã¦ããã®ã§è¼ãã¦ããã¾ããæ©è½ã¨ãã¦ã®ç¹å¾´ã¯æ¸ç±ãããã¤ãåºã¦ããã®ã§ãããããåèã«ããªãã触ã£ã¦ã¿ãã°ããã¨ãã¦ãæ¸ç±ã«ãªãããå°ãå®è£ ããã®ã¨ãããæ°ã«ãªããã®ã§ãã
ãã¼ã¸ã§ã³ã¯ä»¥ä¸ã®ã¨ããã
% svn info
URL: http://redmine.rubyforge.org/svn/trunk
ãªãã¸ã㪠UUID: e93f8b46-1217-0410-a6f0-8f06a7374b81
ãªãã¸ã§ã³: 2819
ã¾ãã¯å
¨ä½æãææ¡ãããã¨ãRailRoad ã試ãã¦ã¿ã¾ãããGraphviz ãå¿ããã«ã¤ã³ã¹ãã¼ã«ãã¦ããã¾ãã
% gem install railload % cd redmine_home % railroad -o controller.dot -C % railroad -o model.dot -M % neato -Tpng controller.dot > controller.png % neato -Tpng model.dot > model.png
ã§ãããã£ãå³ã¯ãããªæãã§ããRailRoad ã®ãªãã·ã§ã³ãå¤ããã¨ã©ãã«ã追å ã§ããããä»ã«ãããããã§ãã¾ãããã¾ããããªæãã
- controller.png
- model.png
ã³ã³ããã¼ã©ã¯ã¨ãããã¨ãã¦ãã¢ãã«ã¯ããã¡ãã£ã¨è¦ããããããã§ãã
ã²ã¨ã¾ã MySQL åãã« migrate ãã¦ããã¦ãDB Designer ã§ãªãã¼ã¹ã¨ã³ã¸ãã¢ãªã³ã°ãã¦ã¿ã¾ãããã§ãããã ãã ã¨é¢é£ãä½ãæãããªãã®ã§ãã¢ãã«ã® has_many ã has_oneãbelongs_to ãªãããè¦ãªããé¢é£ãå ãã¦ã¿ã¾ããããã¦ã§ãããã£ãã®ãã以ä¸ã® ERDãã¨ã³ãã£ãã£ã®ä½ç½®ãé©å½ã«åããã¦ãå°ããã£ããããã¦ã¿ã¾ããã
- ERD
ãã¨ã¯ãRedmine ãé©å½ã«åãããªãããã¬ã³ã¼ãã®çæå
·åããè¦ã¦ã¿ã¾ãã(ã¾ããç´æ¥ã³ã¼ãã ãã追ã£ã¦ãããã®ããããã¾ããããå°éã«é åããã¦ã¿ã¾ããã)
ã¦ã¼ã¶ã¼ç»é²
- ãã°ã¤ã³ç»é²ããã¨ãusers ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- 管çè ã«æ¿èªãããã¨ãã¹ãã¼ã¿ã¹ (ä¸è¨åç §) ã 2 ãã 1 ã«å¤å
- auth_sources 㯠LDAP é£æºã¨ãããã¨ãã«å©ç¨ãããã¿ãã
- ã¡ãªã¿ã«ããã©ã«ãã ã¨ç»é²ããã ããããã¦ã¼ã¶ã¼ã¯ã¢ã¯ãã£ãã«ãªããªã
class User < ActiveRecord::Base # Account statuses STATUS_ANONYMOUS = 0 STATUS_ACTIVE = 1 STATUS_REGISTERED = 2 STATUS_LOCKED = 3
ã¦ã¼ã¶ã¼æ¿èª
- ã¦ã¼ã¶ã¼ç®¡çç»é¢ãããæå¹ã«ããã
- URL ã¯ãããªã
- http://localhost:3000/users/3/edit?status=&user[status]=1
- ãã㧠users ãã¼ãã«ã®ã¹ãã¼ã¿ã¹ã ACTIVE ã«å¤ãã
権é管ç
- 種é¡ã¯ä»¥ä¸ã® 5ã¤: NonMemberãAnonymousã管çè ãéçºè ãå ±åè
- ãã¼ã«ã¯ã¡ã³ãã¼ã«å¯¾ãã¦è¤æ°æå®ã§ãã
- roles ãã¼ãã«ã® permission ã«ã©ã ã« yaml å½¢å¼ã§ã¤ã£ããã§ãã
- code review tools ãå°å ¥ããã¨ãã¯ãplugin ã® migration ãæµãã¨ç®¡çè ãéçºè ã® permission ã«è¿½è¨ããã¦ãã
- ä½è«ã§ãããcode review tools ã®æ¥æ¬èªåã¯ä¸éå端
- ãã¼ã« -> éçºè ã¨ãã§éãã¨è±èªè¡¨è¨ã®ã¾ã¾
ããã¸ã§ã¯ãã®ä½æ
- projects ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- é¸æããã¢ã¸ã¥ã¼ã«ã enabled_modules ã«ã¬ã³ã¼ãçæããã
ããã¸ã§ã¯ãã¸ã®ã¡ã³ãã¼ç»é²
- members ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- ä»ä¸ãããã¼ã«åãmember_roles ãã¼ãã«ã«ã¬ã³ã¼ãçæ
ãã±ããã®ç»é²
- issues ãã¼ãã«ã«ã¬ã³ã¼ãä½æ
- category_id ã¯ããã©ã«ãã§ã¯ null
- ã«ãã´ãªããããããç¨æãã¨ãã°ãé¸ææã«ããã«å¤ãã¯ãã
- ã«ãã´ãªã¯ãã©ãã«ã¼ãã¨ã«ã¯åããããªã
- ãã¤ã«ã¹ãã¼ã³ãå®ç¾©ãã¦ããã¨ãfixed_version_id ãè¨å®ããã
- ãã±ããç£è¦è ã«ãã§ãã¯ãã¨ãã¨ãwatchers ãã¼ãã«ã«ãã¬ã³ã¼ãçæ
æéãè¨é²
- time_entries ãã¼ãã«ã«ã¬ã³ã¼ãä½æ
- ãã±ããã®çµéæéã®å¤ãæ´æ°ããããã¨ã«ãªã
é¢é£ãã±ããã追å
- ãã±ãããä½æãã¦ãããããããé¢é£ã¥ãããªãã¨ãããªãã®ãã¡ãã£ã¨ããã©ã
- issue_relations ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- issues ãã¼ãã«ä¸ã®å¤æ´ã¯ã¨ãã«ãªã
ãã±ããã®ã«ãã´ãªã追å
- issue_categories ãã¼ãã«ã«ã¬ã³ã¼ãçæ
ãã±ããã®ç·¨é
ãã©ã¼ã©ã ã®è¿½å
- boards ãã¼ãã«ã«ã¬ã³ã¼ãçæ
(ãã©ã¼ã©ã ã§) ã¡ãã»ã¼ã¸ã®è¿½å
- messages ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- parent_id ã¯è¿çå
ã® message_id
- reply_count ãã¤ã³ã¯ãªã¡ã³ããããããlast_reply_id ãæ´æ°ããã
- sticky ã«ã©ã ã¯ãªãã ãï¼
ãã±ããã¸ã®æ·»ä»ãã¡ã¤ã«ã®è¿½å
- æ·»ä»ãã¡ã¤ã«ã空ã®ãã¡ã¤ã«ã ã¨ç¡è¦ãããããããã§ãªãã¨â
- journal_details ã«ãå¤æ´ãè¨é²ããã
- attachments ãã¼ãã«ã«ã¬ã³ã¼ãä½æ
- container_type 㯠"Issue" ã«ãªã£ã
- container_id ã¯åã¿ã¤ãã®ã¢ãã«ã«ããã id (ããã§ã¯ issue_id ã®å¤ããã)
- ã¡ãªã¿ã«ææ¸ã¸ã®æ·»ä»ãã¡ã¤ã«ã®è¿½å ã ã¨ãcontainer_type 㯠Document
- æ·»ä»ãã¡ã¤ã«ã¯ REDMINE_HOME ã®files 以ä¸ã«ãã¡ã¤ã«åã« prefix ãã¤ãã¦æ ¼ç´ããã
- ããã¯ææ¸ããã以å¤ã§ã®æ·»ä»ã®ã¨ãã§ãåã
- ãæ·»ä»ãã¡ã¤ã«ãã¨ããã¡ãã¥ã¼ã¿ãããã®æ·»ä»ã¯ãããã¸ã§ã¯ãã¨ãã¦ã®ææç©ã®å
¬éã®ããã£ã½ã
- ããã¸ã§ã¯ãã®ãã¼ã¸ã§ã³ãæå®ãã¦å ¬éã§ãã
ææ¸ã®ç»é²
- documents ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- åè¿°ã®ã¨ãããattachments ãã¼ãã«ã«ãã¬ã³ã¼ãçæ
ã«ã¹ã¿ã ãã£ã¼ã«ãã®è¿½å
- custom_fields ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- possible_values ã«ã¯ Yaml å½¢å¼ã§ã¤ã£ãã¾ãã¦ãã
ã«ã¹ã¿ã ãã£ã¼ã«ãã®ç·¨é
- custm_values ãã¼ãã«ã«ã¬ã³ã¼ããçæ
- ã«ã¹ã¿ã ãã£ã¼ã«ãã®å¤ã¨ãã¦å ¥å/é¸æããå¤ãã¯ãã£ã¦ãã
- customized_type 㯠attachments ãã¼ãã«ã® container_type ã¨ä¼¼ã¦ã
- customized_id ã¯å¯¾è±¡ã¨ãªã user_id ã ã£ãã issue_id ã ã£ãã
- ã«ã¹ã¿ã ãã£ã¼ã«ãã¯ãããã¸ã§ã¯ããã¦ã¼ã¶ã¼ããã±ãããªã©ã対象ã«è¿½å ã§ãã
ãã¼ã¸ã§ã³ã®è¿½å
- ããã¸ã§ã¯ãã®è¨å®ã§ãã¼ã¸ã§ã³ã®è¿½å
- versions ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- ãã±ããä½æ/æ´æ°ã®ã¨ãã«ã対象ãã¼ã¸ã§ã³ãè¨å®ã§ãã
- ãã¼ã¸ã§ã³ã 1ã¤ã§ã追å ããã¨ããã¼ããããã®ã¡ãã¥ã¼ãå¢ãã
ã«ã¹ã¿ã ã¯ã¨ãªã®è¿½å
- ãã±ããã®çµãè¾¼ã¿ç¨ã®ã¯ã¨ãª
- ã¦ã¼ã¶ã¼ãã¨ãããã¸ã§ã¯ããã¨ã«ä½æå¯è½
- queries ãã¼ãã«ã«ã¬ã³ã¼ãçæ
- filter ã«ã©ã ã« Yaml å½¢å¼ã§æ¡ä»¶ãã¯ãã
Wiki ã®ä½æ
wiki ã®ãã¼ã¸åã®å¤æ´
- wiki_redirects ãã¼ãã«ã«ã¬ã³ã¼ãä½æ
ãã¨ã¯ãSubversion ã Git ãªã©ã® SCM ã¨é£æºãããã¨ãrepositories ãã¼ãã«ã«ã¬ã³ã¼ããçæããããããã©ãã«ã¼ã追å ããã trackers ãã¼ãã«ã«ã¬ã³ã¼ããçæãããããã¾ããã¾ããGUI ãããã±ããã®æ¿èªããã¼ãç·¨éããã°ãworkflows ãã¼ãã«ãæ¸ãå¤ããã¾ããã¡ãã£ã¨å¤ãã£ã¦ããã®ã¯ enumerations ãã¼ãã«ã§ããã±ããã®ç·æ¥åº¦ãããã¥ã¡ã³ãã®ç¨®é¡ãã¢ã¯ãã£ããã£ãªã©ã®ããã©ã«ãå¤ãã¾ã¨ãã¦æ¸ããã¦ãããã¾ãã
ãã£ã¨ãããªæãã§ããããã¼ãã«ã®æ§é ãå½¹å²ãã¯ã£ãããã¦ããã¨ã³ã¼ããé ã«å ¥ããããã¨æãã¾ããã¨è¨ãã®ã¯å¤ãã®ããããã¾ããã...ï¼ (^^;
æ©è½ãå°å ¥ãéç¨ãããã«ã¤ãã¦ã¯ä»¥ä¸ãåèã«ã
Redmine -ãã£ã¨æ軽ã«ããã¸ã§ã¯ã管ç!
- ä½è : å貫義人,æ æ 義è£,並河ç¥è²´,åç°ç´æ¨¹
- åºç社/ã¡ã¼ã«ã¼: ã¤ã³ãã¬ã¹
- çºå£²æ¥: 2009/07/24
- ã¡ãã£ã¢: åè¡æ¬
- è³¼å ¥: 6人 ã¯ãªãã¯: 245å
- ãã®ååãå«ãããã° (31件) ãè¦ã
å ¥éRedmine Linux/Windows対å¿
- ä½è : åç°å
- åºç社/ã¡ã¼ã«ã¼: ç§åã·ã¹ãã
- çºå£²æ¥: 2008/11/26
- ã¡ãã£ã¢: åè¡æ¬
- è³¼å ¥: 4人 ã¯ãªãã¯: 129å
- ãã®ååãå«ãããã° (48件) ãè¦ã
å®è·µçãªãã¸ã§ã¯ãæååæã»è¨è¨ã¨å®è£ (ç¶ã ãã®2)
æçµæ¥ã¯昨日ããé£æ度ã®é«ãä¾é¡ã§ã»ã¼ 1æ¥æ¼ç¿ã§ããã対象ã¯èªåé話åæ£ã·ã¹ãã ã§ãè¤æ°ã®ãªãã¬ã¼ã¿ã¨å¤ç·ãç»å ´ããã¬ã¼ã¹ã³ã³ãã£ã·ã§ã³ã®çºçããåé¡ã§ããã
æåããã»ã¨ãã©ã¢ããã¤ã¹ã®ãªãç¶æ 㧠2人 1çµã§ã¢ãã«ãèãã¦ããã¾ããéä¸ã©ã³ãã«ãã§ãã®ã§ãåæ/è¨è¨ã«è¦ããæé㯠3-4 æéã»ã©ã§ãããããéä¸ééã£ãæ¹åã«ãé²ã¿ã¾ããããæçµçã«ã¯ãªãã¨ãå®è£ ã«è½ã¡ãè¨è¨ã«ãã©ãçãã¾ããã
ä¸è¦é·ãããã«ãæãã¾ããããã£ããããè¨è¨ã«ãããããã¦ã¼ã¹ã±ã¼ã¹ãæºããä¸ã§çåã«ãªãé¨åããã¹ã¦è§£æ¶ããã¦ããã®ã§ãå®è£ ã«è½ã¨ãã®ã¯ãã£ããæ©æ¢°çãªä½æ¥ã«ãªãã¾ããæåã«æéã¯ãããã¾ãããææ»ããå°ãªãåãä½æ¥ã«ç¡é§ããªãã§ãããåæ/è¨è¨ã«èªä¿¡ããã¦ã¾ãã
åæ/è¨è¨ã«ããã¦éè¦ã ã£ãã®ã¯ã初日ããã®ãã¼ã¡ãã»ã¼ã¸ã©ããã
- ãªãã¸ã§ã¯ãã¬ãã«ã§èãã
- ã¦ã¼ã¹ã±ã¼ã¹å®ç¾ã®è©³ç´°åº¦ãããã
ã«å°½ãã¾ããããªãã¸ã§ã¯ãã¬ãã«ã§å¤é度ãé¢é£ãå ·ä½çã«ã¤ã¡ã¼ã¸ããç¡é§ã®ãªããããæ¹ãæ¤è¨ãã¾ããããã¦ããã¡ã³ã¯ã·ã§ã³ãã³ã¼ã«ãããæµããã¤ã¡ã¼ã¸ããã¦ã¼ã¹ã±ã¼ã¹ãã¡ããã¨æºãããã¦ãããã¨ã確èªãã¾ãã
æç« ã«ãã¦ãã¾ãã¨ããã ããªã®ã§ãããå®éã«æ¼ç¿ãéãã¦æã¨é ãåããã¦ã¿ãã¨ããªããªãæãããã«ã¯ãããªãã§ãã
ãã£ã¨ç´ æ¯ãããã¦èº«ä½ã«é¦´æã¾ããå¿
è¦ãããã¾ãã... (^^;
以ä¸ã¯ãåæ¥ããã®ã¡ã¢ã®æç²ã§ãã
è¬ç¾©ã®ééééã§å
çããããããªè©±ããã¦ãã ãã£ãã®ã§ããããå«ãã¦ã®ã¡ã¢ã§ãã
- ã©ã¼ãã³ã°ããªã¼ã®è¬åº§
- æ¥æ¬ã§ã¯ PM ç³»ãå¤ããæè¡ç³»ã®è¬åº§ã売ããªã
- ä¼æ¥ã§ã®ãªã³ãµã¤ãè¬åº§ãã¡ã¤ã³ã§ãä»åã®ãããªå ¬éè¬åº§ã¯å¸å°
- ç±³å½ãªã©ã§ã¯æè¡è ã®æµåæ§ãé«ãã®ã§ãå¹´é 6åã»ã©ã¯è¬åº§åå ã®æ¯æ´ããªãã¨ä¼æ¥ããé¢ãã¦ããããã
- ãªãã¸ã§ã¯ãæåã§å¤§äºãªã®ã¯ï¼
- ãã¶ã¤ã³ãã¿ã¼ã³
- ãªãã¸ã§ã¯ãæååæ/è¨è¨
- ãã®é¨åãååã«ç解ããã¦ããªã (æãã«ããããã§ããã)
- ã¯ã©ã¹ã©ã¤ãã©ãª
- C++
- ã¹ã¿ãã¯ã«ç©ã¾ãã«ã¬ã¸ã¹ã¿åç §ããã®ã§é«é
- ãªãã¸ã§ã¯ãæåãªè¨è¨ã§ã¯ãã¢ã¯ã»ã¹çµè·¯ãç´æ¥çã§ã¯ãªããªãã®ã§ãã®åã¯é ã
- ãã ããæ§é ãææ¡ããããã®ã§ã¡ã³ããã³ã¹æ§ã¯ãã
- å¤é度
- B -----> A
- 0..*ãã0..1
- å·¦: ä»»æã® A ã®ãªãã¸ã§ã¯ã 1㤠"ã" åç §ãã B ã®ãªãã¸ã§ã¯ãããããã¤ããã
- å³: ä»»æã® B ã®ãªãã¸ã§ã¯ã 1㤠"ã" åç §ãã A ã®ãªãã¸ã§ã¯ããããã¤ããã
- ãªãã¸ã§ã¯ãæååæ
- Rumbaugh ã®æå±ããåè©æ½åºã¯å½¹ã«ç«ããªã
- Jacobson ã®ã¦ã¼ã¹ã±ã¼ã¹åæ
- ã¡ãªã¿ã«å½¼ã¯ã¨ãªã¯ã½ã³åºèº«! Joe Armstrong ã¨ãããå欧ããããª..
- RumbaughãBoochãJacobson ã RUP ãçã¿ã ããããåè©æ½åºã¯å«ã¾ãã¦ããªã
- RUP
- RUP ã¯ã¢ã«ã´ãªãºã ã§ã¯ãªããéæ³ã®æã§ããªã
- éçºæ³ã®ã¹ãããéã®ã®ã£ããã大ããã®ã§ãç¥è/æè¡/çµé¨ã§åããå¿ è¦ããã
- RUP ã¯æéã§ãããããªãã®é¨åã¯ããã°ã©ãã®è½åã«ä¾å
- ãã®æ¨ãæè¨ããã¦ãã
- ä»æ§ã¨åæ/è¨è¨
- ä»æ§ã¯ãwhatãã§ãåæ/è¨è¨ã¯ãHowã
- æ£ãã/æ£ãããªãã¯ãä»æ§ã«å¯¾ãã¦ã®å®è£
- ä»æ§èªä½ã«æ£ãã/æ£ãããªãã¯ãªããããã®ã¯è¯ã/æªãããã
- è¯ã/æªãã¯æè²ãã«ãã (ãã£ã¼ãããã¯ãããã¥ããã®ã§)
- ããæå³æè½ããã®æè½ããã¤è ã®çºæ³ãããã«æ©ãå®ç¾ããã
- æ©ä¼æ失
- ãã/ãããªãããããã決å®
- ãããªãã¨ãã決æãããå ´åã®æ©ä¼æ失ãå½ç¶ãã
- æ¥æ¬ã§ã¯ããã¨æ±ºæããã¨ãã®è²¬ä»»ã ã追æ±ãã ããçãããªã
- ã¦ã¼ã¹ã±ã¼ã¹ã®åä½
- ãã©ã³ã¶ã¯ã·ã§ã³ãç¶æ ã®å¤ããåä½ã§ããã¨ãã
- ã¦ã¼ã¹ã±ã¼ã¹åæ/è¨è¨
- ã·ã¼ã±ã³ã·ã£ã«ã«ããã§ããªã
- å°æ°ç²¾éã§æ¤è¨ãã
- ãªãã¸ã§ã¯ãã§èãã
- é ã®ãªãã§ã¡ã¢ãªä¸ã«å±é
- ã¦ã¼ã¹ã±ã¼ã¹å®ç¾ã®è©³ç´°åº¦ãããã
- ã¤ã³ããã¯ã¹ãµã¼ãã¯é«ä¾¡
- ãã¡ã³ã¯ã·ã§ã³ã³ã¼ã«ã¯é«ä¾¡
- 大äºãªã®ã¯ã¢ãã«åã§ãããã©ããã§ãUML ã«è©³ãããªã£ã¦ããããããªã
- ãã¡ã³ã¯ã·ã§ã³ã®ä¸èº«ã¯è¨è¿°ããªã
- ä¸åº¦æ¸ã㨠(æ°æã¡çã«) æ¶ãã¥ãããªãã®ã§ãæçµæ®µéã§æ¸ã
- ä¸æµä¸æµã®åé¢
- å·¥å ´ã§ã¯ãã¾ããã£ã¦ããã®ã§ã丸æãæåã®å©é·
- ã·ã¹ãã ã§ã¯ãã¾ããããªã
- é£ããé¨åãå®è£ ã¾ã§ã¢ã¼ããã¯ãããã以å¤ãéçºè
- Life is beautiful: ソフトウェアの仕様書は料理のレシピに似ている
- å¤æ
æ§
- ãªãã¸ã§ã¯ãã¯ã¤ã³ããªã¸ã§ã³ã¹ããã£ã¦ãã
- çµå度ãä¸ããããã«ã¡ãã»ã¼ã¸ããã·ã³ã°
- ãã¶ã¤ã³ãã¿ã¼ã³
- ç¶æ¿ã¯ã³ã³ãã¤ã«æã®çµå
- é¢é£ã¯å®è¡æã®çµå
- ã³ã³ãã¤ã«æã®çµåã¯å®è¡æã«æ¯ã¹ã¦å¼·ã
- çµåå çã®ãã¶ãã¿æ¬ã¯ç´ æ´ããã
- ããã®ãããã§æ¥æ¬äººã®ãã¶ãã¿ã«å¯¾ããç解ã¯ä¸çãããã¬ãã«ãã!?
- ä½å®¶
- å°ããé ã«ã©ãã ãæ¬ãèªãã§ããããéè¦
- æ¸ããã¨ã¯éè¦ã§ã¯ãªã
- ããããæ©ãããæ¸ãéããã¨åã«ã¯ã¾ã£ã¦ãã¾ã
- ããã°ã©ã ãåæ§ã綺éºãªã½ã¼ã¹ãããããèªã¿ã¾ããã
- MINIX
- æ°ä¸è¡ãªã®ã§èªãã®ã«ã¯æé
- ã«ã³ã¶ã¹å¤§å¦ã® (æ°´éå çã®) è¬ç¾©ã®ãªãã§ä¸çªè©ä¾¡ãé«ã
- ä»®æ³ã¡ã¢ãªã¯ä½¿ã£ã¦ããªããããã以å¤ã®åºæ¬ç㪠OS ã®æ©è½ã¯ãããããã
- virtual box ã«ã¯ãã
- ã¢ã¼ããã¯ãã£ã¨ã¯
- ãã¼ã¦ã¼ã¹ã±ã¼ã¹ã«å¯¾ããåæã¢ãã«
- è¨è¨ã¢ãã«
- é å¸ã¢ãã«
- å®è£ ã¢ãã«
- éæ©è½è¦ä»¶
- å®è£ ãã¦åãããã¨ã大äº
- ç¹°ãè¿ãéçº
- ã¢ããªã«ä¾åããªãé¨å (ããã«ã¦ã§ã¢)
- ãã¼ã¦ã¼ã¹ã±ã¼ã¹ã®ã¢ããªåºææ©è½
- 次ã®ãã¼ã¦ã¼ã¹ã±ã¼ã¹ã®ãµãã»ãã
- ã¢ã¼ããã¯ãã£ã®å®è£ /æ¤è¨¼/決å®ã«ãå ¨ä½ã® 30% ã®æéã¨å´åãããã
- ã¢ã¼ããã¯ãã®ç«ã¡ä½ç½®
- PM ã§ãªã
- PM ã¨ãã¼ãããã®æ¨©é
- ãªã¹ã¯ãè¦ã¤ããããªãã²ã¨ããªã¹ã¯ã®ç®¡çããã¦ãã ã
- 管çé¨éããã®å¿ããã®ãµãã¼ããå¿ è¦ # ãããæ¥æ¬ã§å¼±ã
- ãã£ã¼ãããã¯ãåãå ¥ãã
- PM ã§ãªã
- ãã§ã¼ãº
- æ¹åä»ã (ãã¸ãã¹è¦³ç¹ãã¢ã¦ãã©ã¤ã³ãæ©è½ã®é¸æ)
- æ¨æ² (ã¢ã¼ããã¯ãã£ã®æ±ºå®ãè¨ç»/è²»ç¨ã®è¦ç©ã)
- ä½æ
- 移è¡
- ã¨ãã«æ¹åä»ãã§ã¯ãåéãã¨ã®å°é家ãéããªãã¨æ¬è³ªçãªåé¡ã®è§£æ±ºã«ã¯è³ããªã
- ãã¹ã
- ãã¹ãã±ã¼ã¹ã¯ä»æ§ (ã¦ã¼ã¹ã±ã¼ã¹) ããå°åºãããã¹ã
- å®è£ ã³ã¼ããã¿ã¦ãã¹ããã¤ããããã®ã¯æ¬æ«é¡å
- ä»æ§ â è¨è¨/ã¢ããªã³ã° â å®è£ ã³ã¼ãã®æµãã¨å¹³è¡ãã¦ãä»æ§ â ãã¹ãã±ã¼ã¹ â ãã¹ãå®è£
- å¥ç´
- æåã«è©³ç´°ãªã¦ã¼ã¹ã±ã¼ã¹ã¾ã§ã¯ãã¯ã決ã¾ããªã
- å®è£
ãã¯ããã¦ããæ¦ãåããã¦ãããã¨ãéè¦
- ããã§ä¸ä¸é¢ä¿ãã¯ãã£ã¦ãã¦ãã¾ãã®ãæ¥æ¬
- ç±³å½ã®å ´åã¯ãå¥ç´ã§ç¸ã£ã¦ãã¾ã
- 両è ã®ä¸éçãªã¨ãããè½ã¨ãæã..
- ãããã°
- ã§ããã ãããªã
- 失æããè¨è¨ã®ãã¨ã§ã¯ãããªãã®æéããããã㦠(ãããã³ã°)
- æ¥æ¬ã§ã¯åªç§ãªäººã¯ç«æ¶ãã«ãªããç±³å½ã§ã¯ã¢ã¼ããã¯ã
- ãããããªãã¨å¸å ´ã®æµåæ§ãé«ãã®ã§ããã¦ãã¾ã
- ã¹ã¼ãã¼ã¹ã¿ã¼
- çè«çãªç¥èãããã¯ã°ã©ã¦ã³ã
- ã©ããªç°å¢ã§ãåãã
- ã¹ã¼ãã¼ã¹ã¿ã¼ãè²ã¦ãã権éãä¸ãã
- èªåã§ææ¡ãã¦ãèªåã§éçº (ã¢ã¤ãã¢ãå ·ç¾åããè½å)