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

mfunaki id:mfunaki

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

${{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}}

CircleCIã§railsã‚¢ãƒ—ãƒªã®imageã‚’ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸã‚‰mysqlã«æŽ¥ç¶šã§ããªããªã£ãŸè©± - Qiita
æ¦‚è¦ railsã®ã‚¢ãƒ—ãƒªã§rubyã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä¸Šã’ã‚ˆã†ã¨æ€ã£ã¦.circleci/config.ymlã®imageã‚’å¤‰æ›´ã—ãŸã‚‰mysqlã«æŽ¥ç¶šã§ããªããªã£ã¦ã¡ã‚‡ã£ã¨ã¯ã¾ã£ãŸã®ã§å…±æœ‰ã—ã¦ãŠãã¾ã™ã€‚ çµè«– mysql-clientãƒ‘ãƒƒã‚±ãƒ¼ã‚¸åãŒdefault-mysql-clientã«å¤‰ã‚ã£ãŸã®ã§å¤‰æ›´ã™ã‚‹ã€‚ bundle installã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã®æ¶ˆã•ãªã„ã¨mysql-clientã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒå¤‰ã‚ã£ãŸã®ã§æŽ¥ç¶šã§ããªã„ã€‚ ã‚„ã£ãŸã“ã¨ config.ymlã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«å¤‰æ›´ã—ã¦pushã€‚ â€» config.ymlã¯é–¢ä¿‚ãªã„éƒ¨åˆ†ã‚’çœç•¥ã—ã¦ã¾ã™ã€‚ version: 2.1 jobs: build: docker: - - image: circleci/ruby:2.6.1-node-browsers + - image: circleci/ruby:2.6.3-node-browsers -
mfunaki 2021/12/03
CircleCI

MySQL
ãƒªãƒ³ã‚¯
ã€CircleCIã€‘Rails6/Mysql8ã®Projectã‚’Rspec&Rubocop - Qiita
ã¯ã˜ã‚ã« ä¹…ã—ã¶ã‚Šã«ymlè·äººã—ã¦ã„ãŸã‚‰ã€CircleCIã®æ›¸ãæ–¹ã‚’å¿˜ã‚Œã¦ã—ã¾ã£ãŸã®ã§ã€å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¾ã™ æŠ˜è§’ãªã®ã§å†—é•·ãªymlã‚’CircleCI Orbsã§ã‚¹ãƒƒã‚ãƒªã•ã›ã¦ã¿ã¾ã—ãŸ CircleCIã§è¨å®šã™ã‚‹ç’°å¢ƒã¨ã€å®Ÿéš›ã«ã‚¢ãƒ—ãƒªã‚’é‹ç”¨ã™ã‚‹ç’°å¢ƒã‚’ã§ãã‚‹ã ã‘åˆã‚ã›ã‚‹ã“ã¨ãŒãƒã‚¤ãƒ³ãƒˆ Githubã§Pull Requetã‚’ä½œæˆã—ãŸã‚‰ã€masterã«ãƒžãƒ¼ã‚¸ã™ã‚‹å‰ã«è‡ªå‹•ã§ãƒ“ãƒ«ãƒ‰ã•ã‚Œã¦ãƒ†ã‚¹ãƒˆã‚„ãƒªãƒ³ã‚¿ãƒ¼ãŒèµ°ã£ãŸã‚‰ä¾¿åˆ©ã€‚ å‰æ Githubã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ã‚‚ã£ã¦ã„ã‚‹ã“ã¨ã€æ—¢ã«Railsã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒã‚ã‚‹ã“ã¨ Rspec & RubocopãŒè¨å®šæ¸ˆã¿ã§ã‚ã‚‹ã“ã¨ Mysqlã‚’ã¤ã‹ã£ãŸä¾‹ã‚’èª¬æ˜Žã—ã¾ã™ é–‹ç™ºç’°å¢ƒ Rails6 Mysql8 Docker AWS ecs config.ymlã®è¨å®š ðŸ”½å…¨ä½“ã¯ã“ã‚“ãªæ„Ÿã˜ ãƒ»commitã—ãŸæ™‚ã¨mergeã—ãŸæ™‚ã«Rspec&RUbocopãŒèµ°ã‚‹ ãƒ»mergeã—ãŸã‚‰e
mfunaki 2021/05/31
2021/01/28 https://twitter.com/CircleCIJapan/status/1354595110860836873

