SQLite Forum

adding record if it doesn't already exist
Login
You could add a RETURNING clause at the end.