scenic
scenic copied to clipboard
scenic-views
Versioned database views for Rails
Would it be possible to have a 1.7.1 or 1.8.0 release with the `populated?` feature? Thanks!
Rebase of https://github.com/scenic-views/scenic/pull/337
This should resolve the discrepancies in #327 and #325, and is in response to a behavior introduced in #152. The heart of the issue is in how "public" was hardcoded...
Provide an ability to pass `if_not_exists` param for view creation. It's handy to have it when you disable_ddl_transaction in Rails migration and add indexes concurrently. And similar functionality with `if_exists`...
For some time now, Rails has offered [multiple database support](https://guides.rubyonrails.org/active_record_multiple_databases.html). Scenic, however, operated with the assumption that there is one database, hanging its functionality off the singleton, `Scenic.database`. We should...
One of our models is connecting to a warehouse DB since it's for reporting and not to serve the app features. That model is based on a materialized view. When...
This adds a `side_by_side` kwarg to the `update_materialized_view` method, which builds the new view alongside the old one and then atomically swaps them to reduce downtime at the cost of...
We run an app that needs two migrations folders (one each for two very different DB setups). So our project folder looks like: ``` app db migrate views db_2 migrate...
Right now, `update_materialized_view` results in a `DROP MATERIALIZED VIEW` followed by a `CREATE MATERIALIZED VIEW` with the new version; if the view is large, this can result in substantial downtime,...
This is meant to be a cautionary tale for other users, maybe it can be a documentation change once we agree on how this should be presented. The index reapplication...
