What are your thoughts on the 'schema_plus_views' gem? about scenic HOT 7 CLOSED

The ruby string thing in the generator is iffy. I rarely get complicated strings like that right the first try, and on the command line I doubt it would work. I do still like the idea of a to_sql thing though.

What about an example in the README of generating the view in IRB with scopes, then printing the to_sql and throwing it in the view definition file (incidentally, this is how I'd recommend you do it).

from scenic.

Our name is better we can't give up.

from scenic.

This isn't a feature we're going to consider at this time. Thanks for the discussion, though.

from scenic.

We've talked about doing the same, but I have the same concerns as you. It boils down to the same reason you are discouraged from accessing external ActiveRecord models in your migrations - the underlying code can change or go away completely, leaving your migration in an invalid or incorrect state.

I could perhaps see a generator that accepts a ruby string which is then to_sqld or something? Not really sure. To be honest, my intended use case for scenic is one where you want to write SQL.

@calebthompson thoughts?

from scenic.

More broadly, on the schema_plus_views gem: This gem did not exist separately from schema_plus itself when we started this project. schema_plus did things we didn't like, so we weren't comfortable trying to use it just for view support. It also didn't offer view versioning, like scenic tries to.

Now that schema_plus_views does exist, it may make sense to see if we could merge some of the ideas of scenic into schema_plus_views without breaking either. Food for thought anyway.

from scenic.

I don't know. I'm pretty happy with the gem as is. You guys did a great job making this. I looked at the pull requests for materialized views but I just don't have a need for them (selfish, I know).

from scenic.

Totally agree! SQL statements in the schema show how the view's being built - especially important since it relies on other tables in the database. I've been using the gem for a couple of months now and am very pleased with it.

from scenic.