A content_fingerprint column on the thoughts table that stores a SHA-256 hash of normalized content, backed by a unique index. When you insert a thought, the database checks the fingerprint and either ...