Node Type - Database View #46

New Issue

garrettmills · 2021-01-14T00:39:50Z

garrettmills commented

2021-01-14 00:39:50 +00:00

Create a new node type "Database View" which works similar to views in MySQL. Instead of having its own columns and data, this node aggregates data from other databases.
This could be pretty advanced, but in essence:
- Allow adding data sources
  - 1 primary data sources
  - n secondary data sources which "join" on some other data source
- Allow specifying filters and clauses on the view
  - e.g. only rows where column X from data source Y is greater than Z
- Do NOT allow inserts right now

- Create a new node type "Database View" which works similar to views in MySQL. Instead of having its own columns and data, this node aggregates data from other databases. - This could be pretty advanced, but in essence: - Allow adding data sources - 1 primary data sources - n secondary data sources which "join" on some other data source - Allow specifying filters and clauses on the view - e.g. only rows where column X from data source Y is greater than Z - Do NOT allow inserts right now

garrettmills added the

Scope: Databases

Feature Request

labels 2021-01-14 00:39:50 +00:00

Sign in to join this conversation.