[B! MySQL] iR3ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

iR3 id:iR3

MySQLã«é–¢ã™ã‚‹iR3ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (114)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

trilogy ã‚’èª¿æŸ»ã—ãŸã‚‰ Active Record ãŒæŠ±ãˆã‚‹å•é¡Œã«ã¾ã§è¾¿ã‚Šç€ã„ãŸ - Money Forward Developers Blog
ã¯ã˜ã‚ã« ã‚ã‘ã¾ã—ã¦ãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™ã€‚k0iã§ã™ã€‚ çš†ã•ã‚“ã¯å¹´æœ«å¹´å§‹ã€ã„ã‹ãŒãŠéŽã”ã—ã§ã—ãŸã§ã—ã‚‡ã†ã‹ã€‚ ç§ã¯ä¹…ã—ã¶ã‚Šã«ä¼šã£ãŸé«˜æ ¡ã®å‹é”ã¨é£²ã‚“ã§å¸°çœã®åˆ—è»Šã«ä¹—ã‚Šé…ã‚Œã€æ›´ã«ã‚¹ãƒžãƒ›ã‚’è½ã¨ã—ã¦å£Šã—ã¦ã—ã¾ã„ä¸ã€…ç—ºã‚Œã‚‹å¹´è¶Šã—ã¨ãªã‚Šã¾ã—ãŸã€‚ 2024å¹´ã‚‚è‰¯ã„å¹´ã«ãªã‚‹ã¨è‰¯ã„ã§ã™ã.....! ã•ã¦ã€Rails 7.1 ã§ trilogy ã¨ã„ã† MySQL äº’æ›ã® Database Adapter ãŒè¿½åŠ ã•ã‚Œã¾ã—ãŸã€‚ ã—ã‹ã—æˆ‘ã€…ã¯ã™ã§ã« MySQL äº’æ›ã® Database Adapter ã¨ã—ã¦ mysql2 ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ ä¸€ä½“ãªãœæ–°ã—ã„ Adapter ãŒå¿…è¦ãªã®ã‹ã€‚trilogy ã¯ä½•ã‚’è§£æ±ºã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸã®ã‹ã€‚ æ°—ã«ãªã‚Šã¾ã›ã‚“ã‹?(ãªã‚Šã¾ã™ã‚ˆã?) ãã“ã§ã€trilogy ã«ã¤ã„ã¦é–‹ç™ºã®èƒŒæ™¯ã‚„ã€æŽ¡ç”¨ã™ã‚‹ã¨ä½•ãŒå¬‰ã—ã„ã®ã‹ã‚’èª¿æŸ»ã—ã¦ã¿ã¾ã—ãŸã€‚ ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚‚ã‚ã‚‹é€šã‚Šã€èª¿æŸ»ã®éŽç¨‹ã§ Activ
iR3 2024/04/01
ãµã‚€ãµã‚€

MySQL

trilogy
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç¢ºèªæ–¹æ³• - Qiita
$ mysqladmin version mysqladmin Ver 8.42 Distrib 5.7.21, for osx10.13 on x86_64 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.7.21 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock
iR3 2022/03/09
ãµã‚€ãµã‚€

MySQL
ãƒªãƒ³ã‚¯
mysqld_safe A mysqld process already existsã®å¯¾å‡¦æ³•ã€MySQLã€‘
é–‹ç™ºç’°å¢ƒMacBook Pro (macOS Catalina ãƒãƒ¼ã‚¸ãƒ§ãƒ³10.15.2)MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³8.0.19 ã™ã§ã«MySQLãŒèµ·å‹•ã—ã¦ã„ã‚‹ã®ã§ã€ä¸€æ—¦åœæ¢ã—ã¾ã™ã€‚ ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ã§ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¥åŠ›ã—ã¾ã™ã€‚ ã‚¿ãƒ¼ãƒŸãƒŠãƒ« brew services stop mysql mysql.server status ã§ç¢ºèªã™ã‚‹ã¨MySQLãŒåœæ¢ã—ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ ã€è£œè¶³ã€‘mysql.server stop ã ã¨MySQLãŒå‹æ‰‹ã«å†èµ·å‹•ã™ã‚‹mysql.server stop ã‚³ãƒžãƒ³ãƒ‰ã§MySQLã‚’åœæ¢ã—ã‚ˆã†ã¨ã—ã¦ã‚‚ã€å†èµ·å‹•ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ mysql.server status ã§ç¢ºèªã™ã‚‹ã¨MySQLãŒåœæ¢ã—ã¦ã„ãªã„ã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ã€‚ ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¥åŠ›ã™ã‚‹ã“ã¨ã§MySQLã‚’å†èµ·å‹•ã•ã›ãšã«åœæ¢ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ brew services stop mysql
iR3 2021/08/06
ãµã‚€ãµã‚€

