Scenic
Adds methods to ActiveRecord::Migration to create and manage versioned database views in Rails applications.
What is Scenic?
Scenic is a Ruby gem that adds methods to ActiveRecord::Migration for creating and managing versioned database views in Rails applications. It solves the problem of integrating complex SQL views into Rails projects by providing a structured, versioned approach that works with Rails' schema format and migration system. This allows developers to use SQL views without switching to SQL schema dumps or duplicating SQL strings.
Rails developers who need to work with complex SQL queries, materialized views, or want to expose database views as ActiveRecord models. It's particularly useful for teams looking to optimize queries, aggregate data, or create read-only models backed by SQL views.
Developers choose Scenic because it seamlessly integrates database views into Rails conventions, offering versioning, reversible migrations, and generators that simplify view management. Its support for materialized views and multiple update strategies provides flexibility for performance-critical applications.
Overview
Versioned database views for Rails
Use Cases
Best For
- Creating read-only ActiveRecord models backed by complex SQL queries
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
