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

YassLab id:YassLab

SQLã«é–¢ã™ã‚‹YassLabã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œè¨ˆç”»ã‚’ç¢ºèªã—ã‚ˆã†ã¨ã—ãŸã‚‰ã‚µãƒ¼ãƒãƒ¼ãŒè½ã¡ãŸè©± - Qiita
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚½ãƒ¼ã‚·ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€Œã‚¯ãƒ©ã‚¦ãƒ‰ãƒ¯ãƒ¼ã‚¯ã‚¹ï¼ˆcrowdworks.jpï¼‰ã€ã§ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã—ã¦ã„ã‚‹åŽŸã§ã™ã€‚ å…ˆæ—¥æ¥å‹™ã§Railsã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã—ã¦ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ã¦ã„ãŸéš›ã€ActiveRecord::Relation#explainãƒ¡ã‚½ãƒƒãƒ‰ã®æŒ™å‹•ã«é–¢ã™ã‚‹èªè˜ä¸è¶³ã«ã‚ˆã‚Šã‚µãƒ¼ãƒãƒ¼ã®ãƒªã‚½ãƒ¼ã‚¹ã‚’æž¯æ¸‡ã•ã›ã¦ã—ã¾ã£ãŸã¨ã„ã†ã“ã¨ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã€Œå®Ÿè¡Œè¨ˆç”»ï¼ˆEXPLAINï¼‰ã‚’ç¢ºèªã™ã‚‹ã ã‘ãªã‚‰å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿å–å¾—ã¯è¡Œã‚ã‚Œãªã„ã€ã¨è€ƒãˆã¦ã„ã‚‹æ–¹ã‚‚å¤šã„ã‹ã¨æ€ã„ã¾ã™ãŒã€Railsã®ç‰¹å®šã®æ¡ä»¶ä¸‹ã§ã¯é€šå¸¸ã®SELECTæ–‡ãŒç™ºè¡Œã•ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ éšœå®³ç™ºç”Ÿæ™‚ã®çŠ¶æ³ æœ¬ç•ªç’°å¢ƒã®ç®¡ç†ç”¨ã‚µãƒ¼ãƒãƒ¼ã«ã¦ã€é‡ã„ã‚¯ã‚¨ãƒªã®èª¿æŸ»ã®ãŸã‚ã«Railsã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã—ãŸã€‚ ãã®éš›ã€ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œè¨ˆç”»ã‚’ç¢ºèªã™ã‚‹ç›®çš„ã§ActiveRecord::Relation#explainã‚’å®Ÿè¡Œã—ãŸã¨ã“ã‚ã€ã‚µãƒ¼ãƒãƒ¼ã®ãƒ¡
YassLab 2025/12/13
â€œRailsã®explainãƒ¡ã‚½ãƒƒãƒ‰ã¯ã€ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã§ã®è¡¨ç¤ºæ™‚ã«å®Ÿãƒ‡ãƒ¼ã‚¿ã‚’SELECTã™ã‚‹å ´åˆãŒã‚ã‚‹ / å‚è€ƒæ–‡çŒ®: https://railsguides.jp/v7.1/active_record_querying.html#explain%E3%82%92%E5%AE%9F%E8%A1%8C%E3%81%99%E3%82%8Bâ€

Ruby

Rails

Railsã‚¬ã‚¤ãƒ‰

SQL

