UNIQUE constraints in SQLite FTS (FTS3/FTS4) tables
The correct way to do this:
CREATE VIEW playlist_view AS SELECT * FROM playlist;
CREATE TRIGGER insert_playlist INSTEAD OF INSERT ON playlist_view
BEGIN
SELECT RAISE(ABORT, 'column user_id is not unique') FROM playlist
WHERE user_id=new.user_id;
INSE...
roderickkennedy.com1 min read