æ°çCè¨èªããã°ã©ãã³ã°ã¬ãã¹ã³
[結] 2006年8月 - 結城浩の日記
çµå浩ããã®Cè¨èªæ¬ï¼è³¼å
¥æ±ºå®ã
ã§ãæ°çã£ã¦ãã¨ã¯ãã¨ã£ãã®æã«Cè¨èªã®æ¬åºãã¦ãã®ããç¥ããªãã£ãã
ããã°ã©ã ã®ã³ã¡ã³ãã«ã¯ãå®ç¾æ段ããç®çã»çç±ãæ¸ãã¹ãã
å®ç¾æ段ã¯ã³ã¼ããèªããã¨ã§åçºè¦ãããã¨ãåºæ¥ããã
ããã°ã©ã ã®ç®çãããã®å®ç¾æ段ãé¸ãã çç±ã¯ã
ãããã³ã¼ããèªãã§ãè¦ã¤ãããªãã
æ¬æ¥ã¯ãããã°ã©ã ã¯ä½ããã®ç®çãéæããããã®æ段ã«éããªãã®ã«ã
ã³ã¡ã³ããæ¸ãæã¯ãã®åªå
é ãé転ããã¡ã
ï¼ã©ããªããã°ã©ã ããã³ã¡ã³ãã«æ¸ãã¦ãä½ã®ããã®ããã°ã©ã åãæ¸ãå¿ãããï¼ç®çéè¦ã
ã¨ããããç®çã»çç±ãéè¦ãªã®ã¯ãã³ã¡ã³ãã«éããªããªã
ä¾ãã°ãè°äºé²ã
ä¼è°ã§ä¸çæ¸å½ãããããªã±ã¼ã¹ã«ã¤ãã¦è©±ãåã£ãçµæããããªè¨è¨ã§è¡ããã¨æ±ºã¾ã£ãã¨ããã
ãã®æã®è°äºé²ã«ãçµè«ã®è¨è¨æ¹æ³ã ãããè¼ã£ã¦ããªãã£ãã¨ããã
ããã¨ã
ï½¢ãããªã±ã¼ã¹ã®å ´åããã®è¨è¨ã§ã¯æãæ°ããããã ãã©ã
ãã®ã±ã¼ã¹ã«ã¤ãã¦ã¯æ¤è¨ããã£ãï¼
ããè¦ãã¦ãªããã ãã©ãè°äºé²ã«è¼ã£ã¦ãï¼ï½£
ã¨ãªã£ã¦ãæ¤è¨æ¸ã¿ã®ã±ã¼ã¹ãå度æ¤è¨ããç¾½ç®ã«ãªãã
ãããã¯ã
ï½¢ãã®è¨è¨ã¯è¤éãããæ°ããããã©ããªçç±ã§ããããªã«è¤éã«ãªã£ããã ã£ãï¼
ããè¦ãã¦ãªããã ãã©ãè°äºé²ã«è¼ã£ã¦ãï¼ï½£
ã¨ãªã£ã¦ãå度æ¤è¨ããç¾½ç®ã«ãªã£ããã
åç´ãªè¨è¨ã«ç´ãã¦åé¡ãèµ·ãããããã
ï¼ã§ãåé¡ãèµ·ãã¦ãããã¢ã¼ããããã°ãããªè©±ããã£ãã¨æãåºããã ããããï¼
åè«ã®ãã¿ã¤ã¶ããï¼
PostgreSQLã¯æ¡å¼µæ§ãé常ã«é«ãRDBMSã§ãã®ã§ãMySQLã«éããä»ã®åç¨RDBMSã®äºææ§ãå®ç¾ããã®ããä¸å¯è½ã§ã¯ãªãã®ããªããã¨æã£ã¦ããããã¾ãã
ã¨ããããã§ã
* Oracle Compatibility Functions http://pgfoundry.org/projects/oracompat/
ã¨ããããã¸ã§ã¯ããpgFoundryã«ãã£ãããã¾ãããã®ããã¸ã§ã¯ãããªããªãé¢ç½ããã§ãã
Oracle ã®SQLé¢æ°ã移æ¤ããããã¸ã§ã¯ãã¯æ¢ã«ãã£ãã£ã¦ãã¨ã§ããï¼
åè«ã®ãã¿ãååã¤ã¶ããï¼
ãã£ã¨æ¢ãã°ãéã«PostgreSQLã®SQLé¢æ°ãPostgreSQLã«ç§»æ¤ããããã¸ã§ã¯ããããããã
ãã£ãããã¿ãå®å
¨ã«ã¤ã¶ãããã¨ã«ããã
ä½æ ãæ°éãªã®ãï¼
http://d.hatena.ne.jp/habuakihiro/20060829#1156827636
é¢ç½ãã
æ°éã«é¢ããèå¯ãé¢ç½ãããã©ã
âä»ã®RDBMSã¯ã¾ã å®æå½¢ãããªãã®ã§ããâããã«çºããã
ã§ãç§ãããã§ããã©ãæ°éããã®ã¾ã¾æ®ãã¾ããããã¯ã¤ã¾ããã¥ã¼ãã³ã°ã®ä¸ç°ã§ããæ§è½åé¡ãªã®ã§ããã¤ã³ã¹ã¿ã³ã¹ããã®ã¾ã¾ç½®ãã¨ã©ããªãã§ãããããã¬ã³ã¼ãæ°ãè¨å¤§ã«ãªãã¾ããããããåºå¹¹ç³»ã®ãããªå ´åãããã¯ä½ãã¨åé¡ãå¼ãèµ·ããããã¾ãããã ããããããã¦ãã®ã§ãã
...ä¸ç¥...
ã ãã©ããã£ã¦ãã¨ã§ãããã¼ãã¦ã§ã¢ããã£ã¨é²æ©ãããããã£ã¨ãã£ã¨ãªã¬ã¼ã·ã§ãã«ã¢ãã«ã®æ¬è³ªçãªè¡¨ç¾ãå¯è½ã«ãªãã®ã§ããä»ã®RDBMSã¯ã¾ã å®æå½¢ãããªãã®ã§ãããªã®ã§ãã©ããã¦ã妥åç¹ã¯ããã¨ãããã¨ã§ãããã®å¦¥åç¹ã®ã²ã¨ã¤ãæ°éã¨ãã表ç¾ã ã¨ãããã¨ãæ¹ãã¦èããã¨ããã®ã¯ã決ãã¦ç¡é§ãªãã¨ã§ã¯ãªãã¨èãã¦ãã¾ãã
çºæãããå½æã¯ã³ã³ãã¥ã¼ã¿ã®æ§è½ä¸è¶³ã§ä½¿ãç©ã«ãªããªãã£ãã
ã¬ãã¼ã¸ã³ã¬ã¯ã¿ãé¢æ°åè¨èªããæè¿è¦ç´ããã¦ããã®ã¨åãã§ã
RDBMSãã³ã³ãã¥ã¼ã¿ã®æ§è½ä¸è¶³ã足ããã«ãªã£ã¦ãããã ã
ã³ã³ãã¥ã¼ã¿ã®æ§è½ãä¸ããã«ã¤ãã¦ã妥åç¹ãæ¸ããã¦è¡ãã
ããããæ´ã«çæ³å½¢ã«åãã¦é²åãã¦ãããã ã
ï¼Haskellã¯Listããé åºãªä»æ§ã«ãªã£ã¦ããã®ããã³ã³ãã¥ã¼ã¿ã®é²åã®ããã£ã¦ãã¨ããï¼
決ãããæéã¯RDBMSã«ã³ãããããã
好ããªãã¨ãããã®ãä¸çªå¹çããã¯ãã
ï¼ãªãã¦è¨ã£ã¦ããããæ¥åç¥èãã©ã£ãè¡ã£ã¡ãããã ãããªãï¼
ã»ã¸ã¨æ°å ã
http://www.geocities.jp/standing_art/hoheto/kazu.html
ããªãã® ã»ã¸ã¨æ°ç§ã¯ 4 Std ã§ãã
å¹´é½¢XXæ³ã¯ ãã¾ããããç°å¢ã®å¤åãåºä¼ãã訪ãã¾ããéæ°ãä¸æ°ã«ä¸æãã¾ãããå¤ãã®äººãæ¸æãã¾ããèªåã®è¡åç¯å²ãåºããããã«ãã¦ä¸ããã
大å¦ã«è¡ã£ã¦ããã ãã§æ¢ã«ãè¡åç¯å²ã¯å¤§å¹ ã«åºãã£ã¦ããæ°ããããå¼ãããããã¡ãªåã
ï¼ 4ã®æå³
ã»åºæ¬æ§æ ¼
æ ¹æ§ã¨ä½åãæ°ãå¼·ããè² ããå«ãã
ã³ã³ãã¬ãã¯ã¹ã®åºã¾ãã§ããã常ã æé·ãç®æãç²¾é²ã®æ¥ã ã ããããæ¹ãã¾ããå ´åãå¤ããæé·ã®ãã¼ã¹ã¯ä»äººä»¥ä¸ã®å ´åãå¤ããé å¼µããã§æ ¹æ§ãããããéã³å¿ãä½è£ã大åã§ããäºãå¦ãã§æ¬²ããã
èªèããã®ã¯æè¿ã®ãã¨ã§ããã確ãã«è² ããå«ãã
以åã¯ãâ競äºå¿ãç¡ããâã¨æã£ã¦ãããã§ããã
èªåã®å°éåéã§è² ããã®ãã¤ã¤ã§ãä»ã®äººã«æµããªãäºã¯ã
ï½¢ãããªã®èå³ãªãããï½£ã¨ãã£ã¦è¨ã£ã¦ããã ãã§ããã
å£çæãå¼·ãã®ã¯ç¢ºãã
ã§ããæ ãè
ã§ããããï¼è¶£å³ã®ä¸ã¤ã¯ãæ°ç ã貪ããã¨ï¼
ã»äººéé¢ä¿
人éé¢ä¿ã¯ä¸å¨ç¨ã§ãããèªåã®äºã§ç²¾ä¸æ¯ã
ä½æ ãã»ããããã¨å°ãã
å¦ä¸è¡ã«ã¯é·ãã¦ãããã¯ãã«ãã§äººèãéæãã¦ãããããã人ããã¾ãã¡å¤§äºã«ããªãã
ä¸å¹ãªãªã«ãç³»ã«ãªãããããèªåã«ãå³ãããä»äººã«ãå³ãããç¹ã«ç®ä¸ã«å¯¾ãã¦åæããå¹´ä¸ã«ã¯åªããã£ããããããã å°æ¬ã§ãã人éã«ã¯å¾é ã§ããã
確ãã«ãèªåã®ãã¨ã§ç²¾ä¸æ¯ã
確ãã«ã人ã大äºã«ããªãã
確ãã«ãä¸å¹ç¼ãªå¾åã¯ããããã
ã§ããå¦ä¸è¡ãªãã¦ç¥ããªãããèªåã«ãä»äººã«ãçãã¨æããã§ããã
ã»çæ´»æä¸ãããã¤ãã³ã·ã§ã³ã«ãªãã
èµ·ãã¦ãéã¯ãªãããã¦ããªãã¨ãã¡ã§ç¡é§ã«æéãåããå¾åã«æ³¨æãã¦ãã ããã
ä»äºã¯èå©å¤å£²ãä½è³éé·æéå´åãèªåãå®ã売ãå¾åã
æä¸ãããã¤ãã³ã·ã§ã³ï¼
éã«ãç«ã¡ä¸ãã«æéãæããã¿ã¤ãã ã¨æãã
確ãã«ãç¡é§ã«æéãåããå¾åããã
æ¬ããããã°ãããã§ãæéã¤ã¶ãããã©ã
èªããã®ããªããªã£ãç¬éã30ç§ã¨ã¬ãã¼ã¿ãå¾
ã¤ããã3åããã¦é段ã使ãã
é«ã¬ã¹ãã³ã¹ã¿ã¤ã ãä½ã¹ã«ã¼ããããªè¡åãã¿ã¼ã³ã«ãªãã
確ãã«ãèå©å¤å£²ãä½è³éé·æéå´åããªå¾åããã
ã»éé
ãã åã«ã±ãã±ãã¯ééã失ãã¾ãããéã楽ããã§ä¸ãããã¿ããªã¨æ¥½ããã§ä¸ããã
ãéã貯ãã¦ããæ ã«æµããã¦è²¸ããããã ã¾ããããããªãããã«ã
ã®ã£ã³ãã«ç³»ã¯ç±ããªãã¨ãã¡
åæã«ã¯ã¾ã£ã¦èº«ä¸æ½°ãã¨å°ãã
ã£ã¦çå±ã§ã®ã£ã³ãã«ã¯ä¸åãããªããã§ãããæ£è§£ã®ããã§ããã
>è£æ£ãªãã·ã§ã³
stdï¼ãã©ã³ã¹ãã¨ããæ°ç§ã®ãã¤æ§è³ªã®å¼±ç¹ãè£æ£ãè¤æ°ã®èãããã¾ã«èªå·±çç¾ãå¼ãèµ·ãå ´åããããï¼ç¾å®ã«å¹ åºãé©å¿ã§ãããåå¿è åãï¼è¬ï¼ã
確ãã«ãèªå·±çç¾ã§ã常ã«å³å¾å·¦å¾ããããæèã®ç¡éã«ã¼ãã«ã¯ã¾ãã¾ãã
誰ãåã«ãåç
§æ§åæå¶ç´ãå®è£
ãã¦ã