Search for a command to run...
Senior Software Engineer with 12 years of expertise in Ruby on Rails and Vue.js, specializing in health, e-commerce, staffing, and transport. Experienced in software development and version analysis.
No comments yet. Be the first to comment.
Motivation After building several Shopify embedded apps, I've learned valuable lessons about what works (and what definitely doesn't) in the embedded app environment. Today, I'm sharing these insights to help you avoid common pitfalls and build bette...
As a developer working with Shopify's ecosystem, I recently built a multi-tenant SaaS application that synchronizes customer data between Shopify stores and external services. In this article, I'll share my experience and technical insights into crea...
As developers, we're always looking for ways to streamline our deployment process while maintaining security and reliability. Today, I'm excited to share my experience setting up an automated deployment pipeline for a Rails application using Dokku an...
The Challenge: Modernizing Rails Deployment When I recently needed to deploy my Rails 8 application with multiple databases, I faced a common dilemma: choosing between expensive managed solutions and complex self-managed servers. My requirements were...
The Cost-Benefit Realization As a Rails developer who recently migrated from Heroku to Dokku, I want to share my journey and the surprising benefits I discovered. This transition wasn't just about cost savings—it opened up new possibilities for my de...
If you're a Rails developer, you've probably heard about the recent improvements in Rails 8, including optimizations for SQLite. While I mainly use PostgreSQL for my projects, these updates have piqued my curiosity, and I'm always interested in exploring what's new.
In this article, I'll guide you through leveraging PostgreSQL 16 enums in Rails 7+, showing you how to add an enum column to an article model, allowing you to define specific categories like blog, snippet, and vlog. Enums offer better data integrity and readability, making your code more maintainable.
To add a category enum column to the articles table, start by generating a migration:
rails g migration AddCategoryToArticles category:string
Next, modify the generated migration as follows to create an enum type and assign it to the column:
class AddCategoryToArticles < ActiveRecord::Migration[7.2]
def change
create_enum :categories, %w[
blog
snippet
vlog
]
add_column :articles, :category, :enum, enum_type: :categories
add_index :articles, :category
end
end
Run the migration:
rails db:migrate
This will create an enum type called categories in PostgreSQL and add a corresponding enum column to the articles table. You can verify the change in the schema file, where you'll see both the enum definition and the updated column.
Now, let's add the enum definition in the Article model:
class Article < ApplicationRecord
enum :category, {
blog: "blog",
snippet: "snippet",
vlog: "vlog",
}, validate: true
validates :category, presence: true
end
The validate: true option ensures that the enum is validated automatically with inclusion checks. If the category field is required, make sure to backfill existing articles before adding validates :category, presence: true.
To easily filter articles by their category, you can add a scope to your model:
scope :by_category, ->(category) { where(category: category) }
This scope allows you to perform queries like Article.by_category("blog") to filter articles by a specific category.
Using PostgreSQL enums in Rails provides type safety and keeps your database schema organized. This approach is particularly useful for fields with a fixed set of values, like categories in a blog or types in a content management system.
Happy Coding!