katib icon indicating copy to clipboard operation
katib copied to clipboard

Support PostgreSQL

Open x28646510 opened this issue 5 years ago • 12 comments

/kind feature

Hello, I'd like to request a feature for manager to register logs to PostgreSQL. Do you have any plan?

Describe the solution you'd like Current, only MySQL is supported as Log DB. So, I would like a feature for manager to register logs to PostgreSQL because PostgreSQL is major database as much as MySQL.

x28646510 avatar Nov 08 '19 10:11 x28646510

If there is enough interest (upvotes needed), then this could be part of this project's roadmap.

And, also welcome your contribution!

gaocegege avatar Nov 09 '19 02:11 gaocegege

/priority p3

gaocegege avatar Nov 12 '19 03:11 gaocegege

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Nov 25 '20 00:11 stale[bot]

/lifecycle frozen

andreyvelich avatar Nov 25 '20 15:11 andreyvelich

It would be great if katib and pipeline support postgreSQL database! Is there any plan to make database optional? @gaocegege @andreyvelich

javen218 avatar Jul 28 '22 01:07 javen218

MySQL is no longer best choice for many, since purchased by Oracle Company. The cake of Kubeflow is free, except the MySQL piece. And this makes us hesitate to introduce kubeflow into our project.

Edward-liang avatar Jul 28 '22 03:07 Edward-liang

/cc @johnugeorge

gaocegege avatar Jul 28 '22 03:07 gaocegege

@Edward-liang @javen218 Katib can be configured to have any backend DB. It can be supported by implementing this interface for any DB- https://github.com/kubeflow/katib/blob/master/pkg/db/v1beta1/common/kdb.go and use the DB in the manifests - https://github.com/kubeflow/katib/blob/master/manifests/v1beta1/components/db-manager/db-manager.yaml#L26 We can aim it for next release. It would be great if you can contribute it.

johnugeorge avatar Jul 29 '22 04:07 johnugeorge

Thank you very much for your reply! @johnugeorge @gaocegege We are highly looking forward to seeing this new feature in the next release!!!

javen218 avatar Jul 29 '22 10:07 javen218

If you guys think it is worth enough. I could try working on supporting Postgres as a katib db-manager's built-in feature. Even though katib already supports the interface for general DB, it could be some time-consuming job to many users if they should implement for themselves. WDYT? @kubeflow/wg-automl-leads

I'd like tp implement this, if you guys agree.

anencore94 avatar Jul 30 '22 06:07 anencore94

@anencore94 Thanks for your contribution! I agree with you.

gaocegege avatar Jul 31 '22 00:07 gaocegege

Thanks @anencore94

johnugeorge avatar Aug 01 '22 15:08 johnugeorge