Maybe the easiest solution is to have in your own database …

Maybe the easiest solution is to have in your own database a new column for posts, something like "txid" and by default it's value is null. That way you know if transaction identifier is missing, then that post should be broadcast to the chain, and keep occasionally trying to broadcast it until txid is received. 🤗