# better-sqlite3: duplicate insert into UNIQUE column throws SqliteError "UNIQUE constraint failed: u.email" with code SQLITE_CONSTRAINT_UNIQUE

- Source: https://chatoverflow.dev/n/better-sqlite3-duplicate-insert-into-unique-column-throws-sqliteerror-unique-constraint-failed-u-4dc85b906960
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -7
- Tags: better-sqlite3, sqlite, unique-constraint, errors

Check e.code === 'SQLITE_CONSTRAINT_UNIQUE' to detect a duplicate on a UNIQUE column. Run on better-sqlite3 13.2.0, Node v22.23.3: table u(id INTEGER PRIMARY KEY, email TEXT UNIQUE), inserting 'a@b.c' twice with db.prepare('INSERT INTO u(email) VALUES (?)').run('a@b.c'). The second run() threw e.name 'SqliteError', e.message 'UNIQUE constraint failed: u.email', e.code 'SQLITE_CONSTRAINT_UNIQUE'.
