Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement VIEW #3729

Closed
waynexia opened this issue Apr 17, 2024 · 4 comments
Closed

Implement VIEW #3729

waynexia opened this issue Apr 17, 2024 · 4 comments
Assignees
Labels
A-frontend Involves code in the Frontend node A-metasrv Involves code in the meta server C-feature Category Features tracking-issue A tracking issue for a feature.
Milestone

Comments

@waynexia
Copy link
Member

waynexia commented Apr 17, 2024

What problem does the new feature solve?

The VIEW statement in SQL allows users to store complex queries in the database as virtual tables. This provides several benefits:

  1. Simplifies complex queries: Views can encapsulate complex logic and querying requirements into a single easily accessible object. This can simplify the querying process for users by abstracting away the complexity of the underlying data model.
  2. Data security: Views allow users to restrict access to certain rows or columns of a table, providing an additional layer of security. Users can only query the data that is exposed through the view, limiting their access to sensitive information.
  3. Reusability: Views can be reused across multiple queries, reports, and applications. This promotes code reusability, reduces redundancy, and makes it easier to maintain and update the underlying database schema.
  4. Performance optimization: Views can improve planning performance by caching the input plan.
  5. Data abstraction: Views can hide the underlying data model complexity from users, providing a simplified and consistent interface to the database. This can be particularly useful in situations where users need to interact with a complex database schema.

What does the feature do?

Implement VIEW like https://www.postgresql.org/docs/current/sql-createview.html

Implementation challenges

No response

@waynexia waynexia added C-feature Category Features Metasrv A-frontend Involves code in the Frontend node labels Apr 17, 2024
@waynexia waynexia self-assigned this Apr 17, 2024
@waynexia
Copy link
Member Author

Going to try it within one week

@tisonkun

This comment was marked as resolved.

@waynexia

This comment was marked as resolved.

@tisonkun tisonkun added A-metasrv Involves code in the meta server and removed Metasrv labels May 15, 2024
@killme2008 killme2008 added this to the v0.9 milestone May 30, 2024
@killme2008
Copy link
Contributor

killme2008 commented May 30, 2024

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-frontend Involves code in the Frontend node A-metasrv Involves code in the meta server C-feature Category Features tracking-issue A tracking issue for a feature.
Projects
None yet
Development

No branches or pull requests

3 participants