kindred pine
Hello,
I'm trying to get documents from a collection but I need to make sure that the document I pull is unique to another document in another collection. If it was sql, I would do a JOIN query but I don't know what's the equivalent in Appwrite. Thank you
elder topaz
There is no join in appwrite right now, you could do something like listDocuments where foreign_key = id to see if it exists already?
kindred pine
There is no join in appwrite right now, you could do something like listDocument...
Oh, thank you. I didn't know foreign keys were a thing in Appwrite haha
elder topaz
Oh, thank you. I didn't know foreign keys were a thing in Appwrite haha
They’re not, you’d kinda just make your own using string attributes to store the id of the related record
kindred pine
They’re not, you’d kinda just make your own using string attributes to store the...
oh, damn alright
thank you
kindred pine
They’re not, you’d kinda just make your own using string attributes to store the...
just a side question, how do relationships come into effect in this scenario?
elder topaz
just a side question, how do relationships come into effect in this scenario?
They don’t, they’re in beta and do not support queries and are pretty inefficient. You can try and use them but be aware they will slow things down a lot
kindred pine
They don’t, they’re in beta and do not support queries and are pretty inefficien...
damn, thank you. I won't use them then
warped raft
What are the Github issues or projects you guys are using to track the JOIN progress? That's such a core and essential feature.
@elder topaz
warped raft
I think this is all I wanted: https://appwrite.io/docs/products/databases/relationships
You can't apparently join on the fly, but you can prepare those joins beforehand.
elder topaz
I think this is all I wanted: https://appwrite.io/docs/products/databases/relati...
Just know this is in beta and extremely inefficient. You’ll end up having performance issues quick.
