DB Tables and Unique or duplicate values

[bkarabinchak.psi]

You can follow this method I outline in another post after you make the UNIQUE indexes

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…