Back

Relationship / Attributes bugged?

  • 0
  • Self Hosted
  • Databases
yadox
21 Apr, 2024, 11:40

Hi all, I am currently testing BaaS's for a project. With Appwrite (running in Docker) I ran in two big issues where I am not sure if I did something wrong / the functionality is bugged and / or how I can fix it.

  1. To bring multiple collections into relation, I tested the really handy "relationship" functionality. Unfortunately, out of a sudden I saw many empty relationship entries in some documents (see Screenshot). When I want to delete them by pressing x the web-UI stops working and I have to do a page refresh (STRG+R / F5).

Maybe the empty entries are caused by my Relationship-Setting Set NULL - set document ID as NULL in all related documents - but I am not sure. Anyway, even if this is the case I would need to be able to delete the empty entries, or?

Bonus Question: If Relations are not production ready and buggy, what else would be an "Appwrite-style" approach to link different collections? I did not find anything else which would enable a foreign key relationship behavior so far.

2) What I suddenly experienced as well was that I cannot change the name of an attribute of a document. If I try that I just get the not really helpful message Server Error and that's it (See screenshot). I could image that this behavior correlates with the root cause of issue 1 but I have no idea how to solve this.

Finally, and not an issue but curosity: is there an easy possibility to data via UI to backup them and maybe even import it again? Like a csv dump?

TL;DR
1) Issue with empty relationship entries in documents, unable to delete them causing web-UI to stop working. Possibly related to Relationship-Setting 'Set NULL' and question about alternative linking options. 2) Unable to change name of document attribute, encountering 'Server Error' message. Possible correlation with first issue. Solution: 1) The issue with empty relationship entries and the inability to delete them in Appwrite seems to be related to a bug. You might want to check with Appwrite's support team for a workaround. As for alternative methods of linking collections, Appwrite does not currently offer a direct solution, but you can explore using
Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more