MySQL
ãƒªãƒ³ã‚¯
Dockerã§Ruby2.7.xï¼‹Rails6.0.xï¼‹MySQL8.0.xãªç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹ - Qiita
dockerã«ã‚ã‚‹ã‚µãƒ³ãƒ—ãƒ«ã§ä½œã‚‹ç’°å¢ƒã¯Ruby2.5ï¼‹Rails5ï¼‹PostgreSQLã¨å¤ã‚ä¸”ã¤PostgreSQLã ã£ãŸã®ã§ã€ ãã‚Œãžã‚Œæ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ Ruby2.7ï¼†Rails6.0ï¼†MySQL8.0ã®å ´åˆã§æ›¸ãæ›ãˆãŸã‚‚ã®ã§ã™ã€‚ â€»2020å¹´6æœˆ8æ—¥æ™‚ç‚¹ã§ã¯Ruby2.7.1, Rails6.0.3.1, MySQL8.0.20ã«ãªã‚Šã¾ã™ ãƒ•ã‚¡ã‚¤ãƒ«ã®ç”¨æ„ Dockerfile Gemfile Gemfile.lock entrypoint.sh docker-compose.yml .env â€» dockeråŠã³docker-composeã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯æ¸ˆã‚“ã§ã„ã‚‹ã“ã¨ â€» ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åå‰ã¯myappã¨ã—ã€å¤‰æ›´ã™ã‚‹å ´åˆã¯é©å®œç½®ãæ›ãˆã‚‹ 1. Dockerfileã®ç”¨æ„ FROM ruby:2.7 # or latest # nodejsã¨mysql-client (d
iR3 2020/10/01
æœ‰é›£ã„ï¼

docker

Rails

MySQL
ãƒªãƒ³ã‚¯
mysql8.0ã§SequelProãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ | ã‚ãã‚|development_blog
2019å¹´2æœˆ10æ—¥mysql, ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹mysql é–‹ç™ºã§Dockerã‚’ä½¿ã†éš›ã«mysqlã‚’å°Žå…¥ã—ã¾ã—ãŸã€‚mysqlã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ç¢ºèªã—ãŸã¨ã“ã‚mysql 8.0ã®ã‚ˆã†ã§ã—ãŸã€‚ä»Šã¾ã§é€šã‚Šmysqlã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚½ãƒ•ãƒˆã§ã‚ã‚‹Sequel Proã‚’ä½¿ã£ã¦ã‚¢ã‚¯ã‚»ã‚¹ã—ã‚ˆã†ã¨ã—ãŸãŒã€æŽ¥ç¶šã«ã¯æˆåŠŸã—ãŸã‚‚ã®ã®ã€é–‹ãã¨ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚èª¿ã¹ã¦ã¿ãŸã¨ã“ã‚ã€mysql 8.0ãŒéžå¯¾å¿œã ã£ãŸã‚ˆã†ã§è§£æ±ºç–ã‚’æŽ¢ã—ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ Sequel Pro ã®nightlyãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’å…¥ã‚Œã‚‹ ã“ã¡ã‚‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’å…¥ã‚Œã‚‹ã“ã¨ã§è§£æ±ºã§ãã‚‹ã¨ã®ã“ã¨ã§ã—ãŸã®ã§ã€æ—©é€Ÿå…¥ã‚Œã¦ã¿ã‚‹ã“ã¨ã«ã€‚ã¾ãšã€ã‚‚ã¨ã‚‚ã¨å…¥ã£ã¦ã„ãŸSequel ProãŒã‚ã£ãŸã®ã§ã€ä¸€æ™‚çš„ã«ãƒªãƒãƒ¼ãƒ ã§å¯¾å¿œã€‚brew cask install homebrew/cask-versions/sequel-pro-nightlyã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ•ã‚©ãƒ«ãƒ€ã«å…¥
iR3 2020/07/02
ãµã‚€ãµã‚€ â€œbrew cask install homebrew/cask-versions/sequel-pro-nightlyâ€

