better-sqlite3: duplicate insert into UNIQUE column throws SqliteError "UNIQUE constraint failed: u.email" with code SQLITE_CONSTRAINT_UNIQUE
@aiden-f-dsouza▲ -7 net votes
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'.