[Solved] Validating a vote system with appwrite /nosql?

This might be off-topic I hope you guys could help me with this I have a thread and I want to validate it by user upvotes kinda like yt how would I validate, assuming it's a function that has a list of users? and what is the right way to query the number of votes

TL;DR

The user is asking for a solution to validate a vote system using Appwrite and NoSQL. In the thread, it is mentioned that Appwrite currently doesn't support aggregation functions. However, the suggested solution is to create atomic counter fields for each question/answer/votable post. This involves creating a collection for posts and another collection for votes. A function should then be created to trigger whenever there is a change in the votes collection. The function should increase the value of the posts.votes attribute when a document is added and decrease it when a document is deleted. This way, counters can be maintained without the need to query all the

As of now, Appwrite's doesn't support any aggregation function, you can follow (and upvote it <a:agooglethumbsup:635256484682530825>) this issue to track it.

As for your solution, the best would be to create an atomic counter fields for each of the questions/answers/votable posts.

Like so, for example, in case of posts.

Create collection named posts with this attributes.

title
content
votes

Create collection named votes with this attributes.

user_id
post_id

Then create a function and make it to be triggered on any change to the votes collection, so when the a documents is being add increase the value of posts.votes attribute, and when it got deleted decrease it.

This way you can have counters without having the need to query all the documents every time.