MySQL

Sequel
ãƒªãƒ³ã‚¯
ãªã‚‹ã¹ãè‡ªå‹•åŒ–ã—ã¦Nginx, Rails, MySQLã®é–‹ç™ºç’°å¢ƒã‚’Dockerã§ä½œã£ãŸ - Qiita
$ tree â”œâ”€â”€ README.md â”œâ”€â”€ docker # Dockerã‚„Docker Compose â”‚Â Â â”œâ”€â”€ containers # å„ã‚³ãƒ³ãƒ†ãƒŠ(ã‚¤ãƒ¡ãƒ¼ã‚¸) â”‚Â Â â”‚Â Â â”œâ”€â”€ mysql # MySQL 5.7 â”‚Â Â â”‚Â Â â”‚Â Â â”œâ”€â”€ Dockerfile # MySQL 5.7ã®Dockerãƒ•ã‚¡ã‚¤ãƒ« â”‚Â Â â”‚Â Â â”‚Â Â â”œâ”€â”€ grant_user.sql # åˆæœŸã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã§ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆã™ã‚‹ã‚¹ãƒ—ãƒªãƒ—ãƒˆ â”‚Â Â â”‚Â Â â”‚Â Â â””â”€â”€ my.cnf # åˆæœŸã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã§åæ˜ ã™ã‚‹my.cnf â”‚Â Â â”‚Â Â â”œâ”€â”€ nginx # Nginxã€€1.15.2 â”‚Â Â â”‚Â Â â”‚Â Â â”œâ”€â”€ Dockerfile # Nginxã®Dockerãƒ•ã‚¡ã‚¤ãƒ« â”‚Â Â â”‚Â Â â”‚Â Â â””â”€â”€ nginx.conf # åˆæœŸã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã§åæ˜ ã™ã‚‹nginx.con
iR3 2019/09/05
ãµã‚€ãµã‚€ æœ‰é›£ã„

docker

docker compose

Rails

MySQL

nginx
ãƒªãƒ³ã‚¯
CircleCIã§Rails+MySQLãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è‡ªå‹•ãƒ†ã‚¹ãƒˆã‚’è¡Œã†ãŸã‚ã®æœ€ä½Žé™ã®è¨å®š - Qiita
ã“ã‚Œã¯ãªã«ï¼Ÿ Rails + MySQLã§ä½œæˆã—ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®Rspecè‡ªå‹•ãƒ†ã‚¹ãƒˆã‚’ã€CircleCIã§è¡Œã„ãŸã„ï¼ ãã®ãŸã‚ã«æœ€ä½Žé™å¿…è¦ãªã€.circleci/config.ymlã®è¨å®šæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ ç’°å¢ƒ Ruby 2.5.1 Rails 5.2.1 CircleCI 2.0 .circleci/config.ymlã®è¨å®š ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ« CircleCIã®ã€ŒAdd Projectã€ã‹ã‚‰ã€GitHubã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’é¸æŠžã—ã€Languageã®è¨å®šã‹ã‚‰ã€ŒRubyã€ã‚’é¸ã¶ã¨ã€ä»¥ä¸‹ã®Sample .yml FileãŒè‡ªå‹•ã§æ‰•ã„å‡ºã•ã‚Œã¾ã™ (2018å¹´12æœˆç¾åœ¨) # Ruby CircleCI 2.0 configuration file # # Check https://circleci.com/docs/2.0/language-ruby/ for more details
iR3 2019/08/02
ãµã‚€ãµã‚€

CircleCI

