> On 24 Jun 2019, at 17:27, Christian Lenz <[email protected]> wrote: > > Hey Brett, > > external tables you mean, the DB is in the cloud or what does that mean?
Yes, external tables as in amazon redshift spectrum which references data stored in s3 buckets externally. Queries are pushed down to spectrum where possible. > To the question with the Icon, yes it really makes sense to identify the > service via name AND icon. I’m not specifically referring to the service, just the tables. Presently NetBeans does not show external tables which misleadingly makes it look like schemas are empty, but you can query the tables. > Unfortunately, NetBeans uses the same icon for each DB connection, doesn’t > matter which provider/driver it is (MySQL, PostgreSQL, SQLite, etc.). This > needs to be changed. Maybe your PR for Amazon could be the first one? I would > like to change the icons too (Maybe by finding out the base class/driver to > show the specific icon for that). We could do this, other tools I believe have built in icons for this. It could be a bit of a copyright issue if we start including vendor icons? I think the vendor icons might be a totally different requirement. I’m more referring to the icons of normal tables vs system tables vs external tables. Presently tables and system tables have the same icon, and external, well, coming. :) > Anyway, a specific icon for the DB is needed imho. In the DB IDE of JetBrains > (DataGrip) you can easily see how nice it looks and if you know the icon, you > don’t need to read the label anyway. > > If it is a DataBase, there is no need for a new node. NBMongoDB (I think so) > and Cassandra are also under the DB node. So DB (Relational or NoSQL) should > be under the same node. > > Cheers > > Chris > > > > Von: Brett Ryan > Gesendet: Sonntag, 23. Juni 2019 14:18 > An: [email protected] > Betreff: DB External table support > > I’d like to add external table support for amazon redshift using amazon > spectrum tables stored on s3. One easy fix is to add EXTERNAL TABLE to > JDBCSchema which I’ve tested and is working as expected. > > It might be noted that we may want to either > > - have these under a seperate node, though note that system tables don’t > - have an augmented icon? > > I can provide a PR with the change if we’re happy to just return the tables > which is the same behaviour for system tables. > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > For further information about the NetBeans mailing lists, visit: > https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
