VAdvice. When to choose convex over alternatives? benefits caveats etc.
I have a question I'd like to be answered unbiasedly. I would like to know what would be a better option for creating a realtime application that does the following, friend system with realtime online status, group chat/dms, etc? The majority of the question stems from development experience and security. I personally would like to use convex, but my partner is HEAVILY leaning towards appwrite (due to only size/community). If there's an argument to why or why not we should use convex, what would it be? I feel that both of the options are good however I still have questions regarding row level permissions. Sorry for the potentially controversial question, I do not wish to create any drama or argument below. Just seeking thoughts on this. Looking forward to reading the response!
ps: we will also implement some AI related features in a separate yet related project
ps: we will also implement some AI related features in a separate yet related project
