scenic

Added

• refresh_materialized_view now accepts a cascade option, which defaults to
  false. Setting this option to true will refresh any materialized views the
  current view depends on first, ensuring the view being refreshed has the most
  up-to-date information.
• sql_definition argument is now supported when using update_view.

Fixed

• View migrations created under Rails 5 and newer will no longer result in
  warnings.
• ar_internal_metadata is no longer included in the schema dump for Rails 5
  and newer apps.
• Using the scenic:model generator will no longer create a fixture or factory.

Added

• Add replace_view migration statement, which issues CREATE OR REPLACE VIEW rather than CREATE VIEW or DROP VIEW and CREATE VIEW.
• Schema-qualify views outside the 'public' namespace, such as
  scenic.searches

Fixed

• Singularize generated model name when injecting into class.
  Previously, pluralized names would issue a warning and Scenic would
  attempt to insert model code into the pluralized model file.
• Convert shell-based smoke tests to RSpec syntax.

Added

• The generators now accept namespaced view definitions. For example: rails generate scenic:view my_app.users.

Fixed

• Materialized view indexes are now properly dumped to db/schema.rb. This was
  an oversight in previous releases, meaning rake db:schema:load was missing
  indexes.
• Calling update_view for a materialized view now properly finds associated
  indexes for automatic reapplication. An issue in the previous index query was
  returning no indexes.

Note: Dumping materialized view indexes will produce an invalid
db/schema.rb file under Rails 5 beta 1 and beta 2. This is fixed on Rails
master.

Full Changelog

Fixed

• Some schema operations were failing with a PG::ConnectionBad: connection is closed error. This has been fixed by ensuring we grab a fresh connection for
  all operations.

Full Changelog

Added

• Added support for updating materialized view definitions while maintaining
  existing indexes that are still applicable after the update.
• Added support for refreshing materialized views concurrently (requires
  Postgres 9.4 or newer).

Fixed

• The schema dumper will now dump views and materialized views together in the
  order they are returned by Postgres. This fixes issues when loading views that
  depend on other views via rake db:schema:load.
• Scenic now works on supported versions of Postgres older than 9.3.0.
  Attempts to use database features not supported by your specific version of
  Postgres will raise descriptive errors.
• Fixed inability to dump materialized views in Rails 5.0.0.beta1.

Full Changelog

We've arrived at 1.0. Please enjoy!

Added

• Added support for materialized views.
• Allow changing the database adapter via Scenic::Configuration.

Fixed

• Improved formatting of the view when dumped to schema.rb.
• Fixed generation of namespaced models by using ActiveRecord's own model
  generator.
• Eliminated alias_method_chain deprecation when running with Rails master
  (5.0).

Full Changelog

Added

• Previous view definition is copied into new view definition file when updating
  an existing view.

Fixed

• We avoid dumping views that belong to Postgres extensions.
• db/schema.rb is prettier thanks to a blank line after each view definition.

Full Changelog

Fixed

• View generator will now create db/views directory if necessary.

• scenic:view generator is now smart enough to update existing views.
• Add API documentation for Scenic::Statements.
• Raise error for missing view definition (rather than letting the
  database raise the error)

Scenic makes it easier to work with Postgres views in Rails.

It introduces view methods to ActiveRecord::Migration and allows views to be
dumped to db/schema.rb.

It provides generators for models, view definitions, and migrations.

It is build around a basic versioning system for view definition files.

In short, go add a view to your app.