SQLite Forum

unique column constraint vs unique index
Login
I don't think you can set the index to automatically use the on conflict criteria though, you can only specify on the insert statement.