Store pending review inside a Kafka cluster

[chinathaip]

Considering the fact that we are using a free tier for our PostgreSQL database - limited storage and api call

The number of pending reviews can grow more than the number of approved reviews.

• Eventually the database will be full and users will not be able to submit anymore review. This can be avoided if their review is inside our kafka, then even if it's full, we can handle it internally

We can try using a message queue like Kafka to store all the pending reviews instead, and only write the approved reviews to our database.

• This can significantly reduce the data to be stored in our database as well as the API calls we need to make to Supabase

If a review is rejected, we can inform them through our site's notification feature (Not yet implemented)

https://kafka.apache.org/intro https://docs.confluent.io/kafka-clients/go/current/overview.html

[chinathaip]

[chinathaip]

Kinda difficult to remove pending reviews from the Kafka topic once it has been approved

Will stop the R&D for now