[B! database] ichi_Sã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ichi_S id:ichi_S

databaseã«é–¢ã™ã‚‹ichi_Sã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

ãƒ‘ãƒ¼ãƒ•ã‚§ã‚¯ãƒˆRailsè‘—è€…ãŒè§£èª¬ã™ã‚‹deviseã®ç¾ä»£çš„ãªãƒ¦ãƒ¼ã‚¶ãƒ¼èªè¨¼ã®ãƒ¢ãƒ‡ãƒ«æ§‹æˆã«ã¤ã„ã¦ - joker1007â€™s diary
æœ€è¿‘ã€ãƒ‘ãƒ¼ãƒ•ã‚§ã‚¯ãƒˆRuby on Railsã®å¢—è£œæ”¹è¨‚ç‰ˆã‚’ãƒªãƒªãƒ¼ã‚¹ã•ã›ã¦ã„ãŸã ã„ãŸèº«ãªã®ã§ã€ä¹…ã—ã¶ã‚Šã«Railsã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ ã¾ã‚ã€æ›¸ç±ã®å®£ä¼ã¿ãŸã„ãªã‚‚ã®ã§ã™ã€‚ æ•°æ—¥å‰ã«ã€noteã¨ã„ã†ã‚µãƒ¼ãƒ“ã‚¹ã§Webãƒ•ãƒãƒ³ãƒˆå´ã«æŠ•ç¨¿è€…ã®IPã‚¢ãƒ‰ãƒ¬ã‚¹ãŒéœ²å‡ºã™ã‚‹ã¨ã„ã†æ¼æ´©äº‹æ•…ãŒèµ·ãã¾ã—ãŸã€‚ã“ã‚ŒãŒã©ã‚Œãã‚‰ã„å•é¡Œã‹ã¯ä¸€æ—¦ç½®ã„ã¦ãŠã„ã¦ã€ä½•æ•…ã“ã†ã„ã†ã“ã¨ã«ãªã‚‹ã®ã‹ã€ãã—ã¦Railsã§ã‚ˆãä½¿ã‚ã‚Œã‚‹deviseã¨ã„ã†èªè¨¼æ©Ÿæ§‹ä½œæˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚ˆã‚Šè‰¯ã„ä½¿ã„æ–¹ã«ã¤ã„ã¦è©±ã‚’ã—ã¦ã„ãã¾ã™ã€‚ (noteãŒRailsã‚’ä½¿ã£ã¦ã„ã‚‹ã‹ã€ã“ã“ã§è©±ã‚’ã™ã‚‹deviseã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹ã‹ã¯å®šã‹ã§ã¯ãªã„ã®ã§ã€ã“ã“ã‹ã‚‰å…ˆã®è©±ã¯ãã®äº‹æ•…ã¨ã¯ç›´æŽ¥é–¢ä¿‚ã‚ã‚Šã¾ã›ã‚“ã€‚Railsã ã£ãŸã¨ã—ã¦ã‚‚æã‚‰ãä½¿ã£ã¦ãªã„ã‹å¤‰ãªä½¿ã„æ–¹ã—ã¦ã‚‹ã¨æ€ã†ã‚“ã§ã™ãŒã€ç†ç”±ã¯å¾Œè¿°) ä½•æ•…ã“ã‚“ãªã“ã¨ãŒèµ·ãã‚‹ã®ã‹ ãã‚‚ãã‚‚ã€ãƒ•ãƒãƒ³ãƒˆå´ã«ä½•æ•…IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’é€ã£ã¦ã‚“ã ã€ã¨ã„ã†è©±ã§ã™
ichi_S 2020/08/17
devise

rails

activerecord

database

auth
ãƒªãƒ³ã‚¯
Automating MySQL schema migrations with GitHub Actions and more
AI & MLLearn about artificial intelligence and machine learning across the GitHub ecosystem and the wider industry. Generative AILearn how to build with generative AI. GitHub CopilotChange how you work with GitHub Copilot. LLMsEverything developers need to know about LLMs. Machine learningMachine learning tips, tricks, and best practices. How AI code generation worksExplore the capabilities and be
ichi_S 2020/02/19
schema

migration

database

db

