sugar syntax to declaring views

[sibelius]

Do you want to request a feature or report a bug?
feature

What is the current behavior?
a mongoose syntax to create views

What is the expected behavior?
a mongoose syntax to create views

it could be similar to mongoose.Schema

maybe

mongoose.View({
   name: '',
   viewOn: '',
   pipeline: [],
});

[vkarpov15]

Will think about what we can do with views. Any more detailed suggestions are welcome

[3axap4eHko]

What do you think about creating a model with additional schema parameters to be consistent with MongoDB doc

export const Schema = new Mongoose.Schema({

}, { collection: '<collection>', viewOn: '<source>', pipeline: '<pipeline>', collation: '<collation>' });

export default connection.model('View', Schema);

Also, such models should be marked as read-only

[sibelius]

does this also apply to On Demand Materialized Views?

https://www.mongodb.com/docs/manual/core/materialized-views/ ?

view here https://www.mongodb.com/docs/manual/core/views/

[vkarpov15]

@sibelius yeah, from a Mongoose models perspective materialized views and standard views are equivalent.

[sibelius]

what is the best approach to create an on-demand materialized view on mongoose?

should we fallback to mongodb?

or is this approach a valid one https://www.hownowbrownkow.com/posts/mongodb-materialized-views?

[vkarpov15]

https://www.hownowbrownkow.com/posts/mongodb-materialized-views looks valid. Create a Mongoose model on top of your view, and use that model like you would any other model.

[sibelius]

good enough for now

[vkarpov15]

@sibelius I'm going to leave this open for future dev work, if you don't mind