> On 24 Jun 2019, at 22:59, Christian Lenz <[email protected]> wrote:
>
> But here we can discuss about adding the connection to the amazon redshift
> which makes more sense, instead only adding the external tables. I mean how
> does NetBeans DB works. NB adds a connection for a DB to the services DB node
> as MySQL, or PostgreSQL or whatever it is supported. By adding more drivers
> it could be that NetBeans can handle it out of the box, but only known
> relational DB types.
NetBeans provides additional DB types by allowing you to add additional JDBC
drivers agnostically.
I’m not talking about adding the amazon driver, that would be a bad idea since
there’s the AWS SDK involved. All I want to do is add support for the table
type “EXTERNAL TABLE” which is returned by the connection metadata.
> For cloud based DBs, I don’t know how it exactly works but Amazon redshift is
> the DB, right? So if you have a DB hosted in the S3, it is still a DB with
> tables, but they are coming from the remote service (Cloud). So adding this
> to the DB section makes sense if you can add the Amazon RedShift as an
> external DB node to the services of NetBeans and not only the tables.
There are other big data solutions that have external tables, adding one
solution would mean adding them all.
> Maybe you can have a look how JetBrains DataGrip handles it.
>
>
> Cheers
>
> Chris
>
>
>
> Von: Brett Ryan
> Gesendet: Montag, 24. Juni 2019 13:38
> An: [email protected]
> Betreff: Re: AW: DB External table support
>
>
>> 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
>
>
>
>
---------------------------------------------------------------------
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
