GitHub user my-ship-it added a comment to the discussion: [Ideas] Official JDBC/ODBC driver required
Hi @cleverxiao001, Thanks for raising this — recognizing Cloudberry-specific syntax like `DISTRIBUTED BY` and `ORIENTATION` in metadata is genuinely useful for tooling and query optimization, so this is a fair ask. Just to share what I found while looking into it: there is an existing repo at [`cloudberry-contrib/jdbc`](https://github.com/cloudberry-contrib/jdbc) that seems intended as a home for a Cloudberry JDBC driver. However, in its current state it appears to be a straight mirror of upstream pgjdbc — the README is unchanged from PgJDBC, a code search for `cloudberry` or `DISTRIBUTED` returns no hits, and the most recent commits (latest dated 2024-12-12) all look like upstream syncs. So as it stands today, it would not behave any differently from the stock PostgreSQL driver for the cases you described. That said, the repo could be a great starting point if the community wants to build a proper Cloudberry-aware driver on top of it (extended `DatabaseMetaData`, DDL reverse-engineering that preserves distribution/storage clauses, etc.). Since you mentioned you would be willing to submit a PR, it might be worth checking with the maintainers whether `cloudberry-contrib/jdbc` is the intended landing spot for that work, or whether a new official driver effort should be kicked off here. Happy to help think through what the metadata extensions might look like if it is useful. GitHub link: https://github.com/apache/cloudberry/discussions/1705#discussioncomment-16750551 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
