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...