ããã¸ã¿ã«äººæã®è²æãã伿¥ã®æé·ãå éãããã e-Learningãããã³ãºãªã³ç ä¿®ã¾ã§å¹ åºã対å¿ããæ³äººåããµã¼ãã¹ã
Building native extensions. This could take a while... ERROR: Error installing mysql2: ERROR: Failed to build gem native extension. current directory: /Users/aki/.rbenv/versions/2.7.0/lib/ruby/gems/2.7.0/gems/mysql2-0.5.3/ext/mysql2 /Users/aki/.rbenv/versions/2.7.0/bin/ruby -I /Users/aki/.rbenv/versions/2.7.0/lib/ruby/2.7.0 -r ./siteconf20200324-90394-m50btx.rb extconf.rb checking for rb_absint_si
ã¯ããã« 2019å¹´10æç¾å¨Macã§Railsã¢ããªéçºæã«DBã«MySQLã鏿ããå ´åãããã©ã«ãã§ã¯mysql2ã¨ããgemãã¤ã³ã¹ãã¼ã«ãã¾ãã ãã®æã«ããã¤ãã¨ã©ã¼ã«åºä¼ã£ãã®ã§ãã¾ã¨ãã¦ããã¾ãã å®è¡ç°å¢ macOS Mojave v10.14.6 ruby v2.6.4 Rails v6.0.0 MySQLã®ã¯ã©ã¤ã¢ã³ããå¿ è¦ Macã«MySQLã¯ã©ã¤ã¢ã³ããã¤ã³ã¹ãã¼ã«ãã¦ããªãå ´åã以ä¸ã®ãããªã¨ã©ã¼ã表示ããã¾ãã Fetching mysql2 0.5.2 Installing mysql2 0.5.2 with native extensions Gem::Ext::BuildError: ERROR: Failed to build gem native extension. current directory: /Users/hogehoge/sample
ãã¾ããDockerãã¯ããã¦ã¿ã¾ããã ã³ãã³ããå¿ããããããå¤ãã£ããæççã«ããæ¬²ããæ å ±ããªãã£ããã㦠ã©ã®ããã«åä½ãã¦ããã®ãææ¡ã«è¦ããã ã®ã§åå¿é²å«ãã¦ã¾ã¨ãã¦ããã¾ãã ï¼ãã®è¨äºã ãã§ä¸éãã®ä½¿ãæ¹ã¯ãããããã«ããã¤ããã§ããï¼ Dockerã使ããã¨ã®ã¡ãªããã¯æ¬¡ã®ãããªãã®ãããã¾ãã Dockerã³ã³ããä¸ã«ä»®æ³ç°å¢ï¼OS+ããã«ã¦ã§ã¢ï¼ãæ§ç¯ãããããå®ç°å¢ãæ±ããªã 使ããDockerã³ã³ããã¯ã¤ã¡ã¼ã¸ãã¡ã¤ã«åï¼Dockerã¤ã¡ã¼ã¸ï¼ã§ãã Dockerã¤ã¡ã¼ã¸ã¯Docker Hubã§ãã©ã¤ãã¼ããããã¯ãããªãã¯ãªãã¸ããªã«ãã¼ã¸ã§ã³ç®¡çï¼å ¬éã§ãã Dockerã¤ã¡ã¼ã¸ãæã£ã¦ãã¦ã³ã³ããèµ·åããã ããªã®ã§ç°å¢ç§»è¡ã楽 Dockerfileã¨å¼ã°ããç°å¢ä½æãã¡ã¤ã«ããDockerã¤ã¡ã¼ã¸ã®ä½æãã§ãã DBãµã¼ãã®åã³ã³ãããç¨æãã ã¢ããªãµ
4æã«MySQL 8.0ã®Unicodeã¨æ¥æ¬èªå¯¾å¿ã«ã¤ãã¦Manyi Luããã¨ãã£ã¹ã«ãã·ã§ã³ããä¼ããã£ã¦ãããªããããã話ãã¦ã¨ã¦ãããä¼ã ã£ãããã®å¾ããããèãã¦æãã¦ãæ¸å¿µã端çã«æ¸ãè¨ãã¦ããã ããã©ã«ãã®collationãutf8mb4_0900_ai_ciã«ãªã£ã ããã«é¢ãã¦åã¯å¼·ãæ¸å¿µãæã£ã¦ãããMySQL 8.0以åã«ããã¦ããµã¤ãã®Webã¢ããªã±ã¼ã·ã§ã³ãªã©ã§æ¥æ¬èªãæ±ãå ´åãå®ç¨ä¸ããã©ã«ãã®utf8mb4_general_ciãutf8mb4_binã®2æã§ãã£ãã¨æããããã©ã«ããutf8mb4_general_ciãªã®ã§æ°ããä½ãããã¢ããªã±ã¼ã·ã§ã³ã¯éå¸¸ã¯æ¿ç¹åæ¿ç¹ãåºå¥ãããç¶æ ã§ä¸ã«åºã¦ãããã¨ã«ãªãããã©MySQL 8.0.1ã®ããã©ã«ãã®utf8mb4_0900_ai_ciã¯æ¿ç¹åæ¿ç¹ãåºå¥ããªãã®ã§ãå°æ¥ã¦ã¼ã¶ã¼åãç»é²ããã¨ããã§ãã¤
WHY æ©æ¢°å¦ç¿ã®ã¢ãã«ã¯ã§ãããã©ããµã¼ãã¹ã¤ã³ããã«ã¯ä½ããã®å½¢ã§webå´ããåä½ã§ããå½¢ã«ããå¿ è¦ãããã¾ãã Railsã ã¨éãããããGoè¨èªä½¿ãããã ãã®ãããªã¢ããã¼ã·ã§ã³ããç§ã¯Goè¨èªã§APIã使ãã¾ããã Goè¨èªã®WEBãã¬ã¼ã ã¯ã¼ã¯ã¯å¤ã ããã¾ãããä»åç´¹ä»ããè¨äºã¯revelãç¨ãã¦ãã¾ãã ã³ã³ããã¨ã³ã¼ããå ¬éãã¦ããã®ã§ããã«åä½ã確èªãããã¨ãå¯è½ã«ãã¦ãã¾ãã Docker: https://hub.docker.com/r/masayaresearch/go_api/ github: https://github.com/SnowMasaya/go_revel_jwt_mysql revelãæ¡ç¨ããçç±ã¯ä¸è¨ã§ãã testã®ããã®æ©è½ãæã£ã¦ãã deployãç°¡å å¿ è¦ãªãµã³ãã«ããã WHAT ä½ããããã¨ãæ³å®ãã¦ããã ç°¡åãªèªè¨¼ AP
ããããä¸çã§ãã£ã¨ãå¤§è¦æ¨¡ã«MySQLã®ã¯ã©ã¹ã¿ãå±éããéç¨ãã¦ããã®ãFacebookã§ããããè¤æ°ã®ãã¼ã¿ã»ã³ã¿ã¼ã«ã¾ãããä½åå°ãã®MySQLãµã¼ããéç¨ããããã«ãèªååã®ä»çµã¿ã¯æ¬ ããã¾ããã ãã®èªååãã©ã®ãããªä»çµã¿ã«ãªã£ã¦ããã®ããFacebookã®ãã¼ã¿ãã¼ã¹ã¨ã³ã¸ãã¢ã§ããShlomo Priymakæ°ããUnder the hood: MySQL Pool Scanner (MPS)ã¨ããè¨äºãFacebookã§å ¬éãã¦ãã¾ãã ããªãé·ãè¨äºãªã®ã§ãããã§ã¯ãã®ãã¤ã³ããã¾ã¨ãã¦è§£èª¬ãã¦ã¿ã¾ããã詳細ã¯ãã²åæãããã£ã¦ã¿ã¦ãã ããã MPSã®ãããª3ã¤ã®æ©è½ Facebookã§ç¨¼åãã¦ããMySQLã¯ãã¤ãã«1ã¤ã®ãã¹ã¿ã¼ã¨ããããã¬ããªã±ã¼ã·ã§ã³ãããè¤æ°ã®ã¹ã¬ã¼ãã«ããã¬ããªã«ã»ãããæ§æãã¦ãã¾ãããã®ã¬ããªã«ã»ããã®æ§é ãç¶æãç¶ãããã¨ã§ãå¯ç¨æ§ã¨
å æ¥å»ºã¦ãã ãã ã£ãç¶æ ã®Webãµã¼ããã¡ãã£ã¨å©ç¨ãã¦ã¿ãã ä»åã¯ç°¡åãªã¨ããã§PHPã ããå©ç¨ãããå®¶è¨ç°¿ããä½ã£ã¦ã¿ããã¨ã«ããã SQLã§ãã¼ã¿ãã¼ã¹ãå©ç¨ããã®ããã¹ããªã®ã ããã ããã»ãã¥ãªãã£é¢ã§ä¸å®ãããã®ã§å©ç¨ããã®ãåé¿ãã¦ã¿ãããã®çµæãã¼ã¿ã®ä¿æã§å°ãæ©ããã¨ã«ãªã£ãã®ã ãããã PHPã¯ãã§ã«ã¤ã³ã¹ãã¼ã«æ¸ã¿ã ã£ãããä»åã¯ç»åã使ããããã®ã©ã¤ãã©ãªãã¤ã³ã¹ãã¼ã«ããå¿ è¦ããã£ãã®ã§ã次ã®ã³ãã³ãã§ã¤ã³ã¹ãã¼ã«ããã $ sudo apt-get install php5-gd ã¤ã³ã¹ãã¼ã«ãå®äºããããApacheãåèµ·åããã $ sudo /etc/init.d/apache2 restart ã¨ããããåãç¨åº¦ã«å®æããã æä¾ã®ã«ã¬ã³ãã¼ã®ãã¼ã¸ãæéåè¨ã¨é¸æãã¦ããæ¥ã®ãåå ¥ãã¨ãæ¯åºãã表示ããããã«ããã æéã®åè¨ã表示ããç»é¢ãåé ç®æ¯
windwosããubuntuã¸ãªã¢ã¼ããã¹ã¯ãããã§æ¥ç¶ã§ããããã«ããã ubuntu(ãµã¼ãå´)ã§xrdpãå©ç¨ãããã¨ã§ç°¡åã«å®ç¾ã§ããã®ã§ã¤ã³ã¹ãã¼ã«ããã $ sudo apt-get install xrdp Ubuntuã®Unityãã¹ã¯ãããç°å¢ã¯xrdpã§ãµãã¼ãããã¦ããªãã¿ãããªã®ã§ãLXDEãã¤ã³ã¹ãã¼ã«ããã $ sudo apt-get install lxde ç¶ãã¦è¨å®ãããã $ echo lxsession -s LXDE -e LXDE > ~/.xsession æå¾ã«xrdp ãåèµ·åãã¦å®äºããã $ sudo service xrdp restart ãã¼é åãè±èªé åã«ãªã£ã¦ãããããæ¥æ¬èªç¨ãã¼ãã¼ãã使ããããã«ããã æºåã¨ãã¦ãå¿ è¦ãªãã¡ã¤ã«ããã¦ã³ãã¼ãããã $ wget http://w.vmeta.jp/temp/km-04
æ»æã«å©ç¨ãããå ´åãroot権éã§ä»»æã®ã³ã¼ããå®è¡ããããµã¼ããå¶å¾¡ãããå¯è½æ§ãææããã¦ããã ç±³Oracleåä¸ã®ãªã¼ãã³ã½ã¼ã¹ãã¼ã¿ãã¼ã¹ãMySQLãã«æªè§£æ±ºã®èå¼±æ§ãè¦ã¤ãã£ãã¨ãã¦ãã»ãã¥ãªãã£ç ç©¶è ã9æ12æ¥ã«æ¦ç¥ãã³ã³ã»ããå®è¨¼ã³ã¼ããå ¬éããããµã¤ãã¼æ»æã«å©ç¨ãããå ´åãroot権éã§ä»»æã®ã³ã¼ããå®è¡ããããµã¼ããå¶å¾¡ãããå¯è½æ§ãææããã¦ããã ç ç©¶è ã®Dawid Golunskiæ°ãå ¬éããæ å ±ã«ããã°ãMySQLã®èå¼±æ§ã¯è¤æ°çºè¦ããããä¸ã§ãç¹ã«æ·±å»ãª1ä»¶ã«ã¤ãã¦ã¯ããªã¢ã¼ãã®æ»æè ãMySQLã®è¨å®ãã¡ã¤ã«ã«ä¸æ£ãªå 容ãä»è¾¼ãSQLã¤ã³ã¸ã§ã¯ã·ã§ã³æ»æã«å©ç¨ãããæããããã ãã®èå¼±æ§ã¯ãMySQLã®ææ°çãå«ã5.7ç³»ã5.6ç³»ã5.5ç³»ã®å ¨ãã¼ã¸ã§ã³ã«ãããã©ã«ãã®ç¶æ ã§åå¨ãããç¾æç¹ã§Oracle MySQLãµã¼ãã®èå¼±æ§ä¿®æ£ãããã¯åå¨
Windowsç°å¢ã«ã¤ã³ã¹ãã¼ã«ããMySQLã®åæè¨å®ã¨åä½ç¢ºèªæ¹æ³ãç´¹ä»ãã¾ãã MySQLãWindowsç°å¢ã¸ã®ãã¦ã³ãã¼ãã»ã¤ã³ã¹ãã¼ã«ããæ¹æ³ã¯ãã¡ããåèã«ãã¦ãã ããã MySQLã®ãã¦ã³ãã¼ãã¨ã¤ã³ã¹ãã¼ã« MySQLã®åæè¨å® - ç°å¢å¤æ°ã®è¨å® MySQLã®binã³ãã³ããç°¡åã«ä½¿ããããã«ãã¹ãéãã¾ãï¼ç°å¢å¤æ°ãè¨å®ãã¾ãï¼ãç°å¢å¤æ°ã«ã¤ãã¦ã¯ãã¡ããåèã«ãã¦ãã ããã ã·ã¹ãã ã®ããããã£ãããç°å¢å¤æ°ã®è¨å®ããã¯ãªãã¯ãã¾ãã ã·ã¹ãã ç°å¢å¤æ°ã®Path夿°ã鏿ãããç·¨éããã¯ãªãã¯ãã¾ãã Path夿°ã«ã;C:Â¥Program FilesÂ¥MySQLÂ¥MySQL Server 5.6Â¥binãã追å ãããOKããã¯ãªãã¯ãã¾ãã ããã§ç°å¢å¤æ°ã®è¨å®ã¯å®äºã§ãããOKããã¯ãªãã¯ãã¾ãã MySQLã®åä½ç¢ºèª Windowsçã®ã¤ã³ã¹ãã¼ã©ã§ãMySQ
MySQLã«ã¯ãWindowsçã®ã¤ã³ã¹ãã¼ã©ãç¨æããã¦ããã®ã§ãã¾ãã¯ããããã¦ã³ãã¼ããã¾ãããã https://dev.mysql.com/ ä¸é¨ã¿ãã¡ãã¥ã¼ã®ãDownloadsããã¯ãªãã¯ãã¾ãã å·¦ãµã¤ãã¡ãã¥ã¼ã®ãMySQL Installer ( Windows )ããã¯ãªãã¯ãã¾ãã MySQLã®ã¤ã³ã¹ãã¼ã©ã«ã¯ãWebçµç±ã§ãã¦ã³ãã¼ãããªããã¤ã³ã¹ãã¼ã«ããã¤ã³ã¹ãã¼ã©ï¼ä¸ï¼ã¨ã¤ã³ã¿ã¼ããããç¹ãã£ã¦ããªãã¦ãã¤ã³ã¹ãã¼ã«ã§ããã¤ã³ã¹ãã¼ã©ï¼ä¸ï¼ãããã¾ããããã§ã¯ãWebçµç±ã§ã¤ã³ã¹ãã¼ã«ããã®ã§ä¸ã®ãDownloadããã¯ãªãã¯ãã¾ãã â»ãã®ã¤ã³ã¹ãã¼ã©ã§ã32ãããçï¼64ãããçã®ä¸¡æ¹ãã¤ã³ã¹ãã¼ã«ããã¾ãã ãOracle Web accountãã®ãã°ã¤ã³ãä¿ããã¾ããããã°ã¤ã³ããªãã¦ãï¼ã¢ã«ã¦ã³ããæã£ã¦ããªãã¦ãï¼ã¤ã³ã¹ãã¼ã©ããã¦ã³ãã¼ãã§ã
RedHatãMySQLããMariaDBã«ç§»è¡ãã æ¢ã«FedoraãopenSUSEãªã©ã®ãã£ã¹ããªãã¥ã¼ã·ã§ã³ã¯ãMySQLããMariaDBã¸ç§»è¡ãã¦ããã®ã§ããï¼ç§»è¡ã¯å¼·å¶ã§ã¯ãªããMySQLããªãã·ã§ã³ã®ããã±ã¼ã¸ã¨ãã¦æ¨æºã¬ãã¸ããªã«ã¯ç»é²ããã¦ãã¾ãï¼ãæ¨æ¥ã«ãªã£ã¦ãRed Hat Enterprise Linux 7ã§ãMySQLã«ä»£ãã¦MariaDBãæ¡ç¨ã¨ãããã¥ã¼ã¹ãé£ã³è¾¼ãã§ãã¾ãããRHEL7ã§MariaDBãæ¡ç¨ãããã¨ãããã¨ã¯ããã®ã¯ãã¼ã³ã§ããCentOSã§ãMariaDBãæ¨æºã«ãªã£ã¦ããã¨æããã¾ããLinuxçéã®æµãã¯æããã«MariaDBã«åãã£ã¦ãã¾ãããä¸ççã§ãããããä¹ããããªãï¼ãã®ããã°ã¦ã§ã¼ãã«ï¼ãã¨ãããã¨ã§ãèªå® ãµã¼ãã¼ãMariaDBã¸ç§»è¡ããããã¨ã«ãã¾ããã èªå® ã®MySQL使ç¨ç¶æ³ ç§ã®èªå® ãµã¼ãã¼ã¯ãopenSUSE
HeartCore CMS ã«ã¤ã㦠ãã«ãããã¤ã¹ã«å¯¾å¿ããCMSããããã¬ã¹å¯¾å¿ã¨ãå 鲿©è½ãå ¨ã¦æè¼ãããã«ããã¼ã¸ãã¯ã©ã¦ãä¸ã§åä½ããã9å¹´é£ç¶No1ã®CMS
åç½®ã MySQLåå¿è ã®ãRalaxã§ãã ä»åã¯ãã¢ããªå ãããµã¼ãä¸ã®PHPã«ã¢ã¯ã»ã¹ãã¦ã ãµã¼ãä¸ã®MySQLãã¼ã¿ãã¼ã¹ã«ãã¼ã¿ãéä¿¡ããæ¹æ³ãç´¹ä»ãããã¨æãã¾ãã ååã®è¨äºã§ç´¹ä»ããã ãMySQLãiOSã¢ãããªããDBã®ããã¼ã¿ãJSONå½¢å¼ã¦ãåå¾ããæ¹æ³ ãé²è¦§ãã¦ããªãæ¹ã¯ããã¡ãããã覧ãã ããã ãMySQLãiOSã¢ãããªããDBã®ããã¼ã¿ãPHPãç¨ãã¦JSONå½¢å¼ã¦ãåå¾ããæ¹æ³ | ãå¦ç&ä¸äººæ®ãããRalaxã®æ¥èª åææ¡ä»¶ éçºç°å¢ ä»åããååã¨åæ§ã®éçºç°å¢ã§è¡ãã¾ããã 以ä¸ã«è¨è¿°ãã¦ããã¾ãã PHPï¼5.33 MySQLï¼5.1.73 å®é¨ã§ä½¿ç¨ããDBã®ãã¼ãã«ã®æ å ± ä»åããååã¨åæ§ã®ãã¼ãã«ãç¨ãã¦è¡ãã¾ããã 以ä¸ã«è¨è¿°ãã¦ããã¾ãã ãã¼ã¿ãã¼ã¹åï¼test ãã¼ãã«åï¼test_json ç §åé åºï¼utf8_genera
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}