MySQL
ãƒªãƒ³ã‚¯
CircleCIã§mysql8ã‚’ä½¿ç”¨ã™ã‚‹è¨å®š - ã®ã‚“ã³ã‚ŠSEã®è°äº‹éŒ²
CircleCIã§mysqlã‚’ä½¿ç”¨ã—ã‚ˆã†ã¨ã—ãŸã¨ãã«ã€æ€ã£ã¦ãŸä»¥ä¸Šã«ãƒãƒžã£ã¦ã—ã¾ã†ãƒã‚¤ãƒ³ãƒˆãŒã‚ã£ãŸã®ã§ã€å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ versionã¯2ã‚’ä½¿ç”¨ã™ã‚‹æƒ³å®šã§ã™ã€‚ è¨å®šãƒ•ã‚¡ã‚¤ãƒ« Railsã‚¢ãƒ—ãƒªã‚’æƒ³å®šã—ãŸä¾‹ã§ã™ã€‚ .circleci/config.yml version: 2 general: branches: only: - master - develop - /^test.*/ jobs: build: working_directory: ~/sample docker: - image: circleci/ruby:2.5.3-node-browsers environment: RAILS_ENV: test DB_USER: dbuser DB_PASSWORD: ****** DB_HOST: '127.0.0.1' # Point 1 - image: cir
iR3 2019/08/01
ãµã‚€ãµã‚€

MySQL

CircleCI
ãƒªãƒ³ã‚¯
Mac ã§ mysql2 ãŒ bundle install ã§å…¥ã‚‰ãªã„ã¨ã - ç´„æŸã®åœ°
çµè«– Step 1. brew install openssl Step 2. export LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/ â€»Step 2 ã®å†…å®¹ã¯ã‚·ã‚§ãƒ«ã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã„ã¦ãŠãã¾ã—ã‚‡ã† ã‚„ã£ãŸã“ã¨ MySQL ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒ mysql Ver 8.0.12 for osx10.14 on x86_64 (Homebrew) ã ã£ãŸã®ãŒãƒ€ãƒ¡ã ã¨æ€ã„ 5.7 ã«ä¸‹ã’ãŸ ãã‚Œã§ã‚‚å¤±æ•—ã™ã‚‹ï¼ˆé–¢ä¿‚ãªã„ï¼‰ OpenSSL ã¨ LibreSSL ã‚’åˆ‡ã‚Šæ›¿ãˆãŸ ãã‚Œã§ã‚‚å¤±æ•—ã™ã‚‹ Xcode ã®å†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚„ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãã‚Œã§ã‚‚å¤±æ•—ã™ã‚‹ mysql2 ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’æŒ‡å®šã™ã‚‹ ãã‚Œã§ã‚‚å¤±æ•—ã™ã‚‹ ä¸Šè¨˜ã®çµ„ã¿åˆã‚ã› ãã‚Œã§ã‚‚å¤±æ•—ã™ã‚‹ å…¬å¼ Issue ã‚’è¦‹ã‚‹ æˆåŠŸ å‚™è€ƒ ã¨ã«ã‹ãã¾ãšã¯å…¬å¼ã‚’è¦‹ã‚ã€èªã‚ã¨ã„ã†ã“ã¨
iR3 2019/01/11
ãµã‚€ãµã‚€

MySQL
ãƒªãƒ³ã‚¯
Showdown: MySQL 8 vs PostgreSQL 10 | HackerNoon
Now that MySQL 8 and PostgreSQL 10 are out, itâ€™s a good time to revisit how the two major open source relational databases compete against each other.
iR3 2018/12/21
ãµã‚€ãµã‚€

MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
MySQL 8.0ã§æ†¶ãˆã¦ãŠã„ã¦ã»ã—ã„ã“ã¨
2017/10/23 MyNA(æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š)ä¼š 2017å¹´10æœˆ https://atnd.org/events/91275
iR3 2018/10/04
è‰²ã€…ã‚ã‚‹ã®ã

MySQL
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒãƒ¼ãŒå®Œè†šãªãã¾ã§ã«æ»ã‚“ã§ã‚‚MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤±ã‚ãªã„ãŸã‚ã®è¡¨æŠ€
pg_bigmã§å…¨æ–‡æ¤œç´¢ã™ã‚‹ã¨ãã«æ°—ã‚’ä»˜ã‘ãŸã„5ã¤ã®ãƒã‚¤ãƒ³ãƒˆï¼ˆç¬¬23å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ ç™ºè¡¨è³‡æ–™ï¼‰
iR3 2018/10/04
ãµã‚€ãµã‚€