mysql
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆç®¡ç†ã‚·ã‚¹ãƒ†ãƒ dmemo ã®ã”æ¡ˆå†… - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã«å‡ºå‘ä¸ã®å°å®¤ (id:hogelog) ã§ã™ã€‚ ä»Šå›žã¯ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã¨ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆç®¡ç†ã‚·ã‚¹ãƒ†ãƒ dmemo ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ https://github.com/hogelog/dmemo dmemo ã‚’ä½œæˆã—å°Žå…¥ã—ãŸçµŒç·¯ ç§ã¯2016å¹´3æœˆé ƒã‹ã‚‰ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã§ Redshift, bricolage, embulk, re:dash ç‰ã‚’åˆ©ç”¨ã—ãŸãƒ‡ãƒ¼ã‚¿åˆ†æžåŸºç›¤ã®æ§‹ç¯‰ã‚’é€²ã‚ã¦ã„ã¾ã™ã€‚ (ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã®ãƒ‡ãƒ¼ã‚¿åˆ†æžåŸºç›¤ã®ç¾çŠ¶ - ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒ–ãƒã‚°) ç¤¾å†…ã®èª°ã§ã‚‚æ‰±ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ‡ãƒ¼ã‚¿ã®é›†ç´„ãƒ»è¨ˆç®—ãƒ»åŠ å·¥ã€ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ä½œæˆã€ã‚¯ã‚¨ãƒªã®å…±æœ‰ãªã©ã¯ä¸Šè¨˜ãƒ–ãƒã‚°è¨˜äº‹ã§ã‚‚æ›¸ã„ãŸã‚ˆã†ã« Redshift, bricolage, embulk, re:dash ç‰ã‚’çµ„ã¿åˆã‚ã›ã‚‹ã“ã¨ã§å®Ÿç¾
ichi_S 2016/08/08
db

database
ãƒªãƒ³ã‚¯
Redirectingâ€¦
Redirectingâ€¦ Click here if you are not redirected.
ichi_S 2016/08/02
schema

migration

MySQL

database

golang
ãƒªãƒ³ã‚¯
Windowé–¢æ•° â€” Let's Postgres
ã¾ãŸã€CREATE FUNCTION æ–‡ã§ãƒ¦ãƒ¼ã‚¶å®šç¾©ã®Windowé–¢æ•°ã‚’è¿½åŠ ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ãŒã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 8.4 ã§ã¯Cè¨€èªžã§é–¢æ•°ã‚’è¨˜è¿°ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚SQLã‚„PL/pgSQLã¯ä½¿ãˆãªã„ã®ã§ã€æ•·å±…ã¯é«˜ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä¾‹ å…¸åž‹çš„ãªWindowé–¢æ•°ã®ä½¿ã„æ–¹ã‚’æŒ™ã’ã¾ã™ã€‚ã“ã®ä»–ã«ã‚‚ã€ã“ã‚Œã¾ã§è¤‡é›‘ãªSQLãŒå¿…è¦ã ã£ãŸã•ã¾ã–ã¾ãªã‚±ãƒ¼ã‚¹ã‚’åŠ¹çŽ‡åŒ–ã§ãã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã®ã§ã€SQLãƒ‘ã‚ºãƒ«ã ã¨æ€ã£ã¦è©¦ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ã€‚ é€£ç•ªä»˜ä¸Ž é€£ç•ªä»˜ä¸Žã‚’è¡Œã„ã¾ã™ã€‚ã‚½ãƒ¼ãƒˆã—ãŸå¾Œã€ç•ªå·ã‚’ãµã‚‹ã®ãŒãƒã‚¤ãƒ³ãƒˆã§ã™ã€‚ SELECT row_number() OVER (), * FROM (SELECT * FROM tbl ORDER BY sortkey) AS t; ãŸã ã—ã€çµæžœã®æœ€å¤§è¡Œæ•°ã‚’æŒ‡å®šã™ã‚‹ã«ã¯ã€row_number ã¨ã®å€¤ã®æ¯”è¼ƒã§ã¯ãªãã€ã“ã‚Œã¾ã§ã©ãŠã‚Š LIMIT å¥ã‚’ä½¿ã£ã¦ãã ã•ã„ã€‚row_number
ichi_S 2015/07/07
SQL

database

postgres
ãƒªãƒ³ã‚¯
DBã®Master-Slaveå¯¾å¿œ - ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒ¡ãƒ¢
https://github.com/primeminister/cake-master-slave-setup ã“ã¡ã‚‰ã‚’CakePHP 2.xã«å¯¾å¿œã•ã›ãŸã‚‚ã®ã§ã™ã€‚ ã¤ã„ã§ã«è‰²ã€…ã„ã˜ã£ãŸã®ã§ã‚ªãƒªã‚¸ãƒŠãƒ«ã¨ã¯ä½¿ã„æ–¹ãŒé•ã„ã¾ã™ã€‚ app/Model/Datasource/Database/MysqlMasterSlave.php <?php App::uses('Mysql', 'Model/Datasource/Database'); /** * https://github.com/primeminister/cake-master-slave-setup ã‚’Cake 2.xã«å¯¾å¿œã•ã›ãŸã‚‚ã®ã€‚ */ class MysqlMasterSlave extends Mysql { public $description = "MySQL DBO Driver with support for
ichi_S 2014/01/08
replication

