High
Rails
Use database constraints
Official
Rule Description
Don't rely solely on ActiveRecord validations - add database constraints:
- NOT NULL for required fields
- UNIQUE indexes for unique fields
- Foreign key constraints for associations
- Check constraints for business rules
```ruby
# Migration
add_column :users, :email, :string, null: false
add_index :users, :email, unique: true
add_foreign_key :orders, :users
```
Database constraints are your last line of defense against bad data.
Included in Rulesets
Rails Standards
36 rules • 1 standard
PostgreSQL Standards
25 rules • 0 standards
MySQL Standards
25 rules • 0 standards
MongoDB Best Practices
25 rules • 1 standard
Redis Guidelines
25 rules • 0 standards
SQLite Standards
25 rules • 0 standards
Code Review Standards
58 rules • 0 standards
Add This Rule
Sign in to add this rule to your workspace
Sign in with GitHubDetails
- Severity
- High
- Category
- Rails
- Used in
- 7 rulesets