PostgreSQLã«ã³ãã¡ã¬ã³ã¹2013 LightningTalk ï¼2013-11-13: migr8.rbã®è¨å®ç®æãè¥å¹²ä¿®æ£ï¼ ï¼2013-11-14: SQLite3ã§ã®è¨å®çãä¿®æ£ããmigr8.rb new --table=usersãã追å ï¼
æ¯åº¦ããªãã¿ãã¯ã¦ãã®ãããã¨ã³ããªã«ãSIããã¡ã«ããè² ã®ã¹ãã¤ã©ã«ãã¨ããã¿ã¤ãã«ã®ã¾ã¨ããæ²è¼ããããããã æ°ã¨ã¯ããªãè¦ç¹ã¯éããã®ã®ãéçºç¾å ´ã®åé¡ç¹ã«ã¤ãã¦ã¯å°ãæãã¨ãããããã®ã§æè¦ãæ¸ãã¦ã¿ããã¨æããã¨è¨ã£ã¦ãã以ä¸ã®è©±ã®å 容ã¯ãã¼ã¿ãã¼ã¹ã¢ããªã±ã¼ã·ã§ã³ã«éå®ãã話ã§ãããã¾ãSIerã ãã«éã£ã話ã§ã¯ãªãã®ã§ãã®ç¹ã¯ã容赦é ãããããã¡ããSIeråä½ã®æ¡ä»¶ã¯ãã¼ã¿ãã¼ã¹ã¯å¿ é ãªã®ã§ãæ¬ã¨ã³ããªã§è§¦ããåé¡ç¹ã«ã¯è©²å½ããã ããã Q.ãªãçä¸ããã®ãï¼ A.æ£ãããã¼ã¿ãã¼ã¹è¨è¨ãã§ãã¦ããªãããçµè«ããè¨ããããã¼ã¿ãã¼ã¹ã¢ããªã±ã¼ã·ã§ã³ã®éçºãçä¸ããã®ã¯æ£ãããã¼ã¿ãã¼ã¹è¨è¨ãã§ãã¦ããªãããã ãããã§ãããæ£ãããã¨ã¯ãè«ççã«è¨¼æã§ããæ£ããã¨ããæå³ã§ã¯ãªãããæ¬æ¥ããããã¹ããã¨ãã£ãæå³ã§æãã¦æ¬²ããã ãçä¸ãã¨ããã®ã¯ãä¾ãã°ãã¹ããéããªããã
JOIN ç¦æ¢ã®è©±ã«ããã¾ã ã«çµ¡ãã§ããã人ãããã â ãè¦ããããããã½ã¼ã·ã£ã«ç³»ã®ãµã¼ãæ§æãèãã - SQLer ç島åå¯ ã®æ¥è¨ åã以åã«æ¸ããæ¬ãã¼ãã«é¢ããã¨ã³ããªã¯ä»¥ä¸ã®ï¼ã¤ã â ä¿¡ããããªãDBæåãJoinç¦æ¢ãã«ãåºå®é·DBãããã§ããåããã§ãã大è¦æ¨¡ã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã®RDBè¨ â ä¿¡ããããªãDBæåãåºå®é·DBãã§ããããã§ãã大è¦æ¨¡ã³ã³ã·ã¥ã¼ãåããµã¼ãã¹ã®RDBè¨è¨ â ãã³ãä¿¡ããããªãDBæåã ãã©ãçµ±è¨æ å ±åºå®åã¯ãã¸ã§ã¢ãª ã¡ããã©æãããã¦ãã®ä¼ç¤¾ã®ãªã©ã¯ã«å¥³åãæ¸ããã¨ã³ããªã®ç¶ããå ¬éããã¾ããã â ä¸ç·ã«ã¾ãªã¼ï¼ãhiromi ã¨æ¥½ããOracleããã©ã¼ãã³ã¹ãã¥ã¼ãã³ã°ï¼ããVol.2 Statspackãè¦ã¦ã¿ããã ã¨ãããã¨ã§åã®ä¸ã§DBç±ãçãä¸ãã£ã¦ããã®ã§è¿ççãªã¨ã³ããªãæ¸ãã¾ãã ãã¨ããããã¡ã¢ãªã ãæ°ã«ãã¦ããã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}