I have an app that I want to build using Firebase which is basically a chat for users.
There are chat rooms that are temporary, meaning that after each day the rooms (and consequently all the messages) get deleted.
I see a lot of good things about Firestore, but in this case I'll be deleting potentially a lot of messages. Firestore is not only a bit iffy for deleting a bunch of stuff, but also charges for each operation (as I recall I can simply delete a node in rtdb and every children is also deleted).
So which one would be more affordable for my app?