CircleCI

Rails

MySQL
ãƒªãƒ³ã‚¯
Macã«LAMPç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦WordPressã‚’å°Žå…¥ã™ã‚‹æ‰‹é †ã®ãƒ¡ãƒ¢ | Macã¨ã‹ã®é›‘è¨˜å¸³
Macã«æœ€åˆã‹ã‚‰å…¥ã£ã¦ã„ã‚‹Apacheã‚„PHPã‚’ä½¿ã£ã¦LAMPç’°å¢ƒã‚’æ§‹ç¯‰ã—ã€WordPressã‚’å°Žå…¥ã™ã‚‹ã¾ã§ã®æ‰‹é †ã§ã™ã€‚ä»¥å‰ã«ã‚‚åŒã˜æ§˜ãªã“ã¨ã‚’æ›¸ã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€ç’°å¢ƒæ§‹ç¯‰ã«å¿…è¦ãªæœ€ä½Žé™ã®æ‰‹é †ã‚’ã¾ã¨ã‚ã¦ãŠããŸã‹ã£ãŸã®ã§æ”¹ã‚ã¦è¨˜äº‹ã«ã—ã¾ã—ãŸã€‚ Lionã§ã®å†…å®¹ã«ãªã‚Šã¾ã™ãŒã€SnowLeopardã§æ§‹ç¯‰ã™ã‚‹å ´åˆã‚‚åŒã˜ã§ã™ã€‚ãã‚Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚‚ãã‚“ãªã«å¤‰ã‚ã‚‰ãªã„ã¨æ€ã„ã¾ã™ã€‚ æœ€åˆã«â€¦ Lionã®å ´åˆã¯ã€ã¾ãšæœ€åˆã«ã€Œã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒè¨å®šã€â†’ã€Œå…±æœ‰ã€â†’ã€ŒWebå…±æœ‰ã€ã‚’ONã«å‡ºæ¥ã‚‹ã‹ã©ã†ã‹ç¢ºèªã—ã¦ãã ã•ã„ã€‚ ã‚‚ã—ONã«ã§ããªã‹ã£ãŸã‚‰ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦Apacheã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«httpd.confã‚’åˆæœŸçŠ¶æ…‹ã«ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ 1. MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Apacheã‚„phpã¯æœ€åˆã‹ã‚‰å…¥ã£ã¦ã„ã¾ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯å…¥ã£ã¦ã„ãªã„ã®ã§MySQLã‚’å°Žå…¥ã—ã¾ã™ã€‚ ã¾ã Lionç”¨ã®MySQLã¯ç„¡ã„ã®ã§ã€10
mfunaki 2012/02/20
Mac

MySQL

PHP