MySQL
ãƒªãƒ³ã‚¯
Mysql8 ã§sequel pro ãŒã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ãŸä»¶ã€€caching_sha2_password - ã¡ã‚‡ã“ã£ã¨ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
æ–°ã—ã„PCã‚’èª¿é”ã—ãŸã®ã§sqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ç›´ã—ã€‚ brew install mysql ã§ä½•æ™‚ã‚‚ã®ã‚ˆã†ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨æ€ã„ã‚„å…¥ã£ã¦ããŸã®ãŒMysql5.xã§ãªã8ã ã£ãŸã€‚ ãã†ã„ã‚„8å‡ºãŸã£ã¦ãƒ‹ãƒ¥ãƒ¼ã‚¹è¦‹ãŸãªãƒ¼ã¨æ€ã„ã¤ã¤Mysqlã‚’ç«‹ã¡ä¸Šã’Sequel Proã§ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã¿ã‚‹ã¨ Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found ãªã‚“ã˜ã‚ƒã‚Šã‚ƒ èª¿ã¹ã¦ã¿ã‚‹ã¨ã€MySql8ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®èªè¨¼æ–¹æ³•ãŒmysql_native_passwordã‹ã‚‰caching_sha2_passwordã«å¤‰ã‚ã£ãŸã‚‰ã—ã„ã€‚ Mysqlã¯ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæ¯Žã«èªè¨¼æ–¹æ³•ãŒæŒ‡å®šã•ã‚Œã¦ã„ã‚‹
iR3 2018/10/04
ãµã‚€ãµã‚€

MySQL

Sequel pro
ãƒªãƒ³ã‚¯
SequelProãŒMySQL8ã«ç¹‹ãŒã‚‰ãªã„ã®ã§TablePlusã«ä¹—ã‚Šæ›ãˆãŸ | GROUP DEV BLOG | TECHNO DIGITAL
å‚æ±ã§ã™ã€‚ Macã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ„ãƒ¼ãƒ«ã¨ã„ãˆã°Sequel Proã§ã—ã‚‡ã†ã€‚ https://www.sequelpro.com/ ã§ã‚‚ã“ã‚ŒãŒMySQL8.0ã®æ–°ã—ã„èªè¨¼æ–¹å¼ã«å¯¾å¿œã—ã¦ãŠã‚‰ãšæŽ¥ç¶šã§ããªã„ã¾ã¾ã«ã€ã‚‚ã†æ•°ãƒ¶æœˆã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ä»¥ä¸‹ã®è¨˜äº‹ã«ã‚ˆã‚‹ã¨ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ¬ãƒ™ãƒ«ã‚’è½ã¨ã›ã°ä½¿ãˆã‚‹æ§˜ã§ã™ã€‚ Sequre Proã§MySQLã«ãƒã‚°ã‚¤ãƒ³ã§ããªã„ ã¾ã‚ãƒ„ãƒ¼ãƒ«ã§ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã®ã¯é–‹ç™ºãƒ»æ¤œè¨¼æ©Ÿã¾ã§ãªã®ã§ã“ã®å¯¾å¿œã§ã‚‚è‰¯ã„ã®ã§ã™ãŒã€‚ ã›ã£ã‹ããªã®ã§åˆ¥ã®ãƒ„ãƒ¼ãƒ«ã‚’æŽ¢ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã—ãŸã€‚ ã‚°ã‚°ã£ã¦æœ€åˆã«å‡ºã¦ããŸã®ãŒDataGripã€‚ https://www.jetbrains.com/datagrip/ ã‚‚ã®ã™ã”ãé«˜æ©Ÿèƒ½ã‚‰ã—ã„ã®ã§ã™ãŒã€ä¾¡æ ¼ãŒ$499/yearã¨ã„ã†ã®ã‚’ã¿ã¦è«¦ã‚ã¾ã—ãŸã€‚ é«˜æ©Ÿèƒ½ãªä½•ã‹ã‚’ä½¿ã„ã“ãªã›ã‚‹äººãªã‚‰ã„ã„ã‘ã‚Œã©ã€DBã®ä¸ã‚’æ°—è»½ã«è¦—ããŸã„ã ã‘ã®ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã¯é«˜ä¾¡ã™ãŽã‚‹ã€‚
iR3 2018/10/04
ãµã‚€ãµã‚€ TablePlus ä½¿ã†ã—ã‹

