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

ohbarye id:ohbarye

SQLã¨railsã«é–¢ã™ã‚‹ohbaryeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

GitHub - fatkodima/columns_trace: Detect unnecessary selected database columns
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
ohbarye 2023/10/07
SQLã§SELECTã•ã‚ŒãŸã‘ã©ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œãªã‹ã£ãŸcolumnsã‚’ç™ºè¦‹ã™ã‚‹gem ã€‚ActiveRecordã®after_findã§recordã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’è¨˜æ†¶ã—ã¦ãŠã„ã¦ã€action_controllerã‚„active_jobã®after_(action|perform)ã§ãƒã‚°ã«å‡ºã™ä»•çµ„ã¿

ruby

sql

rails
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã›ãšã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã™ã‚‹ - Pepabo Tech Portal
2022å¹´7æœˆ13æ—¥ã«ã‚«ãƒ©ãƒ¼ãƒŸãƒ¼ã‚·ãƒ§ãƒƒãƒ—ã§æä¾›é–‹å§‹ã—ãŸã€Œå‰¯ç®¡ç†è€…æ©Ÿèƒ½ã€ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã«ã‚ãŸã£ã¦ã€å¾“å‰ã®æŒ™å‹•ã‚’å¤‰ãˆãšã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ã‚ãƒ¼ãƒžã®æ§‹é€ ã‚’å¤‰ãˆã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ã¾ãŸã€ã‚µãƒ¼ãƒ“ã‚¹ã®æä¾›ã‚’åœæ¢ã™ã‚‹ã“ã¨ãªãã€ã‚¹ã‚ãƒ¼ãƒžã®æ§‹é€ ã®å¤‰æ›´ã‚’é€²ã‚ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã›ãšã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’å¾ã€…ã«å¤‰æ›´ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã‚’ã©ã®ã‚ˆã†ã«é€²ã‚ãŸã‹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã€ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã«ã¤ã„ã¦ä½“ç³»çš„ã«è¿°ã¹ãŸæ›¸ç±ã¨ã—ã¦"Refactoring Databases"ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®æœ¬ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã®ã•ã¾ã–ã¾ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã«ãŠã„ã¦ã€ã‚¹ã‚ãƒ¼ãƒžã®å¤‰æ›´ã€ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆæ—¢å˜ãƒ‡ãƒ¼ã‚¿ã®ç§»è¡Œï¼‰ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¤‰æ›´ãã‚Œãžã‚Œã‚’ã©ã®ã‚ˆã†ã«é€²ã‚ã‚‹ã¹ãã‹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ã€"Refactoring Dat
ohbarye 2022/07/25
db

database

mysql

rails

sql
ãƒªãƒ³ã‚¯
Rename table without downtime helper (!54354) Â· Merge requests Â· GitLab.org / GitLab Â· GitLab
ohbarye 2022/07/21
ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒªãƒãƒ¼ãƒ ã‚’downtimeãªã—ã§è¡Œã†æ–¹æ³•ã€‚ALTER TABLEã¨åŒæ™‚ã«VIEWä½œæˆã—ã¦äº’æ›æ€§ã‚’æ‹…ä¿ã™ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã€‚GitLabã§ã¯Railsã®migrationã‚’å°‘ã—æ‹¡å¼µã—ãŸãƒ˜ãƒ«ãƒ‘ãƒ¼ã‚’å®Ÿè£…ã—ã¦ã„ã‚‹ã€‚

database

db

SQL

rails
ãƒªãƒ³ã‚¯
Rails - ActiveRecord ã® scope ã‚’ Query object ã§å®Ÿè£…ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
ohbarye 2018/02/10
ActiveRecord

Rails

SQL
ãƒªãƒ³ã‚¯
Rails SQL Injection Examples
Overview The Ruby on Rails web framework provides a library called ActiveRecord which provides an abstraction for accessing databases. This page lists many query methods and options in ActiveRecord which do not sanitize raw SQL arguments and are not intended to be called with unsafe user input. Careless use of these methods can open up code to SQL Injection exploits. The examples here do not inclu
ohbarye 2017/11/12
SQL

security

Rails

ActiveRecord
ãƒªãƒ³ã‚¯
1