é–‹ç™º
ãƒªãƒ³ã‚¯
Kaigi on Rails 2024 ã«ã€ŒActiveRecord SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¤ã‚º (Rails 7.1.3.4)ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ç™»å£‡ã—ã¾ã™ - Classié–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ä¸æ‘ ( id:kozy4324 ) ã§ã™ã€‚ 2024å¹´10æœˆ25æ—¥ (é‡‘) ã‹ã‚‰ 26æ—¥ (åœŸ) ã«ã€æ±äº¬ã®æœ‰æ˜Žã‚»ãƒ³ãƒˆãƒ©ãƒ«ã‚¿ãƒ¯ãƒ¼ãƒ›ãƒ¼ãƒ« & ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§é–‹å‚¬äºˆå®šã® Kaigi on Rails 2024 ã«ã¦ã€ã€ŒActiveRecord SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¤ã‚º (Rails 7.1.3.4)ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ç™»å£‡ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ä»Šå›žã¯ã€ã“ã®ãƒ†ãƒ¼ãƒžã‚’é¸ã‚“ã èƒŒæ™¯ã‚„ã€ç™»å£‡ã‚’é€šã˜ã¦é”æˆã—ãŸã„ã“ã¨ã«ã¤ã„ã¦ã€äº‹å‰ã«ãŠä¼ãˆã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ Rails ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã«ãŠã‘ã‚‹ã‚»ã‚ãƒ¥ã‚¢ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã€ã§ãã¦ã„ã¾ã™ã‹ï¼Ÿ ã“ã‚Œã¯è‡ªæˆ’ã®å¿µã‚’è¾¼ã‚ãŸå•ã„ã‹ã‘ã§ã‚‚ã‚ã‚Šã¾ã™ã€‚ æ˜¨å¹´æœ«ã€ç§ã¯ Ruby on Rails ã‚’ä½¿ã£ãŸæ–°è¦ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚¸ãƒ§ã‚¤ãƒ³ã—ã¾ã—ãŸã€‚ãã‚Œã‚’æ©Ÿã«ã€Rails ã«ãŠã‘ã‚‹ã‚»ã‚ãƒ¥ã‚¢ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å†ç¢ºèªã—ãŸã„ã¨æ€ã„ã€æƒ…å ±
YassLab 2024/10/10
"IPAãŒå…¬é–‹ã—ã¦ã„ã‚‹ã€Œå®‰å…¨ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹ã€ã‚„æ›¸ç±ã€Žä½“ç³»çš„ã«å¦ã¶ å®‰å…¨ãªWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œã‚Šæ–¹ã€ãŒéžå¸¸ã«å‚è€ƒã«ãªã‚Šã¾ã—ãŸã€‚Railsã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ãŸå†…å®¹ã§ã„ãˆã°Railsã‚¬ã‚¤ãƒ‰ã€ŒRailsã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚¬ã‚¤ãƒ‰ã€ã¯å¿…èª"

Ruby

Rails

Security

Railsã‚¬ã‚¤ãƒ‰

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

SQL

é–‹ç™º

ActiveRecord

IPA

ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢
ãƒªãƒ³ã‚¯
Rails Tutorialã§å¦ã¹ã‚‹ã“ã¨ãƒ¡ãƒ¢-ç¬¬14ç« - | tnkzw.sake's blog
YassLab 2024/07/29
â€œå®Ÿéš›ã«èªè¨¼ã‚„èªå¯ãƒ¢ãƒ‡ãƒ«ã‚’ä¼´ã£ãŸã‚‚ã®ã‚’ãƒ‡ãƒ—ãƒã‚¤ã™ã‚‹ã®ã§ã€å‹•ãã‚‚ã®ã‚’ä½œã‚‹ï¼ã¨ã„ã†ã‚¹ã‚¿ãƒ¼ãƒˆåœ°ç‚¹ã¾ã§ã®ã‚¢ã‚¦ãƒˆãƒ©ã‚¤ãƒ³ã¨ã™ã‚‹ã®ã«ã™ã”ãã¡ã‚‡ã†ã©ã„ã„æ•™æâ€

Ruby

Rails

Railsãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«

SQL

Hotwire
ãƒªãƒ³ã‚¯
ActiveRecord SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚¯ã‚¤ã‚º (Rails 7.1.3.4)
å•é¡Œ ActiveRecordã‚¯ã‚¤ã‚ºã§ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯èƒ½ãªã®ã¯ã©ã‚Œã§ã—ã‚‡ã†ï¼Ÿ ï¼ˆRailsãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯7.1.3.4ã€è¤‡æ•°å›žç”ã‚ã‚Šï¼‰ 1ï¸âƒ£ User.find_by(id: params[:id]) 2ï¸âƒ£ User.where("id = #{params[:id]}") 3ï¸âƒ£ User.order("id #{params[:order]}") 4ï¸âƒ£ User.exists?(params[:id]) æ£è§£ã¨è§£èª¬ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯èƒ½ãªã®ã¯ 2ï¸âƒ£ ã¨ 4ï¸âƒ£ 1ï¸âƒ£ User.find_by(id: params[:id]) ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å‡¦ç†ãŒå…¥ã‚‹ãŸã‚ ã“ã‚Œã¯å®‰å…¨ãªå‘¼ã³å‡ºã—ã§ã™ã€‚ Railsã‚¬ã‚¤ãƒ‰ã«ã‚‚å¼•ç”¨ãŒã‚ã‚Šã¾ã™ã€‚ Model.find(id)ã‚„Model.find_by_*(å¼•æ•°)ã¨ã„ã£ãŸã‚¯ã‚¨ãƒªã§ã¯è‡ªå‹•çš„ã«ã“ã®å¯¾ç–ãŒé©ç”¨ã•ã‚Œã¾ã™ã€‚ 2ï¸âƒ£ User.wher
YassLab 2024/07/22
â€œãƒ¦ãƒ¼ã‚¶ãƒ¼å…¥åŠ›ã‚’ç›´æŽ¥æ¸¡ã™ãªï¼ã¨ã„ã†è©±ã¯ãã‚Œã¯ãã†ã€‚å¤§å‰æã¨ã—ã¦ãã‚Œã¯ã¾ãšæœ€åˆã«å®ˆã‚‰ãªã‘ã‚Œã°ãªã‚‰ãªã„ / Brakemanã¨ã„ã†ãƒ„ãƒ¼ãƒ«ãŒæœ€è¿‘æ°—ã«ãªã£ã¦ã„ã‚‹ã€‚Railsã«ç‰¹åŒ–ã—ãŸã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®é™çš„è§£æžãƒ„ãƒ¼ãƒ«ã§ã™ã€‚â€

