blockchain transaction mempools are exactly like this except for the finality, which is another way of saying "it's now in the database"
nostr really is the thing that all shitcoins are trying to do, even to the point that practically none of them any more are about anything other than expensive, over-replicated data storage
nostr, on teh other hand, shifts that so the clients can do the replication as they require it, i mean, idk what to say lol... hurts being on the bleeding edge