Github user tzolov commented on the pull request:
https://github.com/apache/incubator-zeppelin/pull/198#issuecomment-133362004
This is ready to be reviewed and merged.
> Note that the underlying design uses pure JDBC API and will work for any
JDBC driver.
Here are some of the design choices:
* The remote PSQL auto-competer uses the [JDBC
Metadata](http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html)
to retrieve `Schemas`, `Catalogs`, `Tables`, `Functions`, ... and `Columns`
names for a configured Database connection.
* The completer data is updated on data-model update events like: `CREATE`,
`DROP`, `INSERT` and alike. If you create a new table its name will appear in
the suggestions list and consecutively will disappear if the table is dropped.
* Completer is provided with a static list of PSQL keywords that never
change.
* Current version doesn't leverage the context. All completion suggestions
are equally likely to be suggested no matter the context. This is an area for
future improvements.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
