
In SQL, we have the RAND()
function, is there an equivalent in Appwrite?
In my app, the user answers questions, which all have an Elo rating. I'm actually unfamiliar with how to choose which question next (matchmaking algorithms), but one way would be to choose a random value, I guess. If any of you guys have a better suggestion on how to tackle my specific problem, please let me know. Ideally, items would not repeat too much, and the range of question Elo should be similar to the user's.

Currently Nope. Either you would have to know the total ammount of docuements in your collection then use a random function to genarate some random offset then query using those random offset. Or you can fetch much docs See how much docs are there Then pick a random one. Btw There is a feature request of this issue https://github.com/appwrite/appwrite/issues/5205 You could show intrest in this 🤷♂️
Recommended threads
- Do I need Redis if using appwrite
Saw appwrite has built-in redis, but does this work for listdocuments, getdocument and other query etc? what does the appwrite redis covers under the hood?
- How to upload a profile picture from rea...
I need to upload profile picture from a app i am building for my project... How do i do it ? Till now i have done this much but it shows an error
- Offline replication with RXDB
Hey there! Trying out apprwrite with rxdb for an offline focussed application. I cannot seem to find on how to set the permissions on a per document level?
