Feb 24, 2015 `add_foreign_key` gotchas in Rails 4.2 Rails 4.2 finally added native support for database-level foreign keys, which is great. You can write the following code in a migration (assuming the presence of a users table):
ãµã³ãã©ã³ã·ã¹ã³ã®ããã°ã©ãLaurie Vossæ°ãæ¸ããè¦éããªãè¨äºãè³ãã£ã¦ãã¾ããè¿å¹´ã®ãã¬ã¼ã ã¯ã¼ã¯ãã©ã¤ãã©ãªã®å®çªä¸ã®å®çªORãããã¼ãæ¢ã«ã¢ã³ããã¿ã¼ã³ãªã®ã§ã¯ã¨ããã®ãå½¼ã®ä¸»å¼µã§ãããã®è¨äºãæ¸ããã£ããã«ãªã£ãã®ã¯ãã®ãã¤ã¼ãã ããã§ãã I cannot overstate the degree to which ORM is a dangerous antipattern. â Laurie Voss (@seldo) June 9, 2011 ORM ãå±éºãªã¢ã³ããã¿ã¼ã³ã ã£ã¦ããã®ã¯ã©ãã ãè¨ã£ã¦ãè¨ãéãããã¨ã¯ãªã ãã®ãã¤ã¼ãã«å¯¾ãã¦åæ¹é¢(ActiveRecord, Doctrine, Hibernate)ããå¤ãã®ï¼æ¿ããï¼è¿ä¿¡ãå¯ãããã¦æ¸ãããã®ãåé¡ã®ã¨ã³ããªã§ããã¾ãã¯ã¢ã³ããã¿ã¼ã³ã¨ã¯ä½ãã®å®ç¾©ã¨ãã¦ä¸è¨ã®2ã¤ãæãã¦ãã¾ãã å½åã¯æç
DBæä½ãã¼ã« Emacs DBI ãä½ã£ã¦ã¿ã - æè¡æ¥è¨ï¼ kiwanami ãã®ãã¼ã«ã®ç®çã¯ãã¯ãã¹ãã©ãããã©ã¼ã ã§ä¾¿å©ãªDBæä½ç°å¢ãå®ç¾ãããã¨ã§ãã pgAdmin ã MySQL Query Browser ã®ãããªGUIã®è¯ããCUIã§å®ç¾ãã¦ã¿ããã¨ãã¦ã¿ã¾ãããããªãã¡ãã¼ãã®ããããããããããã®DBãã¼ã«ã§ããã¡ãªã¿ã«ããã®ãã¼ã«ã«ã¨ã£ã¦Emacsã¯ãã ã®å®è¡ç°å¢ã§ããEmacs使ããªã人ã§ã使ãã¨ä¾¿å©ã ã¨æãã¾ãã http://d.hatena.ne.jp/kiwanami/20120305/1330939440 Vimãã¼Vimãã¼ï¼ ã£ã¦äºã§ä½ãã¾ããã mattn/vdbi-vim - GitHub Database client for Vim https://github.com/mattn/vdbi-vim Emacsçã¯epcã¨ããRPCããã
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæé¡§ãã ããã¾ãããããããããé¡ããããã¾ãã
A5:SQL Mk-2ã¯è¤éåãããã¼ã¿ãã¼ã¹éçºãæ¯æ´ããããã«éçºãããããªã¼ã®SQLéçºãã¼ã«ã§ãã 髿©è½ãã¤è»½éã§ãä½¿ãæ¹ãåããããããã¨ãç®æ¨ã«éçºããã¦ãã¾ãã SQLãå®è¡ãããããã¼ãã«ãç·¨éããã»ãã«ãSQLã®å®è¡è¨ç»ãåå¾ããããERå³ã使ããããããã¨ãåºæ¥ã¾ãã ç¹å¾´ã»æ©è½ OCIæ¥ç¶ã»ç´æ¥æ¥ç¶ã»ADOã¾ãã¯ODBCãä»ããDBã¸ã®æ¥ç¶ Oracle Databaseã¯OCIçµç±ã®æ¥ç¶ã»ç´æ¥æ¥ç¶ãåºæ¥ã¾ãã PostgreSQLã¨MySQLã¯ç´æ¥æ¥ç¶ãåºæ¥ã¾ãã Microsoft SQL Serverã¯ãOLE DBãããã¤ããç´æ¥å¼ã³åºããæ¥ç¶ãã§ãã¾ãã IBM DB2ã¯ãODBCãã©ã¤ããç´æ¥å¼ã³åºããæ¥ç¶ãã§ãã¾ãã ãã®ä»ã®ãã¼ã¿ãã¼ã¹ã¯ãADOã¾ãã¯ODBCãå©ç¨ãã¦æ¥ç¶ãã¾ãã Oracle, PostgreSQL, MySQLã¯ãA5:SQL
ã¡ãã£ã¨è²ã ã¨èª¿ã¹ã¦ããã®ã§ã¡ã¢å¤ããã«ã¨ã³ããªã¼ ãã¼ãã«ã®æ§é ãåå¾ãã MySQL AB :: MySQL 5.1 ãªãã¡ã¬ã³ã¹ããã¥ã¢ã« :: 12.3.1 DESCRIBE æ§æ mysql> DESC user; +-----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------+------+-----+---------+----------------+ | id | int(4) | NO | PRI | NULL | auto_increment | | nick_name | varchar(30) | NO | | | | |
ãã¼ã¿ãã¼ã¹ç ç©¶è ã®å¤§å¾¡æããã¤ã±ã«ã»ã¹ãã¼ã³ãã¬ã¤ã«ã¼æ°ãããSQL URBAN MYTHSãï¼SQLé½å¸ä¼èª¬ï¼ã¨ããWebã»ããã¼ããèªèº«ãåµè¨ããä¼ç¤¾VoltDBã§å ¬éãã¦ãã¾ãã ä¸è¬ã«ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ã«å¯¾ãã¦è¨ããã¦ãããSQLã¯é ãããããã©ã³ã¶ã¯ã·ã§ã³ã®ã³ã¹ãã¯é«ããããã¨ãã£ãè©ä¾¡ã«ã¤ãã¦ãSQLãé ãã®ã§ã¯ãªããããã©ã³ã¶ã¯ã·ã§ã³ä»¥å¤ã®ã³ã¹ããé«ãããã®ã ãã¨åè«ããå 容ã ãããã¯åæ°ã以åãã主張ãã¦ããå 容ã§ã¯ããã¾ãããæè¿æµè¡ãã¦ããNoSQLãã¼ã¿ãã¼ã¹ã«å¯¾ããåè«ã«ããªã£ã¦ãããããå¤ãã®ã¨ã³ã¸ãã¢ã«åºæ¿ã«ãªãå 容ã¨ãªã£ã¦ãã¾ãã SQLã«é¢ãã6ã¤ã®é½å¸ä¼èª¬ é½å¸ä¼èª¬1ï¼SQLã¯é ããããNoSQLã®ãããªä½ã¬ãã«ãªã¤ã³ã¿ã¼ãã§ã¤ã¹ã使ãã¹ã é½å¸ä¼èª¬2ï¼ãã¼ããªã¥ã¼åãææã§ãSQLã¯åé¡å¤ é½å¸ä¼èª¬3ï¼SQLãã¼ã¿ãã¼ã¹ã¯ã¹ã±ã¼ã©ãã«ã§ã¯ãªã
SQLããããªãå®è¡ ãæ°´é¢-MINAMO-ãã«ã¯ããã«ããªã±ã¼ã·ã§ã³ã試ãã¦ããã ãããã«ããµã³ãã«ãã¼ã¿ãã¼ã¹ãç¨æãã¦ãã¾ãã æ°´é¢-MINAMO-ããã¦ã³ãã¼ããããã®æããã ãµã³ãã«ã®ãã¼ã¿ãã¼ã¹ã使ã£ã¦SQLãå®è¡ãããã¨ãã§ãã¾ãã ãã¡ãããæ°ãããã¼ã¿ãã¼ã¹ã使ããèªåã§ãã¼ãã«ãä½ããã¼ã¿ãæ¿å ¥ããã¨ãã£ããã¨ãã§ãã¾ãã OracleãSQLServerç¹æã®é¢æ°ã試ã ããªãã¯NVLã¨NVL2ã®éãããããã¾ããï¼ãµã¨æ°ã«ãªã£ããã®æãOracleãSQLServerç°å¢ããã°ã«ãªãã¦ããã¾ã3GãWi-Fiã§æ¥ç¶ã§ãããã¼ã¿ãã¼ã¹ããªãã¦ããOracleãSQLServerç¹æã®é¢æ°ãå©ç¨ããSQLã試ããã¨ãã§ãã¾ãã 颿°å¤æå¯¾å¿è¡¨ã¯ãã¡ãã â»æ°´é¢-MINAMO- for iPhone/iPod touchã§ã¯ãOracleã«æ¥ç¶ãããã¨ã¯ã§ãã¾ããã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}