High Rails

Use database constraints

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
View
PostgreSQL Standards
25 rules • 0 standards
View
MySQL Standards
25 rules • 0 standards
View
MongoDB Best Practices
25 rules • 1 standard
View
Redis Guidelines
25 rules • 0 standards
View
SQLite Standards
25 rules • 0 standards
View
Code Review Standards
58 rules • 0 standards
View

Add This Rule

Sign in to add this rule to your workspace

Sign in with GitHub

Details

Severity
High
Category
Rails
Used in
7 rulesets