Apache
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 11.5 ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã®æ‹¡å¼µ
Open Geospatial Consortium (OGC) ã¯ã€ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ã‚ã‚‰ã‚†ã‚‹ç¨®é¡žã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§å½¹ç«‹ã¤ã€å…¬çš„ã«åˆ©ç”¨å¯èƒ½ãªæ¦‚å¿µçš„ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã«æºã‚ã£ã¦ã„ã‚‹ 250 ä»¥ä¸Šã®ä¼æ¥ã€æ©Ÿé–¢ã€ãŠã‚ˆã³å¤§å¦ã®å›½éš›çš„ãªã‚³ãƒ³ã‚½ãƒ¼ã‚·ã‚¢ãƒ ã§ã™ã€‚ ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã‚ˆã†ã« SQL RDBMS ã‚’æ‹¡å¼µã™ã‚‹ãŸã‚ã®è¤‡æ•°ã®æ¦‚å¿µçš„ãªæ–¹æ³•ã‚’ææ¡ˆã—ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨ã—ã¦ã€Open Geospatial Consortium ã‹ã‚‰ã€ŒOpenGISÂ® Implementation Standard for Geographic information - Simple feature access - Part 2: SQL optionã€ãŒç™ºè¡Œã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®ä»•æ§˜æ›¸ã¯ã€OGC Web ã‚µã‚¤ãƒˆ (http://www.opengeospatial.org/standards/sfs) ã‹ã‚‰å…¥æ‰‹
mfunaki 2008/10/27
MySQL

OpenGIS
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šWindowsç’°å¢ƒã«ãŠã‘ã‚‹SQL Serverã¨ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DBã®ç¾çŠ¶ (1/3)
æœ€è¿‘ã€å•†ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒç«¶ã†ã‚ˆã†ã«ç„¡å„Ÿã®DBã‚’æä¾›ã—ã¯ã˜ã‚ã¦ã„ã‚‹ã€‚ä¸€æ–¹ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®DBã¯ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã§åˆ©ç”¨ã™ã‚‹ãŸã‚ã®æ©Ÿèƒ½å¼·åŒ–ã‚’é€²ã‚ã‚‹ã¨ã¨ã‚‚ã«ã€Win32ãƒã‚¤ãƒ†ã‚£ãƒ–ã®ã‚¨ãƒ³ã‚¸ãƒ³ã‚„GUIãƒ„ãƒ¼ãƒ«ã®æ•´å‚™ãªã©Windowsç’°å¢ƒã§ã®æ™®åŠã«é–¢ã™ã‚‹å¼·åŒ–ãŒé€²ã‚“ã§ãã¦ã„ã‚‹ã€‚ä»Šå›žã®é€£è¼‰ã§ã¯ä¸å°è¦æ¨¡ã®Windowsç’°å¢ƒã‚’å‰æã¨ã—ã¦ã€å•†ç”¨ã®Microsoft SQL Server 2005ã¨ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®PostgreSQLã€MySQLã‚’æ¯”è¼ƒã—ã¦ç´¹ä»‹ã—ã¦ã„ãã€‚ æœ¬é€£è¼‰ãŒã€èªè€…ã®ã¿ãªã•ã‚“ã®DBé¸æŠžæ™‚ã®ä¸€åŠ©ã«ãªã‚Œã°å¹¸ã„ã§ã‚ã‚‹ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DBãŒç„¡å„Ÿã§ã‚ã‚‹ã“ã¨ã‚’é…åŠ›ã¨æ„Ÿã˜ã€ãƒ¦ãƒ¼ã‚¶ãŒåˆ©ç”¨ã™ã‚‹ã‚±ãƒ¼ã‚¹ãŒå¢—ãˆã¦ãã¦ã„ã‚‹ã€‚ã“ã‚Œã‚’æ„è˜ã—ã¦ã‹ã©ã†ã‹ã‚ã‹ã‚‰ãªã„ãŒã€å•†ç”¨DBã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ™ãƒ³ãƒ€ãƒ¼ãŒå¾“æ¥ã®è£½å“ãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ï¼ˆãƒ–ãƒ©ãƒ³ãƒ‰ï¼‰ã®1ã¤ã¨ã—ã¦ã€ç„¡å„Ÿã§åˆ©ç”¨ã§ãã‚‹ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã‚’æ¬¡ã€…ã¨æä¾›ã—ã¯ã˜ã‚ã¦ã„ã‚‹ã€‚ ä»Šå›žã¯
mfunaki 2006/06/07
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
http://news.livedoor.com/webapp/journal/cid__1891598/detail
mfunaki 2006/04/28
MySQL
ãƒªãƒ³ã‚¯
1