SQL Fiddleã¯Webä¸ã§SQLãå®è¡ãã¹ãã§ãããã¼ã«ã§ããMySQLãPostgreSQLãSQLiteãªã©ã«å¯¾å¿ãã¦ãã¾ãã SQL Fiddle
3. 諸åã¯èªãã®çµé¨ããããããå¦ã¶ãã¨ã㧠ããã¨ãããå ¨ãæããªèãã§ããããã ä½ã¯ãããä»äººã®å¤±æãå¦ã¶ãã¨ã§ãèªå㮠失æãåé¿ãããã¨ã好ãã âãªããã¼ã»ãã©ã³ã»ãã¹ãã«ã¯ Nur ein Idiot glaubt, aus den eigenen Erfahrungen zu lernen. Ich ziehe es vor, aus den Erfahrungen anderer zu lernen, um von vorneherein eigene Fehler zu vermeiden.
楽ããèªããæ¬ã§ããããã¦ãã¨ã¦ãå®ç¨çã§ãï¼ SQLã¢ã³ããã¿ã¼ã³ ä½è : Bill Karwin,åç°å人(ç£è¨³),åç°çäº(ç£è¨³),å 島修åºç社/ã¡ã¼ã«ã¼: ãªã©ã¤ãªã¼ã¸ã£ãã³çºå£²æ¥: 2013/01/26ã¡ãã£ã¢: 大åæ¬è³¼å ¥: 9人 ã¯ãªãã¯: 698åãã®ååãå«ãããã° (38件) ãè¦ã ãã¼ã¿ãã¼ã¹è¨è¨ã¯ãWebã¢ããªãå§ããã»ã¨ãã©ã®ã·ã¹ãã ã®æ§è½ã»æ¡å¼µæ§ãããã¦éçºã®ããããã決å®ããé常ã«è¨è¨ã§ããããããåãããããããã¤å®è·µçãªæ¸ç±ã¯å¤ããªãã¨æãã¾ãããã®æ¬ã¯ãã¿ã¤ãã«éã ããããªãã¼ã¿ãã¼ã¹è¨è¨ãè¡ã£ã¦ã¯è¡ããªãï¼ã ã¨ããå 容ã§ãã ãã®æ¬ã¯ãã¼ã¿ãã¼ã¹è¨è¨(ã¢ããªã³ã°)ææ³ãæ±ã£ãæ¬ã§ã¯ãã¾ããã®ã§ããã¼ã¿ãã¼ã¹è¨è¨ã®åºæ¬ãç解ãã¦ã人åãã®æ¬ã§ããããã¼ã¿ãã¼ã¹è¨è¨ããã£ããã¨ãç¡ãã¦ããä½å¹´ãéçºãè¡ã£ã人ãªãããã以åãããã£ãã·ã¹ãã ã®DBãã®
WebSQL.jsã¯Web SQL Databaseã使ããããããJavaScriptã©ã¤ãã©ãªã§ãã æãããHTML5ã®ä»æ§ããã¯ããã¦ãã¾ãããæ°ããWebãã©ã¦ã¶ã®æ©è½ã«Web SQL Databaseãããã¾ãããããªWeb SQL Databaseããã使ãããããã¦ãããã©ã¤ãã©ãªãWebSQL.jsã§ãã ãã¢ã§ãããã¼ã¿ã追å ããããåé¤ãããã§ãã¾ãã ããã«è¿½å ãã¾ãããåèªã¿è¾¼ã¿ãã¦ãåç¾ãã¾ãã WebSQL.jsã¯ãã¼ã¿ãã¼ã¹ã®ä½æããã¼ãã«ã®ä½æããã¼ã¿ã®CRUDæä½ããã¼ãã«ã®åé¤ãè¡ãã¾ããããã«ãã©ã³ã¶ã¯ã·ã§ã³ãSQLã®å®è¡ãå¯è½ã§ããåã¡ã½ããã¯ãã§ã¼ã³ã§ã¤ãªãã§å®è¡ããããã¨ãå¯è½ã«ãªã£ã¦ãã¾ãã WebSQL.jsã¯JavaScript製ãMIT Licenseã®ãªã¼ãã³ã½ã¼ã¹ã»ã½ããã¦ã§ã¢ã§ãã MOONGIFTã¯ããè¦ã Web SQL Da
æ¬æ¸ã¯DBè¨è¨ãSQLè¨è¿°ã®éã«é¿ããã¹ãäºæã1ç« ã§1ã¤ã25åç´¹ä»ããæ¸ç±ã§ãããªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ãä¸å¿ã«æ®ããã·ã¹ãã éçºã«ã¯ãæ§ã ãªå ´é¢ã§é¥ãããã失æï¼ã¢ã³ããã¿ã¼ã³ï¼ãããã¾ããæ¬æ¸ã¯ãã¼ã¿ãã¼ã¹è«çè¨è¨ããã¼ã¿ãã¼ã¹ç©çè¨è¨ãã¯ã¨ãªã®è¨è¿°ãã¢ããªã±ã¼ã·ã§ã³éçºã¨ãã4ã¤ã®ã«ãã´ãªã«åããããããã®åéã«ãããã¢ã³ããã¿ã¼ã³ãç´¹ä»ãã失æãé¿ããããã®ããè¯ãæ¹æ³ãç´¹ä»ãã¾ããè¤æ°ã®å¤ãæã¤å±æ§ãå帰çãªããªã¼æ§é ã®æ ¼ç´ãããå°æ°å¤ã®ä¸¸ããNULLã®æ±ãã«èµ·å ããåé¡ãå ¨ææ¤ç´¢ãSQLã¤ã³ã¸ã§ã¯ã·ã§ã³ãMVCã¢ã¼ããã¯ãã£ãªã©ãå®è·µçãã¤å¹ åºããããã¯ãç¶²ç¾ ãã¾ããæ¥æ¬èªçã§ã¯ãMySQLã®ã¨ãã¹ãã¼ãã¨ãã¦èåãªå¥¥éå¹¹ä¹æ°ã«ããã¢ã³ããã¿ã¼ã³ãåé²ããã¼ã¿ãã¼ã¹ã«é¢ãããã¹ã¦ã®ã¨ã³ã¸ãã¢å¿ æºã®ä¸åã§ãã æ¬æ¸ã¸ã®ç§°è³ã®å£° ç£è¨³è ã¾ããã ã¯ããã« Ié¨ ãã¼ã¿ãã¼ã¹è«
Ruby on Rails(3.2.9, 3.1.8, 3.0.17以å)ã®find_by_*ã¡ã½ããã«SQLã¤ã³ã¸ã§ã¯ã·ã§ã³èå¼±æ§ãè¦ã¤ããã¾ãã(CVE-2012-5664)ããã®ã¨ã³ããªã§ã¯ãã®æ¦è¦ã¨å¯¾çã«ã¤ãã¦èª¬æãã¾ãã æ¦è¦ Ruby on Railsã®find_by_*ã¡ã½ããã®å¼æ°ã¨ãã¦ããã·ã¥ãæå®ãããã¨ã§ãä»»æã®SELECTæãå®è¡ã§ããèå¼±æ§ãããã¾ãã æ¤è¨¼ Ruby on Rails3.2.9ã®ç°å¢ãç¨æãã¦ã以ä¸ã®2ã¤ã®ã¢ãã«ãç¨æãã¾ããã $ rails g scaffold user name:string email:string $ rails g scaffold book author:string title:string ã¢ãã«Userã¯å人æ å ±ãä¿æãã¦ãããèªåèªèº«ã®æ å ±ã®ã¿ãé²è¦§ã§ããã¨ããæ³å®ã§ããã¢ãã«Bookã¯æ¸èªãã¼ã¿ãã¼ã¹ã§ã
DB Designer ã®ä½¿ãæ¹ãåç»ã§ãã§ã㯠ããã¸ã§ã¯ãã®ä½æ è¨è¨ã¯ããã¸ã§ã¯ããã¨ã«ç®¡çã§ãã¾ããã¾ãã¯ãå·¦ä¸ã®ãï¼ããã¿ã³ãã¿ãããã¦ããã¸ã§ã¯ããä½æãã¾ãã DB ã®ã¿ã¤ã㯠MS SQLãMySQLãPostgreSQLãSQLite ã®4ã¤ããé¸ã¹ã¾ããããã¸ã§ã¯ãåãªã©ã¯æ¥æ¬èªã§è¨å®ãããã¨ãã§ãã¾ãã å種ããã¸ã§ã¯ãã®æå®ãããããSaveããã¿ãããã¾ãã ãã¼ãã«ã®æ°è¦è¿½å è¨è¨ç»é¢ã¯ç½ç´ã®ç¨ç´ã®ããã«ã·ã³ãã«ã§ããããã¸ã§ã¯ãåã帰ãå ´åã¯å·¦ä¸ã®ã©ãã«ãããæ°è¦ãã¼ãã«ãè¨è¨ãã¦ãã¨ãã¯ãï¼ããã¿ãããããã¨ãç½ãé¨åãã¿ãããã¾ãã ããã§ã«ã©ã ãè¨å®ããã¦ããªã空ãã¼ãã«ãä½æããã¾ãã次ã¯ãã¼ãã«ã®è©³ç´°æ å ±ã®ç·¨éã«é²ã¿ã¾ãã ãã¼ãã«è©³ç´°æ å ±ã®ç·¨éæ¹æ³ ä½æãããã¼ãã«ã«ã«ã©ã ã追å ããã«ã¯2ã¤ã®æé ãå¿ è¦ã§ããã¾ããç»é¢å·¦ã«ããã¡ãã¥ã¼ãã¿ã³ãããi
(PgDay2012çºè¡¨è³æ) SQLã«ã¨ã£ã¦ããªãO/Rãããã¼ãéè¦ãã説æããè³æã§ããRead less
December 07, 201215:49 ã«ãã´ãªããã°ã©ãã³ã°mysql O/Rãããã¼ã¯ãªãæªãã»2 ååããSQLã«ã¯ââã足ããªãï¼ãããããªãï¼ããã§...O/Rãããã¼ï¼ãã¿ãããªã¹ã©ã¤ããè¦ãæ°ããã¦ãã²ã©ãO/Rãããã¼ã«ããããè¦ãããããè¨æ¶ããã©ãã·ã¥ããã¯ã®ããã«è¥²ã£ã¦ãã¦ã ãã¶ã±ã³ãï¼ãåãO/Rãããã¼å¤§å¥½ãæã®ããã§ãã£ã¡ã¯ï¼ãã£ã¡ã¯...ã©ãã ãè¦å´ããã! ã£ã¦ãã¼ã£ã¨ãªã£ã¦è¨äºæ¸ãããã ãã¯ï¼æè¿ã®O/Rãããã¼ã¯ãããªã¢ããããªããï¼wãããï¼ã¯ããããã ã£ããã§ããã¼ã ã¿ãããªæãã§ç¬æ®ºããã¦æ®å¿µãªæãã«ãªã£ãwããããã§ããªããéãããã®æ°æã¡ããªãã ãããã¿ããªã«ãä¼ãããããªã®ã§ããã¡ãã£ã¨æ¸ãã èªåã®O/Rãããã¼ä¸ä¿¡ã«ã¯ããã¤ãã®ã¬ã¤ã¤ã¼ããã£ã¦ããã¾ã ã«ããããã¾ãæ´çã§ããªããã ãã©ããã¶ã 1. ç¾å®ã¬ãã«ã®å
December 07, 201208:49 ã«ãã´ãªããã°ã©ãã³ã°mysql O/Rãããã¼ã¯ãªãæªã ã¿ã¤ã ã©ã¤ã³ã§ãSQLä¸ç´è ããç¥ã£ã¦æ¬²ããããªãO/Rãããã¼ãéè¦ãï¼ãã£ã¦ã®ãè¦ããã¦å± ã¦ãç«ã£ã¦ãããããªããªã£ãã®ã§ãæ¢åºãæ¿ç¥ã§åè«ãã¦ããããã ã¹ã©ã¤ãã ããã話ã®å 容ãæ¨æ¸¬ããã¨ã -- 販売æ績ä¸ä½10åãæ½åº select * from sales where deleted = false order by amount desc limit 10 ã¨ãã£ãSQLã Sales.active().top(10).all() ã®ããã«ãç´°ããå解ããé¨åãçµã¿åããã¦è¡¨ç¾ã§ããæ¹ã便å©ã ãæ§é çã§ããï¼ã¨ãã話ã®ããã ã ããã¯ç¢ºãã«ä¸è¦ç¾ããã®ã ããããããããæ·å± ãä¸ãããã¦ãdbã®æ§è³ªãåãã£ã¦ãªã人ã¾ã§æ°è»½ã«SQLããããããã«ãªã£ãçµ
ã°ã¼ã°ã«ãMySQLäºæã®ãGoogle Cloud SQLãæ§è½å¼·åãæ大ã§ã¡ã¢ãª16GBã¸æ¡å¼µãGoogle Apps Scriptãããå©ç¨å¯è½ã« ã°ã¼ã°ã«ã¯Google App Engineã§æä¾ãã¦ããMySQLäºæã®ãã¼ã¿ãã¼ã¹ãµã¼ãã¹ãGoogle Cloud SQLãã®æ§è½å¼·åãæããã«ãã¾ãããGoogle Developpers Blogã«ãã¹ããããã¨ã³ããªãGet started at no cost with a faster, larger Cloud SQL databaseãã§æ¬¡ã®ããã«èª¬æãã¦ãã¾ãã ã¹ãã¬ã¼ã¸å®¹éãå¾æ¥ã®10GBããæ大100GB㸠ã¤ã³ã¹ã¿ã³ã¹ã®ã¡ã¢ãªå®¹éãå¾æ¥ã®4GBããæ大16GBã¨ãªããèªã¿è¾¼ã¿é度ãåä¸ éåæã¬ããªã±ã¼ã·ã§ã³ãé¸æå¯è½ã«ãããã¨ã§ãæ¸ãè¾¼ã¿é度ãåä¸ æ¬§å·ãã¼ã¿ã»ã³ã¿ã¼ã§æä¾éå§ Google Appsã®Go
æ¬ ç¹$rs->pager(); ã®ããã«ãã¯ã¨ãªããã£ã¦ããã£ã½ããªãã®ã«è£ã§ãã£ã¦ãã®ã§ãéãå¦çãªã®ã«ããããã«ã¿ããªãã¦ãããã®ãé¢åããæ°è»½ã«ã¤ããããã¦å±éºã HAVING ãªã©ãã¤ããã¯ã¨ãªã®å ´åããããããã ããå¤ãã¨ãã¦ãªãã®ã«ããªãã¨ãªããããã¦ãã¾ããã¾ã¡ãã£ãå¤ãããã API ãæ¨æºã§ã¤ããã®ã¯ããããªãã®ãã å¾ã« HAVING ãªã©ã®å¦çããã¾ãã§ããªãã®ã¯èªæãªã®ã§ãããããå®è£ ã¯åã¯å¥½ãã§ã¯ãªãã§ãã â Teng ã«ã¯ã¤ãã¦ãªãã
1ãé£è¼ã®æ¦è¦ 1.1ãæ¬é£è¼ã®è¶£æ¨ã¨æ¦è¦ åºå¹¹ç³»ã¯ã½ã¼ã·ã£ã«ç³»ãªã©ã«æ¯ã¹ã¦ã誤解ãæãè¨ãæ¹ããããã¾ãããä¿å®çãªé¢ããããå 端çãªæ©è½ãªã©ã®åãè¾¼ã¿ãé ããã¡ã§ããã¾ããå®éåé¡ã¨ãã¦åºå¹¹ç³»ã§ã¯ã½ã¼ã·ã£ã«Webãªã©ã«æ¯ã¹ã¦ãã·ã¹ãã æ©è½ã®è¦ä»¶ã®ãã¼ãã«ãé«ããªãé¨åãå¤ãã§ããããããã®ãããªåºå¹¹ç³»ã ãããããã¯ã©ã¦ãä»Webã®å 端æ©è½ãå©ç¨ããã°ã©ã®ããã«å¤è²ã»å¹çåããããèãã¦ã¿ãã®ãæå³ã®ãããã¨ã¨çè ã¯èãã¾ãã æ¬ç¨¿ã§ã¯8åç¨åº¦ã®ããé·æã®é£è¼ãäºå®ãã¦ãã¾ããå 容ã¨ãã¦ã¯ãGoogleã®PaaSã¯ã©ã¦ãï¼Google App Engineã以å¾GAEï¼ä¸ã§RDBã®MySQLã使ç¨ã§ããããã«ãããGoogle Cloud SQLããä¸å¿ã«åãä¸ãã¾ããããã®ä»ã«ããã¾ãã¾ãªãã¼ã«ããµã¼ãã¹ã¨çµã¿åãããå 容ã«ããäºå®ã§ãã ãµã¼ãã¹ã®çµã¿åããã§åãä¸ããå 容ã¨ãã¦ã¯W
çãããããã°ãã¯ã笹äºã§ãã 7æããã£ã¨ããéã«10æ¥éãéãã¦ãå¤çã£çãã«ãªã£ã¦ãã¾ããã èªåãå¤å¯¾çã§ã¢ã¤ã¹ç ã¨ãããããã¬ã¹ãè³¼å ¥ãã¦å¤ãä¹ãè¶ãããã¨æã£ã¦ããã¾ãã ãã¦ãæ¬æ¥ã¯ã¹ãã¢ãããã·ã¼ã¸ã£ã«ã¤ãã¦æ¤è¨¼ããã¦ã¿ããã¨æãã¾ãã ã¹ãã¢ãããã·ã¼ã¸ã£ã¨ã¯ãä¸é£ã®SQLæãå¦çã«ååãã¤ãã¦ä¿åãããã®ã§ãã PHPã®é¢æ°ã¨åãã§SQLãé¢æ°ã¿ããã«ãããã®ãã¹ãã¢ãããã·ã¼ã¸ã£ã«ãªãã¾ãã MySQLã§ã¯ã¹ãã¢ãããã·ã¼ã¸ã£ã¯MySQLã§ã¯5.0ããå©ç¨ãå¯è½ã§ãã ä»åã¯MySQLã®ã¹ãã¢ãããã·ã¼ã¸ã£ã®ä½¿ãæ¹ã ãã§ã¯ãªãã çPHPã§è¨è¼ããã¨ãã¨ã®ããã©ã¼ãã³ã¹ãæ¯è¼ãã¦ã¿ããã¨æãã¾ãã MySQLã®ã¹ãã¢ãããã·ã¼ã¸ã£ãå¼ã³åºãã¦å¦çãããPHPããã°ã©ã ã¨ã¹ãã¢ãããã·ã¼ã¸ã£ã§ä½æãããã®ã¨åãSQLãå®è¡ããPHPããã°ã©ã ãä½æãã¾ãã ä¸è¨ï¼ã¤ã®ã
SQLã¨NoSQLã§ã¯ã©ã¡ããåªãã¦ããã®ãï¼ ã°ã¼ã°ã«ã®æ å½è ããã£ãã¼ãï¼ã¨ããããå°èå± ï¼-ï¼ãè¡ã£ãã»ãã·ã§ã³ãGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeããå ¬éããã¦ãã¾ãã ï¼ãã®è¨äºã¯ãSQL vs NoSQLãã°ã¼ã°ã«ã«ãããæ¦ãï¼åç·¨ï¼ãGoogle I/O 2012ãã®ç¶ãã§ãï¼ ã¹ã±ã¼ã©ããªãã£ã«ã¤ã㦠ï¼NoSQLæ å½ï¼ããããé¢ã§ããã¡ããé«ãã¹ã±ã¼ã©ããªãã£ãæä¾ãã¦ããã ï¼SQLæ å½ï¼ãããªè¨³ãªãã ãã ï¼NoSQLæ å½ï¼ãããªè¨³ãããã ï¼SQLæ å½ï¼ãããã¾ããCloud SQLãã©ã使ããã¦ãããç´¹ä»ããããä¾ãã°ãã°ã¼ã°ã«orgãã£ã¼ãããã°ã¼ã°ã«ã®3ä¸äººã®å¾æ¥å¡ã«ã¤ãã¦ãçµç¹å ã®ã¤ãªãããä»äºã示ãã¢ããªã±ã¼ã·ã§ã³ã ã 社å ã§ã¯èª°ãããã®Webãµã¤ããéãã¦ãã¦ã
SQLã¨NoSQLã§ã¯ã©ã¡ããåªãã¦ããã®ãï¼ ã°ã¼ã°ã«ã®æ å½è ããã£ãã¼ãï¼ã¨ããããå°èå± ï¼-ï¼ãè¡ã£ãã»ãã·ã§ã³ãGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeããå ¬éããã¦ãã¾ãã ãã®ã»ãã·ã§ã³ã¯ãå ã é±éå¬ãããGoogle I/O 2012ã§è¡ããããã®ãSQLã¨NoSQLã«ã¯æ©è½çã«ã©ã®ãããªéãããããã©ã使ãåããã¹ããªã®ããæ確ãªèª¬æãåèã«ãªãã¾ãã ãã¤ã©ã¤ããç´¹ä»ãã¾ãããã ã¯ã©ã¦ãã«ããããã¼ã¿ãã¼ã¹ã®ã¡ãªãã ã°ã¼ã°ã«ã®Alfred Fulleræ°ï¼NoSQLæ å½ï¼ã ã¯ã©ã¦ãã¯ãã©ã«ããã¬ã©ã³ãã§ã¡ã³ããã³ã¹ä¸è¦ãããããç§ãã¡ãé©ç¨ãã¦ãããå©ç¨è ã¯éç¨ã«ã¤ãã¦å¿é ããå¿ è¦ããªããã¨ãã£ãã¡ãªãããããã ãã¼ã¿ã®ã¬ããªã±ã¼ã·ã§ã³ãå°ååæ£ã§ãã¼ã¿ãä¿å ¨ãããã¤ã³ã¿ã¼ãã
Oculusã¯ãã¸ãã¹ç¨ãã¼ã¿ãã¼ã¹ã¯ã¨ãªã¼å ±æã·ã¹ãã ã§ãã éçºè ã®æã«ã¯ãã³ãã³ã¦ã¼ã¶ã訪ãã¦ãã¦ãã¼ã¿ãã¼ã¹ããä¸å®ã®æ¡ä»¶ã§æãåºãããã¼ã¿ã欲ããã¨è¨ããããã¨ãããã¾ãããããªãã¨ãç¹°ãè¿ãããã¨SQLãããã¹ããã¡ã¤ã«ã§æ®ãã¦ãããããã人ãå¤ãã®ã§ã¯ãªãã§ãããããããã§ä½¿ã£ã¦ã¿ããã®ãOculusã§ããã¯ã¨ãªã¼ãå ±æãããããã¼ã¿ã®ãã¦ã³ãã¼ããã§ãã¾ãã ã¤ã³ã¹ãã¼ã«ã¯RubyGemsã§è¡ãã¾ãã ãªãã·ã§ã³ã§ããã¦ã¼ã¶åããã¹ã¯ã¼ãããã¼ã¿ãã¼ã¹ãæå®ãã¦å®è¡ãã¾ãã èµ·åãã¾ããã å®è¡ãã¾ãããçµæãä¸ã«è¡¨ç¤ºããã¾ãã ãã¼ã¿ã¯ãã¼ãã«ä¸ã«è¡¨ç¤ºããã¾ãã ãã¡ãã¯ã¯ã¨ãªã¼ãã°ã§ãã ã¯ã¨ãªã¼ãä¿åãã¦ããã¾ãããæ°ã«å ¥ãç»é²ãå¯è½ã§ããçµæã¯ãã¦ã³ãã¼ããã§ãã¾ãã ãæ°ã«å ¥ãã®ã¯ã¨ãªã¼ä¸è¦§ã§ãã Oculusãå ±æãã¦ä½¿ãã°ãæåã¯éçºè ãã¯ã¨ãªã¼ãä½æããå¾ã¯
BigQueryã¯ã«ã©ã åãã¼ã¿ã¹ãã¢ã®ä¸ç¨®ã§ããã©ãã¤ãã¯ã©ã¹ã®å¤§è¦æ¨¡ãã¼ã¿ã«å¯¾ãã¦å¤§éã®ä¸¦åå¦çãè¡ããã¨ã§é«éã«çµæãå¾ããã¨ãå¯è½ãã°ã¼ã°ã« ä½è¤ä¸æ²æ°ã®çºè¨ã«ããã¨ã OLAP/DWH/Data Miningã§è¡ããããããªread onlyã®ad hocã¯ã¨ãªããããã¦é«éï¼æ°ç§ãæ°åç§ï¼ã«å®è¡ãã¾ãã ã¨ã®ãã¨ã SQLã«ããåãåãããå¯è½ ãã®é«éæ§ã«å ããBigQueryã§ã¯SQLãåãåããè¨èªã«ä½¿ããã¨ããç¹ã«ã大ããªç¹å¾´ãããã¾ããæ°ç§ç¨åº¦ã®ã¬ã¹ãã³ã¹ã¨SQLæã«ããè¨è¿°ã¯ã大è¦æ¨¡ãã¼ã¿ã«å¯¾ããã¢ãããã¯ãªå¦çãè¡ãã®ã«é©ãããµã¼ãã¹ã ã¨ãããã§ãããã BigQueryã®SQLã®æ§æã¯ãQuery Referenceãã§è§£èª¬ããã¦ãã¾ãããSELECTæã«FROMãWHEREãJOINãHAVINGãGROUP BYãORDER BYãLIMITãªã©ã使ãããã
Javaè¨èªããã®ã¢ã¯ã»ã¹ã§ãCloud SQLã§ã¯MySQLã®åçSQLã使ç¨ããBigtableã§ã¯Low-Level APIã使ç¨ãã¦ãã¾ããBigtableã¢ã¯ã»ã¹ç¨ã®APIã¨ãã¦ã¯ãã®ä»ã«ãæ¥æ¬çºã®ãªã¼ãã³ã½ã¼ã¹ãã¬ã¼ã ã¯ã¼ã¯ã®Slim3ãJDOï¼Java Data Objectsï¼ãJPAï¼Java Persistence APIï¼ãªã©ãããã¾ãããã¢ã¯ã»ã¹ããã©ã¼ãã³ã¹ã§ã¯ãããã§ä½¿ç¨ããLow-Level APIãæãåªãã¦ããã¯ãã§ãã å¦çã¹ãã¼ãæ¯è¼ å¦çã¹ãã¼ãã®æ¯è¼ã¯ãã¢ã¤ãã ãã¹ã¿ã®CRUDå¦çï¼ç»é²ã»åç §ã»æ´æ°ã»åé¤ï¼ãããããåãç»é¢å 容ããã®ã¢ã¯ã»ã¹ã§ãBigtableã¯ã¯ã©ã¦ãç°å¢ã§ãCloud SQLã§ã¯ã¯ã©ã¦ãã¨ãã¼ã«ã«ã®ä¸¡æ¹ã§æ¸¬å®ãè¡ã£ã¦ãã¾ããå¦çæéã®æ¸¬å®ã§ã¯è©²å½ã®ã¡ã½ãããå¼ã³åºãããç¬éããç»é²ãªã©ã®å¦çå®äºç´å¾ã¾ã§ã®æéããããããã®å¦ç
XAMPPç°å¢ããGoogle Cloud SQLã«ç§»è¡ããã«ã¯ï¼Google Cloud SQLã¯åºå¹¹ç³»ã§ä½¿ããã®ãï¼åç·¨ï¼ï¼1/4 ãã¼ã¸ï¼ ã°ã¼ã°ã«ã®ã¨ã³ã¿ã¼ãã©ã¤ãºã¸ã®ææ¦ã¯æåããã®ã ã°ã¼ã°ã«ã¯2011å¹´10æ7æ¥ã«ãGoogle Cloud SQLãã®ãµã¼ãã¹éå§ãçºè¡¨ãã¾ãããGoogle Cloud SQLï¼ä»¥éãCloud SQLï¼ã¯ããGoogle App Engineãï¼ä»¥éãGAEï¼ããå©ç¨ã§ããRDBï¼ãªã¬ã¼ã·ã§ãã«ãã¼ã¿ãã¼ã¹ï¼ã¢ã¯ã»ã¹æ©è½ã§ãRDBã¨ãã¦MySQLã使ç¨ãã¾ããããã¾ã§GAEã§ä½¿ç¨ã§ãããã¼ã¿ã¹ãã¢ã¯ããããããNoSQLãã®ãBigtableãã ãã§ããããããã§NoSQLã¨SQLã®ä¸¡æ¹ã使ããããã«ãªã£ãããã§ãã Cloud SQLã®ããªã¼ã¹ã¯ãããæ°å¹´ã°ã¼ã°ã«ãæåãã¦ãããã¨ã³ã¿ã¼ãã©ã¤ãºãã£ã¬ã³ã¸ã®ä¸ã«ä½ç½®ä»ãããã¾ããã¯ã©ã¦ãã¯
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}