The database is postgres under the hood which provides atomicity. We verify the signature of signed pieces (and signed deeds) and then commit the transaction to postgres with a digest of the content (which has a unique constraint on it) - this along with the atomic guarantee ensures there can be no double spend of signed messages.