<ul><li>To upsert a row in a DB that doesn't use primary keys or unique constraints, the process can be broken down into two parts.</li><li>First, update any existing rows with a matching slug using an UPDATE statement.</li><li>Then, create a new row if no rows with matching slugs exist using an INSERT statement with a WHERE NOT EXISTS clause.</li><li>This approach allows for updating or inserting a row without the need for stored procedures or application logic.</li></ul>

Upsert a row in a DB that doesn't use primary keys or unique constraints

Discover more