MySQL
ãƒªãƒ³ã‚¯
MySQL 8.0ã«ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆï¼æ³¨æ„ã™ã¹ãç‚¹ - Database JUNKY
MySQL 8.0ã€€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸã‚‰ã€é€Ÿåº¦ãŒ2å€å‘ä¸Šï¼ä¾¿åˆ©ãªé–¢æ•°ãŒä½¿ãˆã‚‹ï¼ï¼ç‰ã€è‰²ã€…ãªãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾ã™ã€‚ ãƒ»ãƒ»ãŒã€ é€šå¸¸ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸã‹ã‚‰ã¨ã„ã£ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã—ã¦ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã£ã¦ã—ãªã„ã‹ãªãƒ¼ï¼Ÿã£ã¦æ€ã£ã¦ã¾ã™ã€‚è‡ªåˆ†ãŒã‚„ã‚‹ã®ã§ã‚ã‚Œã°ã€åˆ¥ã®ã‚µãƒ¼ãƒç«‹ã¦ã¦æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼å¯èƒ½ãªé™ã‚Šã€ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã‚’æ¸›ã‚‰ã—ãŸã„ã®ã§ã“ã®æ‰‹æ³•ä¸€ç‚¹ã§é€²ã‚ã¾ã™ ãŸã ã€ä»Šå›žã¯ã€ã‹ãªã‚Šè‹¦æˆ¦ã—ã¦ã„ã¾ã™ æ¬¡å›žã€åŒã˜çŠ¶æ…‹ã«ãªã‚‰ãªã„ã‚ˆã†ã«ã€å‚™å¿˜éŒ²ã«æ®‹ã—ã¦ãŠãã¾ã™ã€‚ [Amazonãƒ–ãƒ©ãƒ³ãƒ‰]Presto! ãƒžã‚¹ã‚¯ ãµã¤ã†ã‚µã‚¤ã‚º 200æžš(50æžšÃ—4ãƒ‘ãƒƒã‚¯) PM2.5å¯¾å¿œ å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ãƒ˜ãƒ«ã‚¹ã‚¿ãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ãƒ¡ãƒ‡ã‚£ã‚¢: ãƒ˜ãƒ«ã‚¹ã‚±ã‚¢&ã‚±ã‚¢ç”¨å“ã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚°ã‚’è¦‹ã‚‹ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— mysqldumpã«æ³¨æ„ï¼ï¼ MySQL 8.0ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã€MySQL 5.7ã®
iR3 2018/10/04
ãµã‚€ãµã‚€

MySQL
ãƒªãƒ³ã‚¯
ãƒãƒƒãƒˆãƒžãƒãƒ¼ãƒ©ãƒœ
ãŠã¾ã¨ã‚ãƒãƒ¼ãƒ³ã®ãŠã™ã™ã‚ã‚’ãƒ©ãƒ³ã‚ãƒ³ã‚°å½¢å¼ã§ç´¹ä»‹ï¼å„ç¤¾ã®é‡‘åˆ©æ¯”è¼ƒã¨å¯©æŸ»ã§é€šã‚Šã‚„ã™ã„å‚¾å‘ã«ã¤ã„ã¦ã‚‚å¾¹åº•è§£èª¬
iR3 2018/10/04
ä»Šé ƒ ãµã‚€ãµã‚€ ã€Œã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®å¤‰æ›´ãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã€‚ãã®ãŸã‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚‚ã€Œ5.8ã€ã§ã¯ãªãã€Œ8ã€ã¨ãªã£ãŸã€

