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
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: