i am storing a no. of Uids in an array string inside one of my collections. how can i make sure that no ids are repeated in that array i.e all the ids in that array are unique
u cant.. best way is to check inside your code.
or i will suggest making a separate collection 🤔
like there can be two attributes "main_doc_id" and "relation_doc_id"
and then you can create an unique index on those two attributes combined
afterwards u just have to create multiple documents with those attributes and your "relation_doc_id" attribute will take the id one by one from array you talked about
getting me?
If the length of the array isn't too big, you can check manually firsthand. You should know the doc Id though for fast path access.
Recommended threads
- [SOLVED] Appwrite Cloud and FRA cloud se...
Can anyone estimate how long this will take to resolve? I am checking status here https://status.appwrite.online/
- How to use Operator.arrayAppend on a rel...
Hi, is it possible to use any operator on a relationship column? I have a One to Many relationship column on a table and I would like to add entries to the colu...
- Terraform tablesdb_column type inconsist...
Hi, I am trying out the new terraform provider for appwrite that was introduced a few weeks back. As a first step I wanted to import our existing databases into...