MySQL
ãƒªãƒ³ã‚¯
Docker + Rails + Puma + Nginxï¼ˆSSLï¼‰ + MySQL - Qiita
å‰å›ž ä½œã£ãŸç’°å¢ƒã‚’SSLåŒ–ã—ãŸã„ã¨æ€ã£ãŸã®ã§ã€èª¿æŸ»ãŒã¦ã‚‰ã«æ§‹ç¯‰ã—ã¦ã¿ã¾ã—ãŸã€‚ æœ€è¿‘ã¯ã‹ãªã‚Šå®‰ããªã£ãŸã¨ã¯ã„ãˆã€æ¤œè¨¼ã®ãŸã‚ã«ãŠé‡‘ã‚’å‡ºã—ã¦SSLè¨¼æ˜Žæ›¸ã‚’ç™ºè¡Œã™ã‚‹ã®ã‚‚å«Œã ã—ã€ ã‚ªãƒ¬ã‚ªãƒ¬è¨¼æ˜Žæ›¸ã‚‚ãªã‚“ã ã‹ãªãã€œ ã¨æ€ã£ãŸã®ã§ã€æœ€è¿‘è©±é¡Œã® Let's Encryptï¼ˆCertbotï¼‰ ã§è¨¼æ˜Žæ›¸ç™ºè¡Œã‚’ã—ã¦SSLåŒ–ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Let's Encrypt ã¨ã¯ Let's Encrypt ç·åˆãƒãƒ¼ã‚¿ãƒ« Let's Encrypt ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ŒCertbotã€ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ã€SSL/TLS ã‚µãƒ¼ãƒè¨¼æ˜Žæ›¸ã®å–å¾—ãƒ»æ›´æ–°ä½œæ¥ã‚’è‡ªå‹•åŒ–ã§ãã‚‹ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚ ç‹¬è‡ªãƒ‰ãƒ¡ã‚¤ãƒ³ãŒã‚ã‚Œã°ã€ç°¡å˜ãªã‚³ãƒžãƒ³ãƒ‰æ“ä½œã§ SSL/TLS è¨¼æ˜Žæ›¸ï¼ˆç„¡æ–™ï¼‰ã‚’å–å¾—ã§ãã¾ã™ã€‚ æ§‹ç¯‰æ‰‹é †ã‚„å„ãƒ„ãƒ¼ãƒ«ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ å‰å›ž ã¨å¤‰ã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã®ã§ã€èª¬æ˜Žã¯è¿½åŠ ã—ãŸç®‡æ‰€ä»¥å¤–ã¯çœç•¥ã—ã¾ã™ã€‚ å‰æ ä½œæ¥ã¯ã™ã¹ã¦ ConoHaV
iR3 2017/12/07
ãµã‚€ãµã‚€

docker

Rails

puma

nginx

MySQL
ãƒªãƒ³ã‚¯
Docker + Rails + Puma + Nginx + MySQL - Qiita
Dockerã«èˆˆå‘³ãŒã‚ã£ãŸã‚‚ã®ã®ã€ã‚³ãƒžãƒ³ãƒ‰ã‚’å©ãä»¥å¤–ã¯ã»ã¨ã‚“ã©æ‰‹ã‚’å‡ºã™æ©Ÿä¼šãŒãªã‹ã£ãŸã®ã§ã€ å¤å£ä¼‘æš‡ã®é–“ã«ã—ã£ã‹ã‚Šã¨åŸºæœ¬ã‚’èº«ã«ã¤ã‘ã‚‹ã¹ãã€æ¤œè¨¼ç”¨ã«Railsç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦ã¿ã¾ã—ãŸã€‚ æ€ã£ã¦ãŸä»¥ä¸Šã«æ‚ªæˆ¦è‹¦é—˜ã—ãŸã®ã§ã€è¨˜æ†¶ã‹ã‚‰ã™ã£é£›ã°ãªã„ã‚ˆã†ã«ã¡ã‚ƒã‚“ã¨è¨˜äº‹ã¨ã—ã¦æ®‹ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ å‰æ ä½œæ¥ã¯ã™ã¹ã¦ ConoHaVPS ã®Ubuntu16.04ä¸Šã§ã‚„ã£ã¦ã¾ã™ã€‚ OSä¸Šã«ã™ã§ã« Docker ã¨ docker-compose ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ã¨ã„ã†å‰æã§è©±ã‚’é€²ã‚ã¾ã™ã€‚ ã“ã®ç’°å¢ƒã§ã¯ ãƒ•ãƒãƒ³ãƒˆ ã« Nginx ã‚’é…ç½®ã—ã¦ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã® Puma ã«ãƒ—ãƒã‚ã‚·ã—ã¦ã„ã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ãƒ›ã‚¹ãƒˆOSï¼ˆUbuntu16.04 Xenial Xerusï¼‰ Dockerï¼ˆ17.06.1-ceï¼‰ docker-composeï¼ˆ1.11.2ï¼‰ Nginxï¼ˆ1.15.8ï¼‰ Rubyï¼ˆ2.5.1ï¼‰ Ruby
iR3 2017/11/10
ãµã‚€ãµã‚€ ã“ã‚Œã“ã‚Œ æœ‰é›£ã„â™ª

