[B! Ruby][SQL] clavierã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

clavier id:clavier

Rubyã¨SQLã«é–¢ã™ã‚‹clavierã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

rubyã§SQLæ–‡ã‚’ãƒ‘ãƒ¼ã‚¹ã™ã‚‹ - Qiita
SQLã‚’ãƒ‘ãƒ¼ã‚¹ã™ã‚‹ã“ã¨ã«è¿«ã‚‰ã‚Œã¦Pythonã§è‡ªä½œã—ã¦ã„ãŸãŒã€rubyã§æ›¸ã„ãŸã»ã†ãŒã‚ˆã‚Šéƒ½åˆãŒè‰¯ã‹ã£ãŸã®ã§æ›¸ããªãŠã—ã‹ãƒ¼ã¨ãªã£ãŸã¨ã“ã‚ã§è¦‹ã¤ã‘ãŸã„ã„ã‚‚ã®ã€‚ ãŸã ã—ã€READMEã«ã©ãŠã‚Šã«ä½¿ã£ã¦ã¿ã¦ã‚‚ä½¿ãˆãªã‹ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ #ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ãˆã°ãƒ‘ãƒ¼ã‚¹ã§ãã‚‹ã€‚ https://github.com/cryodex/sql-parser gemã§ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚‹ã€‚ irb(main):001:0> require 'sql-parser' irb(main):002:0> parser = SQLParser::Parser.new irb(main):003:0> ast = parser.scan_str('SELECT * FROM users WHERE id = 1') irb(main):004:0> ast.select_list.to_sql N
clavier 2016/02/28
ruby

sql
ãƒªãƒ³ã‚¯
Predefã‚’ä½¿ã£ãŸsqlã®ãƒˆãƒ¬ãƒ¼ã‚¹
Module#prependã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã€Predefã‚’ä½¿ã£ã¦ãƒ‡ãƒãƒƒã‚°ã‚„ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ä½¿ç”¨ã•ã‚Œã‚‹SQLã®è§£æžã«å½¹ç«‹ã¦ã‚‹ã»ã†æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Read less
clavier 2015/06/06
sql

ruby
ãƒªãƒ³ã‚¯
Railsã‚¢ãƒ—ãƒªã§SQLã‚’ç™ºè¡Œã—ã¦ã„ã‚‹å ´æ‰€ã‚’ç‰¹å®šã™ã‚‹ã®ã«query_traceã¨ã‹ã„ã†gemãŒãã†ä¾¿åˆ© - Qiita
Railsã‚¢ãƒ—ãƒªã§ã‚¯ã‚½ã¿ãŸã„ãªSQLã‚’å¤§é‡ã«ç™ºè¡Œã—ã¦ã„ã‚‹ç®‡æ‰€ã‚’çŸ¥ã‚ŠãŸã€œã„ Railsã‚¢ãƒ—ãƒªã§ã€ç™ºè¡Œã•ã‚Œã‚‹SQLã®é‡ã‚’é ‘å¼µã£ã¦æ¸›ã‚‰ã™ã¨ãã«ã€ä¾‹ãˆã°N+1å•é¡Œã‚’ãªã‚“ã¨ã‹ã—ãŸã„ã¨æ€ã£ã¦Bulletã¨ã‹ã„ã†gemã‚’å…¥ã‚Œã¦ã€N+1ã‚’å‡ºã—ã¦ã„ã‚‹ç®‡æ‰€ã‚’ç‰¹å®šã—ãŸã‚Šã™ã‚‹å ´åˆã¯å¤šã„ã¨æ€ã„ã¾ã™ã€‚ å®Ÿéš›bulletã¯ã™ã£ã”ã„ä¾¿åˆ©ãªã‚“ã§ã™ãŒã€N+1å•é¡Œã‚’ç™ºç”Ÿã•ã›ã¦ã„ã‚‹ç®‡æ‰€ã‚’æ¤œå‡ºã§ããªã„å ´åˆãŒã‚ã£ãŸã‚Šã€ãã‚‚ãã‚‚ã®åŽŸå› ãŒã‚‚ã¨ã‚‚ã¨æ›¸ã„ã¦ã„ã‚‹ãƒã‚¸ãƒƒã‚¯ãŒæ‚ªãã¦ã€ãã‚Œã®è¦‹ç›´ã—ã§è§£æ±ºã—ãªãã‚ƒã„ã‘ãªã„å ´åˆã ã£ãŸã‚Šã¨ã‹ã™ã‚‹å ´åˆãŒã‚ˆãã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã§ã€ãã‚Œã§å‰ã€…ã‹ã‚‰ **ã€Œã“ã®Terminalã«å‡ºã¦ãã‚‹SQLæ–‡ã€Railsã‚¢ãƒ—ãƒªã®ã©ã“ãŒå‡ºã—ã¦ã‚‹ã®ã‹ãªã€œãã‚ŒãŒã‚ã‹ã£ãŸã‚‰è¶…ãƒ™ãƒ³ãƒªãªã®ã«ãªã€œã€œã€œã€**ã¨æ€ã£ã¦ã¾ã—ãŸã€‚ ä¼šç¤¾ã®åŒæœŸã«èžã„ãŸã‚‰ã‚ã£ã¡ã‚ƒä¾¿åˆ©ãªã®ãŒã‚ã£ãŸã‚“ã§ä»¥ä¸‹ã«æ›¸ãã¾ã™ã€‚ã‚‚ã£ã¨æ—©ãçŸ¥ã‚ŠãŸã‹ã£ãŸã€‚ query_traceã‚’ã¶ã£ã“
clavier 2014/07/06
gem