MySQL

database

cakephp
ãƒªãƒ³ã‚¯
Making Rake tasks ignore Rails observers â€“ James Robey
ichi_S 2012/08/23
rake

rails

database

observer

ruby
ãƒªãƒ³ã‚¯
MariaDB Foundation - MariaDB.org
MariaDB Server is one of the most popular open source relational databases. Itâ€™s made by the original developers of MySQL and guaranteed to stay open source. It is part of most cloud offerings and the default in most Linux distributions. It is built upon the values of performance, stability, and openness, and MariaDB Foundation ensures contributions will be accepted on technical merit. Recent new
ichi_S 2012/08/21
database

DB

MariaDB

mysql
ãƒªãƒ³ã‚¯
JavaScriptã®åŸºç¤Žã‹ã‚‰ã¯ã˜ã‚ã‚ˆã† - JavaScriptè¬›åº§
å¤‰æ•°ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«å€¤ã‚’ä»£å…¥ã—ãŸã‚Šå‡ºåŠ›ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ # å¤‰æ•°ã«æ–‡å—åˆ—ã‚’ä»£å…¥ $value = "ãƒ†ã‚¹ãƒˆã§ã™"; # å¤‰æ•°ã‚’å‡ºåŠ› print $value; ã€å‚ç…§ãƒšãƒ¼ã‚¸ã€‘ å¤‰æ•° é…åˆ— è¤‡æ•°ã®å€¤ã‚’1ã¤ã®å¤‰æ•°ã§ç®¡ç†ã—ãŸã„å ´åˆã¯ã€ã€Žé…åˆ—ã€ã¨ã„ã†å¤‰æ•°ãŒæœ€é©ã§ã™ã€‚ é…åˆ—ã‚’åˆæœŸåŒ–ã™ã‚‹å ´åˆã¯ï½¤è¦ç´ ã‚’ã‚«ãƒƒã‚³ã§å›²ã¿ï½¤å„è¦ç´ æ¯Žã«ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã‚Šã¾ã™ï½¡ @week = ('æ—¥æ›œ', 'æœˆæ›œ', 'ç«æ›œ', 'æ°´æ›œ', 'æœ¨æ›œ', 'é‡‘æ›œ', 'åœŸæ›œ'); é…åˆ—ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦å‚ç…§ã—ã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ 0ã‹ã‚‰å§‹ã¾ã‚‹ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ãŸã¨ãˆã°1ç•ªç›®ã®ãƒ‡ãƒ¼ã‚¿ "æ—¥æ›œ" ã‚’å‘¼ã³å‡ºã™ã¨ãã¯ã€$week[0]ã€"æœˆæ›œ"ãªã‚‰ $week[1] ã¨ã—ã¾ã™ã€‚ # é…åˆ— @week ã®1ç•ªç›®ã®è¦ç´ ã‚’è¡¨ç¤º print $week[0], "\n"; > æ—¥æ›œ # é…åˆ— @week ã®2ç•ªç›®ã®è¦ç´ ã‚’è¡¨ç¤º print $
ichi_S 2011/02/08
database

mysql

GRANT

SQL
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹ï¼šãƒ¦ã‚«ã‚¤ã€ãƒ„ãƒ¼ã‚«ã‚¤ã€ã‚«ã‚¤ãƒãƒ„ç’°å¢ƒï¼ï¼ˆ11ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ç„¡æ–™ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŒERMasterã€ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã¨ãã«çš†ã•ã‚“ã¯ã€ã©ã®ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã„ãã¤ã‹ã®ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç†è€…ã¯ãã‚Œã‚‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘ã€ŒERMasterã€ã¨å‘¼ã°ã‚Œã‚‹Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®å˜åœ¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ERMasterã¯ã€ã»ã‹ã®ãƒ„ãƒ¼ãƒ«ã«æ¯”ã¹ã€ç›´æ„Ÿçš„ã§åˆ†ã‹ã‚Šã‚„ã™ã„UIï¼ˆãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ï¼‰ã«ã€ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ãªã€Excelã§å‡ºåŠ›ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã€è¾žæ›¸æ©Ÿèƒ½ãªã©ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±ŠãERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚æœ¬ç¨¿ã§ã¯ã€ã“ã®ERMasterã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ERMasterã®ä¸»ãªç‰¹å¾´ã€8ã¤ ERMasterã«ã¯ã€ä¸»ã«æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ ã€1ã€‘ç›´æ„Ÿçš„ã§ä½¿ã„ã‚„
ichi_S 2010/01/22
plugin

eclipse

database

è¨è¨ˆ
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
ichi_S 2009/10/23
MySQL

server

é‹ç”¨

database
ãƒªãƒ³ã‚¯
1