docker

Rails

puma

nginx
ãƒªãƒ³ã‚¯
Docker Composeã«ã‚ˆã‚‹MySQL, Redis, nginx, Railsæ§‹æˆã®è¨å®šä¾‹ - Qiita
å°Žå…¥ Docker Composeã‚’åˆ©ç”¨ã—ã¦ã€è¤‡æ•°ã®docker containerã‚’ä½¿ã£ãŸç’°å¢ƒã®è¨å®šä¾‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ãªãŠã€Docker Composeã¯Windowsã§ã¯ä½¿ãˆã¾ã›ã‚“ã€‚Max OSX or 64bit Linuxã®ã¿å¯¾è±¡ã¨ãªã£ã¦ã„ã¾ã™ã€‚ æº–å‚™ Docker Toolboxã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚Œã°ç’°å¢ƒã¯ã™ã¹ã¦æ•´ã„ã¾ã™ã€‚ https://www.docker.com/products/docker-toolbox docker, docker-machine, docker-composeã¨ã„ã£ãŸãƒ„ãƒ¼ãƒ«ã¨VirtualBoxãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã¯ãšã§ã™ã€‚ æ¬¡ã«machineã®æº–å‚™ https://docs.docker.com/machine/get-started/ $ docker-machine create --driver virtualbox default $ do
iR3 2017/11/10
ãµã‚€ãµã‚€

Docker Compose

MySQL

Redis

nginx

Rails
ãƒªãƒ³ã‚¯
Dockerã§Rails + MySQLã‚¢ãƒ—ãƒªã‚’ç«‹ã¡ä¸Šã’ã‚‹æ‰‹é †ãƒ¡ãƒ¢ - Qiita
å‰å›žDockerä¸Šã§Railsã‚¢ãƒ—ãƒªã‚’ç«‹ã¡ä¸Šã’ã‚‹ã¨ã“ã‚ã¾ã§ã‚„ã£ã¦MySQLç„¡ã„ã‹ã‚‰ã‚¨ãƒ©ãƒ¼å‡ºã‚‹ã¨ã„ã†æ‰€ã§çµ‚ã‚ã£ã¦ã„ã¾ã—ãŸãŒã€ä»Šå›žã¯Railsã‚³ãƒ³ãƒ†ãƒŠã¨MySQLã‚³ãƒ³ãƒ†ãƒŠã‚’é–¢é€£ä»˜ã‘ã¦ç«‹ã¡ä¸Šã’ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ä½¿ç”¨ã™ã‚‹image docker pullã§è½ã¨ã™ãªã‚Šã—ã¦ãã ã•ã„ takashioshikawa/ruby-native-2.2.4 mysql:latest MySQLã‚³ãƒ³ãƒ†ãƒŠç«‹ã¡ä¸Šã’ mysql-containerã¨ã„ã†åå‰ã®ã‚³ãƒ³ãƒ†ãƒŠã‚’ç«‹ã¡ä¸Šã’ã¾ã™ docker run --name mysql-container -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql ã‚ªãƒ—ã‚·ãƒ§ãƒ³è§£èª¬ -d : ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã§èµ·å‹• --name mysql-container : ã‚³ãƒ³ãƒ†ãƒŠã«åå‰ã‚’ä»˜ã‘ã‚‹ -p 3306:3306 : ãƒãƒ¼ãƒˆæŒ‡å®š ã€Œ
iR3 2016/07/07
ãµã‚€ãµã‚€

docker

Rails

MySQL
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 æ¬¡ã®ãƒšãƒ¼ã‚¸