ruby

rails

SQL
ãƒªãƒ³ã‚¯
ActiveRecord4ã§ã“ã‚“ãªSQLã‚¯ã‚¨ãƒªã©ã†æ›¸ãã®? Arelç·¨ | Webã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºï¼æ•™è‚²ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¿ã‚¤ãƒ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ¡ãƒ‡ã‚£ã‚¢
ActiveRecord4ã§ã“ã‚“ãªSQLã‚¯ã‚¨ãƒªã©ã†æ›¸ãã®ï¼Ÿ Mergeç·¨ ã§ã¯ã€é–¢é€£å…ˆã®scopeã‚’ä½¿ã†ã“ã¨ãŒã§ãã‚‹mergeã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚mergeã‚’ä½¿ã†äº‹ã§ã€å¤‰æ›´ã«å¼·ã„ã‚¯ã‚¨ãƒªã‚’ç¾Žã—ãçµ„ã¿ç«‹ã¦ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ ä»Šå›žã¯ã€ActiveRecord4ã§æ›¸ãã«ãã„SQLã‚¯ã‚¨ãƒªãŸã¡ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ æ›¸ãã«ãã„ã‚¯ã‚¨ãƒªã¨ã¯ã€å…·ä½“çš„ã«ã¯ä»¥ä¸‹ã®ã‚‚ã®ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ æ¯”è¼ƒæ¼”ç®—ORlikeleft outer joinunionã‚µãƒ–ã‚¯ã‚¨ãƒªexists ActiveRecordã§ã“ã‚Œã‚‰ã®ã‚¯ã‚¨ãƒªã‚’çµ„ã¿ç«‹ã¦ã‚‹å ´åˆã€ã©ã†ã—ã¦ã‚‚ç¾Žã—ããªã„ï¼ˆSQLæ–‡å—åˆ—ã‚’ã¹ã£ãŸã‚Šæ›¸ã„ã¦ã—ã¾ã†ã‚ˆã†ãªï¼‰æ›¸ãæ–¹ã¨ãªã£ã¦ã—ã¾ã„ãŒã¡ã§ã™ã€‚ ã“ã®å‡¦ç†ã‚’ç¾Žã—ãæ›¸ããŸã‚ã«ã¯ã€ActiveRecordã ã‘ã®æ©Ÿèƒ½ã§ã¯è¶³ã‚Šãšã€ActiveRecordãŒå†…éƒ¨ã§ä½¿ã£ã¦ã„ã‚‹Arelã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ã†å¿…è¦ãŒã§ã¦ãã¾ã™ã€‚ ä»Šå›žã¯ã€Arelã‚’ä½¿ã£ã¦è¯éº—ã«SQLã‚¯
clavier 2014/04/10
rails

activerecord

Ruby

