scenic
scenic copied to clipboard
scenic-views
Versioned database views for Rails
I ran a scenic migration for a file that doesn't yet exist and was greeted with this: ``` == 20211216184824 CreateSearches: migrating =================================== -- create_view(:searches) rake aborted! StandardError: An error...
This introduces topological sorting (https://ruby-doc.org/stdlib-2.6.8/libdoc/tsort/rdoc/TSort.html#method-i-tsort) for views in dumps which will sort views alphabetically and in case of dependencies between views will use a topological sorting. That provides a consistent...
I needed to use this in a rails engine and didn't want to have to copy db_views over for every rails app. This makes it so the the definition is...
## Why? Without this, default behavior of `rake db:schema:load` is broken because ActiveRecord config option `schema_search_path` for Postgres adapters is automatically used to identify where is the `view` being loaded...
I would like to discuss a new feature to Scenic that will allow renaming (materialized) views. ### Use case: When a materialized view takes a long time to refresh, doing...
Get this stranger error when trying to update the materialized view. It seems that adapter prevents any usage of SAVEPOINT but for transactions. Any help would be appreciated
Two quirks of our setup might explain this 1. the indexes have custom names 2. We are using a custom schema name rather than `public` Not had time to find...
Added a method which return the view is populated or not. `REFRESH MATERIALIZED VIEW CONCURRENTLY` doesn't work for a view which is not populated, even it has unique index. This...
`pg_class` stores `relname` without schema prefix