ec-doris / kohesio-frontend

Web interface for Kohesio project
https://kohesio.ec.europa.eu
8 stars 0 forks source link

Add "like" button to projects #626

Open madewild opened 2 years ago

madewild commented 2 years ago

Functionality to let users highlight examples of nice projects But the storage could be tricky...

madewild commented 2 years ago

@raphdom is this possible or blocking factor to store it in a backend?

raphdom commented 2 years ago

we need to store somewhere indeed...

D063520 commented 2 years ago

Let's discuss this .... I can embed a simple h2 database in the spring boot application. The problem is that the cluster is not persistent. So when the pod is gone the data is lost. As a consequence we need a volume attached to the pod, the problem here is that we have 3 pods and we cannot query the same volume from all 3 and also we cannot mount the same volume on multiple pods. So I guess we need an external database for this, running in a pod or running on aws. I would leave to you this architectural decision. If you can provide a database endpoint we would take over from there.

Makes sense?

madewild commented 2 years ago

Agree with your analysis :)

madewild commented 2 years ago

@svili could you create this simple database/table inside the cluster?

svili commented 2 years ago

@D063520 @DiaZork @madewild Added a MySQL to the dev cluster in the development namespace. For development you can access it via port forwarding to the mysql service via

kubectl port-forward -n development svc/kohesio-backend-mysql-service 3306:3306

and then accessing it from localhost:3306. I can give you the root password via Skype or you can decode it from the kohesio-backend-secrets secret in the dev namespace. Added new environment variables to the backend deployment DB_HOST, DB_PORT, DB_USER, DB_PASSWORD.

raphdom commented 1 year ago

Now, this feature can be implemented in the kohesio-editor backend as we have a database to save this kind of info. Let's discuss if this should be part of this release or we can postpone

madewild commented 1 year ago

Let's postpone it but it's good we have the database already

madewild commented 8 months ago

@raphdom @svili @roberto-musmeci where do we stand with this idea? still on the map for a future release?