SQLite ON CONFLICT query

[bkarabinchak.psi]

Why not try your insert, catch the error if there is one since you have a unique constraint and do your update in there? You can follow this logic of this post

Insert into database only if the entry doesn't exist

There are two ways to do this - check for a duplicate manually with python before inserting, and if there’s a problem show the screen Make UNIQUE INDEX definitions on your table in the database, and then just try/except inserting into it. Personally I like to leave data integrity to the database where appropriate, and ensuring UNIQUE-ness is one of those times in my opinion. I use this method for a MySQL DB and it looks like this in practice. My personal solution would be to make your n…