Ruby

Rails

ActiveRecord

SQL

Security

Brakeman

Railsã‚¬ã‚¤ãƒ‰
ãƒªãƒ³ã‚¯
Conceptual compression - ohbarye
YassLab 2024/07/15
"Conceptual compression -- ç›´è¨³ã™ã‚‹ã¨æ¦‚å¿µçš„åœ§ç¸® / æŠ½è±¡åŒ–ã‚’æ´»ç”¨ã™ã‚‹äº‹ã§è©³ç´°ãªç†è«–ã‚„æ¦‚å¿µã‚’åœ§ç¸®ã—ã¦ç›®çš„ã‚’é”æˆã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚„è€ƒãˆæ–¹ / DHHãŒå¥½ã‚“ã§ä½¿ã† / e.g. ORMã®ç™ºæ˜Žã«ã‚ˆã‚ŠSQLã‚’çŸ¥ã‚‰ãšã¨ã‚‚ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã§ãã‚‹"

DB

SQL

ORM

Ruby

DHH

Rails
ãƒªãƒ³ã‚¯
14 tools every Ruby developer will love for performance and debugging"
Product Performance, Product Scaling, & Technical Assessments
YassLab 2024/03/29
â€œThis one is not a gem, but eh, did you know you can hit the /rails/info/routes route in Rails and get a list of your routes? No need to call bin/rails routes. Plus, itâ€™s searchable, and you can toggle between the path and URL helper. Great when you need a quick copy-paste for your views. â€

Rails

SQL

Ruby

ActiveRecord
ãƒªãƒ³ã‚¯
activerecord-originator ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸ - pockestrap
ã“ã‚“ã«ã¡ã¯ã€‚ id:Pocke ã§ã™ã€‚ ä»Šæ—¥ã¯ activerecord-originator ã¨ã„ã† gem ã‚’ä½œã£ãŸã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ github.com ãªã«ã“ã‚Œ Active Record ãŒç™ºè¡Œã™ã‚‹SQLã®å„éƒ¨åˆ†ã«ã€ãã‚ŒãŒã©ã“ã§ä½œã‚‰ã‚ŒãŸã‚‚ã®ã‹ã‚’ã‚³ãƒ¡ãƒ³ãƒˆã¨ã—ã¦å…¥ã‚Œè¾¼ã‚€ gem ã§ã™ã€‚ ç†è§£ã™ã‚‹ã«ã¯å®Ÿä¾‹ã‚’è¦‹ã‚‹ã®ãŒæ—©ã„ã§ã—ã‚‡ã†ã€‚æ¬¡ã®ãƒã‚°ã¯ArticlesController#indexã§å®Ÿè¡Œã•ã‚Œã‚‹ã‚¯ã‚¨ãƒªã®ä¾‹ã§ã™ã€‚ Article Load (0.1ms) SELECT "articles".* FROM "articles" WHERE "articles"."status" = ? /* app/models/article.rb:3:in `published' */ AND "articles"."category_id" = ? /* app/controllers/artic
YassLab 2024/03/14
"SQL ã®çµ„ã¿ç«‹ã¦ãŒè¤‡é›‘ã«ãªã‚‹ã¨ã€ã“ã® gem ãŒçœŸä¾¡ã‚’ç™ºæ® / ãã®ã‚¯ã‚¨ãƒªãŒã©ã®ã‚ˆã†ã«çµ„ã¿ç«‹ã¦ã‚‰ã‚ŒãŸã‹ãŒãƒ”ãƒ³ãƒã‚¤ãƒ³ãƒˆã§åˆ†ã‹ã‚‹ / default_scope ã®ã‚ˆã†ãªã€ã©ã“ã§ä»˜ä¸Žã•ã‚ŒãŸã®ã‹åˆ†ã‹ã‚Šã¥ã‚‰ã„æ¡ä»¶ã‚’ãƒ‡ãƒãƒƒã‚°ã™ã‚‹éš›ã«ã‚‚å½¹ç«‹ã¤"

SQL

ActiveRecord

Ruby

Rails

Gem
ãƒªãƒ³ã‚¯
1