apache / gravitino

World's most powerful open data catalog for building a high-performance, geo-distributed and federated metadata lake.
https://gravitino.apache.org
Apache License 2.0
909 stars 292 forks source link

Support for other JDBC backends #4101

Closed chanjaljayaram closed 5 hours ago

chanjaljayaram commented 2 months ago

What would you like to be improved?

Support for other JDBC bakends.

How should we improve?

Support for other JDBC bakends like Postgres and Oracle would be great as MySQL is not approved by our security.

justinmclean commented 2 months ago

I assume you mean MySQL is not approved by your security?

chanjaljayaram commented 2 months ago

Yes, that is correct.

On Tue, 9 Jul 2024 at 5:56 AM, Justin Mclean @.***> wrote:

I assume you mean MySQL is not approved by your security?

— Reply to this email directly, view it on GitHub https://github.com/apache/gravitino/issues/4101#issuecomment-2215733933, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMLR7FHYTY33ILM726SACDZLMU3VAVCNFSM6AAAAABKQRACACVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMJVG4ZTGOJTGM . You are receiving this because you authored the thread.Message ID: @.***>

yuqi1129 commented 2 months ago

@chanjaljayaram Thank you for your feedback. We will discuss the necessity and the corresponding plan for PG or Oracle.

jerryshao commented 2 months ago

Yeah, definitely we need to support PG and Oracle, @chanjaljayaram do you want to take a try?

chanjaljayaram commented 2 months ago

Sorry I’ve got no Java experience. :)

On Tue, 9 Jul 2024 at 10:39 AM, Jerry Shao @.***> wrote:

Yeah, definitely we need to support PG and Oracle, @chanjaljayaram https://github.com/chanjaljayaram do you want to take a try?

— Reply to this email directly, view it on GitHub https://github.com/apache/gravitino/issues/4101#issuecomment-2216536385, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMLR7BUSLWVJAHV7ASPOFTZLNV67AVCNFSM6AAAAABKQRACACVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMJWGUZTMMZYGU . You are receiving this because you were mentioned.Message ID: @.***>

yuqi1129 commented 2 months ago

Would anyone like to give it a try, I believe the main task will be handling the SQL dialect difference between MySQL and PG, or introducing a new ORM framework like jdo ,jDBI, and Hibernate since they both support JDBC protocol.