SQL
ãƒªãƒ³ã‚¯
é…’ã¨æ¶™ã¨Rubyã¨Railsã¨
asin: 4797363827 title: â€œ[Railsé«˜é€ŸåŒ–] ãƒšãƒ¼ã‚¸ã‚ãƒ£ãƒƒã‚·ãƒ¥ã€N+1å¯¾ç–ã€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°â€ category: Rails ðŸ¯ tags: [Rails, Ruby, Gem]ã€ŽCookpadã§ã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¸ã®ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ã€€200ms/reqã‚’ç›®æ¨™ã«ã—ã¦ã„ã‚‹ã€ã«æ„ŸéŠ˜ã‚’å—ã‘ã¦æ›¸ãå§‹ã‚ãŸã“ã®è¨˜äº‹ã§ã™ãŒã€ã€Žãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ã‚ªã‚¹ã‚¹ãƒ¡Gem in ã€ŒRailså‹‰å¼·ä¼š@æ±äº¬ ç¬¬88å›žã€ã€ã§ã„ã‚ã„ã‚æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã‚Šã€æœ€è¿‘é–¢ã‚ã£ã¦ã„ã‚‹ã‚µã‚¤ãƒˆã®ãƒªãƒ‹ãƒ¥ã‚¢ãƒ¼ãƒ«ã§è©¦è¡ŒéŒ¯èª¤ã—ãŸã®ã§ã€å¿˜å‚™éŒ²ã‚‚å…¼ãã¦è¨˜äº‹ã‚’ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ã¾ã™ï¼ ðŸš• ç›®æ¬¡(1) N+1å•é¡Œã®å¯¾ç– (2) Railsã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ã¤ã„ã¦ (3) é–‹ç™ºä¸ãªã‚‰rack_mini_profiler (4) é‹ç”¨ä¸ãªã‚‰æ–ç„¶NewRelicãŒãŠã™ã™ã‚ (5) mysqlã®ç°¡å˜ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ðŸšŒ (1) N + 1å•
clavier 2013/01/13
rails

sql

ruby

performance
ãƒªãƒ³ã‚¯
Railsé–‹ç™ºã‚’è£œåŠ©ã™ã‚‹Google Chromeæ©Ÿèƒ½æ‹¡å¼µÂ·RailsPanel MOONGIFT
RailsPanelã¯Google Chromeã®ã‚¤ãƒ³ã‚¹ãƒšã‚¯ã‚¿ã«Railsç”¨ãƒ‘ãƒãƒ«ã‚’è¿½åŠ ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ Ruby on Railsã¯é–‹ç™ºé€Ÿåº¦ã‚’é£›èºçš„ã«å‘ä¸Šã—ã¦ãã‚Œã¾ã™ãŒã€ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã®ãƒã‚°ã¨Webãƒ–ãƒ©ã‚¦ã‚¶ã§ã®è¡¨ç¤ºã‚’äº¤äº’ã«ç¢ºèªã™ã‚‹ã®ã¯é¢å€’ã«æ„Ÿã˜ã¦ã„ã¾ã—ãŸã€‚ãã“ã§ä½¿ã£ã¦ã¿ãŸã„ã®ãŒRailsPanelã§ã™ã€‚ Google Chromeæ©Ÿèƒ½æ‹¡å¼µã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚åˆ¥é€”Railså´ã§ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚å¿…è¦ã§ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒšã‚¯ã‚¿ã«RailsPanelãŒè¿½åŠ ã•ã‚Œã¦ã„ã¾ã™ã€‚ å®Ÿè¡Œã•ã‚ŒãŸSQLã‚‚ç¢ºèªã§ãã¾ã™ã€‚ ãƒ¬ãƒ³ãƒ€ãƒªãƒ³ã‚°ã«ä½¿ã‚ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚‚ç¢ºèªã§ãã¾ã™ã€‚Mac Vimãªã©ã§ã‚ã‚Œã°ã“ã“ã‹ã‚‰ã‚¯ãƒªãƒƒã‚¯ã—ã¦é–‹ã‘ã¾ã™ã€‚ è¨å®šã§ã™ã€‚TextMateã€Mac VimãŒå¯¾å¿œã«ä¸ŠãŒã£ã¦ã„ã¾ã™ã€‚ RailsPanelã‚’ä½¿ãˆã°å®Ÿè¡Œã•ã‚ŒãŸã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã€ä½¿ã‚ã‚ŒãŸãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã€å®Ÿè¡Œã•ã‚ŒãŸSQLãŒä¸€ç›®ã§ç¢ºèªã§ã
clavier 2013/01/13
ruby

chrome

rails

sql
ãƒªãƒ³ã‚¯
SQLä¸Šç´šè€…ã“ãçŸ¥ã£ã¦æ¬²ã—ã„ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ï¼Ÿ
(PgDay2012ç™ºè¡¨è³‡æ–™) SQLã«ã¨ã£ã¦ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ã‚’èª¬æ˜Žã—ãŸè³‡æ–™ã§ã™ã€‚Read less
clavier 2012/12/07
ruby

programming

rails

slideshare

sql
ãƒªãƒ³ã‚¯
1