N+1 detection tools in Ruby on Rails - Mini Project: Build & Apply

Detecting N+1 Queries in Rails with Bullet Gem

📖 Scenario: You are building a simple blog application in Rails. You want to make sure your app does not have N+1 query problems, which can slow down your app when loading posts and their comments.

🎯 Goal: Set up the Bullet gem in your Rails app to detect N+1 queries during development and configure it to alert you when such queries happen.

📋 What You'll Learn

Add the Bullet gem to the Gemfile in the development group

Configure Bullet in the development environment to enable N+1 query detection

Set Bullet to log warnings to the Rails log

Set Bullet to show alerts in the browser

💡 Why This Matters

🌍 Real World

N+1 queries slow down web apps by making many database calls. Detecting them early helps keep apps fast and responsive.

💼 Career

Rails developers often use Bullet or similar tools to improve app performance and write efficient database queries.

1

Add Bullet gem to Gemfile

Add the Bullet gem to the Gemfile inside the group :development do block with the exact line gem 'bullet'.

Ruby on Rails

# Add gem 'bullet' inside the development group in Gemfile
# Your code here

Need a hint?

Open your Gemfile and find the group :development do section. Add gem 'bullet' inside it.

2

Configure Bullet in development environment

In config/environments/development.rb, add a configuration block for Bullet by writing config.after_initialize do and inside it enable Bullet with Bullet.enable = true and Bullet.bullet_logger = true.

Ruby on Rails

group :development do
  gem 'bullet'
end

# Configure Bullet in development.rb
# Your code here

Need a hint?

Open config/environments/development.rb and add config.after_initialize do. Inside that block, set Bullet.enable = true and Bullet.bullet_logger = true.

3

Add browser alert for N+1 queries

Inside the same config.after_initialize do block in development.rb, add Bullet.alert = true to show JavaScript alerts in the browser when N+1 queries are detected.

Ruby on Rails

group :development do
  gem 'bullet'
end

# config/environments/development.rb
Rails.application.configure do
  config.after_initialize do
    Bullet.enable = true
    Bullet.bullet_logger = true
    # Add Bullet alert here
  end
end

Need a hint?

Inside the config.after_initialize do block, add Bullet.alert = true to enable browser alerts.

4

Restart server and verify Bullet is active

Restart your Rails server to apply the Bullet gem and configuration changes. Then load a page with posts and comments to see if Bullet alerts appear in the browser or logs when N+1 queries happen.

Ruby on Rails

group :development do
  gem 'bullet'
end

# config/environments/development.rb
Rails.application.configure do
  config.after_initialize do
    Bullet.enable = true
    Bullet.bullet_logger = true
    Bullet.alert = true
  end
end

# Restart your server and test Bullet alerts
# Your code here

Need a hint?

After saving your changes, restart the Rails server by running rails server in your terminal. Then open your app in a browser and check for Bullet alerts.