sql: Non-materialized Views Overview

[jseldess]

Reference:

• Dev: @a-robinson
• RFC: https://github.com/cockroachdb/cockroach/blob/master/docs/RFCS/views.md
• Issue: sql: support non-materialized VIEWs cockroach#2971
• PRs:
  • sql: Initial support for creating and dropping views cockroach#9212
  • sql: Support for selecting from views cockroach#9355
  • sql: Track view dependencies to support RESTRICT and CASCADE cockroach#9724
  • sql: Persist DB names to view descriptors with new Format flag cockroach#10009
  • sql: Restrict renames of objects that views depend on cockroach#9988

[a-robinson]

Ah, sorry for not putting the docs-todo label on the PRs that have gone out so far! I was going to wait until more of the support was in. Since I haven't gone through this before, what's my role in the documentation process?

[jseldess]

Np, @a-robinson. We don't have a super strict/consistent process yet. It's best if you'd put that label on doc-relevant PRs going forward, perhaps with an comment to me if the feature isn't docs-ready.

Typically, once a feature is ready, Sean or I look through the relevant PRs/RFCs/etc and then go to the dev with questions.

Once views are ready for us to test and document, would you mind updating this ticket?

[a-robinson]

Sure, will do. Assigning to myself for tracking purposes until the feature is ready

[jmank88]

FYI the RFC link points to a dead branch: s/develop/master
https://github.com/cockroachdb/cockroach/blob/master/docs/RFCS/views.md

[jseldess]

Thanks for catching that, @jmank88. Fixed.