I've been using Retool lately to create an admin panel and I think there are some important features missing in firestore integration.
There are no:
I know I can just fetch the latest item and add the items to it, but there is a huge concurrency problem: what if, while I am changing it another user changes it? What is the final version?
A user already asked about that feature in Sep '20 (How do I add or remove a value in an array in a firestore document?)
That was your reply:
Hey @cdedreuille! We don’t have native support for this quite yet, so your best bet is to pass a fully updated array in your query. So basically take the current value of the array, push new values to it via JS, and then pass that updated array to overwrite the existing one. Does that make sense? (We’re working on building a raw query editor so you’ll be able to access the SDK directly!)
Now, after one year, still nothing.
One of the greatest features of Firestore is the real-time updates and if it could be used in Retool that would be great.