News for hackers. Stuff that matters.
Re:GraphQLize: JVM library to build GraphQL API instantly fr... by moehm on Wednesday March 18, 2020 @10:41PM (#22623850)
What's the problem with views?
Re:GraphQLize: JVM library to build GraphQL API instantly fr... by tensor on Wednesday March 18, 2020 @10:52PM (#22623911)
You can't insert/update/delete data in views in all cases, and they can make debugging performance more challenging, but otherwise nothing. I think they are underused.

I rarely see people using views at all, let alone using them as a test aid (composing big queries from smaller more easily tested views), or using them to define interfaces to an internal data model.

Re:GraphQLize: JVM library to build GraphQL API instantly fr... by miles-po on Wednesday March 18, 2020 @11:19PM (#22624083)
For the most part, you can insert/update/delete.

See: INSTEAD OF triggers.

That is unless you're using MySQL/MariaDB, in which case views are the least of your worries.